DELETE FROM t_cr_coderule WHERE FID = '30LHN2MXDVG9';
INSERT INTO t_cr_coderule(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FRULETYPE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FDISABLERID,FISCHECKCODE,FID,FSPLITSIGN,FCTRLMODE,FDISABLEDATE,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','30LHN2MXDVG9','0',NULL,'0',{ts'2023-01-29  00:00:00'},'ifm_dptrevenue','1','0','0','1',NULL,'0','30LHN2MXDVG9','-','1',NULL,'0','C','30LHHZCTKKMA',' ','1',1205742215473681408,'0',{ts'2023-02-03  00:00:00'},0); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '30LHN2MXDUT/';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('30LHN2MXDVG9','30LHN2MXDUT/','zh_CN','内部存款收益处理'); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '310MDEE+5GK4';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('30LHN2MXDVG9',1,'1',' ','0','310MDEE+5GK4',1,'1','1',0,'1',8,'NBCKSY','1',' ',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '310MDEE+5GK5';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('30LHN2MXDVG9',1,'2','-','0','310MDEE+5GK5',1,'1',' ',1,'1',8,'yyyyMMdd','1',' ','createtime','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '310MDEE+5GK6';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('30LHN2MXDVG9',1,'16','-','0','310MDEE+5GK6',1,'1',' ',2,'1',4,' ','1',' ',' ','1',' '); 


DELETE FROM t_cr_coderule WHERE FID = '3100V8=6U/HV';
INSERT INTO t_cr_coderule(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FRULETYPE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FDISABLERID,FISCHECKCODE,FID,FSPLITSIGN,FCTRLMODE,FDISABLEDATE,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','3100V8=6U/HV','0',NULL,'0',{ts'2023-02-03  00:00:00'},'ifm_dptrevenuebatch','1','0','0','1',NULL,'0','3100V8=6U/HV','-','1',NULL,'0','C','3100RXHFFW+3',' ','1',1205742215473681408,'0',{ts'2023-02-03  00:00:00'},0); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '3100V8=6TZH2';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3100V8=6U/HV','3100V8=6TZH2','zh_CN','内部存款收益批量处理预置编码规则'); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '310MC975MDIK';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('3100V8=6U/HV',1,'1',' ','0','310MC975MDIK',1,'1','1',0,'1',8,'NBCKSYPL','1',' ',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '310MC975MDIL';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('3100V8=6U/HV',1,'2','-','0','310MC975MDIL',1,'1',' ',1,'1',8,'yyyyMMdd','1',' ','createtime','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '310MC975MDIM';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('3100V8=6U/HV',1,'16','-','0','310MC975MDIM',1,'1',' ',2,'1',4,' ','1',' ',' ','1',' '); 
