DELETE FROM t_er_standard_dimens WHERE FID = 1748503193714962432;
INSERT INTO t_er_standard_dimens(FID,FBITINDEX,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FSTATUS,FCTRLSTRATEGY,FOPTIONRANGE,FNUMBER,FNAME,FCREATETIME,FSOURCEBITINDEX,FMODIFIERID,FENABLE,FOPTIONTYPE,FVALUESOURCE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1748503193714962432,0,1,0,1748503193714962432,1584852459787018240,'C',' ',' ','meetgrade_bill','会议级别',{ts'2023-08-10  00:00:00'},0,1155765943016650752,'1',' ',' ','1',{ts'2023-08-10  00:00:00'},1155765943016650752);
DELETE FROM t_er_standard_dimens WHERE FID = 1747891354912174080;
INSERT INTO t_er_standard_dimens(FID,FBITINDEX,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FSTATUS,FCTRLSTRATEGY,FOPTIONRANGE,FNUMBER,FNAME,FCREATETIME,FSOURCEBITINDEX,FMODIFIERID,FENABLE,FOPTIONTYPE,FVALUESOURCE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1747891354912174080,0,1,0,1747891354912174080,1584852459787018240,'C',' ',' ','meetitem','会议事项',{ts'2023-08-09  00:00:00'},0,1155765943016650752,'1',' ',' ','1',{ts'2023-08-10  00:00:00'},1155765943016650752);
DELETE FROM t_er_standard_dimens WHERE FID = 1748503741348334592;
INSERT INTO t_er_standard_dimens(FID,FBITINDEX,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FSTATUS,FCTRLSTRATEGY,FOPTIONRANGE,FNUMBER,FNAME,FCREATETIME,FSOURCEBITINDEX,FMODIFIERID,FENABLE,FOPTIONTYPE,FVALUESOURCE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1748503741348334592,0,1,0,1748503741348334592,1584852459787018240,'C',' ',' ','meettype_bill','会议类别',{ts'2023-08-10  00:00:00'},0,1155765943016650752,'1',' ',' ','1',{ts'2023-08-10  00:00:00'},1155765943016650752);
DELETE FROM t_er_standard_dimens WHERE FID = 1748503967127718912;
INSERT INTO t_er_standard_dimens(FID,FBITINDEX,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FSTATUS,FCTRLSTRATEGY,FOPTIONRANGE,FNUMBER,FNAME,FCREATETIME,FSOURCEBITINDEX,FMODIFIERID,FENABLE,FOPTIONTYPE,FVALUESOURCE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1748503967127718912,0,1,0,1748503967127718912,1584852459787018240,'C',' ',' ','treattype_bill','招待类型',{ts'2023-08-10  00:00:00'},0,1155765943016650752,'1',' ',' ','1',{ts'2023-08-10  00:00:00'},1155765943016650752);
DELETE FROM t_er_standard_dimens WHERE FID = 1743581892185334784;
INSERT INTO t_er_standard_dimens(FID,FBITINDEX,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FSTATUS,FCTRLSTRATEGY,FOPTIONRANGE,FNUMBER,FNAME,FCREATETIME,FSOURCEBITINDEX,FMODIFIERID,FENABLE,FOPTIONTYPE,FVALUESOURCE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1743581892185334784,0,1,0,1743581892185334784,1584852459787018240,'C',' ',' ','cityarea_bill','城市类别',{ts'2023-08-03  00:00:00'},0,1155765943016650752,'1',' ',' ','1',{ts'2023-08-10  00:00:00'},1155765943016650752);
-- DELETE FROM t_er_standard_dimens WHERE FID = 1751692157481259008;

