
/** 资产暂估单 编号规则**/
DELETE FROM t_cr_coderule WHERE fid = '1VQGNL2AQS9A';
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','1VQGNL2AQS9A','0',NULL,'0',{ts'2021-09-01  00:00:00'},'er_costestimatebill','0','1','0','1',NULL,'0','1VQGNL2AQS9A','-','1',NULL,'0','C','1VQGBROFN4Z4',' ','1',1155766321963628544,'1',{ts'2021-09-01  00:00:00'},0); 

DELETE FROM t_cr_coderuleentry WHERE fentryid = '1VQH/HPS2LI3';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fstep,fcutstyle,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1VQGNL2AQS9A',1,'1',' ','0','1VQH/HPS2LI3',1,'1','1',0,'1',8,'ZCZG','1',' ',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE fentryid = '1VQH/HPS2LI4';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fstep,fcutstyle,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1VQGNL2AQS9A',1,'2','-','1','1VQH/HPS2LI4',1,'1',' ',1,'1',8,'yyyyMMdd','1',' ','bizdate','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE fentryid = '1VQH/HPS2LI5';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fstep,fcutstyle,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1VQGNL2AQS9A',1,'16','-','0','1VQH/HPS2LI5',1,'1',' ',2,'1',6,' ','1',' ',' ','1',' '); 

DELETE FROM t_cr_coderule_l WHERE fpkid = '1VQGNL2AR7S/';
INSERT INTO t_cr_coderule_l(fid,fpkid,flocaleid,fname) VALUES ('1VQGNL2AQS9A','1VQGNL2AR7S/','zh_CN','资产暂估'); 


/** 编号规则适用条件属性值 **/
DELETE FROM t_cr_appcondprovalue WHERE fid = '1VQGX=JHM7K=';
INSERT INTO t_cr_appcondprovalue(fid,fvalue,fappcondproid) VALUES ('1VQGX=JHM7K=','biztype_applyassetbill','1O93VRW9/UGY'); 

DELETE FROM t_cr_appcondprovalue_l WHERE fpkid = '1VQGX=JHLS1M';
INSERT INTO t_cr_appcondprovalue_l(fid,fpkid,flocaleid,fdescription,fname) VALUES ('1VQGX=JHM7K=','1VQGX=JHLS1M','zh_CN','资产暂估','资产暂估'); 
DELETE FROM t_cr_appcondprovalue_l WHERE fpkid = '1VQGX=JHLS1N';
INSERT INTO t_cr_appcondprovalue_l(fid,fpkid,flocaleid,fdescription,fname) VALUES ('1VQGX=JHM7K=','1VQGX=JHLS1N','zh_TW','資產暫估','資產暫估'); 


/** 编号规则适用条件基础资料列表**/
DELETE FROM T_CR_AppCondition WHERE fentryid = '1VQH/8UKF+XU';
INSERT INTO T_CR_AppCondition(fid,fproperty,fentryid,fseq,fpropertyvalue) VALUES ('1VQGNL2AQS9A','1O93VRW9/UGY','1VQH/8UKF+XU',1,'1VQGX=JHM7K='); 


/** 费用暂估分摊单 默认单据类型**/
DELETE FROM T_BAS_BILLTYPE WHERE fid = 1235302417361368064;
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 (1235302417361368064,'0',NULL,'0',' ','0','0',1235302417361368064,'C','er_costestimatebill',1,' ',' ','er_costestimateassetbill_BT_S',{ts'2021-09-01  00:00:00'},'1VO4W13+DLGB',NULL,1155766321963628544,'1',{ts'2021-09-01  00:00:00'},'0',1155766321963628544); 


DELETE FROM T_BAS_BILLTYPE_l WHERE fpkid = '1VQ6YKGQ5K24';
INSERT INTO T_BAS_BILLTYPE_l(fid,fpkid,flocaleid,fdescription,fname) VALUES (1235302417361368064,'1VQ6YKGQ5K24','zh_CN','资产暂估','资产暂估'); 
DELETE FROM T_BAS_BILLTYPE_l WHERE fpkid = '1VQ6YKGQ5K25';
INSERT INTO T_BAS_BILLTYPE_l(fid,fpkid,flocaleid,fdescription,fname) VALUES (1235302417361368064,'1VQ6YKGQ5K25','zh_TW','資產暫估','資產暫估'); 
 

