DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1980501728294190080;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1876266116096293888,' ','1',' ',' ','单据头.外部系统订单号',' ',1980501728294190080,'1',{ts'2024-06-25  00:00:00'},'tripSync.data.[0].outordernum',{ts'2024-06-25  00:00:00'},' ',81,'1','outordernum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1980501728294190081;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1876266116096293888,' ','1',' ',' ','单据头.商旅方系统拆账id',' ',1980501728294190081,'1',{ts'2024-06-25  00:00:00'},'tripSync.data.[0].outaccountid',{ts'2024-06-25  00:00:00'},' ',82,'1','outaccountid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1980500610008733696;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1887593683327821824,' ','1',' ',' ','单据头.外部系统订单号',' ',1980500610008733696,'1',{ts'2024-06-25  00:00:00'},'tripSync.data.[0].outordernum',{ts'2024-06-25  00:00:00'},' ',52,'1','outordernum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1980501344406198272;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1887593683327821824,' ','1',' ',' ','单据头.商旅方系统拆账id',' ',1980501344406198272,'1',{ts'2024-06-25  00:00:00'},'tripSync.data.[0].outaccountid',{ts'2024-06-25  00:00:00'},' ',53,'1','outaccountid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1980502023883446272;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1887608251814946816,' ','1',' ',' ','单据头.外部系统订单号',' ',1980502023883446272,'1',{ts'2024-06-25  00:00:00'},'tripSync.data.[0].outordernum',{ts'2024-06-25  00:00:00'},' ',56,'1','outordernum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1980502023883446273;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1887608251814946816,' ','1',' ',' ','单据头.商旅方系统拆账id',' ',1980502023883446273,'1',{ts'2024-06-25  00:00:00'},'tripSync.data.[0].outaccountid',{ts'2024-06-25  00:00:00'},' ',57,'1','outaccountid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1980502277294905344;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1918913937991228416,' ','1',' ',' ','单据头.外部系统订单号',' ',1980502277294905344,'1',{ts'2024-06-25  00:00:00'},'tripSync.data.[0].outordernum',{ts'2024-06-25  00:00:00'},' ',57,'1','outordernum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1980502277294905345;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1918913937991228416,' ','1',' ',' ','单据头.商旅方系统拆账id',' ',1980502277294905345,'1',{ts'2024-06-25  00:00:00'},'tripSync.data.[0].outaccountid',{ts'2024-06-25  00:00:00'},' ',58,'1','outaccountid','0');
--结算单
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1980503174389422081;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1888329837358200832,' ','1',' ',' ','单据头.外部系统结算单号',' ',1980503174389422081,'1',{ts'2024-06-25  00:00:00'},'tripSync.data.[0].outsettlementnum',{ts'2024-06-25  00:00:00'},' ',66,'1','outsettlementnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1980503174389422080;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1888329837358200832,' ','1',' ',' ','单据头.商旅方系统拆账id',' ',1980503174389422080,'1',{ts'2024-06-25  00:00:00'},'tripSync.data.[0].outaccountid',{ts'2024-06-25  00:00:00'},' ',67,'1','outaccountid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1980502939818776576;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1888340564274027520,' ','1',' ',' ','单据头.外部系统结算单号',' ',1980502939818776576,'1',{ts'2024-06-25  00:00:00'},'tripSync.data.[0].outsettlementnum',{ts'2024-06-25  00:00:00'},' ',78,'1','outsettlementnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1980502939818776577;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1888340564274027520,' ','1',' ',' ','单据头.商旅方系统拆账id',' ',1980502939818776577,'1',{ts'2024-06-25  00:00:00'},'tripSync.data.[0].outaccountid',{ts'2024-06-25  00:00:00'},' ',79,'1','outaccountid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1980502719550707712;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1888347409587870720,' ','1',' ',' ','单据头.外部系统结算单号',' ',1980502719550707712,'1',{ts'2024-06-25  00:00:00'},'tripSync.data.[0].outsettlementnum',{ts'2024-06-25  00:00:00'},' ',63,'1','outsettlementnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1980502719550707713;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1888347409587870720,' ','1',' ',' ','单据头.商旅方系统拆账id',' ',1980502719550707713,'1',{ts'2024-06-25  00:00:00'},'tripSync.data.[0].outaccountid',{ts'2024-06-25  00:00:00'},' ',64,'1','outaccountid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1980503434402715648;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1918927832646638592,' ','1',' ',' ','单据头.商旅方系统拆账id',' ',1980503434402715648,'1',{ts'2024-06-25  00:00:00'},'tripSync.data.[0].outaccountid',{ts'2024-06-25  00:00:00'},' ',66,'1','outaccountid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1980503434402715649;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1918927832646638592,' ','1',' ',' ','单据头.外部系统结算单号',' ',1980503434402715649,'1',{ts'2024-06-25  00:00:00'},'tripSync.data.[0].outsettlementnum',{ts'2024-06-25  00:00:00'},' ',65,'1','outsettlementnum','0');
--月结账单
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1980503892596873216;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1888446275951762432,' ','1',' ',' ','单据头.商旅方系统拆账id',' ',1980503892596873216,'1',{ts'2024-06-25  00:00:00'},'tripSync.data.[0].outaccountid',{ts'2024-06-25  00:00:00'},' ',18,'1','outaccountid','0');