DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID in(1799217845323073536,1797014402680424448,1799930397417965568,1800025760397166592) ;
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FID in(1799217845323073536,1797014402680424448,1799930397417965568,1800025760397166592) ;
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FID in(1799217845323073536,1797014402680424448,1799930397417965568,1800025760397166592) ;
DELETE FROM T_ER_TRIP_FILTERENTRY WHERE FID in(1799217845323073536,1797014402680424448,1799930397417965568,1800025760397166592) ;
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FID in(1799217845323073536,1797014402680424448,1799930397417965568,1800025760397166592) ;
DELETE FROM T_ER_TRIP_IGNOREEXENTRY WHERE FID in(1799217845323073536,1797014402680424448,1799930397417965568,1800025760397166592) ;
/** 滴滴机票 开始**/
DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 1797014402680424448;
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 (1797014402680424448,1015862345630818304,'{
	"traceId":"0ab8e2be637767f90b8cf08200000a86",
	"errno":0,
	"data":{
		"total":1,
		"last_id":"1125916738127265",
		"detail_list":[
			{
				"reason":"我要改变行程计划、我要改航班",
				"origin_ticket_id_text":"213",
				"discount":"",
				"airline_simple_name":"中国国航",
				"flight_segment_travel":"深圳-北京",
				"total_fee":"0.00",
				"flight_travel_type":0,
				"fuelCost_sp":"1",
				"departure_time":"2022-11-30 15:00:00",
				"create_time":"2022-09-13 19:12:20",
				"change_handle_cost":"0.00",
				"unique_key":"1125917246267315-11125917246180893",
				"budget_center_id":"0",
				"arrival_airport_name":"首都机场",
				"pnr_number":"JFJHV3",
				"transaction_type":1,
				"passenger_member_number":"54074",
				"approval_id":"1125915897867878",
				"flight_segment_number":1,
				"supplier_order_id":"9996739867407",
				"cabin_name":"经济舱",
				"departure_city_name":"深圳",
				"order_id":"1125916738113734",
				"construction_cost_sp":20,
				"ticket_fee":"0.00",
				"departure_airport_name":"宝安机场",
				"travel_itinerary_fee":"",
				"booking_member_number":"54074",
				"pre_order_id":"1125916736058858",
				"remark":"{\"trip_purpose_id\":1125915811459690,\"trip_purpose_name\":\"非必填备注3322\",\"trip_purpose_desc\":\"\"}",
				"cabin_type":4,
				"arrival_airport_code":"PEK",
				"origin_order_id":"123",
				"invoice_fee":"",
				"upgrade_cost":"0.00",
				"pay_type":"企业支付",
				"department":"新孔明环境02环境测试公司",
				"upgrade_final_status":0,
				"member_id":"1125913148685373",
				"arrival_time":"2022-11-30 15:00:00",
				"arrival_city_name":"北京",
				"flight_number":"CA1384",
				"service_fee":"0.00",
				"construction_cost":"0.00",
				"departure_airport_code":"SZX",
				"order_fix_type":0,
				"ticket_fee_sp":20,
				"passenger_name":"曾锦秀",
				"settle_time":"2022-09-13 19:12:20",
				"extra_info":"",
				"economy_original_cost":"0",
				"out_requisition_id":"CCSQ",
				"refund_handle_cost":"0.00",
				"sub_company_no":"",
				"fuelCost":"0.00"
			}
		]
	},
	"errmsg":"SUCCESS"
}','https://api.es.xiaojukeji.com/river/Bill/getNotGeneratedBillDetail','1',1797014402680424448,'GET','C','D_SyncPlaneOrder_List','滴滴-机票订单同步',' ','已录入参数',{ts'2023-10-19  00:00:00'},'pull','1',1205612035459523584,'er_planebill',{ts'2023-11-21  00:00:00'},'{
	"access_token":"611344",
	"end_date":"4",
	"company_id":"car_lixingffcamia1",
	"last_id":"4",
	"business_type":202,
	"sign":"car_lixingffcamia1",
	"client_id":1,
	"timestamp":"364537D769162754A9142BCA53F1C7D2",
	"start_date":5
}','kd.fi.er.business.trip.v2.server.dtrip.DtripSyncOrderInvoke#execute',1205612035459523584,'已录入参数');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '3MQAE76QKTX8';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1797014402680424448,'3MQAE76QKTX8','zh_CN','滴滴-机票订单同步');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '3MQAE76QKTX9';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1797014402680424448,'3MQAE76QKTX9','zh_TW','滴滴-機票訂單同步');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1797014402722367489;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1797014402680424448,'=',' ',' ',1797014402722367489,' ',' ','1',{ts'2023-10-16  00:00:00'},{ts'2023-10-19  00:00:00'},'client_id',' ',2,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getAppKey');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1797014402722367490;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1797014402680424448,'=',' ',' ',1797014402722367490,' ',' ','1',{ts'2023-10-16  00:00:00'},{ts'2023-10-19  00:00:00'},'company_id',' ',3,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getOrationid');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1797014402722367491;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1797014402680424448,'=',' ',' ',1797014402722367491,' ',' ','1',{ts'2023-10-16  00:00:00'},{ts'2023-10-19  00:00:00'},'sign',' ',4,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getReservedfield1');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1797014402722367492;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1797014402680424448,'=',' ',' ',1797014402722367492,' ',' ','1',{ts'2023-10-16  00:00:00'},{ts'2023-10-19  00:00:00'},'timestamp',' ',5,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getNowTime');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1797014402722367493;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1797014402680424448,'=',' ',' ',1797014402722367493,'202',' ','1',{ts'2023-10-16  00:00:00'},{ts'2023-10-19  00:00:00'},'business_type',' ',6,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1797014402722367494;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1797014402680424448,'=',' ',' ',1797014402722367494,'3',' ','1',{ts'2023-10-16  00:00:00'},{ts'2023-10-19  00:00:00'},'start_date','值表示当前时间，往前递减的天数',7,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getShortStartDate');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1797014402722367495;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1797014402680424448,'=',' ',' ',1797014402722367495,' ',' ','1',{ts'2023-10-16  00:00:00'},{ts'2023-10-19  00:00:00'},'end_date','值表示当前时间，往前递减的天数',8,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getShortEndDate');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1797014402722367496;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1797014402680424448,'=',' ',' ',1797014402722367496,'0',' ','1',{ts'2023-10-16  00:00:00'},{ts'2023-10-19  00:00:00'},'last_id',' ',9,'1','and','kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getLastId');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1797014402722367488;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1797014402680424448,'=',' ',' ',1797014402722367488,'D_Token',' ','1',{ts'2023-10-16  00:00:00'},{ts'2023-10-20  00:00:00'},'access_token',' ',1,'1','and','kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getToken');
DELETE FROM T_ER_TRIP_FILTERENTRY WHERE FENTRYID = 1829031333184365568;
INSERT INTO T_ER_TRIP_FILTERENTRY(FID,FFILTERSTATUS,FFILTERCONDITION,FFILTERFIELD,FFILTERVALUE,FFILTERISDEFAULT,FENTRYID,FFILTERDESC,FFILTERMODIFYTIME,FFILTERLOGIC,FFILTERCREATETIME,FFILTERLEFTBRACKET,FSEQ,FFILTERRIGHTBRACKET) VALUES (1797014402680424448,'1','!=','data.detail_list.[0].pay_type','个人支付','1',1829031333184365568,' ',{ts'2023-12-08  00:00:00'},'and',{ts'2023-11-29  00:00:00'},' ',1,' ');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1828204792171044864;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.航空公司',' ',1828204792171044864,'1',{ts'2023-11-28  00:00:00'},'data.detail_list.[0].airline_simple_name',{ts'2023-12-08  00:00:00'},' ',62,'1','airline','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1828208807789429760;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.退票理由',' ',1828208807789429760,'1',{ts'2023-11-28  00:00:00'},'data.detail_list.[0].reason',{ts'2023-12-08  00:00:00'},'IF(data.detail_list.[0].transaction_type = 2, data.detail_list.[0].reason ,'' '')',63,'3','refundreason','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1828208807789429761;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.改签理由',' ',1828208807789429761,'1',{ts'2023-11-28  00:00:00'},'data.detail_list.[0].reason',{ts'2023-12-08  00:00:00'},'IF(data.detail_list.[0].transaction_type = 1, data.detail_list.[0].reason ,'' '')',64,'3','changereason','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1859490538894745600;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.单据编号',' ',1859490538894745600,'1',{ts'2024-01-10  00:00:00'},'data.detail_list.[0].order_id',{ts'2024-01-10  00:00:00'},'data.detail_list.[0].order_id+ ''-'' +  data.detail_list.[0].booking_member_number +''-''+(IF(data.detail_list.[0].transaction_type = 0,''O'', IF(data.detail_list.[0].transaction_type = 1,''G'',''T'')))',65,'3','billno','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247715;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.申请单表单id',' ',1797014402722247715,'1',{ts'2023-10-16  00:00:00'},' ',{ts'2023-10-19  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrderPlugin#getOabillformid',51,'4','oabillformid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247684;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.服务商',' ',1797014402722247684,'1',{ts'2023-10-16  00:00:00'},' ',{ts'2023-10-19  00:00:00'},'DIDI',3,'2','server','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247685;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.订单日期',' ',1797014402722247685,'1',{ts'2023-10-16  00:00:00'},'data.detail_list.[0].create_time',{ts'2023-10-19  00:00:00'},' ',4,'1','orderdate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247696;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.预订人',' ',1797014402722247696,'1',{ts'2023-10-16  00:00:00'},'data.detail_list.[0].booking_member_number',{ts'2023-10-19  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUser',5,'4','sourcebookedid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247697;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.预订人',' ',1797014402722247697,'1',{ts'2023-10-16  00:00:00'},'data.detail_list.[0].booking_member_number',{ts'2023-10-19  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUserName',6,'4','bookedname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247698;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.预订人部门',' ',1797014402722247698,'1',{ts'2023-10-16  00:00:00'},'data.detail_list.[0].booking_member_number',{ts'2023-10-19  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUserDept',7,'4','bookeddept','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247695;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.出差申请/用车申请单号',' ',1797014402722247695,'1',{ts'2023-10-16  00:00:00'},'data.detail_list.[0].out_requisition_id',{ts'2023-10-19  00:00:00'},' ',8,'1','oabillnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247720;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.创建人',' ',1797014402722247720,'1',{ts'2023-10-16  00:00:00'},' ',{ts'2023-11-03  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserId',58,'4','creator','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247721;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.创建时间',' ',1797014402722247721,'1',{ts'2023-10-16  00:00:00'},' ',{ts'2023-11-03  00:00:00'},'NOW()',59,'3','createtime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247690;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.订单性质',' ',1797014402722247690,'1',{ts'2023-10-16  00:00:00'},' ',{ts'2023-11-03  00:00:00'},'IF(data.detail_list.[0].flight_travel_type = 0,1,2)',18,'3','isbusiness','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799384232532282370;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.航空公司名称',' ',1799384232532282370,'1',{ts'2023-10-19  00:00:00'},'data.detail_list.[0].airline_simple_name',{ts'2023-11-03  00:00:00'},' ',19,'1','airlinename','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799384232532282371;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.航班号',' ',1799384232532282371,'1',{ts'2023-10-19  00:00:00'},'data.detail_list.[0].flight_number',{ts'2023-11-03  00:00:00'},' ',20,'1','flightno','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799384232532282372;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.舱位等级',' ',1799384232532282372,'1',{ts'2023-10-19  00:00:00'},'data.detail_list.[0].cabin_name',{ts'2023-11-03  00:00:00'},' ',21,'1','cabinclass','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799384232532282373;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.舱位',' ',1799384232532282373,'1',{ts'2023-10-19  00:00:00'},'data.detail_list.[0].cabin_code',{ts'2023-11-14  00:00:00'},' ',22,'1','cabin','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799384232532282374;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.出发城市',' ',1799384232532282374,'1',{ts'2023-10-19  00:00:00'},'data.detail_list.[0].departure_city_name',{ts'2023-11-03  00:00:00'},' ',23,'1','fromcity','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799384232532282375;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.出发城市名称',' ',1799384232532282375,'1',{ts'2023-10-19  00:00:00'},'data.detail_list.[0].departure_city_name',{ts'2023-11-03  00:00:00'},' ',24,'1','fromcityname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799384232532282376;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.出发机场',' ',1799384232532282376,'1',{ts'2023-10-19  00:00:00'},'data.detail_list.[0].departure_airport_name',{ts'2023-11-03  00:00:00'},' ',25,'1','takeoffport','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799384232532282377;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.出发机场名称',' ',1799384232532282377,'1',{ts'2023-10-19  00:00:00'},'data.detail_list.[0].departure_airport_name',{ts'2023-11-03  00:00:00'},' ',26,'1','takeoffportname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799384232532282378;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.出发时间',' ',1799384232532282378,'1',{ts'2023-10-19  00:00:00'},'data.detail_list.[0].departure_time',{ts'2023-11-03  00:00:00'},' ',27,'1','takeofftime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799384232532282379;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.到达城市',' ',1799384232532282379,'1',{ts'2023-10-19  00:00:00'},'data.detail_list.[0].arrival_city_name',{ts'2023-11-03  00:00:00'},' ',28,'1','tocity','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799384232532282380;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.到达城市名称',' ',1799384232532282380,'1',{ts'2023-10-19  00:00:00'},'data.detail_list.[0].arrival_city_name',{ts'2023-11-03  00:00:00'},' ',29,'1','tocityname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799384232532282381;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.降落机场',' ',1799384232532282381,'1',{ts'2023-10-19  00:00:00'},'data.detail_list.[0].arrival_airport_name',{ts'2023-11-03  00:00:00'},' ',30,'1','landingport','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799384232532282382;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.降落机场名称',' ',1799384232532282382,'1',{ts'2023-10-19  00:00:00'},'data.detail_list.[0].arrival_airport_name',{ts'2023-11-03  00:00:00'},' ',31,'1','landingportname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799384232532282383;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.降落日期',' ',1799384232532282383,'1',{ts'2023-10-19  00:00:00'},'data.detail_list.[0].arrival_time',{ts'2023-11-03  00:00:00'},' ',32,'1','landingtime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247702;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.币种',' ',1797014402722247702,'1',{ts'2023-10-16  00:00:00'},' ',{ts'2023-11-03  00:00:00'},'kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getCheckingCurrency',33,'4','currency','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799370088793934849;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.标准价格',' ',1799370088793934849,'1',{ts'2023-10-19  00:00:00'},'data.detail_list.[0].economy_original_cost',{ts'2023-11-03  00:00:00'},' ',34,'1','standprice','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799370088793934850;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.折扣（%）',' ',1799370088793934850,'1',{ts'2023-10-19  00:00:00'},' ',{ts'2023-11-14  00:00:00'},'IF(data.detail_list.[0].discount = ''全价'',100,NUMBER(REPLACE(data.detail_list.[0].discount,''折'','''')) * 10)',35,'3','discount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799370088793934851;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.最低价格',' ',1799370088793934851,'1',{ts'2023-10-19  00:00:00'},' ',{ts'2023-11-03  00:00:00'},'0',36,'2','lowestpirce','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247722;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.修改人',' ',1797014402722247722,'1',{ts'2023-10-16  00:00:00'},' ',{ts'2023-11-03  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserId',60,'4','modifier','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247723;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.修改时间',' ',1797014402722247723,'1',{ts'2023-10-16  00:00:00'},' ',{ts'2023-11-03  00:00:00'},'NOW()',61,'3','modifytime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247703;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.机场建设费及其他/税费',' ',1797014402722247703,'1',{ts'2023-10-16  00:00:00'},'data.detail_list.[0].construction_cost_sp',{ts'2023-11-21  00:00:00'},' ',38,'1','airportprice','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247701;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.服务费',' ',1797014402722247701,'1',{ts'2023-10-16  00:00:00'},'data.detail_list.[0].service_fee',{ts'2023-11-03  00:00:00'},' ',39,'1','servicefee','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799370088793934848;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.燃油费',' ',1799370088793934848,'1',{ts'2023-10-19  00:00:00'},'data.detail_list.[0].fuelCost_sp',{ts'2023-11-03  00:00:00'},' ',40,'1','fuelprice','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247700;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.订单金额',' ',1797014402722247700,'1',{ts'2023-10-16  00:00:00'},'data.detail_list.[0].company_real_pay',{ts'2023-11-14  00:00:00'},' ',41,'1','totalamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799370088793934852;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.退票费',' ',1799370088793934852,'1',{ts'2023-10-19  00:00:00'},'data.detail_list.[0].refund_handle_cost',{ts'2023-11-03  00:00:00'},' ',42,'1','refundamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799370088793934853;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.改签费',' ',1799370088793934853,'1',{ts'2023-10-19  00:00:00'},'data.detail_list.[0].change_handle_cost',{ts'2023-11-03  00:00:00'},' ',43,'1','endorsementamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799370088793934854;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.保险费',' ',1799370088793934854,'1',{ts'2023-10-19  00:00:00'},' ',{ts'2023-11-03  00:00:00'},'0',44,'2','assuranceamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1810198097498774528;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.PNR',' ',1810198097498774528,'1',{ts'2023-11-03  00:00:00'},'data.detail_list.[0].pnr_number',{ts'2023-11-03  00:00:00'},' ',55,'1','pnr','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1810198097498774529;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.原单订单号',' ',1810198097498774529,'1',{ts'2023-11-03  00:00:00'},'data.detail_list.[0].origin_order_id',{ts'2023-11-03  00:00:00'},' ',56,'1','oriordernum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1810198097498774530;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.订单状态名称',' ',1810198097498774530,'1',{ts'2023-11-03  00:00:00'},' ',{ts'2023-11-28  00:00:00'},'IF(data.detail_list.[0].transaction_type = 0,''已出票'', IF(data.detail_list.[0].transaction_type = 1,''已改签'',''已退票'') )',57,'3','orderstatusname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247683;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.父订单号',' ',1797014402722247683,'1',{ts'2023-10-16  00:00:00'},'data.detail_list.[0].origin_order_id',{ts'2023-11-03  00:00:00'},' ',2,'1','parentordernum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247704;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.个人支付金额',' ',1797014402722247704,'1',{ts'2023-10-16  00:00:00'},'personal_real_pay',{ts'2023-11-03  00:00:00'},' ',46,'1','personalfee','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247682;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.订单号',' ',1797014402722247682,'1',{ts'2023-10-16  00:00:00'},'data.detail_list.[0].order_id',{ts'2023-11-14  00:00:00'},'data.detail_list.[0].order_id+ ''-'' +  data.detail_list.[0].booking_member_number +''-''+(IF(data.detail_list.[0].transaction_type = 0,''O'', IF(data.detail_list.[0].transaction_type = 1,''G'',''T'')))',1,'3','ordernum','1');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247688;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.订单类型',' ',1797014402722247688,'1',{ts'2023-10-16  00:00:00'},' ',{ts'2023-11-14  00:00:00'},'IF(data.detail_list.[0].transaction_type = 0,''O'', IF(data.detail_list.[0].transaction_type = 1,''G'',''T'') )',17,'3','ordertype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247694;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.订单状态',' ',1797014402722247694,'1',{ts'2023-10-16  00:00:00'},' ',{ts'2023-11-14  00:00:00'},'IF(data.detail_list.[0].transaction_type = 0,''40000'', IF(data.detail_list.[0].transaction_type = 1,''50302'',''50202'') )',13,'3','orderstatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799384232532282369;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.订单使用状态',' ',1799384232532282369,'1',{ts'2023-10-19  00:00:00'},' ',{ts'2023-11-09  00:00:00'},'IF(data.detail_list.[0].upgrade_final_status = 1,''USED'', IF(data.detail_list.[0].upgrade_final_status = 2,''REFOUND'',''UNUSED'') )',14,'3','ticketstatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247713;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.机票价格',' ',1797014402722247713,'1',{ts'2023-10-16  00:00:00'},' ',{ts'2023-11-03  00:00:00'},'NUMBER(data.detail_list.[0].ticket_fee_sp)  + NUMBER(data.detail_list.[0].upgrade_cost)',37,'3','ticketprice','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247717;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.费用承担公司',' ',1797014402722247717,'1',{ts'2023-10-16  00:00:00'},' ',{ts'2023-10-26  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrgPlugin#getSettleMain',52,'4','expcommitcomnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247719;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.申请人公司',' ',1797014402722247719,'1',{ts'2023-10-16  00:00:00'},'data.detail_list.[0].out_requisition_id',{ts'2023-10-20  00:00:00'},'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getReqCompanyId',54,'4','company','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247718;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.费用承担部门',' ',1797014402722247718,'1',{ts'2023-10-16  00:00:00'},' ',{ts'2023-10-26  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrgPlugin#getSettleDept',53,'4','expcommitdepnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799384232532282368;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.电子客票号',' ',1799384232532282368,'1',{ts'2023-10-19  00:00:00'},'data.detail_list.[0].supplier_order_id',{ts'2023-10-20  00:00:00'},' ',9,'1','ticketnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247687;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.业务类型',' ',1797014402722247687,'1',{ts'2023-10-16  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'IF(data.detail_list.[0].flight_travel_type = 0,2,4)',10,'3','operationtype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247689;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.订单分类',' ',1797014402722247689,'1',{ts'2023-10-16  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'IF(data.detail_list.[0].flight_travel_type = 0,1,2)',11,'3','ordersort','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247692;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.结算类型',' ',1797014402722247692,'1',{ts'2023-10-16  00:00:00'},' ',{ts'2023-11-30  00:00:00'},'IF(data.detail_list.[0].pay_type  = ''企业支付''  OR data.detail_list.[0].pay_type  = ''混合支付''  OR data.detail_list.[0].pay_type  = ''企业钱包支付'' ,1,2)',12,'3','producttype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247686;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.费用发生时间',' ',1797014402722247686,'1',{ts'2023-10-16  00:00:00'},'data.detail_list.[0].create_time',{ts'2023-10-20  00:00:00'},' ',15,'1','happenddate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247724;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.报销状态',' ',1797014402722247724,'1',{ts'2023-10-16  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'A',16,'2','reimbursestatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247693;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.服务费结算类型',' ',1797014402722247693,'1',{ts'2023-10-16  00:00:00'},' ',{ts'2023-11-30  00:00:00'},'1',45,'2','servicefeepaytype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247705;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.乘机人',' ',1797014402722247705,'1',{ts'2023-10-16  00:00:00'},'data.detail_list.[0].passenger_member_number',{ts'2023-10-20  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUser',47,'4','sourcetravelerid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247706;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.乘机人',' ',1797014402722247706,'1',{ts'2023-10-16  00:00:00'},'data.detail_list.[0].passenger_member_number',{ts'2023-10-20  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUserName',48,'4','travelername','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247707;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ',' ','单据头.乘机人部门',' ',1797014402722247707,'1',{ts'2023-10-16  00:00:00'},'data.detail_list.[0].passenger_member_number',{ts'2023-10-20  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUserDept',49,'4','travelerdept','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1797014402722247716;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1797014402680424448,' ','1',' ','该字段建议放置在字段映射排序靠后，它依赖一些基本信息判断，例如申请单号，出发地，目的地城市，乘车人。','单据头.出差行程ID',' ',1797014402722247716,'1',{ts'2023-10-16  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrderPlugin#getTripId',50,'4','tripid','0');
/** 滴滴机票 结束**/

