-- 更新组装单编码规则
DELETE FROM T_CR_CodeRule WHERE FID = '0APYAVFC5DGP';
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 ('0APYAVFC5DGP','-','1',' ','2',NULL,'0APYAVFC5DGP','C',' ',NULL,' ',{ts'2019-10-28  10:00:33'},'im_assembbill','1',13466739,'0',{ts'2020-04-30  10:14:20'},1,NULL); 

DELETE FROM T_CR_CODERULE_L WHERE FID = '0APYAVFC5DGP';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('0APYAVFC5DGP','0APYAVFFV1VU','zh_CN','组装单编码规则'); 
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('0APYAVFC5DGP','0APYAVFFV1VT','zh_TW','組裝單編碼規則'); 

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