--生产退料申请单据类型预置数据--
DELETE FROM T_BAS_BILLTYPE WHERE FID = 1733480212043151360;
INSERT INTO T_BAS_BILLTYPE(FID,FISDEFAULT,FDEFPRINTTEMPLATE,FCONTROLPRINTCOUNT,FMASTERID,FSTATUS,FMAXPRINTCOUNT,FBILLFORMID,FBILLINITSETTING,FNUMBER,FCREATETIME,FLAYOUTSOLUTION,FMODIFIERID,FENABLE,FMODIFYTIME,FPRINTAFTERAUDIT,FCREATORID) VALUES (1733480212043151360,'1',' ','0',1733480212043151360,'C',1,'im_mdc_mftreturnapplybill',' ','im_mdc_mftreturnapplybill_BT_S',{ts'2023-07-20  00:00:00'},'3EXYVYUG=4V4',1669578611826476032,'1',{ts'2023-07-31  00:00:00'},'1',1627603554673977344); 

DELETE FROM T_BAS_BILLTYPE_l WHERE FPKID = '3EXYANCVCZ6X';
INSERT INTO T_BAS_BILLTYPE_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1733480212043151360,'3EXYANCVCZ6X','zh_CN',' ','生产退料申请'); 
DELETE FROM T_BAS_BILLTYPE_l WHERE FPKID = '3EXYANCVCZ6Y';
INSERT INTO T_BAS_BILLTYPE_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1733480212043151360,'3EXYANCVCZ6Y','zh_TW',' ','生產退料申請'); 

DELETE FROM T_BAS_BILLTYPEPARAMETER WHERE FFORMID = 'im_mdc_mftreturnapplybill' and FBILLTYPEID = 1733480212043151360;
INSERT INTO T_BAS_BILLTYPEPARAMETER(FFORMID,FBILLTYPEID,FDATA) VALUES ('im_mdc_mftreturnapplybill',1733480212043151360,'{"_Type_":"bd_billtypeparameter","entryentity":[{"_Type_":"entryentity","biztypenumber":{"number":"3201","masterid":688864102566811648,"_Type_":"bd_biztype","multilanguagetext":[{"_Type_":"locale","pkid":"04L99XNVAMJF","name":"普通领料退回","description":"","localeid":"zh_CN"},{"_Type_":"locale","pkid":"04L99XNVAMJG","name":"普通領料退回","description":"","localeid":"zh_TW"}],"ispreset":true,"name":{"zh_TW":"普通領料退回","zh_CN":"普通领料退回"},"id":688864102566811648},"ispreset":false,"biztypenumber_id":688864102566811648,"id":0,"isdefault":true,"seq":1},{"_Type_":"entryentity","biztypenumber":{"number":"3231","masterid":688864617560337408,"_Type_":"bd_biztype","multilanguagetext":[{"_Type_":"locale","pkid":"04L9CO/SJKWM","name":"VMI领料退回","description":"","localeid":"zh_CN"},{"_Type_":"locale","pkid":"04L9CO/SJKWN","name":"VMI領料退回","description":"","localeid":"zh_TW"}],"ispreset":true,"name":{"zh_TW":"VMI領料退回","GLang":"VMI领料退回","zh_CN":"VMI领料退回"},"id":688864617560337408},"ispreset":false,"biztypenumber_id":688864617560337408,"id":0,"isdefault":false,"seq":2}]}'); 
--委外退料申请单据类型预置数据--
DELETE FROM T_BAS_BILLTYPE WHERE FID = 1734102272742304768;
INSERT INTO T_BAS_BILLTYPE(FID,FISDEFAULT,FDEFPRINTTEMPLATE,FCONTROLPRINTCOUNT,FMASTERID,FSTATUS,FMAXPRINTCOUNT,FBILLFORMID,FBILLINITSETTING,FNUMBER,FCREATETIME,FLAYOUTSOLUTION,FMODIFIERID,FENABLE,FMODIFYTIME,FPRINTAFTERAUDIT,FCREATORID) VALUES (1734102272742304768,'1',' ','0',1734102272742304768,'C',1,'im_mdc_mftreturnapplybill',' ','im_mdc_mftomreapplybill_BT_S',{ts'2023-07-21  00:00:00'},'3EXYZUFZPVSA',1627603554673977344,'1',{ts'2023-07-31  00:00:00'},'1',1627603554673977344); 

DELETE FROM T_BAS_BILLTYPE_l WHERE FPKID = '3F+XJL8OISZ6';
INSERT INTO T_BAS_BILLTYPE_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1734102272742304768,'3F+XJL8OISZ6','zh_CN',' ','委外退料申请'); 
DELETE FROM T_BAS_BILLTYPE_l WHERE FPKID = '3F+XJL8OISZ7';
INSERT INTO T_BAS_BILLTYPE_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1734102272742304768,'3F+XJL8OISZ7','zh_TW',' ','委外退料申請'); 

DELETE FROM T_BAS_BILLTYPEPARAMETER WHERE FFORMID = 'im_mdc_mftreturnapplybill' and FBILLTYPEID = 1734102272742304768;
INSERT INTO T_BAS_BILLTYPEPARAMETER(FFORMID,FBILLTYPEID,FDATA) VALUES ('im_mdc_mftreturnapplybill',1734102272742304768,'{"_Type_":"bd_billtypeparameter","entryentity":[{"_Type_":"entryentity","biztypenumber":{"number":"WX1101","masterid":1006426561370713088,"_Type_":"bd_biztype","multilanguagetext":[{"_Type_":"locale","pkid":"14LOG6R=TVYF","name":"产品委外退补货","description":"","localeid":"zh_CN"},{"_Type_":"locale","pkid":"14LOG6R=TVYG","name":"產品委外退補貨","description":"","localeid":"zh_TW"}],"ispreset":true,"name":{"zh_TW":"產品委外退補貨","GLang":"产品委外退补货","zh_CN":"产品委外退补货"},"id":1006426561370713088},"ispreset":false,"biztypenumber_id":1006426561370713088,"id":0,"isdefault":true,"seq":1},{"_Type_":"entryentity","biztypenumber":{"number":"3231","masterid":688864617560337408,"_Type_":"bd_biztype","multilanguagetext":[{"_Type_":"locale","pkid":"04L9CO/SJKWM","name":"VMI领料退回","description":"","localeid":"zh_CN"},{"_Type_":"locale","pkid":"04L9CO/SJKWN","name":"VMI領料退回","description":"","localeid":"zh_TW"}],"ispreset":true,"name":{"zh_TW":"VMI領料退回","GLang":"VMI领料退回","zh_CN":"VMI领料退回"},"id":688864617560337408},"ispreset":false,"biztypenumber_id":688864617560337408,"id":0,"isdefault":false,"seq":2}]}'); 