/**滴滴token 开始**/
DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 1799217845323073536;
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 (1799217845323073536,1015862345630818304,'{
	"access_token":"226c5ee64d183e3179ec642d9164b90daae50ea1",
	"scope":"river_member|river_order|river_invoice|river_company",
	"token_type":"Bearer",
	"expires_in":1800
}','https://api.es.xiaojukeji.com/river/Auth/authorize','1',1799217845323073536,'POST','C','D_Token','滴滴-Token',' ','已录入参数',{ts'2023-10-19  00:00:00'},'push','1',1205612035459523584,'er_biz_info',{ts'2023-11-02  00:00:00'},'{
	"grant_type":"client_",
	"phone":"137",
	"sign":"fa88",
	"client_secret":"c30cde",
	"client_id":"ada0",
	"timestamp":"1684824315"
}','kd.fi.er.business.trip.v2.server.dtrip.DtripTokenInvoke#execute',1205612035459523584,'已录入参数');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '3N+W3O=M9ECR';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1799217845323073536,'3N+W3O=M9ECR','zh_CN','滴滴-Token');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '3N+W3O=M9ECS';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1799217845323073536,'3N+W3O=M9ECS','zh_TW','滴滴-Token');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1799217847453779968;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1799217845323073536,'=',' ',' ',1799217847453779968,'DIDI',' ','1',{ts'2023-10-19  00:00:00'},{ts'2023-10-19  00:00:00'},'number','单据头.编号',1,'1','and',' ');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799217847453780994;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799217845323073536,' ','1',' ',' ',' ',' ',1799217847453780994,'1',{ts'2023-10-19  00:00:00'},'appkey',{ts'2023-10-19  00:00:00'},' ',1,'1','client_id','1');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799217847453780995;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799217845323073536,' ','1',' ','单据头.接入app秘钥',' ',' ',1799217847453780995,'1',{ts'2023-10-19  00:00:00'},'appsecurity',{ts'2023-10-19  00:00:00'},' ',2,'1','client_secret','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799217847453780996;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799217845323073536,' ','1',' ',' ',' ',' ',1799217847453780996,'1',{ts'2023-10-19  00:00:00'},' ',{ts'2023-10-19  00:00:00'},'client_credentials',3,'2','grant_type','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799217847453780997;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799217845323073536,' ','1',' ','单据头.自定义字段2',' ',' ',1799217847453780997,'1',{ts'2023-10-19  00:00:00'},'reservedfield2',{ts'2023-10-19  00:00:00'},' ',4,'1','phone','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799217847453780998;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799217845323073536,' ','1',' ','单据头.自定义字段1',' ',' ',1799217847453780998,'1',{ts'2023-10-19  00:00:00'},'reservedfield1',{ts'2023-10-19  00:00:00'},' ',5,'1','sign','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799217847453780999;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799217845323073536,' ','1',' ','获取当前时间时间戳',' ',' ',1799217847453780999,'1',{ts'2023-10-19  00:00:00'},' ',{ts'2023-10-19  00:00:00'},'kd.fi.er.business.trip.v2.plugin.TimePlugin#getNowTime',6,'4','timestamp','0');
DELETE FROM T_ER_TRIP_IGNOREEXENTRY WHERE FENTRYID = 1799217847453779970;
INSERT INTO T_ER_TRIP_IGNOREEXENTRY(FID,FEXDESC,FEXISDEFAULT,FEXNUMBER,FEXCREATETIME,FEXFIELD,FENTRYID,FEXSTATUS,FSEQ,FEXMODIFYTIME) VALUES (1799217845323073536,' ','1','Bearer',{ts'2023-10-19  00:00:00'},'token_type',1799217847453779970,'1',1,{ts'2023-10-19  00:00:00'});
/**滴滴token 结束**/

