/**费用暂估单 单据类型*/
DELETE FROM T_BAS_BILLTYPE WHERE FID = 1142759670612533248;
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 (1142759670612533248,'0','0',NULL,'0',' ','0',1142759670612533248,'C','er_costestimatebill',1,' ',' ','er_costestimatechgbill_BT_S',{ts'2018-08-08 18:08:08'},'1GM01ZFI155S',NULL,1,'1',{ts'2018-08-08 18:08:08'},'0',1);
DELETE FROM T_BAS_BILLTYPE WHERE FID = 1142755940567647232;
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 (1142755940567647232,'0','0',NULL,'1',' ','0',1142755940567647232,'C','er_costestimatebill',1,' ',' ','er_costestimatebill_BT_S',{ts'2018-08-08 18:08:08'},'18YIYCMXCXDW',NULL,1,'1',{ts'2018-08-08 18:08:08'},'0',1);
DELETE FROM T_BAS_BILLTYPE_L WHERE FPKID = '1KBUQ5920IZE';
INSERT INTO T_BAS_BILLTYPE_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1142759670612533248,'1KBUQ5920IZE','zh_CN',' ','暂估变更');
DELETE FROM T_BAS_BILLTYPE_L WHERE FPKID = '1KBUQ5920IZF';
INSERT INTO T_BAS_BILLTYPE_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1142759670612533248,'1KBUQ5920IZF','zh_TW',' ','暫估變更');
DELETE FROM T_BAS_BILLTYPE_L WHERE FPKID = '1KBU0+7OHUWK';
INSERT INTO T_BAS_BILLTYPE_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1142755940567647232,'1KBU0+7OHUWK','zh_CN',' ','费用暂估');
DELETE FROM T_BAS_BILLTYPE_L WHERE FPKID = '1KBU0+7OHUWL';
INSERT INTO T_BAS_BILLTYPE_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1142755940567647232,'1KBU0+7OHUWL','zh_TW',' ','費用暫估');

/**费用暂估单 费用单据类型*/
DELETE FROM t_er_billtype WHERE FID = 1142762533652825088;
INSERT INTO t_er_billtype(FID,FCREATEORGID,FORGID,FMASTERID,FSTATUS,FBILLNUMBER,FCTRLSTRATEGY,FNAME,FNUMBER,FCREATETIME,FENABLE,FMODIFIERID,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1142762533652825088,0,0,1142762533652825088,'C','er_costestimatebill',' ','费用暂估单','er_costestimatebill',{ts'2018-08-08 18:08:08'},'1',1,'1',{ts'2018-08-08 18:08:08'},1);
DELETE FROM t_er_billtype_l WHERE FPKID = '1KBV9/XVTN8X';
INSERT INTO t_er_billtype_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1142762533652825088,'1KBV9/XVTN8X','zh_CN','费用暂估单');

