
--  高德同程人员同步增加附加字段
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID IN (1926772861297600512,
                                                       1926778376421484544,
                                                       1926872545114564608,
                                                       1926892681137844224
    ) ;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY (FID, FSEQ, FENTRYID, FMAPTARGETFIELD, FMAPTARGETFIELDDESC, FMAPSOURCEFIELD, FMAPTYPE, FMAPDESIGN, FMAPSOURCEFIELDEXT, FMAPTYPEEXT, FMAPDESIGNEXT, FMAPPRIMARYKEY, FMAPISDEFAULT, FMAPSTATUS, FMAPDESC, FMAPCREATETIME, FMAPMODIFYTIME) VALUES (1738294548527980544, 13, 1926772861297600512, 'data.[0].extInfo', '员工扩展属性', ' ', '4', 'kd.fi.er.business.trip.v2.plugin.UserPlugin#getExtInfo', ' ', ' ', ' ', '0', '1', '1', ' ', {ts'2024-04-11 09:13:19'}, {ts'2024-04-11 09:13:19'});
INSERT INTO T_ER_TRIP_FIELDMAPENTRY (FID, FSEQ, FENTRYID, FMAPTARGETFIELD, FMAPTARGETFIELDDESC, FMAPSOURCEFIELD, FMAPTYPE, FMAPDESIGN, FMAPSOURCEFIELDEXT, FMAPTYPEEXT, FMAPDESIGNEXT, FMAPPRIMARYKEY, FMAPISDEFAULT, FMAPSTATUS, FMAPDESC, FMAPCREATETIME, FMAPMODIFYTIME) VALUES (1737797910562746368, 13, 1926778376421484544, 'data.[0].extInfo', '员工扩展属性', ' ', '4', 'kd.fi.er.business.trip.v2.plugin.UserPlugin#getExtInfo', ' ', ' ', ' ', '0', '1', '1', ' ', {ts'2024-04-11 09:13:19'}, {ts'2024-04-11 09:13:19'});
INSERT INTO T_ER_TRIP_FIELDMAPENTRY (FID, FSEQ, FENTRYID, FMAPTARGETFIELD, FMAPTARGETFIELDDESC, FMAPSOURCEFIELD, FMAPTYPE, FMAPDESIGN, FMAPSOURCEFIELDEXT, FMAPTYPEEXT, FMAPDESIGNEXT, FMAPPRIMARYKEY, FMAPISDEFAULT, FMAPSTATUS, FMAPDESC, FMAPCREATETIME, FMAPMODIFYTIME) VALUES (1850669174704275456, 22, 1926872545114564608, 'param.remarks.remark1', '备注', ' ', '4', 'kd.fi.er.business.trip.v2.plugin.UserPlugin#getExtInfo', ' ', ' ', ' ', '0', '1', '1', ' ', {ts'2024-04-11 09:13:19'}, {ts'2024-04-11 09:13:19'});
INSERT INTO T_ER_TRIP_FIELDMAPENTRY (FID, FSEQ, FENTRYID, FMAPTARGETFIELD, FMAPTARGETFIELDDESC, FMAPSOURCEFIELD, FMAPTYPE, FMAPDESIGN, FMAPSOURCEFIELDEXT, FMAPTYPEEXT, FMAPDESIGNEXT, FMAPPRIMARYKEY, FMAPISDEFAULT, FMAPSTATUS, FMAPDESC, FMAPCREATETIME, FMAPMODIFYTIME) VALUES (1855121256828052480, 22, 1926892681137844224, 'param.remarks.remark1', '备注', ' ', '4', 'kd.fi.er.business.trip.v2.plugin.UserPlugin#getExtInfo', ' ', ' ', ' ', '0', '1', '1', ' ', {ts'2024-04-11 09:13:19'}, {ts'2024-04-11 09:13:19'});


