/*预算审批单编码规则 added by wangjun at 2019-11-04 */
DELETE FROM t_cr_coderule_l WHERE FID = '0BB8K1MN+FLE';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0BB8K1MN+FLE','0BB8K1MN1NU3','zh_TW','預算審批單編碼規則'); 
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0BB8K1MN+FLE','0BB8K1MN1NU4','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'},'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',' '); 

