-- 外购计划建议单据类型 im_planorder_BT_S
DELETE FROM T_BAS_BILLTYPE WHERE FID = 1393507777883857920;
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 (1393507777883857920,'0','0',NULL,'1',' ','0',1393507777883857920,'C','im_planorder',1,' ',' ','im_planorder_BT_S',{ts'2022-04-07  00:00:00'},'2C472983OA8+',NULL,1,'1',{ts'2022-04-07  00:00:00'},'1',1); 

DELETE FROM T_BAS_BILLTYPE_l WHERE FPKID = '2C54YAZKPW+4';
INSERT INTO T_BAS_BILLTYPE_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1393507777883857920,'2C54YAZKPW+4','zh_CN','外购计划建议','外购计划建议'); 
DELETE FROM T_BAS_BILLTYPE_l WHERE FPKID = '2C54YAZKPW+5';
INSERT INTO T_BAS_BILLTYPE_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1393507777883857920,'2C54YAZKPW+5','zh_TW','外購計劃建議','外購計劃建議'); 

-- 外购计划建议编码规则
DELETE FROM T_CR_CODERULE WHERE FID = '2C5514N881C+';
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 ('2C5514N881C+','-','1',' ','2',NULL,'2C5514N881C+','C','2C55+5YAAW+6',NULL,' ',{ts'2022-04-07  00:00:00'},'im_planorder','1',1,'0',{ts'2022-04-07  00:00:00'},0,NULL); 

DELETE FROM T_CR_CODERULE_L WHERE FPKID = '2C5514N88+NZ';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2C5514N881C+','2C5514N88+NZ','zh_CN','外购计划建议'); 
DELETE FROM T_CR_CODERULE_L WHERE FPKID = '2BOZ67PC9FO1';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2BIKKCI0IZ9E','2BOZ67PC9FO1','zh_CN','外購計劃建議');

DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '2C5514OBR0O4';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2C5514N881C+',1,'1',' ','0','2C5514OBR0O4',1,'1','1',0,8,'1','JHJY',' ','1',' ','0',' '); 
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '2C5514OBR0O5';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2C5514N881C+',1,'2','-','1','2C5514OBR0O5',1,'1',' ',1,8,'1','yyMMdd',' ','1','availabledate','1',' '); 
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '2C5514OBR0O6';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2C5514N881C+',1,'16','-','0','2C5514OBR0O6',1,'1',' ',2,8,'1',' ',' ','1',' ','1',' '); 




