--- 委外采购领料单
DELETE FROM T_BAS_BILLTYPE WHERE FID = 1444180604756164608;
INSERT INTO T_BAS_BILLTYPE(FID,FISSYSPRESET,FDOCUMENTSTATUS,FDEFWNREPORTTEMPLATE,FISDEFAULT,FDEFPRINTTEMPLATE,FCONTROLPRINTCOUNT,FMASTERID,FSTATUS,FBILLFORMID,FMAXPRINTCOUNT,FBILLCODERULEID,FBILLINITSETTING,FNUMBER,FCREATETIME,FLAYOUTSOLUTION,FPARASETTINGXML,FMODIFIERID,FENABLE,FMODIFYTIME,FPRINTAFTERAUDIT,FCREATORID) VALUES (1444180604756164608,'0','0',NULL,'1',' ','0',1444180604756164608,'C','im_osmaterialreqoutbill',1,' ',' ','im_osmaterialreqoutbill_BT_S',{ts'2022-06-16  00:00:00'},'2I=N8+86KMA6',NULL,1155582543786049536,'1',{ts'2022-06-16  00:00:00'},'1',1155582543786049536);

DELETE FROM T_BAS_BILLTYPE_l WHERE FPKID = '2ICXYBVWR83U';
INSERT INTO T_BAS_BILLTYPE_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1444180604756164608,'2ICXYBVWR83U','zh_CN',' ','委外采购领料单');
DELETE FROM T_BAS_BILLTYPE_l WHERE FPKID = '2ICXYBVWR83V';
INSERT INTO T_BAS_BILLTYPE_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1444180604756164608,'2ICXYBVWR83V','zh_TW',' ','委外采購領料單');

DELETE FROM t_bas_billtypeparameter WHERE FFORMID = 'im_osmaterialreqoutbill' and FBILLTYPEID = 1444180604756164608;
INSERT INTO t_bas_billtypeparameter(FFORMID,FBILLTYPEID,FDATA) VALUES ('im_osmaterialreqoutbill',1444180604756164608,'{"_Type_":"bd_billtypeparameter","entryentity":[{"_Type_":"entryentity","biztypenumber":{"number":"115","masterid":1442618928659432448,"_Type_":"bd_biztype","multilanguagetext":[{"_Type_":"locale","pkid":"2I6F4FH7DPFN","name":"委外采购","description":"","localeid":"zh_CN"},{"_Type_":"locale","pkid":"2I6F4FH7DPFO","name":"委外采購","description":"","localeid":"zh_TW"}],"ispreset":true,"name":{"zh_TW":"委外采購","GLang":"委外采购","zh_CN":"委外采购"},"id":1442618928659432448},"ispreset":true,"biztypenumber_id":1442618928659432448,"id":0,"isdefault":true,"seq":1},{"_Type_":"entryentity","biztypenumber":{"number":"1151","masterid":1442619247460089856,"_Type_":"bd_biztype","multilanguagetext":[{"_Type_":"locale","pkid":"2I6F6S2N1U24","name":"委外采购退货","description":"","localeid":"zh_CN"},{"_Type_":"locale","pkid":"2I6F6S2N1U25","name":"委外采購退貨","description":"","localeid":"zh_TW"}],"ispreset":true,"name":{"zh_TW":"委外采購退貨","GLang":"委外采购退货","zh_CN":"委外采购退货"},"id":1442619247460089856},"ispreset":true,"biztypenumber_id":1442619247460089856,"id":0,"isdefault":false,"seq":2}]}');

