DELETE FROM t_cr_coderule WHERE FID = '3TOBDOTRAZ=2';
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,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','3TOBDOTRAZ=2','0',NULL,'0',{ts'2024-01-02  00:00:00'},'tccit_commissions_fees','1','0','1','1',NULL,'0','3TOBDOTRAZ=2','-','1',NULL,'0','C','3TOB9Z1C73BI',' ',13466739,'0',{ts'2024-01-02  00:00:00'},0); 


DELETE FROM t_cr_coderule_l WHERE FPKID = '3TOBDOTUZD4V';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3TOBDOTRAZ=2','3TOBDOTUZD4V','zh_CN','佣金手续费台账'); 


DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '3TOBDOWMQU9+';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('3TOBDOTRAZ=2',1,'1',' ','0','3TOBDOWMQU9+',1,'1','1',0,8,'1','CIT',' ','1',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '3TOBDOWMQU9/';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('3TOBDOTRAZ=2',1,'1','-','0','3TOBDOWMQU9/',1,'1','1',1,8,'1','RULE',' ','1',' ','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '3TOBDOWMQU90';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('3TOBDOTRAZ=2',1,'1','-','0','3TOBDOWMQU90',1,'1','1',2,8,'1','YJSXFZC',' ','1',' ','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '3TOBDOWMQU91';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('3TOBDOTRAZ=2',1,'16','-','0','3TOBDOWMQU91',1,'1',' ',3,5,'1',' ',' ','1',' ','1',' '); 