/**滴滴酒店 开始**/
DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 1799930397417965568;
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 (1799930397417965568,1015862345630818304,'{
	"traceId":"0ab8e2be6377489db661245400000786",
	"errno":0,
	"data":{
		"total":3,
		"last_id":"1125916300327193",
		"detail_list":[
			{
				"rc_low_price":"",
				"rooms":"协议价房型-每天相同价格",
				"check_out_date":"2022-09-09",
				"personal_real_pay":0,
				"booking_member_number":"54074",
				"booking_date":"2022-08-09",
				"remark":"",
				"room_price _average":20,
				"hotel_address":"23",
				"budget_center_name":"测试曹荟萃公司",
				"book_day_number":1,
				"total_nights":1,
				"order_status":"已取消预订",
				"city_name":"黔东南苗族侗族自治州",
				"pay_status":3,
				"room_num":1,
				"personal_coupon_cost":0,
				"origin_order_id":"123",
				"company_pay_type":"退款",
				"pay_type":"企业支付",
				"company_coupon_cost":0,
				"order_type":"退款",
				"member_id":"",
				"amount":50,
				"cost_discount_before":50,
				"original_check_out_date":"2022-09-10",
				"unique_key":"1125917246267315-11125917246180893",
				"tax_ratio":"0%",
				"service_fee":0,
				"budget_center_id":"1125910975328601",
				"company_real_amount":-50,
				"check_in_member_numbers":"",
				"settle_time":"2022-09-06 14:56:47",
				"hotel_name":"黔东南茉莉的小屋",
				"extra_info":"",
				"requisition_id":"1125915744401713",
				"rc_agreed_price":"",
				"hotel_type":"酒店协议价",
				"check_in_names":"曹一一",
				"is_vat":"否",
				"out_requisition_id":"",
				"check_in_member_departments":"",
				"order_id":"1125916267338512",
				"check_in_date":"2022-09-09",
				"personal_real_refund":0
			}
		]
	},
	"errmsg":"SUCCESS"
}','https://api.es.xiaojukeji.com/river/Bill/getNotGeneratedBillDetail','1',1799930397417965568,'GET','C','D_SyncHotelOrder_List','滴滴-酒店订单同步',' ','已录入参数',{ts'2023-10-19  00:00:00'},'pull','1',1205612035459523584,'er_hotelbill',{ts'2023-11-15  00:00:00'},'{
	"access_token":"611344",
	"end_date":"4",
	"company_id":"car_lixingffcamia1",
	"last_id":"4",
	"business_type":201,
	"sign":"car_lixingffcamia1",
	"client_id":1,
	"timestamp":"364537D769162754A9142BCA53F1C7D2",
	"start_date":5
}','kd.fi.er.business.trip.v2.server.dtrip.DtripSyncOrderInvoke#execute',1205612035459523584,'已录入参数');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '3N2=9/JEFSCP';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1799930397417965568,'3N2=9/JEFSCP','zh_CN','滴滴-酒店订单同步');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '3N2=9/JEFSCQ';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1799930397417965568,'3N2=9/JEFSCQ','zh_TW','滴滴-酒店訂單同步');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1799930397468297216;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1799930397417965568,'=',' ',' ',1799930397468297216,'D_Token',' ','1',{ts'2023-10-20  00:00:00'},{ts'2023-10-20  00:00:00'},'access_token',' ',1,'1','and','kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getToken');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1799930397468297217;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1799930397417965568,'=',' ',' ',1799930397468297217,' ',' ','1',{ts'2023-10-20  00:00:00'},{ts'2023-10-20  00:00:00'},'client_id',' ',2,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getAppKey');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1799930397468297218;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1799930397417965568,'=',' ',' ',1799930397468297218,' ',' ','1',{ts'2023-10-20  00:00:00'},{ts'2023-10-20  00:00:00'},'company_id',' ',3,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getOrationid');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1799930397468297219;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1799930397417965568,'=',' ',' ',1799930397468297219,' ',' ','1',{ts'2023-10-20  00:00:00'},{ts'2023-10-20  00:00:00'},'sign',' ',4,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getReservedfield1');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1799930397468297220;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1799930397417965568,'=',' ',' ',1799930397468297220,' ',' ','1',{ts'2023-10-20  00:00:00'},{ts'2023-10-20  00:00:00'},'timestamp',' ',5,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getNowTime');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1799930397468297221;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1799930397417965568,'=',' ',' ',1799930397468297221,'201',' ','1',{ts'2023-10-20  00:00:00'},{ts'2023-10-20  00:00:00'},'business_type',' ',6,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1799930397468297222;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1799930397417965568,'=',' ',' ',1799930397468297222,'3',' ','1',{ts'2023-10-20  00:00:00'},{ts'2023-10-20  00:00:00'},'start_date','值表示当前时间，往前递减的天数',7,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getShortStartDate');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1799930397468297223;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1799930397417965568,'=',' ',' ',1799930397468297223,' ',' ','1',{ts'2023-10-20  00:00:00'},{ts'2023-10-20  00:00:00'},'end_date','值表示当前时间，往前递减的天数',8,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getShortEndDate');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1799930397468297224;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1799930397417965568,'=',' ',' ',1799930397468297224,'0',' ','1',{ts'2023-10-20  00:00:00'},{ts'2023-10-20  00:00:00'},'last_id',' ',9,'1','and','kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getLastId');
DELETE FROM T_ER_TRIP_FILTERENTRY WHERE FENTRYID = 1799935609520163840;
INSERT INTO T_ER_TRIP_FILTERENTRY(FID,FFILTERSTATUS,FFILTERCONDITION,FFILTERFIELD,FFILTERVALUE,FFILTERISDEFAULT,FENTRYID,FFILTERDESC,FFILTERMODIFYTIME,FFILTERLOGIC,FFILTERCREATETIME,FFILTERLEFTBRACKET,FSEQ,FFILTERRIGHTBRACKET) VALUES (1799930397417965568,'1','in','data.detail_list.[0].order_status','预订成功,已入住,已完成,已取消预订,预订未到','1',1799935609520163840,' ',{ts'2023-10-20  00:00:00'},'and',{ts'2023-10-20  00:00:00'},' ',1,' ');
DELETE FROM T_ER_TRIP_FILTERENTRY WHERE FENTRYID = 1829036640195273728;
INSERT INTO T_ER_TRIP_FILTERENTRY(FID,FFILTERSTATUS,FFILTERCONDITION,FFILTERFIELD,FFILTERVALUE,FFILTERISDEFAULT,FENTRYID,FFILTERDESC,FFILTERMODIFYTIME,FFILTERLOGIC,FFILTERCREATETIME,FFILTERLEFTBRACKET,FSEQ,FFILTERRIGHTBRACKET) VALUES (1799930397417965568,'1','!=','data.detail_list.[0].pay_type','个人支付','1',1829036640195273728,' ',{ts'2024-01-10  00:00:00'},'and',{ts'2023-11-29  00:00:00'},' ',2,' ');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1859489987553484800;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.单据编号',' ',1859489987553484800,'1',{ts'2024-01-10  00:00:00'},'data.detail_list.[0].order_id',{ts'2024-01-10  00:00:00'},'data.detail_list.[0].order_id  + ''-'' +RIGHT(data.detail_list.[0].unique_key,4) + ''-''+ data.detail_list.[0].booking_member_number  + ''-'' + IF(data.detail_list.[0].order_type= ''预订'',''O'', ''T'')',47,'3','billno','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1810206927582436352;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.原单订单号',' ',1810206927582436352,'1',{ts'2023-11-03  00:00:00'},'data.detail_list.[0].origin_order_id',{ts'2024-01-10  00:00:00'},' ',40,'1','oriordernum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298242;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.订单号',' ',1799930397468298242,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].order_id',{ts'2023-11-08  00:00:00'},'data.detail_list.[0].order_id  + ''-'' +RIGHT(data.detail_list.[0].unique_key,4) + ''-''+ data.detail_list.[0].booking_member_number  + ''-'' + IF(data.detail_list.[0].order_type= ''预订'',''O'', ''T'')',1,'3','ordernum','1');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298243;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.父订单号',' ',1799930397468298243,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].order_id',{ts'2023-11-08  00:00:00'},' ',2,'1','parentordernum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298244;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.服务商',' ',1799930397468298244,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'DIDI',3,'2','server','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298285;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.订单类型',' ',1799930397468298285,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-11-03  00:00:00'},'IF(data.detail_list.[0].order_type= ''预订'',''O'', ''T'')',4,'3','ordertype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298245;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.订单日期',' ',1799930397468298245,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].booking_date',{ts'2023-10-20  00:00:00'},' ',5,'1','orderdate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298246;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.预订人',' ',1799930397468298246,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].booking_member_number',{ts'2023-10-20  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUser',6,'4','sourcebookedid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298247;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.预订人姓名',' ',1799930397468298247,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].booking_member_number',{ts'2023-10-20  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUserName',7,'4','bookedname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298248;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.预订人部门',' ',1799930397468298248,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].booking_member_number',{ts'2023-10-20  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUserDept',8,'4','bookeddept','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298249;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.出差申请/用车申请单号',' ',1799930397468298249,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].out_requisition_id',{ts'2023-10-20  00:00:00'},' ',9,'1','oabillnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298292;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.申请单表单id',' ',1799930397468298292,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrderPlugin#getOabillformid',36,'4','oabillformid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298296;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.创建人',' ',1799930397468298296,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-11-03  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserId',41,'4','creator','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298297;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.创建时间',' ',1799930397468298297,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-11-03  00:00:00'},'NOW()',42,'3','createtime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298298;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.修改人',' ',1799930397468298298,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-11-03  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserId',43,'4','modifier','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298299;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.修改时间',' ',1799930397468298299,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-11-03  00:00:00'},'NOW()',44,'3','modifytime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298293;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.费用承担公司',' ',1799930397468298293,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-26  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrgPlugin#getSettleMain',37,'4','expcommitcomnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298294;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.费用承担部门',' ',1799930397468298294,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-26  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrgPlugin#getSettleDept',38,'4','expcommitdepnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298295;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.申请人公司',' ',1799930397468298295,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].out_requisition_id',{ts'2023-10-20  00:00:00'},'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getReqCompanyId',39,'4','company','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298252;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.业务类型',' ',1799930397468298252,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'1',10,'2','operationtype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298253;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.订单分类',' ',1799930397468298253,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'1',11,'2','ordersort','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298254;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.结算类型',' ',1799930397468298254,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'IF(data.detail_list.[0].pay_type  = ''企业支付'',1,2)',12,'3','producttype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298255;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.订单状态',' ',1799930397468298255,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].order_status',{ts'2023-10-20  00:00:00'},'kd.fi.er.business.trip.v2.plugin.EnumPlugin#getEnum',13,'4','orderstatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298257;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.费用发生时间',' ',1799930397468298257,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].booking_date',{ts'2023-10-20  00:00:00'},' ',14,'1','happenddate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298258;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.报销状态',' ',1799930397468298258,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'A',15,'2','reimbursestatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298273;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.币种',' ',1799930397468298273,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getCheckingCurrency',16,'4','currency','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298279;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.服务费',' ',1799930397468298279,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].service_fee',{ts'2023-10-20  00:00:00'},' ',17,'1','servicefee','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298281;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.订单金额',' ',1799930397468298281,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].company_real_amount',{ts'2023-11-15  00:00:00'},' ',18,'1','totalamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298282;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.退订费',' ',1799930397468298282,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'0',19,'2','unbookfee','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298286;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.订单性质',' ',1799930397468298286,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'1',20,'2','isbusiness','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298287;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.服务费结算类型',' ',1799930397468298287,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'IF(data.detail_list.[0].pay_type  = ''企业支付'',1,2)',21,'3','servicefeepaytype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298288;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.个人支付金额',' ',1799930397468298288,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].personal_real_pay',{ts'2023-10-20  00:00:00'},' ',22,'1','personalfee','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298289;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.入住人工号',' ',1799930397468298289,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].check_in_member_numbers',{ts'2023-10-20  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUser',23,'4','sourcetravelerid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298290;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.入住人',' ',1799930397468298290,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].check_in_member_numbers',{ts'2023-10-20  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUserName',24,'4','travelername','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298291;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.入住人部门',' ',1799930397468298291,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].check_in_member_numbers',{ts'2023-10-20  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUserDept',25,'4','travelerdept','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799950362699271168;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.城市',' ',1799950362699271168,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].city_name',{ts'2023-10-20  00:00:00'},' ',26,'1','cityname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799950362699271169;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.酒店名称',' ',1799950362699271169,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].hotel_name',{ts'2023-10-20  00:00:00'},' ',27,'1','hotelname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799950362699271170;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.酒店地址',' ',1799950362699271170,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].hotel_address',{ts'2023-11-03  00:00:00'},' ',28,'1','hoteladdress','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799950362699271171;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.入住日期',' ',1799950362699271171,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].check_in_date',{ts'2023-10-20  00:00:00'},' ',29,'1','checkindate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799950362699271172;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.离店日期',' ',1799950362699271172,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'IF(data.detail_list.[0].check_out_date  <>  null  AND data.detail_list.[0].check_out_date  <> '''' ,data.detail_list.[0].check_out_date ,data.detail_list.[0].original_check_out_date )',30,'3','checkoutdate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799952155848116224;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.房型',' ',1799952155848116224,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].rooms',{ts'2023-10-20  00:00:00'},' ',31,'1','roomstylename','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799952155848116225;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.订房间数',' ',1799952155848116225,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].room_num',{ts'2023-10-20  00:00:00'},' ',32,'1','roomcount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799952155848116226;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.房价',' ',1799952155848116226,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].room_price _average',{ts'2023-11-03  00:00:00'},' ',33,'1','roomamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799952155848116227;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.超标理由',' ',1799952155848116227,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'IF(data.detail_list.[0].rc_low_price   <> null  AND data.detail_list.[0].rc_low_price  <> '''',data.detail_list.[0].rc_low_price ,data.detail_list.[0].rc_agreed_price )',34,'3','overdesc','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1799930397468298250;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ','该字段建议放置在字段映射排序靠后，它依赖一些基本信息判断，例如申请单号，出发地，目的地城市，乘车人。','单据头.出差行程ID',' ',1799930397468298250,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrderPlugin#getTripId',35,'4','tripid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1829103203850418176;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.票价开票类型',' ',1829103203850418176,'1',{ts'2023-11-29  00:00:00'},' ',{ts'2024-01-10  00:00:00'},'9999',45,'2','pricebillingtype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1829630749532227584;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.订单状态名称',' ',1829630749532227584,'1',{ts'2023-11-30  00:00:00'},' ',{ts'2024-01-10  00:00:00'},'IF(data.detail_list.[0].order_status =''预订成功'',''已确认'', IF(data.detail_list.[0].order_status =''已完成''  OR data.detail_list.[0].order_status =''已入住''  OR data.detail_list.[0].order_status =''预订未到'',''已离店'', IF(data.detail_list.[0].order_status =''已取消预订'',''已退订'','' '') ) )',46,'3','orderstatusname','0');
/**滴滴酒店 结束**/