DELETE FROM T_CR_CODERULE WHERE FID = '2IGCU7IB=FGC';
INSERT INTO T_CR_CODERULE(FID,FSPLITSIGN,FCTRLMODE,FEXAMPLE,FAPPMODE,FDISABLEDATE,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FENABLE,FMODIFIERID,FISUPDATERECOVER,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('2IGCU7IB=FGC','-','1',' ','2',NULL,'2IGCU7IB=FGC','C','2IFU+DBDKNDW',NULL,' ',{ts'2022-06-17  00:00:00'},'im_osmaterialreqoutbill','1',1155582543786049536,'0',{ts'2022-06-17  00:00:00'},0,NULL);

DELETE FROM T_CR_CODERULE_L WHERE FPKID = '2IGCU7IEXV+M';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2IGCU7IB=FGC','2IGCU7IEXV+M','zh_CN','委外采购领料单编码规则');
DELETE FROM T_CR_CODERULE_L WHERE FPKID = '2IGD3PSXZSVK';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2IGCU7IB=FGC','2IGD3PSXZSVK','zh_TW','委外采購領料單編碼規則');

DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '2IGDWY1WM=QV';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2IGCU7IB=FGC',1,'1',' ','0','2IGDWY1WM=QV',1,'1','1',0,8,'1','WWLLCK',' ','1',' ','0',' ');
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '2IGDWY1WM=QW';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2IGCU7IB=FGC',1,'2','-','1','2IGDWY1WM=QW',1,'1',' ',1,8,'1','yyMMdd',' ','1','biztime','1',' ');
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '2IGDWY1WM=QX';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2IGCU7IB=FGC',1,'16','-','0','2IGDWY1WM=QX',1,'1',' ',2,6,'1',' ',' ','1',' ','1',' ');



---委外采购入库单
DELETE FROM T_BAS_BILLTYPE WHERE FID = 1444181245796811776;
INSERT INTO T_BAS_BILLTYPE(FID,FISSYSPRESET,FDOCUMENTSTATUS,FDEFWNREPORTTEMPLATE,FISDEFAULT,FDEFPRINTTEMPLATE,FCONTROLPRINTCOUNT,FMASTERID,FSTATUS,FBILLFORMID,FMAXPRINTCOUNT,FBILLCODERULEID,FBILLINITSETTING,FNUMBER,FCREATETIME,FLAYOUTSOLUTION,FPARASETTINGXML,FMODIFIERID,FENABLE,FMODIFYTIME,FPRINTAFTERAUDIT,FCREATORID) VALUES (1444181245796811776,'0','0',NULL,'1',' ','0',1444181245796811776,'C','im_ospurinbill',1,' ',' ','im_ospurinbill_BT_S',{ts'2022-06-16  00:00:00'},'2I=NAZQ7JJ3M',NULL,1155582543786049536,'1',{ts'2022-06-16  00:00:00'},'1',1155582543786049536);

DELETE FROM T_BAS_BILLTYPE_l WHERE FPKID = '2ICY100S484S';
INSERT INTO T_BAS_BILLTYPE_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1444181245796811776,'2ICY100S484S','zh_CN',' ','委外采购入库单');
DELETE FROM T_BAS_BILLTYPE_l WHERE FPKID = '2ICY100S484T';
INSERT INTO T_BAS_BILLTYPE_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1444181245796811776,'2ICY100S484T','zh_TW',' ','委外采購入庫單');

DELETE FROM t_bas_billtypeparameter WHERE FFORMID = 'im_ospurinbill' and FBILLTYPEID = 1444181245796811776;
INSERT INTO t_bas_billtypeparameter(FFORMID,FBILLTYPEID,FDATA) VALUES ('im_ospurinbill',1444181245796811776,'{"_Type_":"bd_billtypeparameter","entryentity":[{"_Type_":"entryentity","biztypenumber":{"number":"115","masterid":1442618928659432448,"_Type_":"bd_biztype","multilanguagetext":[{"_Type_":"locale","pkid":"2I6F4FH7DPFN","name":"委外采购","description":"","localeid":"zh_CN"},{"_Type_":"locale","pkid":"2I6F4FH7DPFO","name":"委外采購","description":"","localeid":"zh_TW"}],"ispreset":true,"name":{"zh_TW":"委外采購","GLang":"委外采购","zh_CN":"委外采购"},"id":1442618928659432448},"ispreset":true,"biztypenumber_id":1442618928659432448,"id":0,"isdefault":true,"seq":1},{"_Type_":"entryentity","biztypenumber":{"number":"1151","masterid":1442619247460089856,"_Type_":"bd_biztype","multilanguagetext":[{"_Type_":"locale","pkid":"2I6F6S2N1U24","name":"委外采购退货","description":"","localeid":"zh_CN"},{"_Type_":"locale","pkid":"2I6F6S2N1U25","name":"委外采購退貨","description":"","localeid":"zh_TW"}],"ispreset":true,"name":{"zh_TW":"委外采購退貨","GLang":"委外采购退货","zh_CN":"委外采购退货"},"id":1442619247460089856},"ispreset":true,"biztypenumber_id":1442619247460089856,"id":0,"isdefault":false,"seq":2}]}');

