/*费用预算审批单编码规则 added by wangjun at 2020-02-12 */
DELETE FROM t_cr_coderule_l WHERE FID = '0BB8K1MN-FLE';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0BB8K1MN-FLE','0BB8K1MN-NU4','zh_CN','预算审批单编码规则');

DELETE FROM t_cr_coderule WHERE FID = '0BB8K1MN-FLE';
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 ('0BB8K1MN-FLE','-','1',' ','1',null,'0BB8K1MN-FLE','C',' ',null,' ',{ts'2019-11-04  10:03:37'},'bcm_eb_approvebill','1',13466739,'0',{ts'2019-11-04  10:03:37'},13466739,null); 

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '0BB8K1OSD-07';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('0BB8K1MN-FLE',1,'2',' ','0','0BB8K1OSD-07',1,'1','1',0,8,'1','yyyyMMdd',' ','1','approvecreatedate','0',' '); 

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '0BB8K1OSD-08';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('0BB8K1MN-FLE',1,'16','-','0','0BB8K1OSD-08',1,'1','1',1,6,'1',' ',' ','1',' ','1',' '); 
