DELETE FROM T_CR_CodeRule WHERE FID = '03=HHEYWWAS5';
INSERT INTO T_CR_CodeRule(FID,FCTRLMODE,FSPLITSIGN,FEXAMPLE,FDISABLEDATE,FAPPMODE,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('03=HHEYWWAS5','1','-',' ',null,'2','03=HHEYWWAS5','C',' ',null,' ',{ts'2019-07-25  19:58:01'},'bei_bankpaybill','1','0',546346682883868672,{ts'2019-07-25  20:02:14'},546346682883868672,null); 

DELETE FROM t_cr_coderule_l WHERE FPKID = '03=HHEYWVW9I';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('03=HHEYWWAS5','03=HHEYWVW9I','zh_CN','银行付款单编码规则(资金)'); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '03=HHEYWVW9H';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('03=HHEYWWAS5','03=HHEYWVW9H','zh_TW','銀行付款單編碼規則(資金)'); 

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '03=HWWVKW5X+';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('03=HHEYWWAS5',1,'1',' ','0','03=HWWVKW5X+','1',1,' ',0,'1',8,'BTU','1',' ',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '03=HWWVKW5X/';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('03=HHEYWWAS5',1,'2','-','0','03=HWWVKW5X/','1',1,'1',1,'1',8,'yyyyMMdd','1',' ','createtime','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '03=HWWVKW5X0';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('03=HHEYWWAS5',1,'16','-','0','03=HWWVKW5X0','1',1,'1',2,'1',8,' ','1',' ',' ','1',' '); 






DELETE FROM T_CR_CodeRule WHERE FID = '0+=HIUKC/J1X';
INSERT INTO T_CR_CodeRule(FID,FCTRLMODE,FSPLITSIGN,FEXAMPLE,FDISABLEDATE,FAPPMODE,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('0+=HIUKC/J1X','1','-',' ',null,'2','0+=HIUKC/J1X','C',' ',null,' ',{ts'2019-05-30  16:10:44'},'bei_bankagentpay','1','0',546346682883868672,{ts'2019-07-25  20:02:21'},546346682883868672,null); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '0+=HIUKFMYL6';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0+=HIUKC/J1X','0+=HIUKFMYL6','zh_CN','银行代发单编码规则(资金)'); 

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '03=HXB/BXNVF';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('0+=HIUKC/J1X',1,'1',' ','0','03=HXB/BXNVF','1',1,' ',0,'1',8,'BPR','1',' ',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '03=HXB/BXNVG';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('0+=HIUKC/J1X',1,'2','-','0','03=HXB/BXNVG','1',1,'1',1,'1',8,'yyyyMM','1',' ','createtime','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '03=HXB/BXNVH';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('0+=HIUKC/J1X',1,'16','-','0','03=HXB/BXNVH','1',1,'1',2,'1',8,' ','1',' ',' ','1',' '); 






DELETE FROM T_CR_CodeRule WHERE FID = '03=HX6YSLD5Z';
INSERT INTO T_CR_CodeRule(FID,FCTRLMODE,FSPLITSIGN,FEXAMPLE,FDISABLEDATE,FAPPMODE,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('03=HX6YSLD5Z','1','-',' ',null,'2','03=HX6YSLD5Z','C',' ',null,' ',{ts'2019-07-25  20:02:19'},'bei_banktransupbill','1','0',546346682883868672,{ts'2019-07-25  20:02:19'},546346682883868672,null); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '03=HX6YSLCHQ';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('03=HX6YSLD5Z','03=HX6YSLCHQ','zh_CN','银行上划单编码规则(资金)'); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '03=HX6YSLCHP';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('03=HX6YSLD5Z','03=HX6YSLCHP','zh_TW','銀行上劃單編碼規則(資金)'); 

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '03=HX6ZBBWB0';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('03=HX6YSLD5Z',1,'1',' ','0','03=HX6ZBBWB0','1',1,' ',0,'1',8,'BTU','1',' ',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '03=HX6ZBBWB1';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('03=HX6YSLD5Z',1,'2','-','0','03=HX6ZBBWB1','1',1,'1',1,'1',8,'yyyyMMdd','1',' ','createtime','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '03=HX6ZBBWB2';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('03=HX6YSLD5Z',1,'16','-','0','03=HX6ZBBWB2','1',1,'1',2,'1',8,' ','1',' ',' ','1',' '); 



DELETE FROM T_CR_CodeRule WHERE FID = '03=HK6R0Q6X7';
INSERT INTO T_CR_CodeRule(FID,FCTRLMODE,FSPLITSIGN,FEXAMPLE,FDISABLEDATE,FAPPMODE,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('03=HK6R0Q6X7','1','-',' ',null,'2','03=HK6R0Q6X7','C',' ',null,' ',{ts'2019-07-25  19:58:47'},'bei_banktransdownbill','1','0',546346682883868672,{ts'2019-07-25  20:02:17'},546346682883868672,null); 

DELETE FROM t_cr_coderule_l WHERE FPKID = '03=HK6R0QNDX';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('03=HK6R0Q6X7','03=HK6R0QNDX','zh_CN','银行下拨单编码规则(资金)'); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '03=HK6R0QNDW';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('03=HK6R0Q6X7','03=HK6R0QNDW','zh_TW','銀行下撥單編碼規則(資金)'); 

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '03=HX1=IIS4U';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('03=HK6R0Q6X7',1,'1',' ','0','03=HX1=IIS4U','1',1,' ',0,'1',8,'BTU','1',' ',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '03=HX1=IIS4V';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('03=HK6R0Q6X7',1,'2','-','0','03=HX1=IIS4V','1',1,'1',1,'1',8,'yyyyMMdd','1',' ','createtime','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '03=HX1=IIS4W';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('03=HK6R0Q6X7',1,'16','-','0','03=HX1=IIS4W','1',1,'1',2,'1',8,' ','1',' ',' ','1',' '); 



DELETE FROM T_CR_CodeRule WHERE FID = '03COM04HZC5+';
INSERT INTO T_CR_CodeRule(FID,FCTRLMODE,FSPLITSIGN,FEXAMPLE,FDISABLEDATE,FAPPMODE,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('03COM04HZC5+','1','-',' ',null,'2','03COM04HZC5+','C',' ',null,' ',{ts'2019-07-26  17:57:50'},'bei_paybillupdatestatus','1','0',154770,{ts'2019-08-21  19:09:08'},695049,null); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '03COM04HZDHI';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('03COM04HZC5+','03COM04HZDHI','zh_CN','付款状态变更单编码规则'); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '03COM04HZDHH';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('03COM04HZC5+','03COM04HZDHH','zh_TW','付款狀態變更單編碼規則'); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '05P49OFU55DV';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('03COM04HZC5+',1,'1',' ','0','05P49OFU55DV','1',1,'1',0,'1',8,'BTU','1',' ',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '05P49OFU55DW';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('03COM04HZC5+',1,'2','-','0','05P49OFU55DW','1',1,'1',1,'1',8,'yyMMdd','1',' ','createtime','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '05P49OFU55DX';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('03COM04HZC5+',1,'16','-','0','05P49OFU55DX','1',1,'1',2,'1',8,' ','1',' ',' ','1',' '); 