-- 高德订单结算单 费用承担公司部门申请人公司部门新增 商旅字段取值源单字段
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPSOURCEFIELD = 'data.list.[0].extInfo' WHERE FENTRYID IN(1769477916284215306,1769477916284215307,1769477916284215308,1769477916284215309,1782672127246362647,1782672127246362648,1782672127246362649,1782672127246362650);
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPSOURCEFIELD='orders.[0].extInfo' WHERE FENTRYID IN(1769714420017214464,1769714420017214465,1792815187359716352,1792830743831925796,1792830743831925797,1792830743831925798);
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPISDEFAULT = 1 WHERE FENTRYID IN(1859492297029541888);

-- 高德订单结算单增加成本
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID IN ( 1926894297681326080,1926897628713428992,1926898134160615424,1926898782583484416);
INSERT INTO T_ER_TRIP_FIELDMAPENTRY (FID, FSEQ, FENTRYID, FMAPTARGETFIELD, FMAPTARGETFIELDDESC, FMAPSOURCEFIELD, FMAPTYPE, FMAPDESIGN, FMAPSOURCEFIELDEXT, FMAPTYPEEXT, FMAPDESIGNEXT, FMAPPRIMARYKEY, FMAPISDEFAULT, FMAPSTATUS, FMAPDESC, FMAPCREATETIME, FMAPMODIFYTIME) VALUES (1792830743781593088, 45, 1926894297681326080, 'std_costcenter', '单据头.成本中心', 'orders.[0].extInfo', '4', 'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getReqCostcenter', ' ', ' ', ' ', '0', '1', '1', ' ', {ts'2024-04-11 09:13:19'}, {ts'2024-04-11 09:13:19'});
INSERT INTO T_ER_TRIP_FIELDMAPENTRY (FID, FSEQ, FENTRYID, FMAPTARGETFIELD, FMAPTARGETFIELDDESC, FMAPSOURCEFIELD, FMAPTYPE, FMAPDESIGN, FMAPSOURCEFIELDEXT, FMAPTYPEEXT, FMAPDESIGNEXT, FMAPPRIMARYKEY, FMAPISDEFAULT, FMAPSTATUS, FMAPDESC, FMAPCREATETIME, FMAPMODIFYTIME) VALUES (1768225189230945280, 54, 1926897628713428992, 'std_costcenter', '单据头.成本中心', 'data.list.[0].extInfo', '4', 'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getReqCostcenter', ' ', ' ', ' ', '0', '1', '1', ' ', {ts'2024-04-11 09:13:19'}, {ts'2024-04-11 09:13:19'});
INSERT INTO T_ER_TRIP_FIELDMAPENTRY (FID, FSEQ, FENTRYID, FMAPTARGETFIELD, FMAPTARGETFIELDDESC, FMAPSOURCEFIELD, FMAPTYPE, FMAPDESIGN, FMAPSOURCEFIELDEXT, FMAPTYPEEXT, FMAPDESIGNEXT, FMAPPRIMARYKEY, FMAPISDEFAULT, FMAPSTATUS, FMAPDESC, FMAPCREATETIME, FMAPMODIFYTIME) VALUES (1782672127104004096, 54, 1926898134160615424, 'std_costcenter', '单据头.成本中心', 'data.list.[0].extInfo', '4', 'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getReqCostcenter', ' ', ' ', ' ', '0', '1', '1', ' ', {ts'2024-04-11 09:13:19'}, {ts'2024-04-11 09:13:19'});
INSERT INTO T_ER_TRIP_FIELDMAPENTRY (FID, FSEQ, FENTRYID, FMAPTARGETFIELD, FMAPTARGETFIELDDESC, FMAPSOURCEFIELD, FMAPTYPE, FMAPDESIGN, FMAPSOURCEFIELDEXT, FMAPTYPEEXT, FMAPDESIGNEXT, FMAPPRIMARYKEY, FMAPISDEFAULT, FMAPSTATUS, FMAPDESC, FMAPCREATETIME, FMAPMODIFYTIME) VALUES (1762332510073081856, 45, 1926898782583484416, 'std_costcenter', '单据头.成本中心', 'orders.[0].extInfo', '4', 'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getReqCostcenter', ' ', ' ', ' ', '0', '1', '1', ' ', {ts'2024-04-11 09:13:19'}, {ts'2024-04-11 09:13:19'});



UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPSOURCEFIELD='data.orders.[0].extend_info' WHERE FENTRYID=1803572580872051757;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPSOURCEFIELD='data.orders.[0].extend_info' WHERE FENTRYID=1803572580872051758;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPSOURCEFIELD='data.orders.[0].extend_info' WHERE FENTRYID=1803572580872051759;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPSOURCEFIELD='data.orders.[0].extend_info' WHERE FENTRYID=1803572580872051748;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPSOURCEFIELD='data.detail_list.[0].extend_info' WHERE FENTRYID=1799930397468298293;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPSOURCEFIELD='data.detail_list.[0].extend_info' WHERE FENTRYID=1799930397468298294;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPSOURCEFIELD='data.detail_list.[0].extend_info' WHERE FENTRYID=1799930397468298295;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPSOURCEFIELD='data.orders.[0].extend_info' WHERE FENTRYID=1804291042271422515;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPSOURCEFIELD='data.orders.[0].extend_info' WHERE FENTRYID=1804291042271422516;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPSOURCEFIELD='data.orders.[0].extend_info' WHERE FENTRYID=1804291042271422517;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPSOURCEFIELD='data.orders.[0].extend_info' WHERE FENTRYID=1804292305453180928;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPSOURCEFIELD='data.detail_list.[0].extend_info' WHERE FENTRYID=1797014402722247717;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPSOURCEFIELD='data.detail_list.[0].extend_info' WHERE FENTRYID=1797014402722247718;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPSOURCEFIELD='data.detail_list.[0].extend_info' WHERE FENTRYID=1797014402722247719;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPSOURCEFIELD='data.orders.[0].extend_info' WHERE FENTRYID=1804382278080651305;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPSOURCEFIELD='data.orders.[0].extend_info' WHERE FENTRYID=1804382278080651307;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPSOURCEFIELD='data.orders.[0].extend_info' WHERE FENTRYID=1804382278080651312;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPSOURCEFIELD='data.orders.[0].extend_info' WHERE FENTRYID=1923998856081687552;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPSOURCEFIELD='data.detail_list.[0].extend_info' WHERE FENTRYID=1800025760430721069;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPSOURCEFIELD='data.detail_list.[0].extend_info' WHERE FENTRYID=1800025760430721070;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPSOURCEFIELD='data.detail_list.[0].extend_info' WHERE FENTRYID=1800025760430721071;


DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID IN (2022597210960888832,2022598806474130432,2022599669821154304,2022600939353211904,2022601695997264896,2022602475869373440);

