--简单委外入库单据类型预置数据--
DELETE FROM T_BAS_BILLTYPE WHERE FID = 989772873411359744;
INSERT INTO T_BAS_BILLTYPE(FID,FISDEFAULT,FDEFPRINTTEMPLATE,FCONTROLPRINTCOUNT,FMASTERID,FSTATUS,FMAXPRINTCOUNT,FBILLFORMID,FBILLINITSETTING,FNUMBER,FCREATETIME,FLAYOUTSOLUTION,FMODIFIERID,FENABLE,FMODIFYTIME,FPRINTAFTERAUDIT,FCREATORID) VALUES (989772873411359744,'1',' ','0',989772873411359744,'C',1,'im_mdc_ominbill',' ','im_mdc_ominbill_BT_S',{ts'2020-06-23  00:00:00'},'129RQZ42Z6+9',1467255694653663232,'1',{ts'2022-08-31  00:00:00'},'1',1); 

DELETE FROM T_BAS_BILLTYPE_l WHERE FPKID = '12JWT+DE8AD4';
INSERT INTO T_BAS_BILLTYPE_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (989772873411359744,'12JWT+DE8AD4','zh_CN','标准委外入库单','标准委外入库单'); 
DELETE FROM T_BAS_BILLTYPE_l WHERE FPKID = '12JWT+DE8AD5';
INSERT INTO T_BAS_BILLTYPE_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (989772873411359744,'12JWT+DE8AD5','zh_TW','標準委外入庫單','標準委外入庫單'); 

DELETE FROM T_BAS_BILLTYPEPARAMETER WHERE FFORMID = 'im_mdc_ominbill' and FBILLTYPEID = 989772873411359744;
INSERT INTO T_BAS_BILLTYPEPARAMETER(FFORMID,FBILLTYPEID,FDATA) VALUES ('im_mdc_ominbill',989772873411359744,'{"_Type_":"bd_billtypeparameter","entryentity":[{"_Type_":"entryentity","biztypenumber":{"number":"4011","masterid":966651870204521472,"_Type_":"bd_biztype","ispreset":true,"multilanguagetext":[{"_Type_":"locale","pkid":"1/Q3QMIUP=+F","name":"普通委外","description":"普通委外","localeid":"zh_CN"},{"_Type_":"locale","pkid":"26/ZY/Y5R2HQ","name":"Generic Subcontracting","description":"Generic Subcontracting","localeid":"en_US"},{"_Type_":"locale","pkid":"1/Q3QMIUP=+G","name":"普通委外","description":"普通委外","localeid":"zh_TW"}],"name":{"zh_TW":"普通委外","en_US":"Generic Subcontracting","zh_CN":"普通委外"},"id":966651870204521472},"ispreset":true,"biztypenumber_id":966651870204521472,"id":0,"isdefault":true,"seq":1},{"_Type_":"entryentity","biztypenumber":{"number":"4051","masterid":990500657985463296,"_Type_":"bd_biztype","ispreset":true,"multilanguagetext":[{"_Type_":"locale","pkid":"26/ZY/Y5R35C","name":"Generic Subcontract Order Return","description":"","localeid":"en_US"},{"_Type_":"locale","pkid":"12NCSB6CO+CR","name":"普通委外退补货","description":"","localeid":"zh_CN"},{"_Type_":"locale","pkid":"12NCSB6CO+CS","name":"普通委外退貨","description":"","localeid":"zh_TW"}],"name":{"zh_TW":"普通委外退貨","en_US":"Generic Subcontract Order Return","zh_CN":"普通委外退补货"},"id":990500657985463296},"ispreset":true,"biztypenumber_id":990500657985463296,"id":0,"isdefault":false,"seq":2},{"_Type_":"entryentity","biztypenumber":{"number":"4052","masterid":1487749822973742080,"_Type_":"bd_biztype","ispreset":true,"multilanguagetext":[{"_Type_":"locale","pkid":"2NQNNHNG5B8Q","name":"普通委外退货","description":"","localeid":"zh_CN"},{"_Type_":"locale","pkid":"2NQNNHNG5B8R","name":"普通委外退貨","description":"","localeid":"zh_TW"}],"name":{"zh_TW":"普通委外退貨","zh_CN":"普通委外退货"},"id":1487749822973742080},"ispreset":true,"biztypenumber_id":1487749822973742080,"id":0,"isdefault":false,"seq":3}]}'); 

