/*预算调整单、调剂单编码规则预置*/

DELETE FROM t_cr_coderule WHERE FID = '06QHIYM67MGS';
DELETE FROM t_cr_coderule WHERE FID = '06RGP68UIY7O';

DELETE FROM t_cr_coderule_l WHERE FID = '06QHIYM67MGS';
DELETE FROM t_cr_coderule_l WHERE FID = '06RGP68UIY7O';

DELETE FROM t_cr_coderuleentry WHERE FID = '06QHIYM67MGS';
DELETE FROM t_cr_coderuleentry WHERE FID = '06RGP68UIY7O';


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 ('06QHIYM67MGS','-','1',' ','1',null,'06QHIYM67MGS','C',' ',null,' ',{ts'2019-09-02  10:09:02'},'eb_adjustbill','1',405874707150149648,'0',{ts'2019-09-02  10:09:02'},405874707150149648,null); 
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 ('06RGP68UIY7O','-','1',' ','1',null,'06RGP68UIY7O','C',' ',null,' ',{ts'2019-09-02  16:54:48'},'eb_adjpstbill','1',405874707150149648,'0',{ts'2019-09-02  16:54:48'},405874707150149648,null); 

INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('06QHIYM67MGS','06QHIYM67L4=','zh_CN','预算调整单编码规则'); 
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('06QHIYM67MGS','06QHIYM67L49','zh_TW','預算調整單編碼規則'); 

INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('06RGP68UIY7O','06RGP68UIXJF','zh_CN','预算调剂单编码规则'); 
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('06RGP68UIY7O','06RGP68UIXJE','zh_TW','預算調劑單編碼規則'); 


INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('06QHIYM67MGS',1,'1',' ','0','06QHIYNO89K+',1,'1',' ',0,8,'1','ADJ',' ','1',' ','0',' '); 
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('06QHIYM67MGS',1,'2','-','0','06QHIYNO89K/',1,'1','1',1,8,'1','yyyyMMdd',' ','1','applydate','1',' '); 
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('06QHIYM67MGS',1,'16','-','0','06QHIYNO89K0',1,'1','1',2,6,'1',' ',' ','1',' ','1',' '); 

INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('06RGP68UIY7O',1,'1',' ','0','06RGP6BCAPJ5',1,'1',' ',0,8,'1','ADJP',' ','1',' ','0',' '); 
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('06RGP68UIY7O',1,'2','-','0','06RGP6BCAPJ6',1,'1','1',1,8,'1','yyyyMMdd',' ','1','applydate','1',' '); 
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('06RGP68UIY7O',1,'16','-','0','06RGP6BCAPJ7',1,'1','1',2,6,'1',' ',' ','1',' ','1',' '); 