DELETE FROM T_CR_CODERULE WHERE FID = '2IGD8ZMQ019X';
INSERT INTO T_CR_CODERULE(FID,FSPLITSIGN,FCTRLMODE,FEXAMPLE,FAPPMODE,FDISABLEDATE,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FENABLE,FMODIFIERID,FISUPDATERECOVER,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('2IGD8ZMQ019X','-','1',' ','2',NULL,'2IGD8ZMQ019X','C','2IGD+KNRAI7T',NULL,' ',{ts'2022-06-17  00:00:00'},'im_ospurinbill','1',1155582543786049536,'0',{ts'2022-06-17  00:00:00'},0,NULL);

DELETE FROM T_CR_CODERULE_L WHERE FPKID = '2IGD8ZMQ01Z6';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2IGD8ZMQ019X','2IGD8ZMQ01Z6','zh_CN','委外采购入库单编码规则');
DELETE FROM T_CR_CODERULE_L WHERE FPKID = '2IGD8ZMQ01Z5';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2IGD8ZMQ019X','2IGD8ZMQ01Z5','zh_TW','委外采購入庫單編碼規則');

DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '2IGD8ZNCDZMH';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2IGD8ZMQ019X',1,'1',' ','0','2IGD8ZNCDZMH',1,'1','1',0,8,'1','WWCGRK',' ','1',' ','0',' ');
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '2IGD8ZNCDZMI';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2IGD8ZMQ019X',1,'2','-','1','2IGD8ZNCDZMI',1,'1',' ',1,8,'1','yyMMdd',' ','1','biztime','1',' ');
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '2IGD8ZNCDZMJ';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2IGD8ZMQ019X',1,'16','-','0','2IGD8ZNCDZMJ',1,'1',' ',2,6,'1',' ',' ','1',' ','1',' ');



DELETE FROM T_BAS_BILLTYPE WHERE FID = 1444181835524341760;
INSERT INTO T_BAS_BILLTYPE(FID,FISSYSPRESET,FDOCUMENTSTATUS,FDEFWNREPORTTEMPLATE,FISDEFAULT,FDEFPRINTTEMPLATE,FCONTROLPRINTCOUNT,FMASTERID,FSTATUS,FBILLFORMID,FMAXPRINTCOUNT,FBILLCODERULEID,FBILLINITSETTING,FNUMBER,FCREATETIME,FLAYOUTSOLUTION,FPARASETTINGXML,FMODIFIERID,FENABLE,FMODIFYTIME,FPRINTAFTERAUDIT,FCREATORID) VALUES (1444181835524341760,'0','0',NULL,'0',' ','0',1444181835524341760,'C','im_purreceivebill',1,' ',' ','im_purreceivebill_WW_BT_S',{ts'2022-06-16  00:00:00'},'/Z43CHZ/D7C8',NULL,1155582543786049536,'1',{ts'2022-06-16  00:00:00'},'1',1155582543786049536);


DELETE FROM T_BAS_BILLTYPE_l WHERE FPKID = '2ICY5AMY2I5A';
INSERT INTO T_BAS_BILLTYPE_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1444181835524341760,'2ICY5AMY2I5A','zh_CN',' ','委外采购收货单');
DELETE FROM T_BAS_BILLTYPE_l WHERE FPKID = '2ICY5AMY2I5B';
INSERT INTO T_BAS_BILLTYPE_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1444181835524341760,'2ICY5AMY2I5B','zh_TW',' ','委外采購收貨單');


DELETE FROM t_bas_billtypeparameter WHERE FFORMID = 'im_purreceivebill' and FBILLTYPEID = 1444181835524341760;
INSERT INTO t_bas_billtypeparameter(FFORMID,FBILLTYPEID,FDATA) VALUES ('im_purreceivebill',1444181835524341760,'{"_Type_":"bd_billtypeparameter","entryentity":[{"_Type_":"entryentity","biztypenumber":{"number":"115","masterid":1442618928659432448,"_Type_":"bd_biztype","multilanguagetext":[{"_Type_":"locale","pkid":"2I6F4FH7DPFN","name":"委外采购","description":"","localeid":"zh_CN"},{"_Type_":"locale","pkid":"2I6F4FH7DPFO","name":"委外采購","description":"","localeid":"zh_TW"}],"ispreset":true,"name":{"zh_TW":"委外采購","GLang":"委外采购","zh_CN":"委外采购"},"id":1442618928659432448},"ispreset":true,"biztypenumber_id":1442618928659432448,"id":0,"isdefault":true,"seq":1},{"_Type_":"entryentity","biztypenumber":{"number":"1151","masterid":1442619247460089856,"_Type_":"bd_biztype","multilanguagetext":[{"_Type_":"locale","pkid":"2I6F6S2N1U24","name":"委外采购退货","description":"","localeid":"zh_CN"},{"_Type_":"locale","pkid":"2I6F6S2N1U25","name":"委外采購退貨","description":"","localeid":"zh_TW"}],"ispreset":true,"name":{"zh_TW":"委外采購退貨","GLang":"委外采购退货","zh_CN":"委外采购退货"},"id":1442619247460089856},"ispreset":true,"biztypenumber_id":1442619247460089856,"id":0,"isdefault":false,"seq":2}]}');
