--付款预警规则预置
DELETE FROM t_cr_coderule_l WHERE fid = (SELECT FID FROM t_cr_coderule WHERE FBIZOBJECTID = 'cas_paywarnset');
DELETE FROM t_cr_coderuleentry WHERE fid = (SELECT FID FROM t_cr_coderule WHERE FBIZOBJECTID = 'cas_paywarnset');
DELETE FROM t_cr_coderule WHERE FBIZOBJECTID = 'cas_paywarnset';

DELETE FROM t_cr_coderule WHERE FID = '0RUAVE=U08Y/';
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 ('0RUAVE=U08Y/','1','-',' ',NULL,'2','0RUAVE=U08Y/','C',' ',NULL,' ',{ts'2020-05-07  14:54:34'},'cas_paywarnset','1','0',859854237998279680,{ts'2020-05-07  15:10:41'},859854237998279680,NULL); 

DELETE FROM t_cr_coderule_l WHERE FPKID = '0RUAVE=XPK5R';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0RUAVE=U08Y/','0RUAVE=XPK5R','zh_CN','付款预警编码规则'); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '0RUAVE=XPK5Q';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0RUAVE=U08Y/','0RUAVE=XPK5Q','zh_TW','付款預警編碼規則'); 

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '0RUD5D2HGR1H';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('0RUAVE=U08Y/',1,'1',' ','0','0RUD5D2HGR1H','1',1,' ',0,'1',8,'CASYJ','1',' ',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '0RUD5D2HGR1I';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('0RUAVE=U08Y/',1,'16','-','0','0RUD5D2HGR1I','1',1,'1',1,'1',4,' ','1',' ',' ','1',' '); 
