
/** 费用暂估单 编号规则**/
DELETE FROM t_cr_coderule WHERE FID = '1KBX=MXWABLE';
DELETE FROM t_cr_coderule WHERE FID = '1KBXKBNJ5FHX';
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1KBXCTAQSUPS';
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1KBXCTAQSUPT';
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1KBXCTAQSUPU';
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1KBXQ0RD1B2T';
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1KBXQ0RD1B2U';
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1KBXQ0RD1B2V';
DELETE FROM t_cr_coderule_l WHERE FPKID = '1KBX=MXWA7WN';
DELETE FROM t_cr_coderule_l WHERE FPKID = '1KBXKBNMSR+N';



DELETE FROM t_cr_coderule WHERE fid = '1O8UHEJ2SUGS';
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','1O8UHEJ2SUGS','0',NULL,'0',{ts'2021-06-09  00:00:00'},'er_costestimatebill','0','1','0','1',NULL,'0','1O8UHEJ2SUGS','-','1',NULL,'0','C','1O8UAWLB18DJ',' ','0',1155766321963628544,'1',{ts'2021-06-09  00:00:00'},0);
DELETE FROM t_cr_coderule WHERE fid = '1O8UOVNLZO5Z';
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','1O8UOVNLZO5Z','0',NULL,'0',{ts'2021-06-09  00:00:00'},'er_costestimatebill','0','1','0','1',NULL,'0','1O8UOVNLZO5Z','-','1',NULL,'0','C','1O8UKHMTP66E',' ','0',1155766321963628544,'1',{ts'2021-06-09  00:00:00'},0);

DELETE FROM t_cr_coderuleentry WHERE fentryid = '1O94KPP/=VH7';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fstep,fcutstyle,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1O8UHEJ2SUGS',1,'1',' ','0','1O94KPP/=VH7',1,'1','1',0,'1',8,'FYZG','1',' ',' ','0',' ');
DELETE FROM t_cr_coderuleentry WHERE fentryid = '1O94KPP/=VH8';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fstep,fcutstyle,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1O8UHEJ2SUGS',1,'2','-','1','1O94KPP/=VH8',1,'1',' ',1,'1',8,'yyyyMMdd','1',' ','bizdate','1',' ');
DELETE FROM t_cr_coderuleentry WHERE fentryid = '1O94KPP/=VH9';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fstep,fcutstyle,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1O8UHEJ2SUGS',1,'16','-','0','1O94KPP/=VH9',1,'1',' ',2,'1',6,' ','1',' ',' ','1',' ');

DELETE FROM t_cr_coderuleentry WHERE fentryid = '1O94LQF+VKYF';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fstep,fcutstyle,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1O8UOVNLZO5Z',1,'1',' ','0','1O94LQF+VKYF',1,'1','1',0,'1',8,'ZGBG','1',' ',' ','0',' ');
DELETE FROM t_cr_coderuleentry WHERE fentryid = '1O94LQF+VKYG';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fstep,fcutstyle,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1O8UOVNLZO5Z',1,'2','-','1','1O94LQF+VKYG',1,'1',' ',1,'1',8,'yyyyMMdd','1',' ','bizdate','1',' ');
DELETE FROM t_cr_coderuleentry WHERE fentryid = '1O94LQF+VKYH';
INSERT INTO t_cr_coderuleentry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fstep,fcutstyle,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1O8UOVNLZO5Z',1,'16','-','0','1O94LQF+VKYH',1,'1',' ',2,'1',6,' ','1',' ',' ','1',' ');

DELETE FROM t_cr_coderule_l WHERE fpkid = '1O8UHEJ2S9YL';
INSERT INTO t_cr_coderule_l(fid,fpkid,flocaleid,fname) VALUES ('1O8UHEJ2SUGS','1O8UHEJ2S9YL','zh_CN','费用暂估');
DELETE FROM t_cr_coderule_l WHERE fpkid = '1O8UOVNLZ3MS';
INSERT INTO t_cr_coderule_l(fid,fpkid,flocaleid,fname) VALUES ('1O8UOVNLZO5Z','1O8UOVNLZ3MS','zh_CN','费用暂估单变更');

/** 编号规则适用条件属性 **/
DELETE FROM t_cr_appcondpro WHERE FID = '1KBW0INVEF/2';
DELETE FROM t_cr_appcondpro_l WHERE FPKID = '1KBW0INVEA==';
DELETE FROM t_cr_appcondpro_l WHERE FPKID = '1KBW0INVEA=A';


DELETE FROM t_cr_appcondpro WHERE fid = '1O93VRW9/UGY';
INSERT INTO t_cr_appcondpro(fid,fbizobjectid,fnumber) VALUES ('1O93VRW9/UGY','er_costestimatebill','detailtype');

