--委外完工入库单	im_mdc_omcmplinbill_BT_S	委外完工入库单
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 1444074358900315136;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FAUDITENABLED,FVINIT,FVSUBMIT,FVNEW,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT) VALUES (1228835943272797184,'1','0',1444074358900315136,'0','1','1','0','1','1','1','1',0,'1','0','warehouse',1,' ',' ','1'); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 1444074358900315137;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FAUDITENABLED,FVINIT,FVSUBMIT,FVNEW,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT) VALUES (1228835943272797184,'1','0',1444074358900315137,'0','1','1','1','1','1','1','1',0,'1','1','producttype',2,' ',' ','1'); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 1444074358900315138;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FAUDITENABLED,FVINIT,FVSUBMIT,FVNEW,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT) VALUES (1228835943272797184,'1','0',1444074358900315138,'0','1','1','0','1','1','1','1',0,'1','0','qualitystatus',3,' ',' ','1'); 

DELETE FROM T_BAS_BILLTYPE WHERE FID = 1228835943272797184;
INSERT INTO T_BAS_BILLTYPE(FID,FISDEFAULT,FDEFPRINTTEMPLATE,FCONTROLPRINTCOUNT,FMASTERID,FSTATUS,FMAXPRINTCOUNT,FBILLFORMID,FBILLINITSETTING,FNUMBER,FCREATETIME,FLAYOUTSOLUTION,FMODIFIERID,FENABLE,FMODIFYTIME,FPRINTAFTERAUDIT,FCREATORID) VALUES (1228835943272797184,'1',' ','0',1228835943272797184,'C',1,'im_mdc_omcmplinbill',' ','im_mdc_omcmplinbill_BT_S',{ts'2021-08-23  00:00:00'},'1UE2HDSO5/P7',1,'1',{ts'2022-06-16  00:00:00'},'1',1159363507540525056); 

DELETE FROM T_BAS_BILLTYPE_l WHERE FPKID = '1UY7PH0LZ0UA';
INSERT INTO T_BAS_BILLTYPE_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1228835943272797184,'1UY7PH0LZ0UA','zh_CN',' ','委外完工入库单'); 
DELETE FROM T_BAS_BILLTYPE_l WHERE FPKID = '1UY7PH0LZ0UB';
INSERT INTO T_BAS_BILLTYPE_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1228835943272797184,'1UY7PH0LZ0UB','zh_TW',' ','委外完工入庫單'); 

--委外完工入库单	im_mdc_omcmplinbill_OPM_S	工序加工结算
--DELETE FROM T_BAS_BILLTYPE WHERE FID = 1421713311166131200;
--INSERT INTO T_BAS_BILLTYPE(FID,FISDEFAULT,FDEFPRINTTEMPLATE,FCONTROLPRINTCOUNT,FMASTERID,FSTATUS,FMAXPRINTCOUNT,FBILLFORMID,FBILLINITSETTING,FNUMBER,FCREATETIME,FLAYOUTSOLUTION,FMODIFIERID,FENABLE,FMODIFYTIME,FPRINTAFTERAUDIT,FCREATORID) VALUES (1421713311166131200,'0',' ','0',1421713311166131200,'C',1,'im_mdc_omcmplinbill',' ','im_mdc_omcmplinbill_OPM_S',{ts'2022-05-16  00:00:00'},'2F8WVR+K1E3Q',1,'1',{ts'2022-05-16  00:00:00'},'1',1);

--DELETE FROM T_BAS_BILLTYPE_l WHERE FPKID = '2FM=/KCW6NFQ';
--INSERT INTO T_BAS_BILLTYPE_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1421713311166131200,'2FM=/KCW6NFQ','zh_CN',' ','工序加工结算');
--DELETE FROM T_BAS_BILLTYPE_l WHERE FPKID = '2FM=/KCW6NFR';
--INSERT INTO T_BAS_BILLTYPE_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1421713311166131200,'2FM=/KCW6NFR','zh_TW',' ','工序加工結算');


--工序加工结算 单据类型参数
--IF NOT EXISTS (SELECT 1 FROM t_bas_billtypeparameter WHERE FFORMID = 'im_mdc_omcmplinbill' and FBILLTYPEID = 1421713311166131200)
--INSERT INTO t_bas_billtypeparameter(FFORMID,FBILLTYPEID,FDATA) VALUES ('im_mdc_omcmplinbill',1421713311166131200,'{"_Type_":"bd_billtypeparameter","entryentity":[{"_Type_":"entryentity","biztypenumber":{"number":"604","masterid":1448629546520676352,"_Type_":"bd_biztype","multilanguagetext":[{"_Type_":"locale","pkid":"2IY86Q/DDEGT","name":"工序委外","description":"","localeid":"zh_CN"},{"_Type_":"locale","pkid":"2IY86Q/DDEGU","name":"工序委外","description":"","localeid":"zh_TW"}],"ispreset":true,"name":{"zh_TW":"工序委外","GLang":"工序委外","zh_CN":"工序委外"},"id":1448629546520676352},"ispreset":true,"biztypenumber_id":1448629546520676352,"id":0,"isdefault":true,"seq":1},{"_Type_":"entryentity","biztypenumber":{"number":"6041","masterid":1448630870343681024,"_Type_":"bd_biztype","multilanguagetext":[{"_Type_":"locale","pkid":"2IY8FC7WXX=S","name":"工序委外退货","description":"","localeid":"zh_CN"},{"_Type_":"locale","pkid":"2IY8FC7WXX=T","name":"工序委外退貨","description":"","localeid":"zh_TW"}],"ispreset":true,"name":{"zh_TW":"工序委外退貨","GLang":"工序委外退货","zh_CN":"工序委外退货"},"id":1448630870343681024},"ispreset":true,"biztypenumber_id":1448630870343681024,"id":0,"isdefault":false,"seq":2}]}');