/**滴滴火车 开始**/
DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 1800025760397166592;
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 (1800025760397166592,1015862345630818304,'{
	"errno":0,
	"data":{
		"total":6,
		"last_id":"1125920715099540",
		"detail_list":[
			{
				"origin_ticket_id_text":"1125920714275008",
				"ticket_id_text":"",
				"budget_center_name":"",
				"order_time":"2023-05-29 14:19:20",
				"booking_dep_code":"1111111",
				"booking_member_id":1125915646212716,
				"passenger_member_id":1125915646212716,
				"passenger_dep_code":"1111111",
				"order_pay":55.5,
				"is_change":"否",
				"change_time":"",
				"rc_change_level":"",
				"from_city_id":1,
				"stub_pay":0,
				"ticket_price":54.5,
				"unique_key":"1125920714275008-0",
				"order_id_text":"",
				"budget_center_id":0,
				"budget_center_parent_path_name":"",
				"seat_level":"二等座",
				"transaction_type":"出票",
				"passenger_member_number":"caozhengbo01",
				"booking_member_name":"曹欻欻",
				"travel_purpose":"",
				"start_time":"2023-06-07 06:00:00",
				"booking_dep_name":"11100011245公司",
				"abnormal":"",
				"person_real_pay":0,
				"company_real_pay":55.5,
				"seat_name":"03A座",
				"budget_center_code":"",
				"ex_info_02":"",
				"refund_time":"",
				"to_station_name":"天津",
				"ex_info_01":"",
				"refund_fee":0,
				"ex_info_03":"",
				"passenger_legal_entity_name":"",
				"person_handing_extra_fee":0,
				"booking_dep_id":1125915646135311,
				"order_id":"11259207142364021",
				"trip_reason":"",
				"from_station_name":"北京南",
				"legal_entity_id":0,
				"passenger_legal_entity_id":0,
				"booking_member_number":"caozhengbo01",
				"person_ticket_price":0,
				"change_extra_fee":0,
				"remark":"",
				"institution_name":"",
				"refund_extra_fee":0,
				"total_ticket_price":54.5,
				"booking_parent_path_dep_name":"11100011245公司",
				"trip_description":"",
				"pay_type":"企业支付",
				"rc_normal_level":"",
				"train_code":"C2551",
				"is_refund":"否",
				"handing_extra_fee":0,
				"passenger_member_name":"曹欻欻",
				"total_handing_extra_fee":0,
				"from_city_name":"北京市",
				"passenger_dep_id":1125915646135311,
				"end_time":"2023-06-07 06:30:00",
				"service_fee":1,
				"to_city_name":"天津市",
				"settle_time":"2023-05-29 14:32:40",
				"extra_info":"",
				"requisition_id":"",
				"to_city_id":7,
				"out_requisition_id":"",
				"passenger_dep_name":"11100011245公司",
				"legal_entity_name":"",
				"passenger_parent_path_dep_name":"11100011245公司"
			}
		]
	},
	"errmsg":"成功",
	"request_id":"mbSxNllrNolK8t1kQKZDZcgc+oIuLJ6ZTcjlyg8Hj3MK+yDDl6DvzZ4kdvXl7TAC"
}','https://api.es.xiaojukeji.com/river/Bill/getNotGeneratedBillDetail','1',1800025760397166592,'GET','C','D_SyncTrainOrder_List','滴滴-火车订单同步',' ','已录入参数',{ts'2023-10-19  00:00:00'},'pull','1',1205612035459523584,'er_trainbill',{ts'2023-11-16  00:00:00'},'{
	"access_token":"611344",
	"end_date":"4",
	"company_id":"car_lixingffcamia1",
	"last_id":"4",
	"business_type":201,
	"sign":"car_lixingffcamia1",
	"client_id":1,
	"timestamp":"364537D769162754A9142BCA53F1C7D2",
	"start_date":5
}','kd.fi.er.business.trip.v2.server.dtrip.DtripSyncOrderInvoke#execute',1205612035459523584,'已录入参数');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '3N2R1XZXJDAQ';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1800025760397166592,'3N2R1XZXJDAQ','zh_CN','滴滴-火车订单同步');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '3N2R1XZXJDAR';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1800025760397166592,'3N2R1XZXJDAR','zh_TW','滴滴-火車訂單同步');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1800025760430721030;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1800025760397166592,'=',' ',' ',1800025760430721030,'3',' ','1',{ts'2023-10-20  00:00:00'},{ts'2023-10-20  00:00:00'},'start_date','值表示当前时间，往前递减的天数',7,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getShortStartDate');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1800025760430721031;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1800025760397166592,'=',' ',' ',1800025760430721031,' ',' ','1',{ts'2023-10-20  00:00:00'},{ts'2023-10-20  00:00:00'},'end_date','值表示当前时间，往前递减的天数',8,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getShortEndDate');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1800025760430721032;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1800025760397166592,'=',' ',' ',1800025760430721032,'0',' ','1',{ts'2023-10-20  00:00:00'},{ts'2023-10-20  00:00:00'},'last_id',' ',9,'1','and','kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getLastId');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1800025760430721029;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1800025760397166592,'=',' ',' ',1800025760430721029,'203',' ','1',{ts'2023-10-20  00:00:00'},{ts'2023-10-20  00:00:00'},'business_type',' ',6,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1800025760430721024;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1800025760397166592,'=',' ',' ',1800025760430721024,'D_Token',' ','1',{ts'2023-10-20  00:00:00'},{ts'2023-10-20  00:00:00'},'access_token',' ',1,'1','and','kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getToken');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1800025760430721025;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1800025760397166592,'=',' ',' ',1800025760430721025,' ',' ','1',{ts'2023-10-20  00:00:00'},{ts'2023-10-20  00:00:00'},'client_id',' ',2,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getAppKey');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1800025760430721026;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1800025760397166592,'=',' ',' ',1800025760430721026,' ',' ','1',{ts'2023-10-20  00:00:00'},{ts'2023-10-20  00:00:00'},'company_id',' ',3,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getOrationid');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1800025760430721027;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1800025760397166592,'=',' ',' ',1800025760430721027,' ',' ','1',{ts'2023-10-20  00:00:00'},{ts'2023-10-20  00:00:00'},'sign',' ',4,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getReservedfield1');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1800025760430721028;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1800025760397166592,'=',' ',' ',1800025760430721028,' ',' ','1',{ts'2023-10-20  00:00:00'},{ts'2023-10-20  00:00:00'},'timestamp',' ',5,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getNowTime');
DELETE FROM T_ER_TRIP_FILTERENTRY WHERE FENTRYID = 1829036361660181504;
INSERT INTO T_ER_TRIP_FILTERENTRY(FID,FFILTERSTATUS,FFILTERCONDITION,FFILTERFIELD,FFILTERVALUE,FFILTERISDEFAULT,FENTRYID,FFILTERDESC,FFILTERMODIFYTIME,FFILTERLOGIC,FFILTERCREATETIME,FFILTERLEFTBRACKET,FSEQ,FFILTERRIGHTBRACKET) VALUES (1800025760397166592,'1','!=','data.detail_list.[0].pay_type','个人支付','1',1829036361660181504,' ',{ts'2024-01-10  00:00:00'},'and',{ts'2023-11-29  00:00:00'},' ',1,' ');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1859491147236597760;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.单据编号',' ',1859491147236597760,'0',{ts'2024-01-10  00:00:00'},'data.detail_list.[0].order_id',{ts'2024-01-10  00:00:00'},'data.detail_list.[0].order_id+ ''-'' +  data.detail_list.[0].booking_member_number +''-''+(IF(data.detail_list.[0].transaction_type= ''出票'',''O'',  IF(data.detail_list.[0].transaction_type= ''改签单'',''G'',''T'')))',48,'3','billno','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721033;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.订单号',' ',1800025760430721033,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].order_id',{ts'2023-11-08  00:00:00'},'data.detail_list.[0].order_id+ ''-'' +  data.detail_list.[0].booking_member_number +''-''+(IF(data.detail_list.[0].transaction_type= ''出票'',''O'',  IF(data.detail_list.[0].transaction_type= ''改签单'',''G'',''T'')))',1,'3','ordernum','1');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721071;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.申请人公司',' ',1800025760430721071,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].out_requisition_id',{ts'2023-10-20  00:00:00'},'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getReqCompanyId',42,'4','company','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721072;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.创建人',' ',1800025760430721072,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserId',43,'4','creator','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721073;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.创建时间',' ',1800025760430721073,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'NOW()',44,'3','createtime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721074;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.修改人',' ',1800025760430721074,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserId',45,'4','modifier','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721075;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.修改时间',' ',1800025760430721075,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'NOW()',46,'3','modifytime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721066;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.席位',' ',1800025760430721066,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].seat_level',{ts'2023-12-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.EnumPlugin#getEnum',36,'4','trainseat','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721034;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.父订单号',' ',1800025760430721034,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].origin_ticket_id_text',{ts'2023-11-03  00:00:00'},' ',2,'1','parentordernum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721035;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.服务商',' ',1800025760430721035,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'DIDI',3,'2','server','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721036;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.订单类型',' ',1800025760430721036,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-11-03  00:00:00'},'IF(data.detail_list.[0].transaction_type= ''出票'',''O'',  IF(data.detail_list.[0].transaction_type= ''改签单'',''G'',''T'') )',4,'3','ordertype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721037;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.订单日期',' ',1800025760430721037,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].order_time',{ts'2023-10-20  00:00:00'},' ',5,'1','orderdate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721038;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.预订人',' ',1800025760430721038,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].booking_member_number',{ts'2023-10-20  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUser',6,'4','sourcebookedid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721039;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.预订人姓名',' ',1800025760430721039,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].booking_member_number',{ts'2023-11-30  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUserName',7,'4','bookedname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721040;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.预订人部门',' ',1800025760430721040,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].booking_member_number',{ts'2023-10-20  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUserDept',8,'4','bookeddept','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721041;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.出差申请/用车申请单号',' ',1800025760430721041,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].out_requisition_id',{ts'2023-10-20  00:00:00'},' ',9,'1','oabillnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721068;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.申请单表单id',' ',1800025760430721068,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrderPlugin#getOabillformid',39,'4','oabillformid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721069;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.费用承担公司',' ',1800025760430721069,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-26  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrgPlugin#getSettleMain',40,'4','expcommitcomnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721070;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.费用承担部门',' ',1800025760430721070,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-26  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrgPlugin#getSettleDept',41,'4','expcommitdepnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721043;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.业务类型',' ',1800025760430721043,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-11-15  00:00:00'},'6',10,'2','operationtype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721044;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.订单分类',' ',1800025760430721044,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'1',11,'2','ordersort','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721045;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.结算类型',' ',1800025760430721045,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'IF(data.detail_list.[0].pay_type  = ''企业支付'',1,2)',12,'3','producttype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721046;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.订单状态',' ',1800025760430721046,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'IF(data.detail_list.[0].transaction_type =''出票'',1, IF(data.detail_list.[0].transaction_type =''改签'',2,3) )',13,'3','orderstatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721047;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.费用发生时间',' ',1800025760430721047,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].order_time',{ts'2023-10-20  00:00:00'},' ',14,'1','happenddate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721048;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.报销状态',' ',1800025760430721048,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'A',15,'2','reimbursestatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721049;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.币种',' ',1800025760430721049,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getCheckingCurrency',16,'4','currency','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721050;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.服务费',' ',1800025760430721050,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].service_fee',{ts'2023-10-20  00:00:00'},' ',17,'1','servicefee','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721051;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.订单金额',' ',1800025760430721051,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].company_real_pay',{ts'2023-10-20  00:00:00'},' ',18,'1','totalamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800036506011076608;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.火车票价',' ',1800036506011076608,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].stub_pay',{ts'2023-10-20  00:00:00'},' ',19,'1','ticketprice','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800036506011076609;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.保险费',' ',1800036506011076609,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'0',20,'2','dealamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800036506011076610;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.火车票车票号',' ',1800036506011076610,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-20  00:00:00'},' ',21,'2','trainticketnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721052;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.退票费',' ',1800025760430721052,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].refund_extra_fee',{ts'2023-10-20  00:00:00'},' ',22,'1','refundamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721053;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.订单性质',' ',1800025760430721053,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'1',23,'2','isbusiness','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721054;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.服务费结算类型',' ',1800025760430721054,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'IF(data.detail_list.[0].pay_type  = ''企业支付'',1,2)',24,'3','servicefeepaytype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721055;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.个人支付金额',' ',1800025760430721055,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].personal_real_pay',{ts'2023-10-20  00:00:00'},' ',25,'1','personalfee','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721056;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.乘客',' ',1800025760430721056,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].passenger_member_number',{ts'2023-10-20  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUser',26,'4','passeger','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721057;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.乘客姓名',' ',1800025760430721057,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].passenger_member_name',{ts'2023-11-15  00:00:00'},' ',27,'1','passegername','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721058;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.乘客部门',' ',1800025760430721058,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].passenger_member_number',{ts'2023-10-20  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUserDept',28,'4','passegerdept','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721059;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.出发城市',' ',1800025760430721059,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].city_name',{ts'2023-10-20  00:00:00'},' ',29,'1','departcity','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721060;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.到达城市',' ',1800025760430721060,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].hotel_name',{ts'2023-10-20  00:00:00'},' ',30,'1','arrivecity','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721061;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.出发车站',' ',1800025760430721061,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].from_station_name',{ts'2023-10-20  00:00:00'},' ',31,'1','departaddress','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721062;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.到达车站',' ',1800025760430721062,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].to_station_name',{ts'2023-10-20  00:00:00'},' ',32,'1','arriveaddress','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721063;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.出发时间',' ',1800025760430721063,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].start_time',{ts'2023-10-20  00:00:00'},' ',33,'1','departtime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721064;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.到达时间',' ',1800025760430721064,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].end_time',{ts'2023-10-20  00:00:00'},' ',34,'1','arrivetime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721065;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.车次',' ',1800025760430721065,'1',{ts'2023-10-20  00:00:00'},'data.detail_list.[0].train_code',{ts'2023-10-20  00:00:00'},' ',35,'1','vendorname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721067;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.超标理由',' ',1800025760430721067,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'''''',37,'2','overdesc','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1800025760430721042;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ','该字段建议放置在字段映射排序靠后，它依赖一些基本信息判断，例如申请单号，出发地，目的地城市，乘车人。','单据头.出差行程ID',' ',1800025760430721042,'1',{ts'2023-10-20  00:00:00'},' ',{ts'2023-10-20  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrderPlugin#getTripId',38,'4','tripid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1830479688079186944;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1800025760397166592,' ','1',' ',' ','单据头.预订人公司',' ',1830479688079186944,'1',{ts'2023-12-01  00:00:00'},'data.detail_list.[0].booking_member_number',{ts'2024-01-10  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUserCompany',47,'4','bookedcompany','0');

/**滴滴火车 结束**/