/** 立项分摊单 默认单据类型**/
DELETE FROM T_BAS_BILLTYPE WHERE fid = 1179660282566346752;
INSERT INTO T_BAS_BILLTYPE(fid,fissyspreset,fdefwnreporttemplate,fdocumentstatus,fdefprinttemplate,fisdefault,fcontrolprintcount,fmasterid,fstatus,fbillformid,fmaxprintcount,fbillinitsetting,fbillcoderuleid,fnumber,fcreatetime,flayoutsolution,fparasettingxml,fmodifierid,fenable,fmodifytime,fprintafteraudit,fcreatorid) VALUES (1179660282566346752,'0',NULL,'0',' ','0','0',1179660282566346752,'C','er_applyprojectbill',1,' ',' ','er_projectsharebill_BT_S',{ts'2021-06-16  00:00:00'},'1OWK5NEP7ZJ5',NULL,1155766321963628544,'1',{ts'2021-06-16  00:00:00'},'0',1155766321963628544); 

DELETE FROM T_BAS_BILLTYPE_l WHERE fpkid = '1OWMF==K+AFF';
INSERT INTO T_BAS_BILLTYPE_l(fid,fpkid,flocaleid,fdescription,fname) VALUES (1179660282566346752,'1OWMF==K+AFF','zh_CN',' ','立项分摊'); 
DELETE FROM T_BAS_BILLTYPE_l WHERE fpkid = '1OWMF==K+AFG';
INSERT INTO T_BAS_BILLTYPE_l(fid,fpkid,flocaleid,fdescription,fname) VALUES (1179660282566346752,'1OWMF==K+AFG','zh_TW',' ','立項分攤'); 


/** 费用暂估分摊单 默认单据类型**/
DELETE FROM T_BAS_BILLTYPE WHERE fid = 1179679098256036864;
INSERT INTO T_BAS_BILLTYPE(fid,fissyspreset,fdocumentstatus,fdefwnreporttemplate,fisdefault,fdefprinttemplate,fcontrolprintcount,fmasterid,fstatus,fbillformid,fmaxprintcount,fbillcoderuleid,fbillinitsetting,fnumber,fcreatetime,flayoutsolution,fparasettingxml,fmodifierid,fenable,fmodifytime,fprintafteraudit,fcreatorid) VALUES (1179679098256036864,'0','0',NULL,'0',' ','0',1179679098256036864,'C','er_costestimatebill',1,' ',' ','er_costestimatesharebill_BT_S',{ts'2021-06-16  00:00:00'},'1OWOJ8UBYG1P',NULL,1155766321963628544,'1',{ts'2021-06-16  00:00:00'},'0',1155766321963628544); 

DELETE FROM T_BAS_BILLTYPE_l WHERE fpkid = '1OWPZDJF8T50';
INSERT INTO T_BAS_BILLTYPE_l(fid,fpkid,flocaleid,fdescription,fname) VALUES (1179679098256036864,'1OWPZDJF8T50','zh_CN',' ','暂估分摊'); 
DELETE FROM T_BAS_BILLTYPE_l WHERE fpkid = '1OWPZDJF8T51';
INSERT INTO T_BAS_BILLTYPE_l(fid,fpkid,flocaleid,fdescription,fname) VALUES (1179679098256036864,'1OWPZDJF8T51','zh_TW',' ','暫估分攤'); 


/** 立项分摊单 编号规则**/

DELETE FROM t_cr_coderule WHERE fid = '1OFDS7VJU=NW';
INSERT INTO t_cr_coderule(fexample,fappmode,fisaddview,fisappcondition,fmasterid,fisunique,fruletype,fismodifiable,fcreatetime,fbizobjectid,fisupdaterecover,fenable,fisapporg,fisserialnumber,fdisablerid,fischeckcode,fid,fsplitsign,fctrlmode,fdisabledate,fislog,fstatus,fnumber,fexamplelength,fisfast,fmodifierid,fisnonbreak,fmodifytime,fcreatorid) VALUES (' ','2','1','1','1OFDS7VJU=NW','0',NULL,'0',{ts'2021-06-11  00:00:00'},'er_applyprojectbill','0','1','0','1',NULL,'0','1OFDS7VJU=NW','-','1',NULL,'0','C','1OFDN=/8G1NE',' ','0',1155766321963628544,'1',{ts'2021-06-11  00:00:00'},0); 

