DELETE FROM t_cr_coderule WHERE FID = '2QHRGHH8Y3Y1';
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 ('2QHRGHH8Y3Y1','1','-',' ',NULL,'2','2QHRGHH8Y3Y1','C','2QHRE11N1RXY',NULL,' ',{ts'2022-09-15  00:00:00'},'ifm_intbill_batch_bank','1','0',1205742215473681408,{ts'2022-10-02  00:00:00'},0,NULL); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '2QHRGHH8U7S3';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2QHRGHH8Y3Y1','2QHRGHH8U7S3','zh_CN','计息对象批量结息处理预置编码规则'); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '2S+ALZGAQG0P';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2QHRGHH8Y3Y1','2S+ALZGAQG0P','zh_TW','計息對象批量結息處理預置編碼規則'); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2SI9WV1YPFX2';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2QHRGHH8Y3Y1',1,'1',' ','0','2SI9WV1YPFX2','1',1,'1',0,'1',8,'DXJX','1',' ',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2SI9WV1YPFX3';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2QHRGHH8Y3Y1',1,'2',' ','1','2SI9WV1YPFX3','1',1,' ',1,'1',8,'yyyyMMdd','1',' ','createtime','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2SI9WV1YPFX4';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2QHRGHH8Y3Y1',1,'16',' ','0','2SI9WV1YPFX4','1',1,' ',2,'1',4,' ','1',' ',' ','0',' '); 


DELETE FROM t_cr_coderule WHERE FID = '2S8XUBC7BR+H';
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 ('2S8XUBC7BR+H','1','-',' ',NULL,'2','2S8XUBC7BR+H','C','2S8XQJZNHLGA',NULL,' ',{ts'2022-10-05  00:00:00'},'ifm_accrual_batch_bank','1','0',1205742215473681408,{ts'2022-10-08  00:00:00'},0,NULL); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '2S8XUBC7I/CL';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2S8XUBC7BR+H','2S8XUBC7I/CL','zh_CN','计息对象预提批量处理预置编码规则'); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '2S8XUBC7I/CK';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2S8XUBC7BR+H','2S8XUBC7I/CK','zh_TW','計息對象預提批量處理預置編碼規則'); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2SI=+2CO1ZB/';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2S8XUBC7BR+H',1,'1',' ','0','2SI=+2CO1ZB/','1',1,'1',0,'1',8,'PLYT','1',' ',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2SI=+2CO1ZB0';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2S8XUBC7BR+H',1,'2',' ','0','2SI=+2CO1ZB0','1',1,' ',1,'1',8,'yyyyMMdd','1',' ','bizdate','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2SI=+2CO1ZB1';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2S8XUBC7BR+H',1,'16',' ','0','2SI=+2CO1ZB1','1',1,' ',2,'1',4,' ','1',' ',' ','0',' '); 


DELETE FROM t_cr_coderule WHERE FID = '2S58JYV=TPWT';
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 ('2S58JYV=TPWT','1','-',' ',NULL,'2','2S58JYV=TPWT','C','2S58DUGMCAF5',NULL,' ',{ts'2022-10-04  00:00:00'},'ifm_currentintbill_bank','1','0',1205742215473681408,{ts'2022-10-04  00:00:00'},0,NULL); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '2S58JYV=T5BM';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2S58JYV=TPWT','2S58JYV=T5BM','zh_CN','计息对象结息处理预置编码规则'); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '2S58JYV=T5BL';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2S58JYV=TPWT','2S58JYV=T5BL','zh_TW','計息對象結息處理預置編碼規則'); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2S58JYX+26C0';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2S58JYV=TPWT',1,'8',' ','0','2S58JYX+26C0','1',1,'3',0,'1',8,' ','1',' ','batchno','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2S58JYX+26C1';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2S58JYV=TPWT',1,'1',' ','0','2S58JYX+26C1','1',1,'1',1,'1',8,'JX','1',' ',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2S58JYX+26C2';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2S58JYV=TPWT',1,'16',' ','0','2S58JYX+26C2','1',1,' ',2,'1',6,' ','1',' ',' ','0',' '); 


DELETE FROM t_cr_coderule WHERE FID = '2S8XYQ=X8YSS';
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 ('2S8XYQ=X8YSS','1','-',' ',NULL,'2','2S8XYQ=X8YSS','C','2S8XV6X/2WLU',NULL,' ',{ts'2022-10-05  00:00:00'},'ifm_preintbill_bank','1','0',1205742215473681408,{ts'2022-10-05  00:00:00'},0,NULL); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '2S8XYQ=XE75W';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2S8XYQ=X8YSS','2S8XYQ=XE75W','zh_CN','计息对象预提处理预置编码规则'); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '2S8XYQ=XE75V';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2S8XYQ=X8YSS','2S8XYQ=XE75V','zh_TW','計息對象預提處理預置編碼規則'); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2S8XYQAG/EYV';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2S8XYQ=X8YSS',1,'8',' ','0','2S8XYQAG/EYV','1',1,'3',0,'1',8,' ','1',' ','batchno','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2S8XYQAG/EYW';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2S8XYQ=X8YSS',1,'1',' ','0','2S8XYQAG/EYW','1',1,'1',1,'1',8,'YT','1',' ',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2S8XYQAG/EYX';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2S8XYQ=X8YSS',1,'16',' ','0','2S8XYQAG/EYX','1',1,' ',2,'1',6,' ','1',' ',' ','0',' '); 