--委外完工入库单据类型预置数据--
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',1467255694653663232,'1',{ts'2022-08-30  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',' ','委外完工入庫單'); 

DELETE 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":"4031","masterid":989851541752212480,"_Type_":"bd_biztype","multilanguagetext":[{"_Type_":"locale","pkid":"12K9H8AS1IH3","name":"工序委外","description":"","localeid":"zh_CN"},{"_Type_":"locale","pkid":"12K9H8AS1IH4","name":"工序委外","description":"","localeid":"zh_TW"}],"ispreset":true,"name":{"zh_TW":"工序委外","GLang":"工序委外","zh_CN":"工序委外"},"id":989851541752212480},"ispreset":false,"biztypenumber_id":989851541752212480,"id":0,"isdefault":true,"seq":1}]}'); 
DELETE FROM T_BAS_BILLTYPEPARAMETER WHERE FFORMID = 'im_mdc_omcmplinbill' and FBILLTYPEID = 1228835943272797184;
INSERT INTO T_BAS_BILLTYPEPARAMETER(FFORMID,FBILLTYPEID,FDATA) VALUES ('im_mdc_omcmplinbill',1228835943272797184,'{"_Type_":"bd_billtypeparameter","entryentity":[{"_Type_":"entryentity","biztypenumber":{"number":"WX110","masterid":1002795213917594624,"_Type_":"bd_biztype","ispreset":true,"multilanguagetext":[{"_Type_":"locale","pkid":"26/ZY/Y5R35=","name":"Product Subcontracting","description":"","localeid":"en_US"},{"_Type_":"locale","pkid":"1459ZJQN6FCU","name":"产品委外","description":"","localeid":"zh_CN"},{"_Type_":"locale","pkid":"1459ZJQN6FCV","name":"產品委外","description":"","localeid":"zh_TW"}],"name":{"zh_TW":"產品委外","en_US":"Product Subcontracting","zh_CN":"产品委外"},"id":1002795213917594624},"ispreset":true,"biztypenumber_id":1002795213917594624,"id":0,"isdefault":false,"seq":1},{"_Type_":"entryentity","biztypenumber":{"number":"WX1101","masterid":1006426561370713088,"_Type_":"bd_biztype","ispreset":true,"multilanguagetext":[{"_Type_":"locale","pkid":"26/ZY/Y5R2H1","name":"Outsourcing Product Returns","description":"","localeid":"en_US"},{"_Type_":"locale","pkid":"14LOG6R=TVYF","name":"产品委外退补货","description":"","localeid":"zh_CN"},{"_Type_":"locale","pkid":"14LOG6R=TVYG","name":"產品委外退貨","description":"","localeid":"zh_TW"}],"name":{"zh_TW":"產品委外退貨","en_US":"Outsourcing Product Returns","zh_CN":"产品委外退补货"},"id":1006426561370713088},"ispreset":true,"biztypenumber_id":1006426561370713088,"id":0,"isdefault":false,"seq":2},{"_Type_":"entryentity","biztypenumber":{"number":"WX1102","masterid":1487741602792213504,"_Type_":"bd_biztype","ispreset":true,"multilanguagetext":[{"_Type_":"locale","pkid":"2NQM3LJ1YUKM","name":"产品委外退货","description":"","localeid":"zh_CN"},{"_Type_":"locale","pkid":"2NQM3LJ1YUKN","name":"產品委外退貨","description":"","localeid":"zh_TW"}],"name":{"zh_TW":"產品委外退貨","zh_CN":"产品委外退货"},"id":1487741602792213504},"ispreset":true,"biztypenumber_id":1487741602792213504,"id":0,"isdefault":false,"seq":3}]}'); 
