--仓位移动单编码规则更新
DELETE FROM T_CR_CODERULE WHERE FID = '0C+88RINK2PS';
INSERT INTO T_CR_CODERULE(FID,FSPLITSIGN,FCTRLMODE,FEXAMPLE,FDISABLEDATE,FISADDVIEW,FMASTERID,FSTATUS,FNUMBER,FISMODIFIABLE,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FENABLE,FMODIFIERID,FISUPDATERECOVER,FISNONBREAK,FMODIFYTIME,FISSERIALNUMBER,FCREATORID,FDISABLERID) VALUES ('0C+88RINK2PS','-','1',' ',NULL,'1','0C+88RINK2PS','C','cwyd001','0',NULL,' ',{ts'2019-11-11  14:47:54'},'im_locationtransfer','1',13466739,'1','0',{ts'2020-11-09  19:46:40'},'1',275188253840125478,NULL); 
DELETE FROM T_CR_CODERULE_L WHERE FID = '0C+88RINK2PS';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('0C+88RINK2PS','0C+88RIN8CIU','zh_CN','仓位移动单编码规则'); 
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('0C+88RINK2PS','16DWLYM1BF=7','zh_TW','倉位移動單編碼規則'); 
DELETE FROM T_CR_CODERULEENTRY WHERE FID = '0C+88RINK2PS';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('0C+88RINK2PS',1,'1',' ','0','16DWOF+91FRA',1,'1',' ',0,8,'1','CWYD',' ','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 ('0C+88RINK2PS',1,'2','-','1','16DWOF+91FRB',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 ('0C+88RINK2PS',1,'16','-','0','16DWOF+91FRC',1,'1','1',2,6,'1',' ',' ','1',' ','1',' '); 

--形态转换单编码规则更新
DELETE FROM T_CR_CodeRule WHERE FID = '08MHOUOEE2NL';
INSERT INTO T_CR_CodeRule(FID,FSPLITSIGN,FCTRLMODE,FEXAMPLE,FDISABLEDATE,FISADDVIEW,FMASTERID,FSTATUS,FNUMBER,FISMODIFIABLE,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FENABLE,FMODIFIERID,FISUPDATERECOVER,FISNONBREAK,FMODIFYTIME,FISSERIALNUMBER,FCREATORID,FDISABLERID) VALUES ('08MHOUOEE2NL','-','1',' ',NULL,'1','08MHOUOEE2NL','C','xtzh001','0',NULL,' ',{ts'2019-09-27  10:08:00'},'im_adjustbill','1',13466739,'1','0',{ts'2020-11-09  19:52:57'},'1',1,NULL); 
DELETE FROM T_CR_CODERULE_L WHERE FID = '08MHOUOEE2NL';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('08MHOUOEE2NL','08MHOUP91HN8','zh_CN','形态转换单编码规则'); 
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('08MHOUOEE2NL','08MHOUP91HN7','zh_TW','形態轉換單編碼規則'); 
DELETE FROM T_CR_CODERULEENTRY WHERE FID = '08MHOUOEE2NL';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('08MHOUOEE2NL',1,'1',' ','0','16DX9FX1KX+P',1,'1',' ',0,8,'1','XTZH',' ','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 ('08MHOUOEE2NL',1,'2','-','1','16DX9FX1KX+Q',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 ('08MHOUOEE2NL',1,'16','-','0','16DX9FX1KX+R',1,'1','1',2,6,'1',' ',' ','1',' ','1',' '); 

--组装单编码规则更新
DELETE FROM T_CR_CodeRule WHERE FID = '0APYAVFC5DGP';
INSERT INTO T_CR_CodeRule(FID,FSPLITSIGN,FCTRLMODE,FEXAMPLE,FDISABLEDATE,FISADDVIEW,FMASTERID,FSTATUS,FNUMBER,FISMODIFIABLE,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FENABLE,FMODIFIERID,FISUPDATERECOVER,FISNONBREAK,FMODIFYTIME,FISSERIALNUMBER,FCREATORID,FDISABLERID) VALUES ('0APYAVFC5DGP','-','1',' ',NULL,'1','0APYAVFC5DGP','C','zzd001','0',NULL,' ',{ts'2019-10-28  10:00:33'},'im_assembbill','1',13466739,'1','0',{ts'2020-11-09  19:53:50'},'1',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','16DXBR1AE7MB',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','16DXBR1AE7MC',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','16DXBR1AE7MD',1,'1','1',2,6,'1',' ',' ','1',' ','1',' '); 

--拆卸单编码规则更新
DELETE FROM T_CR_CodeRule WHERE FID = '0YEPTCSH8F+Z';
INSERT INTO T_CR_CodeRule(FID,FSPLITSIGN,FCTRLMODE,FEXAMPLE,FDISABLEDATE,FISADDVIEW,FMASTERID,FSTATUS,FNUMBER,FISMODIFIABLE,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FENABLE,FMODIFIERID,FISUPDATERECOVER,FISNONBREAK,FMODIFYTIME,FISSERIALNUMBER,FCREATORID,FDISABLERID) VALUES ('0YEPTCSH8F+Z','-','1',' ',NULL,'1','0YEPTCSH8F+Z','C','cxd001','0',NULL,' ',{ts'2020-07-20  17:52:57'},'im_disassemblebill','1',13466739,'1','0',{ts'2020-11-09  19:54:57'},'1',13466739,NULL); 
DELETE FROM T_CR_CODERULE_L WHERE FID = '0YEPTCSH8F+Z';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('0YEPTCSH8F+Z','0YEPTCSH8BMP','zh_CN','拆卸单编码规则'); 
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('0YEPTCSH8F+Z','0YEPTCSH8BMO','zh_TW','拆卸單編碼規則'); 
DELETE FROM T_CR_CODERULEENTRY WHERE FID = '0YEPTCSH8F+Z';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('0YEPTCSH8F+Z',1,'1',' ','0','16DXFUFFIK7K',1,'1',' ',0,8,'1','CXD',' ','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 ('0YEPTCSH8F+Z',1,'2','-','1','16DXFUFFIK7L',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 ('0YEPTCSH8F+Z',1,'16','-','0','16DXFUFFIK7M',1,'1','1',2,8,'1',' ',' ','1',' ','1',' '); 
