EAS 供应链，业务类型相关

供应链：业务类型相关的事务类型等，为平台基础资料，不可新建，但是可以再数据层级进行操作；

表说明

业务类型：T_SCM_BizType （业务类型可以在界面复制，然后编辑；添加删除，单据类型，事务类型即可）

单据类型：T_SCM_BillType  

手动插入数据

INSERT INTO T_SCM_BillType ("FID", "FCREATORID", "FCREATETIME", "FLASTUPDATEUSERID", "FLASTUPDATETIME", "FCONTROLUNITID", "FNAME_L2", "FNAME_L3", "FNUMBER",  "FDESCRIPTION_L2", "FDESCRIPTION_L3", "FSIMPLENAME", "FBILLTYPEGROUP", "FSCHEDULED", "FHEADTABLE", "FENTRYTABLE", "FBOSTYPE")
 VALUES (NEWBOSid('463ED552'), '00000000-0000-0000-0000-00000000000013B7DE7F', SYSDATE, '00000000-0000-0000-0000-00000000000013B7DE7F', SYSDATE, '00000000-0000-0000-0000-000000000000CCE7AED4', '非货品需求申请单','非货品需求申请单', 'HN_FHP_01', '非货品需求申请单', '非货品需求申请单','需求申请单', '11', '1', 'CT_FHP_CSSRequireApplyBill', 'CT_FHP_CSSRABE', '4488014C');

INSERT INTO T_SCM_BillType ("FID", "FCREATORID", "FCREATETIME", "FLASTUPDATEUSERID", "FLASTUPDATETIME", "FCONTROLUNITID", "FNAME_L2", "FNAME_L3", "FNUMBER",  "FDESCRIPTION_L2", "FDESCRIPTION_L3", "FSIMPLENAME", "FBILLTYPEGROUP", "FSCHEDULED", "FHEADTABLE", "FENTRYTABLE", "FBOSTYPE")
 VALUES (NEWBOSid('463ED552'), '00000000-0000-0000-0000-00000000000013B7DE7F', SYSDATE, '00000000-0000-0000-0000-00000000000013B7DE7F', SYSDATE, '00000000-0000-0000-0000-000000000000CCE7AED4', '非货品采购申请单','非货品采购申请单', 'HN_FHP_02', '非货品采购申请单', '非货品采购申请单','采购申请单', '10', '1', 'CT_FHP_PurchoseRequsetBill', 'CT_FHP_PurchoseRBE', '298630F6');

所属分组

采购=10,销售=11,库存=12,核算=13,发运=14,渠道=15,委外=16,销售与运作计划=60,生产数据管理=61,主生产计划=62,物料需求计划=63,需求计划=64,生产线排程=65,流程生产执行=66,质量=80,计量检斤=81,离散生产执行=67,设备=70

有单据了,就可以复制一个业务类型，然后添加单据类型即可；

业务类型与事物类型关表查询

select B.FID, B.fname_l2,C.FID ,C.FNAME_l2 from T_SCM_BillBizType A  
inner join  T_SCM_BizType B ON A.FBizTypeID = B.FID 
INNER JOIN   T_SCM_TransactionType C  ON A.FBillTypeID=C.FBillTypeID where A.FBizTypeID='d8e80652-0110-1000-e000-04c5c0a812202407435C'

需要查看EAS基础数据表说明的，可在下面链接下载

http://download.csdn.net/download/a1055186977/9872106

运行

查看说明