DELETE FROM t_cr_coderule WHERE FID = '17COGOHE95K=';
INSERT INTO t_cr_coderule(FID,FSPLITSIGN,FCTRLMODE,FEXAMPLE,FAPPMODE,FDISABLEDATE,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FENABLE,FMODIFIERID,FISUPDATERECOVER,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('17COGOHE95K=','-','1',' ','2',NULL,'17COGOHE95K=','C','17COB+QHD+RO',NULL,' ',{ts'2020-11-20  16:58:19'},'pur_thirddata','1',89186823,'0',{ts'2020-11-20  17:00:38'},0,NULL); 

DELETE FROM t_cr_coderule_l WHERE FPKID = '17COGOHE8DZ/';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('17COGOHE95K=','17COGOHE8DZ/','zh_CN','电商对账数据'); 

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '17COP41DBH6U';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('17COGOHE95K=',1,'1',' ','0','17COP41DBH6U',1,'1','1',0,8,'1','chk',' ','1',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '17COP41DBH6V';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('17COGOHE95K=',1,'9','-','0','17COP41DBH6V',1,'1',' ',1,8,'1','yyyyMMdd',' ','1',' ','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '17COP41DBH6W';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('17COGOHE95K=',1,'16','-','0','17COP41DBH6W',1,'1',' ',2,8,'1',' ',' ','1',' ','1',' '); 