INSERT INTO T_ER_TRIP_FIELDMAPENTRY (FID, FSEQ, FENTRYID, FMAPTARGETFIELD, FMAPTARGETFIELDDESC, FMAPSOURCEFIELD, FMAPTYPE, FMAPDESIGN, FMAPSOURCEFIELDEXT, FMAPTYPEEXT, FMAPDESIGNEXT, FMAPPRIMARYKEY, FMAPISDEFAULT, FMAPSTATUS, FMAPDESC, FMAPCREATETIME, FMAPMODIFYTIME) VALUES (1803572579831864320, 57, 2022597210960888832, 'std_costcenter', '单据头.成本中心', 'data.orders.[0].extend_info', '4', 'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getReqCostcenter', ' ', ' ', ' ', '0', '1', '1', ' ', {ts'2024-08-22 15:34:36'}, {ts'2024-08-22 15:34:36'});
INSERT INTO T_ER_TRIP_FIELDMAPENTRY (FID, FSEQ, FENTRYID, FMAPTARGETFIELD, FMAPTARGETFIELDDESC, FMAPSOURCEFIELD, FMAPTYPE, FMAPDESIGN, FMAPSOURCEFIELDEXT, FMAPTYPEEXT, FMAPDESIGNEXT, FMAPPRIMARYKEY, FMAPISDEFAULT, FMAPSTATUS, FMAPDESC, FMAPCREATETIME, FMAPMODIFYTIME) VALUES (1799930397417965568, 49, 2022598806474130432, 'std_costcenter', '单据头.成本中心', 'data.detail_list.[0].extend_info', '4', 'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getReqCostcenter', ' ', ' ', ' ', '0', '1', '1', ' ', {ts'2024-08-22 15:34:36'}, {ts'2024-08-22 15:34:36'});
INSERT INTO T_ER_TRIP_FIELDMAPENTRY (FID, FSEQ, FENTRYID, FMAPTARGETFIELD, FMAPTARGETFIELDDESC, FMAPSOURCEFIELD, FMAPTYPE, FMAPDESIGN, FMAPSOURCEFIELDEXT, FMAPTYPEEXT, FMAPDESIGNEXT, FMAPPRIMARYKEY, FMAPISDEFAULT, FMAPSTATUS, FMAPDESC, FMAPCREATETIME, FMAPMODIFYTIME) VALUES (1804291042221088768, 66, 2022599669821154304, 'std_costcenter', '单据头.成本中心', 'data.orders.[0].extend_info', '4', 'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getReqCostcenter', ' ', ' ', ' ', '0', '1', '1', ' ', {ts'2024-08-22 15:34:36'}, {ts'2024-08-22 15:34:36'});
INSERT INTO T_ER_TRIP_FIELDMAPENTRY (FID, FSEQ, FENTRYID, FMAPTARGETFIELD, FMAPTARGETFIELDDESC, FMAPSOURCEFIELD, FMAPTYPE, FMAPDESIGN, FMAPSOURCEFIELDEXT, FMAPTYPEEXT, FMAPDESIGNEXT, FMAPPRIMARYKEY, FMAPISDEFAULT, FMAPSTATUS, FMAPDESC, FMAPCREATETIME, FMAPMODIFYTIME) VALUES (1797014402680424448, 67, 2022600939353211904, 'std_costcenter', '单据头.成本中心', 'data.detail_list.[0].extend_info', '4', 'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getReqCostcenter', ' ', ' ', ' ', '0', '1', '1', ' ', {ts'2024-08-22 15:34:36'}, {ts'2024-08-22 15:34:36'});
INSERT INTO T_ER_TRIP_FIELDMAPENTRY (FID, FSEQ, FENTRYID, FMAPTARGETFIELD, FMAPTARGETFIELDDESC, FMAPSOURCEFIELD, FMAPTYPE, FMAPDESIGN, FMAPSOURCEFIELDEXT, FMAPTYPEEXT, FMAPDESIGNEXT, FMAPPRIMARYKEY, FMAPISDEFAULT, FMAPSTATUS, FMAPDESC, FMAPCREATETIME, FMAPMODIFYTIME) VALUES (1804382278055487488, 60, 2022601695997264896, 'std_costcenter', '单据头.成本中心', 'data.orders.[0].extend_info', '4', 'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getReqCostcenter', ' ', ' ', ' ', '0', '1', '1', ' ', {ts'2024-08-22 15:34:36'}, {ts'2024-08-22 15:34:36'});
INSERT INTO T_ER_TRIP_FIELDMAPENTRY (FID, FSEQ, FENTRYID, FMAPTARGETFIELD, FMAPTARGETFIELDDESC, FMAPSOURCEFIELD, FMAPTYPE, FMAPDESIGN, FMAPSOURCEFIELDEXT, FMAPTYPEEXT, FMAPDESIGNEXT, FMAPPRIMARYKEY, FMAPISDEFAULT, FMAPSTATUS, FMAPDESC, FMAPCREATETIME, FMAPMODIFYTIME) VALUES (1800025760397166592, 50, 2022602475869373440, 'std_costcenter', '单据头.成本中心', 'data.detail_list.[0].extend_info', '4', 'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getReqCostcenter', ' ', ' ', ' ', '0', '1', '1', ' ', {ts'2024-08-22 15:34:36'}, {ts'2024-08-22 15:34:36'});

