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

DELETE FROM t_cr_coderule WHERE FID = '1=4L7ZEJON3U';
DELETE FROM t_cr_coderule WHERE FID = '1==I5FJTVCG5';

DELETE FROM t_cr_coderule_l WHERE FID = '1=4L7ZEJON3U';
DELETE FROM t_cr_coderule_l WHERE FID = '1==I5FJTVCG5';

DELETE FROM t_cr_coderuleentry WHERE FID = '1=4L7ZEJON3U';
DELETE FROM t_cr_coderuleentry WHERE FID = '1==I5FJTVCG5';

Insert into T_CR_CODERULE (FID,FNUMBER,FRULETYPE,FBIZOBJECTID,FSPLITSIGN,FCTRLMODE,FAPPMODE,FEXAMPLE,FEXAMPLELENGTH,FENABLE,FSTATUS,FCREATORID,FCREATETIME,FMODIFIERID,FMODIFYTIME,FDISABLERID,FDISABLEDATE,FMASTERID,FISUPDATERECOVER,FISADDVIEW,FISMODIFIABLE,FISUNIQUE,FISSERIALNUMBER,FISLOG,FISAPPORG,FISAPPCONDITION,FISCHECKCODE,FISNONBREAK,FISFAST) values ('1=4L7ZEJON3U','1=4L29XS2UFD',null,'bgm_adjpstbill','-','1','2',' ',' ','1','C',0,{ts'2020-12-23 11:11:11'},0,{ts'2020-12-23 11:11:11'},null,null,'1=4L7ZEJON3U','0','0','0','0','1','0','0','0','0','0','0');
Insert into T_CR_CODERULE (FID,FNUMBER,FRULETYPE,FBIZOBJECTID,FSPLITSIGN,FCTRLMODE,FAPPMODE,FEXAMPLE,FEXAMPLELENGTH,FENABLE,FSTATUS,FCREATORID,FCREATETIME,FMODIFIERID,FMODIFYTIME,FDISABLERID,FDISABLEDATE,FMASTERID,FISUPDATERECOVER,FISADDVIEW,FISMODIFIABLE,FISUNIQUE,FISSERIALNUMBER,FISLOG,FISAPPORG,FISAPPCONDITION,FISCHECKCODE,FISNONBREAK,FISFAST) values ('1==I5FJTVCG5','1==I1FW95QOX',null,'bgm_adjustbill','-','1','2',' ',' ','1','C',0,{ts'2020-12-23 11:11:11'},0,{ts'2020-12-23 11:11:11'},null,null,'1==I5FJTVCG5','0','1','0','0','1','0','0','0','0','0','0');


Insert into T_CR_CODERULE_L (FPKID,FID,FLOCALEID,FNAME) values ('1=4L7ZENC5FN','1=4L7ZEJON3U','zh_CN','全面预算调剂单');
Insert into T_CR_CODERULE_L (FPKID,FID,FLOCALEID,FNAME) values ('1=4L7ZENC5FM','1=4L7ZEJON3U','zh_TW','全麵預算調劑單');
Insert into T_CR_CODERULE_L (FPKID,FID,FLOCALEID,FNAME) values ('1==I5FJTV9EM','1==I5FJTVCG5','zh_CN','全面预算调整单');

Insert into T_CR_CODERULEENTRY (FENTRYID,FID,FSEQ,FATTRIBUTETYPE,FATTUSINGMODE,FVALUEATRIBUTE,FFORMAT,FSETTINGVALUE,FLENGTH,FINITIAL,FSTEP,FADDCHAR,FISSPLITSIGN,FADDSTYLE,FCUTSTYLE,FISSORTITEM,FSPLITSIGN,FISVISABLE) values ('1=4L7ZF71JGE','1=4L7ZEJON3U',0,'1',' ',' ','BGM_ADJP',' ',8,1,1,' ','0','1','1','0',' ','1');
Insert into T_CR_CODERULEENTRY (FENTRYID,FID,FSEQ,FATTRIBUTETYPE,FATTUSINGMODE,FVALUEATRIBUTE,FFORMAT,FSETTINGVALUE,FLENGTH,FINITIAL,FSTEP,FADDCHAR,FISSPLITSIGN,FADDSTYLE,FCUTSTYLE,FISSORTITEM,FSPLITSIGN,FISVISABLE) values ('1=4L7ZF71JGF','1=4L7ZEJON3U',1,'2',' ','applydate','yyyyMMdd',' ',8,1,1,' ','1','1','1','0','-','1');
Insert into T_CR_CODERULEENTRY (FENTRYID,FID,FSEQ,FATTRIBUTETYPE,FATTUSINGMODE,FVALUEATRIBUTE,FFORMAT,FSETTINGVALUE,FLENGTH,FINITIAL,FSTEP,FADDCHAR,FISSPLITSIGN,FADDSTYLE,FCUTSTYLE,FISSORTITEM,FSPLITSIGN,FISVISABLE) values ('1=4L7ZF71JGG','1=4L7ZEJON3U',2,'16',' ',' ',' ',' ',6,1,1,' ','1','1','1','0','-','1');
Insert into T_CR_CODERULEENTRY (FENTRYID,FID,FSEQ,FATTRIBUTETYPE,FATTUSINGMODE,FVALUEATRIBUTE,FFORMAT,FSETTINGVALUE,FLENGTH,FINITIAL,FSTEP,FADDCHAR,FISSPLITSIGN,FADDSTYLE,FCUTSTYLE,FISSORTITEM,FSPLITSIGN,FISVISABLE) values ('1==I5FLH3UYD','1==I5FJTVCG5',0,'1','1',' ','BGM_ADJ',' ',8,1,1,' ','0','1','1','0',' ','1');
Insert into T_CR_CODERULEENTRY (FENTRYID,FID,FSEQ,FATTRIBUTETYPE,FATTUSINGMODE,FVALUEATRIBUTE,FFORMAT,FSETTINGVALUE,FLENGTH,FINITIAL,FSTEP,FADDCHAR,FISSPLITSIGN,FADDSTYLE,FCUTSTYLE,FISSORTITEM,FSPLITSIGN,FISVISABLE) values ('1==I5FLH3UYE','1==I5FJTVCG5',1,'2',' ','applydate','yyyyMMdd',' ',8,1,1,' ','1','1','1','0','-','1');
Insert into T_CR_CODERULEENTRY (FENTRYID,FID,FSEQ,FATTRIBUTETYPE,FATTUSINGMODE,FVALUEATRIBUTE,FFORMAT,FSETTINGVALUE,FLENGTH,FINITIAL,FSTEP,FADDCHAR,FISSPLITSIGN,FADDSTYLE,FCUTSTYLE,FISSORTITEM,FSPLITSIGN,FISVISABLE) values ('1==I5FLH3UYF','1==I5FJTVCG5',2,'16',' ',' ',' ',' ',6,1,1,' ','1','1','1','0','-','1');


