--销售报表任务的编码规则
DELETE FROM t_cr_coderule WHERE FID = '28+0GZKE2NH7';
INSERT INTO t_cr_coderule(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FRULETYPE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISSERIALNUMBER,FDISABLERID,FISCHECKCODE,FID,FSPLITSIGN,FCTRLMODE,FDISABLEDATE,FISLOG,FSTATUS,FISAPPORG,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','28+0GZKE2NH7','0',NULL,'0',{ts'2022-02-08  00:00:00'},'sm_reporttask','1','0','1',NULL,'0','28+0GZKE2NH7','-','1',NULL,'0','C','0','28+084RCG2R+',' ','0',209852,'0',{ts'2022-04-11  00:00:00'},0); 

DELETE FROM t_cr_coderule_l WHERE FPKID = '28+0GZKE2Q68';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('28+0GZKE2NH7','28+0GZKE2Q68','zh_CN','销售报表任务'); 

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2CHVY519M3BK';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('28+0GZKE2NH7',1,'1',' ','0','2CHVY519M3BK',1,'1',' ',0,8,'1','TK',' ','1',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2CHVY519M3BL';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('28+0GZKE2NH7',1,'9','-','0','2CHVY519M3BL',1,'1',' ',1,8,'1','yyMMdd',' ','1',' ','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2CHVY519M3BM';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('28+0GZKE2NH7',1,'16','-','0','2CHVY519M3BM',1,'1',' ',2,6,'1',' ',' ','1',' ','1',' '); 






