-- 美团到店订单获取字段映射
DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 2215222731912473600;
INSERT INTO T_ER_TRIP_FIELDMAPPING(FID,FSERVER,FDATAJSON_TAG,FURL,FISDEFAULT,FMASTERID,FMETHOD,FSTATUS,FNUMBER,FNAME,FSYNCTYPE,FDATAJSON,FCREATETIME,FPORTTYPE,FENABLE,FMODIFIERID,FFUNCTION,FMODIFYTIME,FPARAMSJSON_TAG,FCLASSFORNAME,FCREATORID,FPARAMSJSON) VALUES (2215222731912473600,2046351792677283840,' ','https://bep-openapi.meituan.com/api/sqt/open/settle/bill/querySettlementDetail','1',2215222731912473600,'POST','C','MT_SyncInStoreMealOrder','美团-用餐到店订单获取',' ','已录入参数。',{ts'2025-05-15  00:00:00'},'pull','1',1925266062056993792,'er_mealbill',{ts'2025-06-04  00:00:00'},'{
	"accessKey":"CC1NRDRJLC76-TK",
	"content":{
		"firstBusinessType":"030",
		"sqtBizOrderId":"1803001172009717804",
		"entDate":"2023-02-29",
		"nextStartId":"180300117200971780",
		"entId":100678,
		"pageSize":20,
		"requestNo":"e982b3b690d344c9ba093385f022f852",
		"startDate":"2023-02-01",
		"ts":1703660390000
	}
}','kd.fi.er.business.trip.v2.server.mttrip.order.MTtripSyncOrderInvoke#execute',1925266062056993792,'已录入参数。');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '4Z2XV59=VU47';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (2215222731912473600,'4Z2XV59=VU47','zh_CN','美团-用餐到店订单获取');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2215228091008248832;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2215222731912473600,'=',' ',' ',2215228091008248832,' ',' ','1',{ts'2025-05-15  00:00:00'},{ts'2025-05-15  00:00:00'},'accessKey',' ',1,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getAppKey');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2215228091008248833;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2215222731912473600,'=',' ',' ',2215228091008248833,'010',' ','1',{ts'2025-05-15  00:00:00'},{ts'2025-05-15  00:00:00'},'content.firstBusinessType','到店',2,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2215228091008248834;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2215222731912473600,'=',' ',' ',2215228091008248834,'3',' ','1',{ts'2025-05-15  00:00:00'},{ts'2025-05-15  00:00:00'},'content.startDate','值表示当前时间，往前递减的天数',3,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getShortStartDate');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2215228091008248835;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2215222731912473600,'=',' ',' ',2215228091008248835,' ',' ','1',{ts'2025-05-15  00:00:00'},{ts'2025-05-15  00:00:00'},'content.entDate',' ',4,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getShortEndDate');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2215230646446803968;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2215222731912473600,'=',' ',' ',2215230646446803968,' ',' ','1',{ts'2025-05-15  00:00:00'},{ts'2025-05-15  00:00:00'},'content.entId',' ',5,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getOrationid');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2215230646446803969;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2215222731912473600,'=',' ',' ',2215230646446803969,' ',' ','1',{ts'2025-05-15  00:00:00'},{ts'2025-06-04  00:00:00'},'content.nextStartId',' ',6,'1','and','kd.fi.er.business.trip.v2.plugin.mttrip.MTtripPlugin#getNextStartId');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2215230646446803970;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2215222731912473600,'=',' ',' ',2215230646446803970,'100',' ','1',{ts'2025-05-15  00:00:00'},{ts'2025-05-15  00:00:00'},'content.pageSize',' ',7,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2215231410816764928;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2215222731912473600,'=',' ',' ',2215231410816764928,' ',' ','1',{ts'2025-05-15  00:00:00'},{ts'2025-05-15  00:00:00'},'content.ts',' ',8,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getNowTime');
DELETE FROM T_ER_TRIP_FILTERENTRY WHERE FENTRYID = 2215240076575861760;
INSERT INTO T_ER_TRIP_FILTERENTRY(FID,FFILTERSTATUS,FFILTERCONDITION,FFILTERFIELD,FFILTERVALUE,FFILTERISDEFAULT,FENTRYID,FFILTERDESC,FFILTERMODIFYTIME,FFILTERLOGIC,FFILTERCREATETIME,FFILTERLEFTBRACKET,FSEQ,FFILTERRIGHTBRACKET) VALUES (2215222731912473600,'1','=','status','0','1',2215240076575861760,' ',{ts'2025-05-15  00:00:00'},'and',{ts'2025-05-15  00:00:00'},' ',1,' ');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215329116801166336;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.服务商',' ',2215329116801166336,'1',{ts'2025-05-15  00:00:00'},' ',{ts'2025-05-15  00:00:00'},'MEITUAN_NEW',1,'2','server','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215329116801166337;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.订单号',' ',2215329116801166337,'1',{ts'2025-05-15  00:00:00'},'data.settlementDetailList.[0].settlementBaseInfo.settlementId',{ts'2025-05-15  00:00:00'},' ',2,'1','ordernum','1');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215329116801166338;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.父订单号',' ',2215329116801166338,'1',{ts'2025-05-15  00:00:00'},'data.settlementDetailList.[0].settlementBaseInfo.sqtBizOrderId',{ts'2025-05-15  00:00:00'},' ',3,'1','parentordernum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215329116801166339;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.订单类型',' ',2215329116801166339,'1',{ts'2025-05-15  00:00:00'},' ',{ts'2025-06-04  00:00:00'},'IF(STRING(data.settlementDetailList.[0].settlementBaseInfo.eventType)=''pay'',''O'', IF(STRING(data.settlementDetailList.[0].settlementBaseInfo.eventType)=''rebook'',''G'',''T'') )',4,'3','ordertype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215337397137525760;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.业务类型',' ',2215337397137525760,'1',{ts'2025-05-15  00:00:00'},' ',{ts'2025-05-15  00:00:00'},'8',5,'2','operationtype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215337397137525761;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.订单性质',' ',2215337397137525761,'1',{ts'2025-05-15  00:00:00'},' ',{ts'2025-05-15  00:00:00'},'1',6,'2','isbusiness','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215337397137525762;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.结算类型',' ',2215337397137525762,'1',{ts'2025-05-15  00:00:00'},' ',{ts'2025-05-15  00:00:00'},'IF(STRING(data.settlementDetailList.[0].daodianSettlementFeeInfo.payType)=''10'' OR STRING(data.settlementDetailList.[0].daodianSettlementFeeInfo.payType)=''50'' ,1,2)',7,'3','producttype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215352934777187329;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.预订人姓名',' ',2215352934777187329,'1',{ts'2025-05-15  00:00:00'},'data.settlementDetailList.[0].daodianSettlementStaffInfo.bookerStaffName',{ts'2025-05-15  00:00:00'},' ',9,'1','bookedname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215352934777187330;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.预订人',' ',2215352934777187330,'1',{ts'2025-05-15  00:00:00'},'data.settlementDetailList.[0].daodianSettlementStaffInfo.bookerStaffNum',{ts'2025-05-15  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUser',10,'4','sourcebookedid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215352934777187331;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.申请单号',' ',2215352934777187331,'1',{ts'2025-05-15  00:00:00'},'data.settlementDetailList.[0].daodianSettlementApplyInfo.externalApplyNo',{ts'2025-05-15  00:00:00'},' ',11,'1','oabillnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215352934777187332;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.订单状态',' ',2215352934777187332,'1',{ts'2025-05-15  00:00:00'},' ',{ts'2025-05-15  00:00:00'},'PAY',12,'2','orderstatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215352934777187333;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.订单金额',' ',2215352934777187333,'1',{ts'2025-05-15  00:00:00'},'data.settlementDetailList.[0].daodianSettlementFeeInfo.entSettleAmount',{ts'2025-05-15  00:00:00'},' ',13,'1','totalamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215352934777187335;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.用餐城市',' ',2215352934777187335,'1',{ts'2025-05-15  00:00:00'},'data.settlementDetailList.[0].settlementBaseInfo.cityName',{ts'2025-05-15  00:00:00'},' ',15,'1','mealcityname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215352934777187336;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.用餐场景',' ',2215352934777187336,'1',{ts'2025-05-15  00:00:00'},' ',{ts'2025-05-15  00:00:00'},'IF(STRING(data.settlementDetailList.[0].settlementBaseInfo.sceneType)=''1'',1, IF(STRING(data.settlementDetailList.[0].settlementBaseInfo.sceneType)=''4'',4, IF(STRING(data.settlementDetailList.[0].settlementBaseInfo.sceneType)=''5'',5, IF(STRING(data.settlementDetailList.[0].settlementBaseInfo.sceneType)=''8'',9,9999) ) ) )',16,'3','dinnerscene','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215352934777187337;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.服务费',' ',2215352934777187337,'1',{ts'2025-05-15  00:00:00'},'data.settlementDetailList.[0].daodianSettlementFeeInfo.consumeServiceFee',{ts'2025-05-15  00:00:00'},' ',17,'1','servicefee','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215352934777187338;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.个人支付金额',' ',2215352934777187338,'1',{ts'2025-05-15  00:00:00'},'data.settlementDetailList.[0].daodianSettlementFeeInfo.staffRealAmount',{ts'2025-05-15  00:00:00'},' ',18,'1','personalfee','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215352934777187339;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.店铺名称',' ',2215352934777187339,'1',{ts'2025-05-15  00:00:00'},'data.settlementDetailList.[0].daodianSettlementOrderInfo.shopName',{ts'2025-05-15  00:00:00'},' ',19,'1','shopname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215352934777187340;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.店铺地址',' ',2215352934777187340,'1',{ts'2025-05-15  00:00:00'},'data.settlementDetailList.[0].daodianSettlementOrderInfo.shopAddress',{ts'2025-05-15  00:00:00'},' ',20,'1','shopaddress','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215352934777187341;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.预订人部门',' ',2215352934777187341,'1',{ts'2025-05-15  00:00:00'},' ',{ts'2025-05-15  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getBookUserDept',21,'4','bookeddept','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215352934777187342;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.预订人公司',' ',2215352934777187342,'1',{ts'2025-05-15  00:00:00'},' ',{ts'2025-05-15  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getBookUserCompany',22,'4','bookedcompany','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215352934777187343;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.申请人公司',' ',2215352934777187343,'1',{ts'2025-05-15  00:00:00'},' ',{ts'2025-05-15  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getBookUserCompany',23,'4','company','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215352934777187344;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.费用承担部门',' ',2215352934777187344,'1',{ts'2025-05-15  00:00:00'},' ',{ts'2025-05-15  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getBookUserDept',24,'4','expcommitdepnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2225512099248291840;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.创建人',' ',2225512099248291840,'1',{ts'2025-05-29  00:00:00'},' ',{ts'2025-05-29  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserId',26,'4','creator','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2225512099248291841;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.创建时间',' ',2225512099248291841,'1',{ts'2025-05-29  00:00:00'},' ',{ts'2025-05-29  00:00:00'},'NOW()',27,'3','createtime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215352934777187334;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.用餐时间',' ',2215352934777187334,'1',{ts'2025-05-15  00:00:00'},'data.settlementDetailList.[0].daodianSettlementOrderInfo.orderTime',{ts'2025-05-29  00:00:00'},'data.settlementDetailList.[0].daodianSettlementOrderInfo.orderDate +'' ''+  data.settlementDetailList.[0].daodianSettlementOrderInfo.orderTime',14,'3','mealtime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2225519407923303424;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.订单日期',' ',2225519407923303424,'1',{ts'2025-05-29  00:00:00'},'data.settlementDetailList.[0].daodianSettlementOrderInfo.orderDate',{ts'2025-05-29  00:00:00'},' ',33,'1','orderdate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215352934777187328;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.费用发生时间',' ',2215352934777187328,'1',{ts'2025-05-15  00:00:00'},'data.settlementDetailList.[0].settlementBaseInfo.bizTime',{ts'2025-05-29  00:00:00'},' ',8,'1','happenddate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2225512099248291842;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.修改人',' ',2225512099248291842,'1',{ts'2025-05-29  00:00:00'},' ',{ts'2025-05-29  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserId',28,'4','modifier','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2225512099248291843;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.修改时间',' ',2225512099248291843,'1',{ts'2025-05-29  00:00:00'},' ',{ts'2025-05-29  00:00:00'},'NOW()',29,'3','modifytime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2225512099248291844;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.单据编号',' ',2225512099248291844,'1',{ts'2025-05-29  00:00:00'},'data.settlementDetailList.[0].settlementBaseInfo.settlementId',{ts'2025-05-29  00:00:00'},' ',30,'1','billno','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2225514843950126080;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.币别',' ',2225514843950126080,'1',{ts'2025-05-29  00:00:00'},' ',{ts'2025-05-29  00:00:00'},'kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getCheckingCurrency',31,'4','currency','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2225517695666176000;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.申请单表单id',' ',2225517695666176000,'1',{ts'2025-05-29  00:00:00'},' ',{ts'2025-05-29  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrderPlugin#getOabillformid',32,'4','oabillformid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2225538008579412992;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215222731912473600,' ','1',' ',' ','单据头.费用承担公司',' ',2225538008579412992,'1',{ts'2025-05-29  00:00:00'},' ',{ts'2025-05-29  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrgPlugin#getSettleMain',25,'4','expcommitcomnum','0');


-- 美团外卖订单获取
DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 2215406539836189696;
INSERT INTO T_ER_TRIP_FIELDMAPPING(FID,FSERVER,FDATAJSON_TAG,FURL,FISDEFAULT,FMASTERID,FMETHOD,FSTATUS,FNUMBER,FNAME,FSYNCTYPE,FDATAJSON,FCREATETIME,FPORTTYPE,FENABLE,FMODIFIERID,FFUNCTION,FMODIFYTIME,FPARAMSJSON_TAG,FCLASSFORNAME,FCREATORID,FPARAMSJSON) VALUES (2215406539836189696,2046351792677283840,' ','https://bep-openapi.meituan.com/api/sqt/open/settle/bill/querySettlementDetail','1',2215406539836189696,'POST','C','MT_SyncOutStoreMealOrder','美团-用餐外卖订单获取',' ','已录入参数。',{ts'2025-05-15  00:00:00'},'pull','1',1925266062056993792,'er_mealbill',{ts'2025-06-04  00:00:00'},'{
	"accessKey":"CC1NRDRJLC76-TK",
	"content":{
		"firstBusinessType":"030",
		"sqtBizOrderId":"1803001172009717804",
		"entDate":"2023-02-29",
		"nextStartId":"180300117200971780",
		"entId":100678,
		"pageSize":20,
		"requestNo":"e982b3b690d344c9ba093385f022f852",
		"startDate":"2023-02-01",
		"ts":1703660390000
	}
}','kd.fi.er.business.trip.v2.server.mttrip.order.MTtripSyncOrderInvoke#execute',1925266062056993792,'已录入参数。');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '4Z3T6K+XO63F';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (2215406539836189696,'4Z3T6K+XO63F','zh_CN','美团-用餐外卖订单获取');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2215406540138179584;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2215406539836189696,'=',' ',' ',2215406540138179584,' ',' ','1',{ts'2025-05-15  00:00:00'},{ts'2025-05-15  00:00:00'},'accessKey',' ',1,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getAppKey');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2215406540138179585;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2215406539836189696,'=',' ',' ',2215406540138179585,'020',' ','1',{ts'2025-05-15  00:00:00'},{ts'2025-05-15  00:00:00'},'content.firstBusinessType','到店',2,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2215406540138179586;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2215406539836189696,'=',' ',' ',2215406540138179586,'3',' ','1',{ts'2025-05-15  00:00:00'},{ts'2025-05-15  00:00:00'},'content.startDate','值表示当前时间，往前递减的天数',3,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getShortStartDate');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2215406540138179587;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2215406539836189696,'=',' ',' ',2215406540138179587,' ',' ','1',{ts'2025-05-15  00:00:00'},{ts'2025-05-15  00:00:00'},'content.entDate',' ',4,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getShortEndDate');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2215406540138179588;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2215406539836189696,'=',' ',' ',2215406540138179588,' ',' ','1',{ts'2025-05-15  00:00:00'},{ts'2025-05-15  00:00:00'},'content.entId',' ',5,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getOrationid');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2215406540138179589;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2215406539836189696,'=',' ',' ',2215406540138179589,' ',' ','1',{ts'2025-05-15  00:00:00'},{ts'2025-06-04  00:00:00'},'content.nextStartId',' ',6,'1','and','kd.fi.er.business.trip.v2.plugin.mttrip.MTtripPlugin#getNextStartId');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2215406540138179590;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2215406539836189696,'=',' ',' ',2215406540138179590,'100',' ','1',{ts'2025-05-15  00:00:00'},{ts'2025-05-15  00:00:00'},'content.pageSize',' ',7,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2215406540138179591;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2215406539836189696,'=',' ',' ',2215406540138179591,' ',' ','1',{ts'2025-05-15  00:00:00'},{ts'2025-05-15  00:00:00'},'content.ts',' ',8,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getNowTime');
DELETE FROM T_ER_TRIP_FILTERENTRY WHERE FENTRYID = 2215406540138302466;
INSERT INTO T_ER_TRIP_FILTERENTRY(FID,FFILTERSTATUS,FFILTERCONDITION,FFILTERFIELD,FFILTERVALUE,FFILTERISDEFAULT,FENTRYID,FFILTERDESC,FFILTERMODIFYTIME,FFILTERLOGIC,FFILTERCREATETIME,FFILTERLEFTBRACKET,FSEQ,FFILTERRIGHTBRACKET) VALUES (2215406539836189696,'1','=','status','0','1',2215406540138302466,' ',{ts'2025-05-15  00:00:00'},'and',{ts'2025-05-15  00:00:00'},' ',1,' ');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215406540138179598;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.结算类型',' ',2215406540138179598,'1',{ts'2025-05-15  00:00:00'},' ',{ts'2025-05-15  00:00:00'},'IF(STRING(data.settlementDetailList.[0].waimaiSettlementFeeInfo.payType)=''10'' OR STRING(data.settlementDetailList.[0].waimaiSettlementFeeInfo.payType)=''50'' ,1,2)',7,'3','producttype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215406540138179599;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.费用发生时间',' ',2215406540138179599,'1',{ts'2025-05-15  00:00:00'},'data.settlementDetailList.[0].settlementBaseInfo.bizTime',{ts'2025-05-29  00:00:00'},' ',8,'1','happenddate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215406540456946688;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.预订人姓名',' ',2215406540456946688,'1',{ts'2025-05-15  00:00:00'},'data.settlementDetailList.[0].waimaiSettlementStaffInfo.bookerStaffName',{ts'2025-05-15  00:00:00'},' ',9,'1','bookedname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215406540456946689;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.预订人',' ',2215406540456946689,'1',{ts'2025-05-15  00:00:00'},'data.settlementDetailList.[0].waimaiSettlementStaffInfo.bookerStaffNum',{ts'2025-05-15  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUser',10,'4','sourcebookedid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215406540456946690;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.申请单号',' ',2215406540456946690,'1',{ts'2025-05-15  00:00:00'},'data.settlementDetailList.[0].waimaiSettlementApplyInfo.externalApplyNo',{ts'2025-06-04  00:00:00'},' ',11,'1','oabillnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215406540456946691;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.订单状态',' ',2215406540456946691,'1',{ts'2025-05-15  00:00:00'},' ',{ts'2025-05-15  00:00:00'},'PAY',12,'2','orderstatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215406540456946692;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.订单金额',' ',2215406540456946692,'1',{ts'2025-05-15  00:00:00'},'data.settlementDetailList.[0].waimaiSettlementFeeInfo.entSettleAmount',{ts'2025-05-15  00:00:00'},' ',13,'1','totalamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215406540456946694;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.用餐城市',' ',2215406540456946694,'1',{ts'2025-05-15  00:00:00'},'data.settlementDetailList.[0].settlementBaseInfo.cityName',{ts'2025-05-15  00:00:00'},' ',15,'1','mealcityname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215406540456946695;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.用餐场景',' ',2215406540456946695,'1',{ts'2025-05-15  00:00:00'},' ',{ts'2025-05-15  00:00:00'},'IF(STRING(data.settlementDetailList.[0].settlementBaseInfo.sceneType)=''1'',1, IF(STRING(data.settlementDetailList.[0].settlementBaseInfo.sceneType)=''4'',4, IF(STRING(data.settlementDetailList.[0].settlementBaseInfo.sceneType)=''5'',5, IF(STRING(data.settlementDetailList.[0].settlementBaseInfo.sceneType)=''8'',9,9999) ) ) )',16,'3','dinnerscene','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215406540456946696;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.服务费',' ',2215406540456946696,'1',{ts'2025-05-15  00:00:00'},'data.settlementDetailList.[0].waimaiSettlementFeeInfo.consumeServiceFee',{ts'2025-05-15  00:00:00'},' ',17,'1','servicefee','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215406540456946697;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.个人支付金额',' ',2215406540456946697,'1',{ts'2025-05-15  00:00:00'},'data.settlementDetailList.[0].waimaiSettlementFeeInfo.staffRealAmount',{ts'2025-05-15  00:00:00'},' ',18,'1','personalfee','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215406540456946699;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.店铺地址',' ',2215406540456946699,'1',{ts'2025-05-15  00:00:00'},'data.settlementDetailList.[0].waimaiSettlementOrderInfo.shopAddress',{ts'2025-05-15  00:00:00'},' ',20,'1','shopaddress','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215406540456946700;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.预订人部门',' ',2215406540456946700,'1',{ts'2025-05-15  00:00:00'},' ',{ts'2025-05-15  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getBookUserDept',21,'4','bookeddept','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215406540456946701;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.预订人公司',' ',2215406540456946701,'1',{ts'2025-05-15  00:00:00'},' ',{ts'2025-05-15  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getBookUserCompany',22,'4','bookedcompany','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215406540456946702;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.申请人公司',' ',2215406540456946702,'1',{ts'2025-05-15  00:00:00'},' ',{ts'2025-05-15  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getBookUserCompany',23,'4','company','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215406540456946703;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.费用承担部门',' ',2215406540456946703,'1',{ts'2025-05-15  00:00:00'},' ',{ts'2025-05-15  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getBookUserDept',24,'4','expcommitdepnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215406540456946698;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.店铺名称',' ',2215406540456946698,'1',{ts'2025-05-15  00:00:00'},'data.settlementDetailList.[0].waimaiSettlementOrderInfo.shopName',{ts'2025-05-15  00:00:00'},' ',19,'1','shopname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215406540138179592;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.服务商',' ',2215406540138179592,'1',{ts'2025-05-15  00:00:00'},' ',{ts'2025-05-15  00:00:00'},'MEITUAN_NEW',1,'2','server','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215406540138179593;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.订单号',' ',2215406540138179593,'1',{ts'2025-05-15  00:00:00'},'data.settlementDetailList.[0].settlementBaseInfo.settlementId',{ts'2025-05-15  00:00:00'},' ',2,'1','ordernum','1');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215406540138179594;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.父订单号',' ',2215406540138179594,'1',{ts'2025-05-15  00:00:00'},'data.settlementDetailList.[0].settlementBaseInfo.sqtBizOrderId',{ts'2025-05-15  00:00:00'},' ',3,'1','parentordernum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215406540138179595;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.订单类型',' ',2215406540138179595,'1',{ts'2025-05-15  00:00:00'},' ',{ts'2025-06-04  00:00:00'},'IF(STRING(data.settlementDetailList.[0].settlementBaseInfo.eventType)=''pay'',''O'', IF(STRING(data.settlementDetailList.[0].settlementBaseInfo.eventType)=''rebook'',''G'',''T''))',4,'3','ordertype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215406540138179596;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.业务类型',' ',2215406540138179596,'1',{ts'2025-05-15  00:00:00'},' ',{ts'2025-05-15  00:00:00'},'8',5,'2','operationtype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215406540138179597;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.订单性质',' ',2215406540138179597,'1',{ts'2025-05-15  00:00:00'},' ',{ts'2025-05-15  00:00:00'},'1',6,'2','isbusiness','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2215406540456946693;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.用餐时间',' ',2215406540456946693,'1',{ts'2025-05-15  00:00:00'},'data.settlementDetailList.[0].settlementBaseInfo.bizTime',{ts'2025-05-29  00:00:00'},'data.settlementDetailList.[0].waimaiSettlementOrderInfo.orderDate +'' ''+  data.settlementDetailList.[0].waimaiSettlementOrderInfo.orderTime',14,'3','mealtime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2225555266194215936;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.费用承担公司',' ',2225555266194215936,'1',{ts'2025-05-29  00:00:00'},' ',{ts'2025-05-29  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrgPlugin#getSettleMain',25,'4','expcommitcomnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2225555266194215937;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.创建人',' ',2225555266194215937,'1',{ts'2025-05-29  00:00:00'},' ',{ts'2025-05-29  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserId',26,'4','creator','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2225555266194215938;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.创建时间',' ',2225555266194215938,'1',{ts'2025-05-29  00:00:00'},' ',{ts'2025-05-29  00:00:00'},'NOW()',27,'3','createtime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2225555266194215939;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.修改人',' ',2225555266194215939,'1',{ts'2025-05-29  00:00:00'},' ',{ts'2025-05-29  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserId',28,'4','modifier','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2225555266194215940;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.修改时间',' ',2225555266194215940,'1',{ts'2025-05-29  00:00:00'},' ',{ts'2025-05-29  00:00:00'},'NOW()',29,'3','modifytime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2225555266194215941;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.单据编号',' ',2225555266194215941,'1',{ts'2025-05-29  00:00:00'},'data.settlementDetailList.[0].settlementBaseInfo.settlementId',{ts'2025-05-29  00:00:00'},' ',30,'1','billno','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2225555266194215942;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.币别',' ',2225555266194215942,'1',{ts'2025-05-29  00:00:00'},' ',{ts'2025-05-29  00:00:00'},'kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getCheckingCurrency',31,'4','currency','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2225555266194215943;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.申请单表单id',' ',2225555266194215943,'1',{ts'2025-05-29  00:00:00'},' ',{ts'2025-05-29  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrderPlugin#getOabillformid',32,'4','oabillformid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2225555266194215944;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2215406539836189696,' ','1',' ',' ','单据头.订单日期',' ',2225555266194215944,'1',{ts'2025-05-29  00:00:00'},'data.settlementDetailList.[0].waimaiSettlementOrderInfo.orderDate',{ts'2025-05-29  00:00:00'},' ',33,'1','orderdate','0');