/** 费用暂估单 编号规则**/
DELETE FROM t_cr_coderule WHERE FID = '1KBX=MXWABLE';
INSERT INTO t_cr_coderule(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FRULETYPE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FDISABLERID,FISCHECKCODE,FID,FSPLITSIGN,FCTRLMODE,FDISABLEDATE,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','1','1KBX=MXWABLE','0',NULL,'0',{ts'2021-04-26  17:26:52'},'er_costestimatebill','1','0','0','1',NULL,'0','1KBX=MXWABLE','-','1',NULL,'0','C','1KBX3WHSA+XJ',' ','0',13466739,'1',{ts'2021-04-26  17:27:43'},0);
DELETE FROM t_cr_coderule WHERE FID = '1KBXKBNJ5FHX';
INSERT INTO t_cr_coderule(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FRULETYPE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FDISABLERID,FISCHECKCODE,FID,FSPLITSIGN,FCTRLMODE,FDISABLEDATE,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','1','1KBXKBNJ5FHX','0',NULL,'0',{ts'2021-04-26  17:29:47'},'er_costestimatebill','1','0','0','1',NULL,'0','1KBXKBNJ5FHX','-','1',NULL,'0','C','1KBXH6KPAUYR',' ','0',13466739,'1',{ts'2021-04-26  17:31:20'},0);
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1KBXCTAQSUPS';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1KBX=MXWABLE',1,'1',' ','0','1KBXCTAQSUPS',1,'1','1',0,8,'1','FYZG',' ','1',' ','0',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1KBXCTAQSUPT';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1KBX=MXWABLE',1,'2','-','1','1KBXCTAQSUPT',1,'1',' ',1,8,'1','yyyyMMdd',' ','1','bizdate','1',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1KBXCTAQSUPU';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1KBX=MXWABLE',1,'16','-','0','1KBXCTAQSUPU',1,'1',' ',2,6,'1',' ',' ','1',' ','1',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1KBXQ0RD1B2T';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1KBXKBNJ5FHX',1,'1',' ','0','1KBXQ0RD1B2T',1,'1','1',0,8,'1','ZGBG',' ','1',' ','0',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1KBXQ0RD1B2U';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1KBXKBNJ5FHX',1,'2','-','0','1KBXQ0RD1B2U',1,'1',' ',1,8,'1','yyyyMMdd',' ','1','bizdate','1',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1KBXQ0RD1B2V';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1KBXKBNJ5FHX',1,'16','-','0','1KBXQ0RD1B2V',1,'1',' ',2,6,'1',' ',' ','1',' ','1',' ');
DELETE FROM t_cr_coderule_l WHERE FPKID = '1KBX=MXWA7WN';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1KBX=MXWABLE','1KBX=MXWA7WN','zh_CN','费用暂估');
DELETE FROM t_cr_coderule_l WHERE FPKID = '1KBXKBNMSR+N';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1KBXKBNJ5FHX','1KBXKBNMSR+N','zh_CN','费用暂估变更');

/** 编号规则适用条件属性 **/
DELETE FROM t_cr_appcondpro WHERE FID = '1KBW0INVEF/2';
INSERT INTO t_cr_appcondpro(FID,FBIZOBJECTID,FNUMBER) VALUES ('1KBW0INVEF/2','er_costestimatebill','ischange');
DELETE FROM t_cr_appcondpro_l WHERE FPKID = '1KBW0INVEA==';
INSERT INTO t_cr_appcondpro_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('1KBW0INVEF/2','1KBW0INVEA==','zh_CN',' ','是否变更');
DELETE FROM t_cr_appcondpro_l WHERE FPKID = '1KBW0INVEA=A';
INSERT INTO t_cr_appcondpro_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('1KBW0INVEF/2','1KBW0INVEA=A','zh_TW',' ','是否變更');

/** 编号规则适用条件属性值 **/
DELETE FROM t_cr_appcondprovalue WHERE FID = '1KBW7Q17N34+';
INSERT INTO t_cr_appcondprovalue(FID,FVALUE,FAPPCONDPROID) VALUES ('1KBW7Q17N34+','true','1KBW0INVEF/2');
DELETE FROM t_cr_appcondprovalue WHERE FID = '1KBW4Y=HW0O2';
INSERT INTO t_cr_appcondprovalue(FID,FVALUE,FAPPCONDPROID) VALUES ('1KBW4Y=HW0O2','false','1KBW0INVEF/2');
DELETE FROM t_cr_appcondprovalue_l WHERE FPKID = '1KBW7Q17N+E6';
INSERT INTO t_cr_appcondprovalue_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('1KBW7Q17N34+','1KBW7Q17N+E6','zh_CN',' ','是');
DELETE FROM t_cr_appcondprovalue_l WHERE FPKID = '1KBW7Q17N+E7';
INSERT INTO t_cr_appcondprovalue_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('1KBW7Q17N34+','1KBW7Q17N+E7','zh_TW',' ','是');
DELETE FROM t_cr_appcondprovalue_l WHERE FPKID = '1KBW4Y=HVXZ=';
INSERT INTO t_cr_appcondprovalue_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('1KBW4Y=HW0O2','1KBW4Y=HVXZ=','zh_CN',' ','否');
DELETE FROM t_cr_appcondprovalue_l WHERE FPKID = '1KBW4Y=HVXZA';
INSERT INTO t_cr_appcondprovalue_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('1KBW4Y=HW0O2','1KBW4Y=HVXZA','zh_TW',' ','否');

/** 编号规则适用条件基础资料列表**/
DELETE FROM T_CR_AppCondition WHERE FENTRYID = '1KBXC4ZD6VKN';
INSERT INTO T_CR_AppCondition(FID,FPROPERTY,FENTRYID,FSEQ,FPROPERTYVALUE) VALUES ('1KBX=MXWABLE','1KBW0INVEF/2','1KBXC4ZD6VKN',1,'1KBW4Y=HW0O2');
DELETE FROM T_CR_AppCondition WHERE FENTRYID = '1KBXKQR96BK=';
INSERT INTO T_CR_AppCondition(FID,FPROPERTY,FENTRYID,FSEQ,FPROPERTYVALUE) VALUES ('1KBXKBNJ5FHX','1KBW0INVEF/2','1KBXKQR96BK=',1,'1KBW7Q17N34+');

/**对公费用下 特殊数据权限 **/
DELETE FROM t_perm_operationrule WHERE FID = '1KBZDO6AAQ5Z';
INSERT INTO t_perm_operationrule(FID,FOPERATIONKEY,FRULE,FENABLED,FOPERATIONTYPE,FISPRESET,FBIZAPPID,FDESCRIPTION,FISPUBLIC,FENTITYTYPEID,FNAME) VALUES ('1KBZDO6AAQ5Z','view','{"filterRow":[{"id":"1KBZDO6AAQ5W","leftBracket":"","compareType":"103","fieldName":"applier.number","rightBracket":"","logic":"1","value":[{"id":"1KBZDO6AALG2","value":""}],"baseDataIds":[]},{"id":"1KBZDO6AAQ5X","leftBracket":"","compareType":"103","fieldName":"creator.number","rightBracket":"","logic":"1","value":[{"id":"1KBZDO6AALG3","value":""}],"baseDataIds":[]},{"id":"1KBZDO6AAQ5Y","leftBracket":"","compareType":"953718393159160832","fieldName":"creator.number","rightBracket":"","logic":"0","value":[{"id":"1KBZDO6AALG4","value":""}],"baseDataIds":[]}],"forList":false}','1','view','0','1GARA29DA8+R',' ','0','er_costestimatebill','费用暂估单特殊数据查看权限');
DELETE FROM t_perm_operationruleobj WHERE FID = '1KBZEUWNB0/N';
INSERT INTO t_perm_operationruleobj(FID,FOPERATIONRULEID,FBIZAPPID,FSEQ,FOBJENABLED,FENTITYTYPEID) VALUES ('1KBZEUWNB0/N','1KBZDO6AAQ5Z','1GARA29DA8+R',0,'1','er_costestimatebill');
DELETE FROM t_perm_operationrule_l WHERE FPKID = '1KBZDO6AALG5';
INSERT INTO t_perm_operationrule_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('1KBZDO6AAQ5Z','1KBZDO6AALG5','zh_CN',' ','费用暂估单特殊数据查看权限'); 