-- INSERT INTO t_er_standard_dimens(FID,FBITINDEX,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FSTATUS,FCTRLSTRATEGY,FOPTIONRANGE,FNUMBER,FNAME,FCREATETIME,FSOURCEBITINDEX,FMODIFIERID,FENABLE,FOPTIONTYPE,FVALUESOURCE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1751692157481259008,0,1,0,1751692157481259008,1584852459787018240,'C',' ',' ','reimburselevel_bill','报销级别',{ts'2023-08-14  00:00:00'},0,13466739,'1',' ',' ','1',{ts'2023-08-14  00:00:00'},13466739);

DELETE FROM t_er_standard_dimens_l WHERE FPKID = '3G5ASEBYZS9I';
INSERT INTO t_er_standard_dimens_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1743581892185334784,'3G5ASEBYZS9I','zh_CN','城市类别');
DELETE FROM t_er_standard_dimens_l WHERE FPKID = '3G5ASEBYZS9J';
INSERT INTO t_er_standard_dimens_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1743581892185334784,'3G5ASEBYZS9J','zh_TW','城市類別');
DELETE FROM t_er_standard_dimens_l WHERE FPKID = '3GP++DP/0MUG';
INSERT INTO t_er_standard_dimens_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1747891354912174080,'3GP++DP/0MUG','zh_CN','会议事项');
DELETE FROM t_er_standard_dimens_l WHERE FPKID = '3GP++DP/0MUH';
INSERT INTO t_er_standard_dimens_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1747891354912174080,'3GP++DP/0MUH','zh_TW','會議事項');
DELETE FROM t_er_standard_dimens_l WHERE FPKID = '3GRX=VICW3/O';
INSERT INTO t_er_standard_dimens_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1748503193714962432,'3GRX=VICW3/O','zh_CN','会议级别');
DELETE FROM t_er_standard_dimens_l WHERE FPKID = '3GRX=VICW3/P';
INSERT INTO t_er_standard_dimens_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1748503193714962432,'3GRX=VICW3/P','zh_TW','會議級別');
DELETE FROM t_er_standard_dimens_l WHERE FPKID = '3GRXDV55PUJO';
INSERT INTO t_er_standard_dimens_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1748503741348334592,'3GRXDV55PUJO','zh_CN','会议类别');
DELETE FROM t_er_standard_dimens_l WHERE FPKID = '3GRXDV55PUJP';
INSERT INTO t_er_standard_dimens_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1748503741348334592,'3GRXDV55PUJP','zh_TW','會議類別');
DELETE FROM t_er_standard_dimens_l WHERE FPKID = '3GRXFHAHPE5Q';
INSERT INTO t_er_standard_dimens_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1748503967127718912,'3GRXFHAHPE5Q','zh_CN','招待类型');
DELETE FROM t_er_standard_dimens_l WHERE FPKID = '3GRXFHAHPE5R';
INSERT INTO t_er_standard_dimens_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1748503967127718912,'3GRXFHAHPE5R','zh_TW','招待類型');
-- DELETE FROM t_er_standard_dimens_l WHERE FPKID = '3H564SMTIBG0';
-- INSERT INTO t_er_standard_dimens_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1751692157481259008,'3H564SMTIBG0','zh_CN','报销级别');
-- DELETE FROM t_er_standard_dimens_l WHERE FPKID = '3H564SMTIBG1';
-- INSERT INTO t_er_standard_dimens_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1751692157481259008,'3H564SMTIBG1','zh_TW','報銷級別');

DELETE FROM t_er_standard_type WHERE FID = 1743583425094283264;
INSERT INTO t_er_standard_type(FID,FBITINDEX,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FSTATUS,FCTRLSTRATEGY,FNUMBER,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FBILLTYPE,FISPRESET,FMODIFYTIME,FDESCRIBE,FCREATORID) VALUES (1743583425094283264,0,1,0,1743583425094283264,0,'C',' ','entertainment_bill','招待费',{ts'2023-08-03  00:00:00'},13466739,'1',' ','1',{ts'2023-08-14  00:00:00'},' ',10000357);

