-- 新增VMI结算记录的编码规则 2019-10-21
-- t_cr_coderule
DELETE FROM t_cr_coderule WHERE FID = '0A39P7ZU4Q9O';
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 ('0A39P7ZU4Q9O','-','1',' ','2',null,'0A39P7ZU4Q9O','C',' ',null,' ',{ts'2019-10-21  14:29:46'},'pm_vmi_settlementrecord','1',13466739,'0',{ts'2019-10-21  14:30:33'},13466739,null); 

-- t_cr_coderule_l
DELETE FROM t_cr_coderule_l WHERE FPKID = '0A39P7ZU0ND6';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0A39P7ZU4Q9O','0A39P7ZU0ND6','zh_CN','VMI结算记录编码规则'); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '0A39P7ZU0ND5';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0A39P7ZU4Q9O','0A39P7ZU0ND5','zh_TW','VMI結算記錄編碼規則'); 

-- t_cr_coderuleentry
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '0A39S3D8W3ER';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('0A39P7ZU4Q9O',1,'1',' ','0','0A39S3D8W3ER',1,'1',' ',0,8,'1','VMIJSJL',' ','1',' ','0',' '); 

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '0A39S3D8W3ES';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('0A39P7ZU4Q9O',1,'2','-','0','0A39S3D8W3ES',1,'1','1',1,8,'1','yyMMdd',' ','1','settlementdate','1',' '); 

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '0A39S3D8W3ET';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('0A39P7ZU4Q9O',1,'16','-','0','0A39S3D8W3ET',1,'1','1',2,6,'1',' ',' ','1',' ','1',' '); 