DELETE FROM t_cr_appcondpro_l WHERE fpkid = '1O93VRW9/9YQ';
INSERT INTO t_cr_appcondpro_l(fid,fpkid,flocaleid,fdescription,fname) VALUES ('1O93VRW9/UGY','1O93VRW9/9YQ','zh_CN','暂估类型','暂估类型');
DELETE FROM t_cr_appcondpro_l WHERE fpkid = '1O93VRW9/9YR';
INSERT INTO t_cr_appcondpro_l(fid,fpkid,flocaleid,fdescription,fname) VALUES ('1O93VRW9/UGY','1O93VRW9/9YR','zh_TW','暫估類型','暫估類型');


/** 编号规则适用条件属性值 **/
DELETE FROM t_cr_appcondprovalue WHERE FID = '1KBW7Q17N34+';
DELETE FROM t_cr_appcondprovalue WHERE FID = '1KBW4Y=HW0O2';
DELETE FROM t_cr_appcondprovalue_l WHERE FPKID = '1KBW7Q17N+E6';
DELETE FROM t_cr_appcondprovalue_l WHERE FPKID = '1KBW7Q17N+E7';
DELETE FROM t_cr_appcondprovalue_l WHERE FPKID = '1KBW4Y=HVXZ=';
DELETE FROM t_cr_appcondprovalue_l WHERE FPKID = '1KBW4Y=HVXZA';


DELETE FROM t_cr_appcondprovalue WHERE fid = '1O94=ENYF98B';
INSERT INTO t_cr_appcondprovalue(fid,fvalue,fappcondproid) VALUES ('1O94=ENYF98B','biztype_applybill','1O93VRW9/UGY');
DELETE FROM t_cr_appcondprovalue WHERE fid = '1O94C0SWZUL1';
INSERT INTO t_cr_appcondprovalue(fid,fvalue,fappcondproid) VALUES ('1O94C0SWZUL1','biztype_changebill','1O93VRW9/UGY');
DELETE FROM t_cr_appcondprovalue WHERE fid = '1O94E0UBFVBQ';
INSERT INTO t_cr_appcondprovalue(fid,fvalue,fappcondproid) VALUES ('1O94E0UBFVBQ','biztype_sharebill','1O93VRW9/UGY');

DELETE FROM t_cr_appcondprovalue_l WHERE fpkid = '1O94=ENYEPP4';
INSERT INTO t_cr_appcondprovalue_l(fid,fpkid,flocaleid,fdescription,fname) VALUES ('1O94=ENYF98B','1O94=ENYEPP4','zh_CN','费用暂估','费用暂估');
DELETE FROM t_cr_appcondprovalue_l WHERE fpkid = '1O94=ENYEPP5';
INSERT INTO t_cr_appcondprovalue_l(fid,fpkid,flocaleid,fdescription,fname) VALUES ('1O94=ENYF98B','1O94=ENYEPP5','zh_TW','費用暫估','費用暫估');

DELETE FROM t_cr_appcondprovalue_l WHERE fpkid = '1O94C0SWZ=0V';
INSERT INTO t_cr_appcondprovalue_l(fid,fpkid,flocaleid,fdescription,fname) VALUES ('1O94C0SWZUL1','1O94C0SWZ=0V','zh_CN','暂估变更','暂估变更');
DELETE FROM t_cr_appcondprovalue_l WHERE fpkid = '1O94C0SWZ=0W';
INSERT INTO t_cr_appcondprovalue_l(fid,fpkid,flocaleid,fdescription,fname) VALUES ('1O94C0SWZUL1','1O94C0SWZ=0W','zh_TW','暫估變更','暫估變更');

DELETE FROM t_cr_appcondprovalue_l WHERE fpkid = '1O94E0UBF=TI';
INSERT INTO t_cr_appcondprovalue_l(fid,fpkid,flocaleid,fdescription,fname) VALUES ('1O94E0UBFVBQ','1O94E0UBF=TI','zh_CN','暂估分摊','暂估分摊');
DELETE FROM t_cr_appcondprovalue_l WHERE fpkid = '1O94E0UBF=TJ';
INSERT INTO t_cr_appcondprovalue_l(fid,fpkid,flocaleid,fdescription,fname) VALUES ('1O94E0UBFVBQ','1O94E0UBF=TJ','zh_TW','暫估分攤','暫估分攤');


/** 编号规则适用条件基础资料列表**/
DELETE FROM T_CR_AppCondition WHERE FENTRYID = '1KBXC4ZD6VKN';
DELETE FROM T_CR_AppCondition WHERE FENTRYID = '1KBXKQR96BK=';


DELETE FROM T_CR_AppCondition WHERE fentryid = '1O94KJHC87=6';
INSERT INTO T_CR_AppCondition(fid,fproperty,fentryid,fseq,fpropertyvalue) VALUES ('1O8UHEJ2SUGS','1O93VRW9/UGY','1O94KJHC87=6',1,'1O94=ENYF98B');
DELETE FROM T_CR_AppCondition WHERE fentryid = '1O94LLU+V7FE';
INSERT INTO T_CR_AppCondition(fid,fproperty,fentryid,fseq,fpropertyvalue) VALUES ('1O8UOVNLZO5Z','1O93VRW9/UGY','1O94LLU+V7FE',1,'1O94C0SWZUL1');