DELETE FROM t_er_standard_type WHERE FID = 1751504995112475648;
INSERT INTO t_er_standard_type(FID,FBITINDEX,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FSTATUS,FCTRLSTRATEGY,FNUMBER,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FBILLTYPE,FISPRESET,FMODIFYTIME,FDESCRIBE,FCREATORID) VALUES (1751504995112475648,0,1,0,1751504995112475648,0,'C',' ','meetting_bill','会议费',{ts'2023-08-14  00:00:00'},13466739,'1',' ','1',{ts'2023-08-14  00:00:00'},' ',209993);

DELETE FROM t_er_standard_type WHERE FID = 1752259007651059712;
INSERT INTO t_er_standard_type(FID,FBITINDEX,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FSTATUS,FCTRLSTRATEGY,FNUMBER,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FBILLTYPE,FISPRESET,FMODIFYTIME,FDESCRIBE,FCREATORID) VALUES (1752259007651059712,0,1,0,1752259007651059712,0,'C',' ','asset','资产报账',{ts'2023-08-15  00:00:00'},13466739,'1',' ','1',{ts'2023-08-15  00:00:00'},' ',13466739);

DELETE FROM t_er_standard_type WHERE FID = 1731896658717035520;
INSERT INTO t_er_standard_type(FID,FBITINDEX,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FSTATUS,FCTRLSTRATEGY,FNUMBER,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FBILLTYPE,FISPRESET,FMODIFYTIME,FDESCRIBE,FCREATORID) VALUES (1731896658717035520,0,1,0,1731896658717035520,0,'C',' ','expense','费用报账',{ts'2023-07-18  00:00:00'},13466739,'1',' ','1',{ts'2023-08-14  00:00:00'},' ',1362173695086547968);

DELETE FROM t_er_standard_type_l WHERE FID = 1743583425094283264;
INSERT INTO t_er_standard_type_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1743583425094283264,'3G5B1L/483US','zh_CN','招待费');
INSERT INTO t_er_standard_type_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1743583425094283264,'3G5B1L/483UT','zh_TW','招待費');

DELETE FROM t_er_standard_type_l WHERE FID = 1751504995112475648;
INSERT INTO t_er_standard_type_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1751504995112475648,'3H4=5YG64K1N','zh_CN','会议费');
INSERT INTO t_er_standard_type_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1751504995112475648,'3H4=5YG64K1O','zh_TW','會議費');

DELETE FROM t_er_standard_type_l WHERE FID = 1752259007651059712;
INSERT INTO t_er_standard_type_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1752259007651059712,'3H7X1E2O=D96','zh_CN','资产报账');
INSERT INTO t_er_standard_type_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1752259007651059712,'3H7X1E2O=D97','zh_TW','資產報賬');

DELETE FROM t_er_standard_type_l WHERE FID = 1731896658717035520;
INSERT INTO t_er_standard_type_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1731896658717035520,'3EQBFAO1S7RX','zh_CN','费用报账');
INSERT INTO t_er_standard_type_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1731896658717035520,'3EQBFAO1S7RY','zh_TW','費用報賬');

DELETE FROM t_er_standard_select_dim WHERE FID = 1743583425094283264;
INSERT INTO t_er_standard_select_dim(FID,FBASEDATAID,FPKID) VALUES (1743583425094283264,1743581892185334784,1753053666921018368);
INSERT INTO t_er_standard_select_dim(FID,FBASEDATAID,FPKID) VALUES (1743583425094283264,1748503967127718912,1753053666921018369);
-- INSERT INTO t_er_standard_select_dim(FID,FBASEDATAID,FPKID) VALUES (1743583425094283264,1751692157481259008,1753053666921018370);
INSERT INTO t_er_standard_select_dim(FID,FBASEDATAID,FPKID) VALUES (1743583425094283264,1594995047378728960,1753053666921018371);