DELETE FROM t_cr_coderuleentry WHERE fentryid = '1OFDV3KLTKX1';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fstep,fcutstyle,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1OFDS7VJU=NW',1,'1',' ','0','1OFDV3KLTKX1',1,'1','1',0,'1',8,'LXFT','1',' ',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE fentryid = '1OFDV3KLTKX2';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fstep,fcutstyle,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1OFDS7VJU=NW',1,'2','-','1','1OFDV3KLTKX2',1,'1',' ',1,'1',8,'yyyyMMdd','1',' ','bizdate','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE fentryid = '1OFDV3KLTKX3';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fstep,fcutstyle,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1OFDS7VJU=NW',1,'16','-','0','1OFDV3KLTKX3',1,'1',' ',2,'1',6,' ','1',' ',' ','1',' '); 

DELETE FROM t_cr_coderule_l WHERE fpkid = '1OFDS7VNG5C2';
INSERT INTO t_cr_coderule_l(fid,fpkid,flocaleid,fname) VALUES ('1OFDS7VJU=NW','1OFDS7VNG5C2','zh_CN','立项分摊单'); 



/** 编号规则适用条件基础资料列表**/


DELETE FROM T_CR_AppCondition WHERE fentryid = '1OFDV01YJP7W';
INSERT INTO T_CR_AppCondition(fid,fproperty,fentryid,fseq,fpropertyvalue) VALUES ('1OFDS7VJU=NW','1O93QX8JE27M','1OFDV01YJP7W',1,'1O947SZR=FV1'); 


/** 费用暂估分摊单 编号规则**/
DELETE FROM t_cr_coderule WHERE fid = '1OFE2R+ZLZI+';
INSERT INTO t_cr_coderule(fexample,fappmode,fisaddview,fisappcondition,fmasterid,fisunique,fruletype,fismodifiable,fcreatetime,fbizobjectid,fisupdaterecover,fenable,fisapporg,fisserialnumber,fdisablerid,fischeckcode,fid,fsplitsign,fctrlmode,fdisabledate,fislog,fstatus,fnumber,fexamplelength,fisfast,fmodifierid,fisnonbreak,fmodifytime,fcreatorid) VALUES (' ','2','1','1','1OFE2R+ZLZI+','0',NULL,'0',{ts'2021-06-11  00:00:00'},'er_costestimatebill','0','1','0','1',NULL,'0','1OFE2R+ZLZI+','-','1',NULL,'0','C','1OFDY/3SGLCZ',' ','0',0,'1',{ts'2021-06-11  00:00:00'},0); 

DELETE FROM t_cr_coderuleentry WHERE fentryid = '1OFE2R/ICFO1';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fstep,fcutstyle,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1OFE2R+ZLZI+',1,'1',' ','0','1OFE2R/ICFO1',1,'1','1',0,'1',8,'ZGFT','1',' ',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE fentryid = '1OFE2R/ICFO2';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fstep,fcutstyle,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1OFE2R+ZLZI+',1,'2','-','1','1OFE2R/ICFO2',1,'1',' ',1,'1',8,'yyyyMMdd','1',' ','bizdate','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE fentryid = '1OFE2R/ICFO3';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fstep,fcutstyle,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1OFE2R+ZLZI+',1,'16','-','0','1OFE2R/ICFO3',1,'1',' ',2,'1',6,' ','1',' ',' ','1',' '); 

DELETE FROM t_cr_coderule_l WHERE fpkid = '1OFE2R+ZME/N';
INSERT INTO t_cr_coderule_l(fid,fpkid,flocaleid,fname) VALUES ('1OFE2R+ZLZI+','1OFE2R+ZME/N','zh_TW','費用暫估單分攤'); 
DELETE FROM t_cr_coderule_l WHERE fpkid = '1OFE2R+ZME/O';
INSERT INTO t_cr_coderule_l(fid,fpkid,flocaleid,fname) VALUES ('1OFE2R+ZLZI+','1OFE2R+ZME/O','zh_CN','费用暂估单分摊'); 


/** 编号规则适用条件基础资料列表**/

DELETE FROM T_CR_AppCondition WHERE fentryid = '1OFE36IWPL0Z';
INSERT INTO T_CR_AppCondition(fid,fproperty,fentryid,fseq,fpropertyvalue) VALUES ('1OFE2R+ZLZI+','1O93VRW9/UGY','1OFE36IWPL0Z',1,'1O94E0UBFVBQ'); 