DELETE FROM t_er_standard_select_dim WHERE FID = 1751504995112475648;
INSERT INTO t_er_standard_select_dim(FID,FBASEDATAID,FPKID) VALUES (1751504995112475648,1748503193714962432,1753744119806567424);
INSERT INTO t_er_standard_select_dim(FID,FBASEDATAID,FPKID) VALUES (1751504995112475648,1748503741348334592,1753744119806567425);
INSERT INTO t_er_standard_select_dim(FID,FBASEDATAID,FPKID) VALUES (1751504995112475648,1743581892185334784,1753744119806567426);
-- INSERT INTO t_er_standard_select_dim(FID,FBASEDATAID,FPKID) VALUES (1751504995112475648,1751692157481259008,1753744119806567427);
INSERT INTO t_er_standard_select_dim(FID,FBASEDATAID,FPKID) VALUES (1751504995112475648,1747891354912174080,1753744119806567428);

/*字段设置业务事项*/
update t_er_bill_setting set FBIZITEM = 1585715600121324544  where FREIMBURSETYPE = 'meetting';
update t_er_bill_setting set FBIZITEM = 1585715417744594944  where FREIMBURSETYPE = 'entertainment';
update t_er_bill_setting set FBIZITEM = 1585716319679341568  where FREIMBURSETYPE = 'otherexpenses';
update t_er_bill_setting set FBIZITEM = 1731896658717035520  where FREIMBURSETYPE = 'expense';

/*单据上业务事项*/
update t_er_dailyapplybill set FBIZITEM = 1585715600121324544  where fstdreimbursetype = 'meetting';
update t_er_dailyapplybill set FBIZITEM = 1585715417744594944  where fstdreimbursetype = 'entertainment';
update t_er_dailyapplybill set FBIZITEM = 1585716319679341568  where fstdreimbursetype = 'otherexpenses';
update t_er_dailyapplybill set FBIZITEM = 1731896658717035520  where fstdreimbursetype = 'expense';

update t_er_dailyreimbursebill_a set FBIZITEM = 1585715600121324544  where FID IN (SELECT FID FROM t_er_dailyreimbursebill WHERE FREIMBURSETYPE = 'meetting');
update t_er_dailyreimbursebill_a set FBIZITEM = 1585715417744594944  where FID IN (SELECT FID FROM t_er_dailyreimbursebill WHERE FREIMBURSETYPE = 'entertainment');
update t_er_dailyreimbursebill_a set FBIZITEM = 1585716319679341568  where FID IN (SELECT FID FROM t_er_dailyreimbursebill WHERE FREIMBURSETYPE = 'otherexpenses');
update t_er_dailyreimbursebill_a set FBIZITEM = 1731896658717035520  where FID IN (SELECT FID FROM t_er_dailyreimbursebill WHERE FREIMBURSETYPE = 'expense');

/*先更新对公报销单上的拆分表数据*/
update t_er_pubreimbill_a set FBIZITEM = 1585715600121324544  where FID IN (SELECT FID FROM t_er_pubreimbill WHERE FREIMBURSETYPE = 'meetting');
update t_er_pubreimbill_a set FBIZITEM = 1585715417744594944  where FID IN (SELECT FID FROM t_er_pubreimbill WHERE FREIMBURSETYPE = 'entertainment');
update t_er_pubreimbill_a set FBIZITEM = 1585716319679341568  where FID IN (SELECT FID FROM t_er_pubreimbill WHERE FREIMBURSETYPE = 'otherexpenses');
update t_er_pubreimbill_a set FBIZITEM = 1752259007651059712  where FID IN (SELECT FID FROM t_er_pubreimbill WHERE FREIMBURSETYPE = 'asset');
update t_er_pubreimbill_a set FBIZITEM = 1731896658717035520  where FID IN (SELECT FID FROM t_er_pubreimbill WHERE FREIMBURSETYPE = 'expense');


update t_er_bill_setting set fpicturefield = '/icons/mobile/shortcut_entrance/icon_ExpenseReimbursement_104_104.png'  where  fpicturefield = ' ' ;


