DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID in(1802166827372003328,1804382278055487488,1803572579831864320,1804291042221088768) ;
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FID in(1802166827372003328,1804382278055487488,1803572579831864320,1804291042221088768) ;
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FID in(1802166827372003328,1804382278055487488,1803572579831864320,1804291042221088768) ;
DELETE FROM T_ER_TRIP_FILTERENTRY WHERE FID in(1802166827372003328,1804382278055487488,1803572579831864320,1804291042221088768) ;
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FID in(1802166827372003328,1804382278055487488,1803572579831864320,1804291042221088768) ;
DELETE FROM T_ER_TRIP_IGNOREEXENTRY WHERE FID in(1802166827372003328,1804382278055487488,1803572579831864320,1804291042221088768) ;

/**滴滴 月结账单开始**/
DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 1802166827372003328;
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 (1802166827372003328,1015862345630818304,'{
	"errno":"1",
	"data":{
		"total":1,
		"records":[
			{
				"bill_id":1125922582836226,
				"end_date":"",
				"groupType":0,
				"bill_amount":14.9,
				"bill_difference":0,
				"bill_period":"2023年07月01日 - 2023年07月31日",
				"root_batch_id":0,
				"companyName":"",
				"bill_consumption":14.9,
				"bill_status":1,
				"bill_refund":0,
				"companyId":"",
				"start_date":"",
				"status":0
			}
		]
	},
	"errmsg":"1"
}','https://api.es.xiaojukeji.com/river/Bill/get','1',1802166827372003328,'GET','C','D_SyncCheck_List','滴滴-月结账单同步',' ','已录入参数',{ts'2023-10-23  00:00:00'},'pull','1',1205612035459523584,'er_checkingbill',{ts'2023-11-17  00:00:00'},'{
	"access_token":"611344",
	"bill_stsatus":1,
	"company_id":"car_lixingffcamia1",
	"offset":5,
	"last_id":"4",
	"sign":"car_lixingffcamia1",
	"business_line":1,
	"client_id":1,
	"timestamp":"364537D769162754A9142BCA53F1C7D2"
}','kd.fi.er.business.trip.v2.server.dtrip.DtripSyncCheckInvoke#execute',1205612035459523584,'已录入参数');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '3NC/3Z4+RFB+';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1802166827372003328,'3NC/3Z4+RFB+','zh_CN','滴滴-月结账单同步');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '3NC/3Z4+RFB/';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1802166827372003328,'3NC/3Z4+RFB/','zh_TW','滴滴-月結賬單同步');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1802223540930363398;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1802166827372003328,'=',' ',' ',1802223540930363398,' ',' ','1',{ts'2023-10-23  00:00:00'},{ts'2023-12-04  00:00:00'},'offset',' ',7,'1','and','kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getOffset');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1802223540930363397;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1802166827372003328,'=',' ',' ',1802223540930363397,'100',' ','1',{ts'2023-10-23  00:00:00'},{ts'2023-12-05  00:00:00'},'length',' ',6,'1','and','kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#putLength');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1802223540930363392;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1802166827372003328,'=',' ',' ',1802223540930363392,'D_Token',' ','1',{ts'2023-10-23  00:00:00'},{ts'2023-11-03  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 = 1802223540930363393;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1802166827372003328,'=',' ',' ',1802223540930363393,' ',' ','1',{ts'2023-10-23  00:00:00'},{ts'2023-11-03  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 = 1802223540930363394;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1802166827372003328,'=',' ',' ',1802223540930363394,' ',' ','1',{ts'2023-10-23  00:00:00'},{ts'2023-11-03  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 = 1802223540930363395;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1802166827372003328,'=',' ',' ',1802223540930363395,' ',' ','1',{ts'2023-10-23  00:00:00'},{ts'2023-11-03  00:00:00'},'sign',' ',4,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getReservedfield1');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1802223540930363396;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1802166827372003328,'=',' ',' ',1802223540930363396,' ',' ','1',{ts'2023-10-23  00:00:00'},{ts'2023-11-03  00:00:00'},'timestamp',' ',5,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getNowTime');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1820443544817832960;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1802166827372003328,'=',' ',' ',1820443544817832960,'1',' ','1',{ts'2023-11-17  00:00:00'},{ts'2023-11-17  00:00:00'},'bill_status',' ',8,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1820443728855493632;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1802166827372003328,'=',' ',' ',1820443728855493632,'1',' ','1',{ts'2023-11-17  00:00:00'},{ts'2023-11-17  00:00:00'},'business_line',' ',9,'1','and',' ');
-- DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1833444273031446528;
-- INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1802166827372003328,' ','1',' ','源单字段【data.records.[0].formid】并非第三方提供。','单据头.表单ID',' ',1833444273031446528,'1',{ts'2023-12-05  00:00:00'},'data.records.[0].formid',{ts'2023-12-05  00:00:00'},' ',10,'1','formid','0');
-- DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1802223540930362383;
-- INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1802166827372003328,' ','1',' ',' ','单据头.修改人',' ',1802223540930362383,'1',{ts'2023-10-23  00:00:00'},' ',{ts'2023-12-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserId',13,'4','modifier','0');
-- DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1802223540930362370;
-- INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1802166827372003328,' ','1',' ',' ','单据头.组织',' ',1802223540930362370,'1',{ts'2023-10-23  00:00:00'},'1',{ts'2023-11-03  00:00:00'},' ',3,'1','org','0');
-- DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1802223540930362378;
-- INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1802166827372003328,' ','1',' ',' ','单据头.账单起始日',' ',1802223540930362378,'1',{ts'2023-10-23  00:00:00'},'data.records.[0].bill_period',{ts'2023-11-16  00:00:00'},'kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getPeriodStart',7,'4','periodstartdate','0');
-- DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1802223540930362379;
-- INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1802166827372003328,' ','1',' ',' ','单据头.账单截止日',' ',1802223540930362379,'1',{ts'2023-10-23  00:00:00'},'data.records.[0].bill_period',{ts'2023-11-16  00:00:00'},'kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getPeriodEnd',8,'4','periodenddate','0');
-- DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1802223540930362368;
-- INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1802166827372003328,' ','1',' ',' ','单据头.单据编号',' ',1802223540930362368,'1',{ts'2023-10-23  00:00:00'},'data.records.[0].bill_id',{ts'2023-11-16  00:00:00'},'STRING(data.records.[0].bill_id) + ''-'' +  data.records.[0].operationtype',1,'3','billno','1');
-- DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1802223540930362369;
-- INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1802166827372003328,' ','1',' ','源单字段【data.records.[0].operationtype】并非第三方提供。','单据头.服务类型',' ',1802223540930362369,'1',{ts'2023-10-23  00:00:00'},'data.records.[0].operationtype',{ts'2023-11-03  00:00:00'},' ',2,'1','operationtype','0');
-- DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1802223540930362371;
-- INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1802166827372003328,' ','1',' ',' ','单据头.服务商',' ',1802223540930362371,'1',{ts'2023-10-23  00:00:00'},' ',{ts'2023-11-03  00:00:00'},'DIDI',4,'2','server','0');
-- DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1802223540930362372;
-- INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1802166827372003328,' ','1',' ',' ','单据头.账单编号',' ',1802223540930362372,'1',{ts'2023-10-23  00:00:00'},' ',{ts'2023-11-16  00:00:00'},'STRING(data.records.[0].bill_id) + ''-'' +  data.records.[0].operationtype',5,'3','billnum','0');
-- DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1802223540930362376;
-- INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1802166827372003328,' ','1',' ',' ','单据头.结算金额',' ',1802223540930362376,'1',{ts'2023-10-23  00:00:00'},'1',{ts'2023-11-03  00:00:00'},' ',6,'1','settlementamount','0');
-- DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1802223540930362380;
-- INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1802166827372003328,' ','1',' ',' ','单据头.账单状态',' ',1802223540930362380,'1',{ts'2023-10-23  00:00:00'},' ',{ts'2023-11-03  00:00:00'},'1',9,'2','billstatusname','0');
-- DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1802223540930362381;
-- INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1802166827372003328,' ','1',' ',' ','单据头.创建人',' ',1802223540930362381,'1',{ts'2023-10-23  00:00:00'},' ',{ts'2023-12-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserId',11,'4','creator','0');
-- DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1802223540930362382;
-- INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1802166827372003328,' ','1',' ',' ','单据头.创建时间',' ',1802223540930362382,'1',{ts'2023-10-23  00:00:00'},' ',{ts'2023-12-05  00:00:00'},'NOW()',12,'3','createtime','0');
-- DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1802223540930362384;
-- INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1802166827372003328,' ','1',' ',' ','单据头.修改时间',' ',1802223540930362384,'1',{ts'2023-10-23  00:00:00'},' ',{ts'2023-12-05  00:00:00'},'NOW()',14,'3','modifytime','0');

/**滴滴 月结账单结束**/

/**滴滴 酒店结算单开始**/
DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 1803572579831864320;
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 (1803572579831864320,1015862345630818304,'{
	"errno":0,
	"data":{
		"total":21,
		"is_last":true,
		"last_id":"1125925709168441",
		"orders":[
			{
				"rooms":"豪华房-大床",
				"check_out_date":"2023-10-18",
				"personal_real_pay":94,
				"approval_second":"",
				"check_in_path_dep_name":"金蝶*****&gt;Sales",
				"budget_center_name":"",
				"hotel_address":"远大一路730号",
				"booking_dep_code":"564873160",
				"book_day_number":1,
				"approval_history":"",
				"order_status":"已完成",
				"room_num":1,
				"approval_first":"",
				"approval_third":"",
				"company_coupon_cost":0,
				"order_type":"预订",
				"bill_id":1125925817698479,
				"cost_discount_before":594,
				"original_check_out_date":"2023-10-18",
				"unique_key":"1125925276542238",
				"tax_ratio":"6%",
				"budget_center_id":"0",
				"budget_center_parent_path_name":"",
				"company_real_amount":505,
				"check_in_member_numbers":"100638",
				"booking_member_name":"郑宇",
				"hotel_name":"长沙东盈广场希尔顿欢朋酒店",
				"travel_purpose":"",
				"booking_dep_name":"Sales",
				"rc_agreed_price":"",
				"budget_center_code":"",
				"ex_info_02":"",
				"ex_info_01":"",
				"ex_info_03":"",
				"check_in_names":"郑宇",
				"is_vat":"是",
				"passenger_legal_entity_name":"",
				"booking_dep_id":"1125924435890719",
				"order_id":"1125925276514879",
				"trip_reason":"会议",
				"personal_real_refund":0,
				"rc_low_price":"",
				"legal_entity_id":0,
				"passenger_legal_entity_id":0,
				"booking_date":"2023-10-17 16:48:28",
				"booking_member_number":"100638",
				"travel_description":"",
				"remark":"",
				"check_in_dep_code":"564873160",
				"institution_name":"员工出差管控制度-1125925276312518",
				"check_in_dep_name":"Sales",
				"total_nights":1,
				"city_name":"长沙市",
				"personal_coupon_cost":0,
				"booking_parent_path_dep_name":"金蝶*****&gt;Sales",
				"company_pay_type":"消费",
				"pay_type":"混合支付",
				"department":"Sales",
				"member_id":"1125924678069946",
				"amount":594,
				"room_price_average":594,
				"rc_book":"",
				"service_fee":5,
				"room_serial_name":"",
				"passenger_name":"郑宇",
				"settle_time":"2023-10-17 16:48:28",
				"extra_info":"",
				"requisition_id":"1125925276312518",
				"check_in_dep_id":"1125924435890719",
				"order_source":"企业APP",
				"hotel_type":"酒店协议价",
				"out_requisition_id":"CCSQ-202310-00047",
				"rc_level":"",
				"check_in_member_departments":"Sales",
				"legal_entity_name":"",
				"check_in_date":"2023-10-17",
				"gust_order_id":"1125925276542238"
			}
		]
	},
	"errmsg":"SUCCESS",
	"request_id":"mbSxNllrNolRlUhL05npUK45D1XG2SlcDFZzA2RvAxwk7I3XRYg5tlk4VFKixiJo"
}','https://api.es.xiaojukeji.com/river/Bill/detail','1',1803572579831864320,'GET','C','D_SyncHotelChecking_List','滴滴-酒店结算单同步',' ','已录入参数',{ts'2023-10-25  00:00:00'},'pull','1',1205612035459523584,'er_hotelcheckingbill',{ts'2023-11-15  00:00:00'},'{
	"access_token":"611344",
	"bill_id":"4",
	"company_id":"car_lixingffcamia1",
	"last_id":"4",
	"business_type":201,
	"sign":"car_lixingffcamia1",
	"length":5,
	"client_id":1,
	"timestamp":"364537D769162754A9142BCA53F1C7D2"
}','kd.fi.er.business.trip.v2.server.dtrip.DtripSyncCheckingInvoke#execute',1205612035459523584,'已录入参数');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '3NIQSJ4U9J8T';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1803572579831864320,'3NIQSJ4U9J8T','zh_CN','滴滴-酒店结算单同步');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '3NIQSJ4U9J8U';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1803572579831864320,'3NIQSJ4U9J8U','zh_TW','滴滴-酒店結算單同步');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1803572580872051712;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1803572579831864320,'=',' ',' ',1803572580872051712,'D_Token',' ','1',{ts'2023-10-25  00:00:00'},{ts'2023-10-25  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 = 1803572580872051713;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1803572579831864320,'=',' ',' ',1803572580872051713,' ',' ','1',{ts'2023-10-25  00:00:00'},{ts'2023-10-25  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 = 1803572580872051714;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1803572579831864320,'=',' ',' ',1803572580872051714,' ',' ','1',{ts'2023-10-25  00:00:00'},{ts'2023-10-25  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 = 1803572580872051715;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1803572579831864320,'=',' ',' ',1803572580872051715,' ',' ','1',{ts'2023-10-25  00:00:00'},{ts'2023-10-25  00:00:00'},'sign',' ',4,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getReservedfield1');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1803572580872051716;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1803572579831864320,'=',' ',' ',1803572580872051716,' ',' ','1',{ts'2023-10-25  00:00:00'},{ts'2023-10-25  00:00:00'},'timestamp',' ',5,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getNowTime');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1803572580872051717;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1803572579831864320,'=',' ',' ',1803572580872051717,'201',' ','1',{ts'2023-10-25  00:00:00'},{ts'2023-10-25  00:00:00'},'business_type',' ',6,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1803572580872051718;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1803572579831864320,'=',' ',' ',1803572580872051718,'100',' ','1',{ts'2023-10-25  00:00:00'},{ts'2023-10-25  00:00:00'},'length',' ',7,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1803572580872051719;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1803572579831864320,'=',' ',' ',1803572580872051719,' ',' ','1',{ts'2023-10-25  00:00:00'},{ts'2023-10-25  00:00:00'},'bill_id',' ',8,'1','and','kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getBillId');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1803572580872051720;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1803572579831864320,'=',' ',' ',1803572580872051720,'0',' ','1',{ts'2023-10-25  00:00:00'},{ts'2023-10-25  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 = 1803681993561595904;
INSERT INTO T_ER_TRIP_FILTERENTRY(FID,FFILTERSTATUS,FFILTERCONDITION,FFILTERFIELD,FFILTERVALUE,FFILTERISDEFAULT,FENTRYID,FFILTERDESC,FFILTERMODIFYTIME,FFILTERLOGIC,FFILTERCREATETIME,FFILTERLEFTBRACKET,FSEQ,FFILTERRIGHTBRACKET) VALUES (1803572579831864320,'1','in','data.orders.[0].order_status','预订成功,已入住,已完成,已取消预订,预订未到','1',1803681993561595904,' ',{ts'2023-11-29  00:00:00'},'and',{ts'2023-10-25  00:00:00'},' ',1,' ');
DELETE FROM T_ER_TRIP_FILTERENTRY WHERE FENTRYID = 1833489135995020288;
INSERT INTO T_ER_TRIP_FILTERENTRY(FID,FFILTERSTATUS,FFILTERCONDITION,FFILTERFIELD,FFILTERVALUE,FFILTERISDEFAULT,FENTRYID,FFILTERDESC,FFILTERMODIFYTIME,FFILTERLOGIC,FFILTERCREATETIME,FFILTERLEFTBRACKET,FSEQ,FFILTERRIGHTBRACKET) VALUES (1803572579831864320,'1','in','data.orders.[0].pay_type','企业支付,企业钱包支付,混合支付','1',1833489135995020288,' ',{ts'2023-12-05  00:00:00'},'and',{ts'2023-12-05  00:00:00'},' ',2,' ');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1829120914936465409;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.预订人姓名',' ',1829120914936465409,'1',{ts'2023-11-29  00:00:00'},'data.orders.[0].booking_member_number',{ts'2023-12-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUserName',27,'4','bookedname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803706635517026304;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.个人支付金额',' ',1803706635517026304,'1',{ts'2023-10-25  00:00:00'},'data.orders.[0].personal_real_pay',{ts'2023-12-05  00:00:00'},' ',40,'1','personalfee','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803706635517026305;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.是否对平',' ',1803706635517026305,'1',{ts'2023-10-25  00:00:00'},' ',{ts'2023-12-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getIsbalance',41,'4','isbalance','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803706635517026306;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.可抵扣',' ',1803706635517026306,'1',{ts'2023-10-25  00:00:00'},' ',{ts'2023-12-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getIsdeductible',42,'4','isdeductible','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803706635517026307;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.票价税额',' ',1803706635517026307,'1',{ts'2023-10-25  00:00:00'},' ',{ts'2023-12-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getOrderamounttax',43,'4','orderamounttax','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803706635517026308;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.票价税率(%)',' ',1803706635517026308,'1',{ts'2023-10-25  00:00:00'},' ',{ts'2023-12-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getOrderdeductrate',44,'4','orderdeductrate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803706635517026309;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.服务费税额',' ',1803706635517026309,'1',{ts'2023-10-25  00:00:00'},' ',{ts'2023-12-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getServiceamounttax',45,'4','serviceamounttax','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803706635517026310;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.服务费税率(%)',' ',1803706635517026310,'1',{ts'2023-10-25  00:00:00'},' ',{ts'2023-12-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getServicedeductrate',46,'4','servicedeductrate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803706635517026311;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.可抵扣税额',' ',1803706635517026311,'1',{ts'2023-10-25  00:00:00'},' ',{ts'2023-12-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getTotaltax',47,'4','totaltax','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803706635517026312;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.是否对账',' ',1803706635517026312,'1',{ts'2023-10-25  00:00:00'},' ',{ts'2023-12-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getIsreconciliation',48,'4','isreconciliation','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051760;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.创建人',' ',1803572580872051760,'1',{ts'2023-10-25  00:00:00'},' ',{ts'2023-12-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserId',49,'4','creator','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1813898740029726720;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.单据状态',' ',1813898740029726720,'1',{ts'2023-11-08  00:00:00'},' ',{ts'2023-12-05  00:00:00'},'A',50,'2','billstatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051761;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.创建时间',' ',1803572580872051761,'1',{ts'2023-10-25  00:00:00'},' ',{ts'2023-12-05  00:00:00'},'NOW()',51,'3','createtime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051762;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.修改人',' ',1803572580872051762,'1',{ts'2023-10-25  00:00:00'},' ',{ts'2023-12-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserId',52,'4','modifier','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051763;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.修改时间',' ',1803572580872051763,'1',{ts'2023-10-25  00:00:00'},' ',{ts'2023-12-05  00:00:00'},'NOW()',53,'3','modifytime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803710824594925568;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.表单ID',' ',1803710824594925568,'1',{ts'2023-10-25  00:00:00'},' ',{ts'2023-12-05  00:00:00'},'er_hotelcheckingbill',54,'2','formid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051723;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.服务商',' ',1803572580872051723,'1',{ts'2023-10-25  00:00:00'},' ',{ts'2023-12-05  00:00:00'},'DIDI',3,'2','server','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051724;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.订单类型',' ',1803572580872051724,'1',{ts'2023-10-25  00:00:00'},' ',{ts'2023-12-05  00:00:00'},'IF(data.orders.[0].order_type= ''预订'',''O'', ''T'')',4,'3','ordertype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051725;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.订单日期',' ',1803572580872051725,'1',{ts'2023-10-25  00:00:00'},'data.orders.[0].booking_date',{ts'2023-12-05  00:00:00'},' ',5,'1','orderdate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051730;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.业务类型',' ',1803572580872051730,'1',{ts'2023-10-25  00:00:00'},' ',{ts'2023-12-05  00:00:00'},'1',6,'2','operationtype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051727;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.单据编号',' ',1803572580872051727,'1',{ts'2023-10-25  00:00:00'},'data.orders.[0].bill_id',{ts'2023-12-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getBillIdByJsonValue',7,'4','checkingbillnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051726;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.结算批次号',' ',1803572580872051726,'1',{ts'2023-10-25  00:00:00'},'data.orders.[0].bill_id',{ts'2023-12-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getBillIdByJsonValue',8,'4','batchno','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051756;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.申请单表单id',' ',1803572580872051756,'1',{ts'2023-10-25  00:00:00'},' ',{ts'2023-12-28  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrderPlugin#getOabillformid',10,'4','oabillformid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051729;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.申请单号',' ',1803572580872051729,'1',{ts'2023-10-25  00:00:00'},'data.orders.[0].out_requisition_id',{ts'2023-12-28  00:00:00'},' ',9,'1','oabillnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051731;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.订单分类',' ',1803572580872051731,'1',{ts'2023-10-25  00:00:00'},' ',{ts'2023-12-05  00:00:00'},'1',11,'2','ordersort','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051732;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.结算类型',' ',1803572580872051732,'1',{ts'2023-10-25  00:00:00'},' ',{ts'2023-12-05  00:00:00'},'IF(data.orders.[0].pay_type= ''企业支付''  OR data.orders.[0].pay_type= ''企业钱包支付''  OR data.orders.[0].pay_type= ''混合支付'',''1'',''2'')',12,'3','producttype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051733;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.订单状态',' ',1803572580872051733,'1',{ts'2023-10-25  00:00:00'},'data.orders.[0].order_status',{ts'2023-12-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.EnumPlugin#getEnum',13,'4','orderstatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051734;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.结算发生时间',' ',1803572580872051734,'1',{ts'2023-10-25  00:00:00'},'data.orders.[0].settle_time',{ts'2023-12-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getHappenddate',14,'4','happenddate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1813202295236939776;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.期间',' ',1813202295236939776,'1',{ts'2023-11-07  00:00:00'},' ',{ts'2024-01-10  00:00:00'},'kd.fi.er.business.trip.v2.plugin.TimePlugin#getPeriod',15,'4','period','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051735;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.报销状态',' ',1803572580872051735,'1',{ts'2023-10-25  00:00:00'},' ',{ts'2023-12-05  00:00:00'},'A',16,'2','reimbursestatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051736;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.币种',' ',1803572580872051736,'1',{ts'2023-10-25  00:00:00'},' ',{ts'2023-12-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getCheckingCurrency',17,'4','currency','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051737;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.服务费',' ',1803572580872051737,'1',{ts'2023-10-25  00:00:00'},'data.orders.[0].service_fee',{ts'2023-12-05  00:00:00'},' ',18,'1','servicefee','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051738;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.结算金额',' ',1803572580872051738,'1',{ts'2023-10-25  00:00:00'},'data.orders.[0].company_real_amount',{ts'2023-12-05  00:00:00'},' ',19,'1','totalamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051739;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.退订费',' ',1803572580872051739,'1',{ts'2023-10-25  00:00:00'},' ',{ts'2023-12-05  00:00:00'},'0',20,'2','unbookfee','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051752;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.订房间数',' ',1803572580872051752,'1',{ts'2023-10-25  00:00:00'},'data.orders.[0].room_num',{ts'2023-12-05  00:00:00'},' ',34,'1','roomcount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051740;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.订单性质',' ',1803572580872051740,'1',{ts'2023-10-25  00:00:00'},'data.orders.[0].pay_type',{ts'2023-12-05  00:00:00'},'IF(data.orders.[0].pay_type= ''企业支付''  OR data.orders.[0].pay_type= ''企业钱包支付''  OR data.orders.[0].pay_type= ''混合支付'',''1'',''2'')',21,'3','isbusiness','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051741;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.服务费结算类型',' ',1803572580872051741,'1',{ts'2023-10-25  00:00:00'},' ',{ts'2023-12-05  00:00:00'},'1',22,'2','servicefeepaytype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051742;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.订单总表数据',' ',1803572580872051742,'1',{ts'2023-10-25  00:00:00'},' ',{ts'2023-12-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#allOrderId',23,'4','allorderbase','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051743;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.入住人工号',' ',1803572580872051743,'1',{ts'2023-10-25  00:00:00'},'data.orders.[0].check_in_member_numbers',{ts'2023-12-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUser',24,'4','sourcetravelerid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051744;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.入住人',' ',1803572580872051744,'1',{ts'2023-10-25  00:00:00'},'data.orders.[0].check_in_member_numbers',{ts'2023-12-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUserName',25,'4','travelername','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1829120914936465408;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.预订人工号',' ',1829120914936465408,'1',{ts'2023-11-29  00:00:00'},'data.orders.[0].booking_member_number',{ts'2023-12-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUser',26,'4','sourcebookedid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1829120914936465410;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.票价开票类型',' ',1829120914936465410,'1',{ts'2023-11-29  00:00:00'},' ',{ts'2023-12-05  00:00:00'},'9999',28,'2','pricebillingtype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051746;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.城市',' ',1803572580872051746,'1',{ts'2023-10-25  00:00:00'},'data.orders.[0].city_name',{ts'2023-12-05  00:00:00'},' ',29,'1','cityname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051747;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.酒店名称',' ',1803572580872051747,'1',{ts'2023-10-25  00:00:00'},'data.orders.[0].hotel_name',{ts'2023-12-05  00:00:00'},' ',30,'1','hotelname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051749;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.入住日期',' ',1803572580872051749,'1',{ts'2023-10-25  00:00:00'},'data.orders.[0].check_in_date',{ts'2023-12-05  00:00:00'},' ',31,'1','checkindate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051750;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.离店日期',' ',1803572580872051750,'1',{ts'2023-10-25  00:00:00'},' ',{ts'2023-12-05  00:00:00'},'IF(data.orders.[0].check_out_date  <>  null  AND data.orders.[0].check_out_date  <> '''' ,data.orders.[0].check_out_date ,data.orders.[0].original_check_out_date )',32,'3','checkoutdate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051751;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.房型',' ',1803572580872051751,'1',{ts'2023-10-25  00:00:00'},'data.orders.[0].rooms',{ts'2023-12-05  00:00:00'},' ',33,'1','roomstylename','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051753;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.房价',' ',1803572580872051753,'1',{ts'2023-10-25  00:00:00'},'data.orders.[0].room_price_average',{ts'2023-12-05  00:00:00'},' ',35,'1','roomamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051757;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.费用承担公司',' ',1803572580872051757,'1',{ts'2023-10-25  00:00:00'},' ',{ts'2023-12-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrgPlugin#getSettleMain',36,'4','settlemain','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051758;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.费用承担部门',' ',1803572580872051758,'1',{ts'2023-10-25  00:00:00'},' ',{ts'2023-12-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrgPlugin#getSettleDept',37,'4','settledept','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051759;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.申请人公司',' ',1803572580872051759,'1',{ts'2023-10-25  00:00:00'},'data.orders.[0].out_requisition_id',{ts'2023-12-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getReqCompanyId',38,'4','company','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051748;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.申请人部门',' ',1803572580872051748,'1',{ts'2023-10-25  00:00:00'},'data.orders.[0].out_requisition_id',{ts'2023-12-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getReqCompanyId',39,'4','org','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1859489563417075712;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.单据编号',' ',1859489563417075712,'1',{ts'2024-01-10  00:00:00'},'data.orders.[0].order_id',{ts'2024-01-10  00:00:00'},'data.orders.[0].order_id  + ''-'' +RIGHT(data.orders.[0].unique_key,4) + ''-''+ data.orders.[0].booking_member_number  + ''-'' + IF(data.orders.[0].order_type= ''预订'',''O'', ''T'')',55,'3','billno','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051722;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.父订单号',' ',1803572580872051722,'1',{ts'2023-10-25  00:00:00'},'data.orders.[0].order_id',{ts'2023-11-29  00:00:00'},' ',2,'1','parentordernum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1803572580872051721;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1803572579831864320,' ','1',' ',' ','单据头.订单号',' ',1803572580872051721,'1',{ts'2023-10-25  00:00:00'},'data.orders.[0].order_id',{ts'2023-11-29  00:00:00'},'data.orders.[0].order_id  + ''-'' +RIGHT(data.orders.[0].unique_key,4) + ''-''+ data.orders.[0].booking_member_number  + ''-'' + IF(data.orders.[0].order_type= ''预订'',''O'', ''T'')',1,'3','ordernum','1');

/**滴滴 酒店结算单结束**/

/**滴滴 机票结算单开始**/
DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 1804291042221088768;
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 (1804291042221088768,1015862345630818304,'{
	"errno":0,
	"data":{
		"total":4,
		"is_last":true,
		"last_id":"1125925676595965-2-1125925676595965",
		"orders":[
			{
				"reason":"",
				"ticket_id_text":"",
				"discount":"2.9折",
				"budget_center_name":"",
				"rc_time_period":"",
				"booking_dep_code":"564873160",
				"added_es_cut_fee":0,
				"approval_history":"",
				"passenger_dep_code":"564873160",
				"flight_travel_type":0,
				"bill_id":1125925817698479,
				"final_departure_time":"",
				"before_cut_service_fee":0,
				"final_offline_status":"",
				"pnr_number":"KTH4VK",
				"approval_id":"1125925457969018",
				"travel_purpose":"",
				"ex_info_02":"",
				"flight_segment_number":1,
				"is_agreement":"否",
				"ex_info_01":"",
				"cabin_name":"经济舱",
				"employee_number":"100638",
				"ex_info_03":"",
				"departure_city_name":"杭州",
				"order_id":"1125925593790796",
				"trip_reason":"三会议",
				"legal_entity_id":0,
				"ticket_fee":"920.00",
				"departure_airport_name":"萧山机场",
				"travel_itinerary_fee":"1100.00",
				"pre_order_id":"0",
				"booking_parent_path_dep_name":"金蝶*****&gt;Sales",
				"upgrade_cost":"0.00",
				"upgrade_final_status":1,
				"passenger_member_name":"郑宇",
				"arrival_city_name":"北京",
				"department_id":"1125924435890719",
				"order_fix_type":0,
				"added_goods_name":"",
				"economy_original_cost":"0",
				"out_requisition_id":"CCSQ-202310-00061",
				"rc_level":"",
				"added_cut_reason":"",
				"rc_lowPrice":"航空公司偏好",
				"order_fix_settle_time":"",
				"settlement_time":"2023-10-27 18:00:00",
				"airline_simple_name":"中国国航",
				"flight_segment_travel":"杭州-北京",
				"cabin_code":"P",
				"total_fee":"1100.00",
				"origin_ticket_id":"1125925593796961",
				"departure_time":"2023-10-28 08:00:00",
				"fuelCost_sp":"130.00",
				"create_time":"2023-10-27 07:30:26",
				"change_handle_cost":"0.00",
				"unique_key":"1125925593796961-0",
				"budget_center_id":"0",
				"arrival_airport_name":"首都机场",
				"budget_center_parent_path_name":"",
				"transaction_type":0,
				"passenger_member_number":"100638",
				"booking_member_name":"郑宇",
				"booking_dep_name":"Sales",
				"company_real_pay":"1108.00",
				"budget_center_code":"",
				"supplier_order_id":"9993015615666",
				"passenger_legal_entity_name":"",
				"is_added":0,
				"construction_cost_sp":"50.00",
				"passenger_legal_entity_id":0,
				"booking_date":"2023-10-27 07:30:26",
				"booking_member_number":"100638",
				"cabin_type":4,
				"arrival_airport_code":"PEK",
				"institution_name":"员工出差管控制度-1125925457969018",
				"exception_info":"",
				"origin_order_id":"1125925593790796",
				"invoice_fee":"0.00",
				"trip_description":"",
				"pay_type":"企业支付",
				"department":"Sales",
				"member_id":"1125924678069946",
				"arrival_time":"2023-10-28 10:15:00",
				"supplier_ticket_number":"999-3015615666",
				"flight_number":"CA1703",
				"rc_book":"",
				"service_fee":"8.00",
				"construction_cost":"50.00",
				"departure_airport_code":"HGH",
				"passenger_name":"郑宇",
				"ticket_fee_sp":"920.00",
				"extra_info":"",
				"requisition_id":"1125925457969018",
				"passenger_dep_name":"Sales",
				"refund_handle_cost":"0",
				"legal_entity_name":"",
				"passenger_parent_path_dep_name":"金蝶*****&gt;Sales",
				"sub_company_no":"",
				"fuelCost":"130.00"
			}
		]
	},
	"errmsg":"SUCCESS",
	"request_id":"zP0OSTssYlb36/c0NwC21MzYjqgdmUM8hSUZY5Q+f4uDssExlAnoSd46i8svC0Za"
}','https://api.es.xiaojukeji.com/river/Bill/detail','1',1804291042221088768,'GET','C','D_SyncPlaneChecking_List','滴滴-机票结算单同步',' ','已录入参数',{ts'2023-10-26  00:00:00'},'pull','1',1205612035459523584,'er_planecheckingbill',{ts'2023-11-21  00:00:00'},'{
	"access_token":"611344",
	"bill_id":"4",
	"company_id":"car_lixingffcamia1",
	"last_id":"4",
	"business_type":202,
	"sign":"car_lixingffcamia1",
	"length":5,
	"client_id":1,
	"timestamp":"364537D769162754A9142BCA53F1C7D2"
}','kd.fi.er.business.trip.v2.server.dtrip.DtripSyncCheckingInvoke#execute',1205612035459523584,'已录入参数');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '3NM6/ZCCIYNM';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1804291042221088768,'3NM6/ZCCIYNM','zh_CN','滴滴-机票结算单同步');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '3NM6/ZCCIYNN';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1804291042221088768,'3NM6/ZCCIYNN','zh_TW','滴滴-機票結算單同步');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1804291042263031808;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1804291042221088768,'=',' ',' ',1804291042263031808,'D_Token',' ','1',{ts'2023-10-26  00:00:00'},{ts'2023-12-01  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 = 1804291042263031809;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1804291042221088768,'=',' ',' ',1804291042263031809,' ',' ','1',{ts'2023-10-26  00:00:00'},{ts'2023-12-01  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 = 1804291042263031810;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1804291042221088768,'=',' ',' ',1804291042263031810,' ',' ','1',{ts'2023-10-26  00:00:00'},{ts'2023-12-01  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 = 1804291042263031811;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1804291042221088768,'=',' ',' ',1804291042263031811,' ',' ','1',{ts'2023-10-26  00:00:00'},{ts'2023-12-01  00:00:00'},'sign',' ',4,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getReservedfield1');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1804291042263031812;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1804291042221088768,'=',' ',' ',1804291042263031812,' ',' ','1',{ts'2023-10-26  00:00:00'},{ts'2023-12-01  00:00:00'},'timestamp',' ',5,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getNowTime');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1804291042263031813;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1804291042221088768,'=',' ',' ',1804291042263031813,'202',' ','1',{ts'2023-10-26  00:00:00'},{ts'2023-12-01  00:00:00'},'business_type',' ',6,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1804291042263031814;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1804291042221088768,'=',' ',' ',1804291042263031814,'100',' ','1',{ts'2023-10-26  00:00:00'},{ts'2023-12-01  00:00:00'},'length',' ',7,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1804291042263031815;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1804291042221088768,'=',' ',' ',1804291042263031815,' ',' ','1',{ts'2023-10-26  00:00:00'},{ts'2023-12-01  00:00:00'},'bill_id',' ',8,'1','and','kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getBillId');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1804291042263031816;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1804291042221088768,'=',' ',' ',1804291042263031816,'0',' ','1',{ts'2023-10-26  00:00:00'},{ts'2023-12-01  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 = 1830513909363222528;
INSERT INTO T_ER_TRIP_FILTERENTRY(FID,FFILTERSTATUS,FFILTERCONDITION,FFILTERFIELD,FFILTERVALUE,FFILTERISDEFAULT,FENTRYID,FFILTERDESC,FFILTERMODIFYTIME,FFILTERLOGIC,FFILTERCREATETIME,FFILTERLEFTBRACKET,FSEQ,FFILTERRIGHTBRACKET) VALUES (1804291042221088768,'1','!=','data.orders.[0].pay_type','个人支付','1',1830513909363222528,' ',{ts'2024-01-10  00:00:00'},'and',{ts'2023-12-01  00:00:00'},' ',1,' ');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422467;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.订单日期',' ',1804291042271422467,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].create_time',{ts'2023-12-01  00:00:00'},' ',4,'1','orderdate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1859490364428384256;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.单据编号',' ',1859490364428384256,'1',{ts'2024-01-10  00:00:00'},'data.orders.[0].order_id',{ts'2024-01-10  00:00:00'},'data.orders.[0].order_id+ ''-'' +  data.orders.[0].booking_member_number +''-''+(IF(data.orders.[0].transaction_type = 0,''O'', IF(data.orders.[0].transaction_type = 1,''G'',''T'')))',64,'3','billno','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422468;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.预订人',' ',1804291042271422468,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].booking_member_number',{ts'2023-12-01  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUser',5,'4','sourcebookedid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422469;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.预订人',' ',1804291042271422469,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].booking_member_number',{ts'2023-12-01  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUserName',6,'4','bookedname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422472;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.申请单号',' ',1804291042271422472,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].out_requisition_id',{ts'2023-12-28  00:00:00'},' ',7,'1','oabillnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422475;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.订单分类',' ',1804291042271422475,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'IF(data.orders.[0].flight_travel_type = 0,1,2)',11,'3','ordersort','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422476;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.结算类型',' ',1804291042271422476,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'IF(data.orders.[0].pay_type  = ''企业支付''  OR data.orders.[0].pay_type  = ''混合支付''  OR data.orders.[0].pay_type  = ''企业钱包支付'',1,2)',12,'3','producttype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422507;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.订单类型',' ',1804291042271422507,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'IF(data.orders.[0].transaction_type = 0,''O'', IF(data.orders.[0].transaction_type = 1,''G'',''T'') )',37,'3','ordertype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422508;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.订单性质',' ',1804291042271422508,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'IF(data.orders.[0].pay_type = ''企业支付'' OR data.orders.[0].pay_type =''企业钱包支付'' OR data.orders.[0].pay_type =''混合支付'',1,2)',38,'3','isbusiness','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422465;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.父订单号',' ',1804291042271422465,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].origin_order_id',{ts'2023-12-01  00:00:00'},' ',2,'1','parentordernum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422473;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.电子客票号',' ',1804291042271422473,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].supplier_order_id',{ts'2023-12-01  00:00:00'},' ',9,'1','ticketnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422479;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.结算发生时间',' ',1804291042271422479,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].departure_time',{ts'2023-12-01  00:00:00'},'kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getHappenddate',15,'4','happenddate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422481;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.航空公司名称',' ',1804291042271422481,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].airline_simple_name',{ts'2023-12-01  00:00:00'},' ',18,'1','airlinename','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422482;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.航班号',' ',1804291042271422482,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].flight_number',{ts'2023-12-01  00:00:00'},' ',19,'1','flightno','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422483;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.舱位等级',' ',1804291042271422483,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].cabin_name',{ts'2023-12-01  00:00:00'},' ',20,'1','cabinclass','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422484;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.舱位',' ',1804291042271422484,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].cabin_code',{ts'2023-12-01  00:00:00'},' ',21,'1','cabin','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422486;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.出发城市名称',' ',1804291042271422486,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].departure_city_name',{ts'2023-12-01  00:00:00'},' ',22,'1','fromcityname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422489;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.出发时间',' ',1804291042271422489,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].departure_time',{ts'2023-12-01  00:00:00'},' ',23,'1','takeofftime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422491;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.到达城市名称',' ',1804291042271422491,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].arrival_city_name',{ts'2023-12-01  00:00:00'},' ',24,'1','tocityname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422494;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.到达时间',' ',1804291042271422494,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].arrival_time',{ts'2023-12-01  00:00:00'},' ',25,'1','landingtime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422503;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.结算金额',' ',1804291042271422503,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].company_real_pay',{ts'2023-12-01  00:00:00'},' ',33,'1','totalamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422517;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.申请人公司',' ',1804291042271422517,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].out_requisition_id',{ts'2023-12-01  00:00:00'},'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getReqCompanyId',45,'4','company','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804292305453180928;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.申请人部门',' ',1804292305453180928,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].out_requisition_id',{ts'2023-12-01  00:00:00'},'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getReqCompanyId',46,'4','org','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804292885785468929;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.结算批次号',' ',1804292885785468929,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].bill_id',{ts'2023-12-01  00:00:00'},'kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getBillIdByJsonValue',56,'4','batchno','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422464;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.订单号',' ',1804291042271422464,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].order_id',{ts'2023-12-01  00:00:00'},'data.orders.[0].order_id+ ''-'' +  data.orders.[0].booking_member_number +''-''+(IF(data.orders.[0].transaction_type = 0,''O'', IF(data.orders.[0].transaction_type = 1,''G'',''T'')))',1,'3','ordernum','1');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422474;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.业务类型',' ',1804291042271422474,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'IF(data.orders.[0].flight_travel_type = 0,2,4)',10,'3','operationtype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422477;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.订单状态',' ',1804291042271422477,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'IF(data.orders.[0].transaction_type = 0,40000, IF(data.orders.[0].transaction_type = 1,50302,50202) )',13,'3','orderstatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422497;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.折扣（%）',' ',1804291042271422497,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'IF(data.orders.[0].discount = ''全价'',100,NUMBER(REPLACE(data.orders.[0].discount,''折'','''')) * 10)',27,'3','discount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422466;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.服务商',' ',1804291042271422466,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'DIDI',3,'2','server','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422471;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.申请单表单id',' ',1804291042271422471,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-28  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrderPlugin#getOabillformid',8,'4','oabillformid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804389725075793920;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.期间',' ',1804389725075793920,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'kd.fi.er.business.trip.v2.plugin.TimePlugin#getPeriod',16,'4','period','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422480;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.报销状态',' ',1804291042271422480,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'A',17,'2','reimbursestatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422495;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.币种',' ',1804291042271422495,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getCheckingCurrency',26,'4','currency','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422498;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.最低价格',' ',1804291042271422498,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'0',28,'2','lowestpirce','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422506;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.保险费',' ',1804291042271422506,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'0',36,'2','assuranceamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422510;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.个人支付金额',' ',1804291042271422510,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'0',40,'2','personalfee','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422515;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.费用承担公司',' ',1804291042271422515,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrgPlugin#getSettleMain',43,'4','settlemain','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422516;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.费用承担部门',' ',1804291042271422516,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrgPlugin#getSettleDept',44,'4','settledept','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422522;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.是否对平',' ',1804291042271422522,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getIsbalance',47,'4','isbalance','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422523;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.可抵扣',' ',1804291042271422523,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getIsdeductible',48,'4','isdeductible','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422524;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.票价税额',' ',1804291042271422524,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getOrderamounttax',49,'4','orderamounttax','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422525;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.票价税率(%)',' ',1804291042271422525,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getOrderdeductrate',50,'4','orderdeductrate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422526;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.服务费税额',' ',1804291042271422526,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getServiceamounttax',51,'4','serviceamounttax','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422527;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.服务费税率(%)',' ',1804291042271422527,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getServicedeductrate',52,'4','servicedeductrate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422528;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.可抵扣税额',' ',1804291042271422528,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getTotaltax',53,'4','totaltax','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422529;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.是否对账',' ',1804291042271422529,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getIsreconciliation',54,'4','isreconciliation','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804292885785468928;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.订单总表数据',' ',1804292885785468928,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#allOrderId',55,'4','allorderbase','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804292885785468930;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.单据编号',' ',1804292885785468930,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].bill_id',{ts'2023-12-01  00:00:00'},'kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getBillIdByJsonValue',57,'4','checkingbillnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804295790374545408;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.表单ID',' ',1804295790374545408,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'er_planecheckingbill',58,'2','formid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422518;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.创建人',' ',1804291042271422518,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserId',59,'4','creator','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1813898495367990272;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.单据状态',' ',1813898495367990272,'1',{ts'2023-11-08  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'A',60,'2','billstatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422519;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.创建时间',' ',1804291042271422519,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'NOW()',61,'3','createtime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422520;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.修改人',' ',1804291042271422520,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserId',62,'4','modifier','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422521;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.修改时间',' ',1804291042271422521,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'NOW()',63,'3','modifytime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422499;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.机票价格',' ',1804291042271422499,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'NUMBER(data.orders.[0].ticket_fee_sp)  + NUMBER(data.orders.[0].upgrade_cost)',29,'3','ticketprice','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422500;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.机场基建费',' ',1804291042271422500,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].construction_cost_sp',{ts'2023-12-01  00:00:00'},' ',30,'1','airportprice','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422501;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.服务费',' ',1804291042271422501,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].service_fee',{ts'2023-12-01  00:00:00'},' ',31,'1','servicefee','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422502;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.燃油费',' ',1804291042271422502,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].fuelCost_sp',{ts'2023-12-01  00:00:00'},' ',32,'1','fuelprice','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422504;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.退票费',' ',1804291042271422504,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].refund_handle_cost',{ts'2023-12-01  00:00:00'},' ',34,'1','refundamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422505;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.改签费',' ',1804291042271422505,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].change_handle_cost',{ts'2023-12-01  00:00:00'},' ',35,'1','endorsementamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422511;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.乘机人',' ',1804291042271422511,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].passenger_member_number',{ts'2023-12-01  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUser',41,'4','sourcetravelerid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422512;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.乘机人',' ',1804291042271422512,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].passenger_member_number',{ts'2023-12-01  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUserName',42,'4','travelername','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422478;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.使用状态',' ',1804291042271422478,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'IF(data.orders.[0].upgrade_final_status = 1,''USED'', IF(data.orders.[0].upgrade_final_status = 2,''REFOUND'',''UNUSED'') )',14,'3','ticketstatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804291042271422509;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804291042221088768,' ','1',' ',' ','单据头.服务费结算类型',' ',1804291042271422509,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-01  00:00:00'},'1',39,'2','servicefeepaytype','0');

/**滴滴 机票结算单结束**/

DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 1804382278055487488;
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 (1804382278055487488,1015862345630818304,'{
	"errno":0,
	"data":{
		"total":22,
		"is_last":true,
		"last_id":"1125925678938461-0",
		"orders":[
			{
				"origin_ticket_id_text":"1125925278005124",
				"approval_second":"",
				"train_ticket_refund_handle_fee":0,
				"ticket_id_text":"",
				"budget_center_name":"",
				"order_time":"2023-10-17 17:45:02",
				"booking_dep_code":"564873160",
				"booking_member_id":1125924678069946,
				"passenger_member_id":1125924678069946,
				"passenger_dep_code":"564873160",
				"approval_first":"",
				"approval_third":"",
				"order_pay":396.5,
				"is_change":"否",
				"added_cut_service_fee":0,
				"change_time":"",
				"rc_change_level":"",
				"bill_id":1125925817698479,
				"from_city_id":24,
				"stub_pay":388.5,
				"ticket_price":388.5,
				"before_cut_service_fee":0,
				"unique_key":"1125925278005124-0",
				"order_id_text":"",
				"budget_center_id":0,
				"budget_center_parent_path_name":"",
				"seat_level":"二等座",
				"transaction_type":"出票",
				"passenger_member_number":"100638",
				"booking_member_name":"郑宇",
				"travel_purpose":"",
				"start_time":"2023-10-18 15:00:00",
				"booking_dep_name":"Sales",
				"abnormal":"",
				"person_real_pay":0,
				"company_real_pay":396.5,
				"seat_name":"03C座",
				"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":1125924435890719,
				"order_id":"1125925277997999",
				"trip_reason":"协作会议",
				"from_station_name":"长沙南",
				"legal_entity_id":0,
				"passenger_legal_entity_id":0,
				"booking_member_number":"100638",
				"person_ticket_price":0,
				"change_extra_fee":0,
				"remark":"",
				"institution_name":"员工出差管控制度-1125925276312518",
				"refund_extra_fee":0,
				"total_ticket_price":388.5,
				"booking_parent_path_dep_name":"金蝶*****>Sales",
				"trip_description":"",
				"pay_type":"企业支付",
				"rc_normal_level":"",
				"train_code":"G6001",
				"is_refund":"否",
				"handing_extra_fee":0,
				"passenger_member_name":"郑宇",
				"total_handing_extra_fee":0,
				"from_city_name":"长沙市",
				"passenger_dep_id":1125924435890719,
				"end_time":"2023-10-18 18:00:00",
				"service_fee":8,
				"to_city_name":"深圳市",
				"settle_time":"2023-10-18 15:00:00",
				"extra_info":"",
				"requisition_id":"1125925276312518",
				"added_goods_name":"",
				"to_city_id":2,
				"out_requisition_id":"CCSQ-202310-00047",
				"passenger_dep_name":"Sales",
				"added_cut_reason":"",
				"legal_entity_name":"",
				"passenger_parent_path_dep_name":"金蝶"
			}
		]
	},
	"errmsg":"SUCCESS",
	"request_id":""
}','https://api.es.xiaojukeji.com/river/Bill/detail','1',1804382278055487488,'GET','C','D_SyncTrainChecking_List','滴滴-火车结算单同步',' ','已录入参数',{ts'2023-10-26  00:00:00'},'pull','1',1205612035459523584,'er_traincheckingbill',{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.DtripSyncCheckingInvoke#execute',1205612035459523584,'已录入参数');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '3NMM1SWN=O=I';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1804382278055487488,'3NMM1SWN=O=I','zh_CN','滴滴-火车结算单同步');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '3NMM1SWN=O=J';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1804382278055487488,'3NMM1SWN=O=J','zh_TW','滴滴-火車結算單同步');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1804382278080653312;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1804382278055487488,'=',' ',' ',1804382278080653312,'D_Token',' ','1',{ts'2023-10-26  00:00:00'},{ts'2023-10-26  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 = 1804382278080653313;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1804382278055487488,'=',' ',' ',1804382278080653313,' ',' ','1',{ts'2023-10-26  00:00:00'},{ts'2023-10-26  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 = 1804382278080653314;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1804382278055487488,'=',' ',' ',1804382278080653314,' ',' ','1',{ts'2023-10-26  00:00:00'},{ts'2023-10-26  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 = 1804382278080653315;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1804382278055487488,'=',' ',' ',1804382278080653315,' ',' ','1',{ts'2023-10-26  00:00:00'},{ts'2023-10-26  00:00:00'},'sign',' ',4,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getReservedfield1');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1804382278080653316;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1804382278055487488,'=',' ',' ',1804382278080653316,' ',' ','1',{ts'2023-10-26  00:00:00'},{ts'2023-10-26  00:00:00'},'timestamp',' ',5,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getNowTime');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1804382278080653317;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1804382278055487488,'=',' ',' ',1804382278080653317,'203',' ','1',{ts'2023-10-26  00:00:00'},{ts'2023-10-26  00:00:00'},'business_type',' ',6,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1804382278080653318;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1804382278055487488,'=',' ',' ',1804382278080653318,'100',' ','1',{ts'2023-10-26  00:00:00'},{ts'2023-10-26  00:00:00'},'length',' ',7,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1804382278080653319;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1804382278055487488,'=',' ',' ',1804382278080653319,' ',' ','1',{ts'2023-10-26  00:00:00'},{ts'2023-10-26  00:00:00'},'bill_id',' ',8,'1','and','kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getBillId');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1804382278080653320;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1804382278055487488,'=',' ',' ',1804382278080653320,'0',' ','1',{ts'2023-10-26  00:00:00'},{ts'2023-10-26  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 = 1833491180466562048;
INSERT INTO T_ER_TRIP_FILTERENTRY(FID,FFILTERSTATUS,FFILTERCONDITION,FFILTERFIELD,FFILTERVALUE,FFILTERISDEFAULT,FENTRYID,FFILTERDESC,FFILTERMODIFYTIME,FFILTERLOGIC,FFILTERCREATETIME,FFILTERLEFTBRACKET,FSEQ,FFILTERRIGHTBRACKET) VALUES (1804382278055487488,'1','=','data.orders.[0].pay_type','企业支付','1',1833491180466562048,' ',{ts'2023-12-05  00:00:00'},'and',{ts'2023-12-05  00:00:00'},' ',1,' ');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651267;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.父订单号',' ',1804382278080651267,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].origin_ticket_id_text',{ts'2023-12-04  00:00:00'},' ',2,'1','parentordernum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651270;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.订单日期',' ',1804382278080651270,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].order_time',{ts'2023-12-04  00:00:00'},' ',5,'1','orderdate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651271;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.预订人',' ',1804382278080651271,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].booking_member_number',{ts'2023-12-04  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUser',6,'4','sourcebookedid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651274;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.申请单号',' ',1804382278080651274,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].out_requisition_id',{ts'2023-12-04  00:00:00'},' ',8,'1','oabillnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651279;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.结算发生时间',' ',1804382278080651279,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].start_time',{ts'2023-12-04  00:00:00'},'kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getHappenddate',13,'4','happenddate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651282;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.服务费',' ',1804382278080651282,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].service_fee',{ts'2023-12-04  00:00:00'},' ',17,'1','servicefee','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651283;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.订单金额',' ',1804382278080651283,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].company_real_pay',{ts'2023-12-04  00:00:00'},' ',18,'1','totalamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651287;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.退票费',' ',1804382278080651287,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].refund_extra_fee',{ts'2023-12-04  00:00:00'},' ',22,'1','refundamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651290;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.个人支付金额',' ',1804382278080651290,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].personal_real_pay',{ts'2023-12-04  00:00:00'},' ',25,'1','personalfee','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651291;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.乘客',' ',1804382278080651291,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].passenger_member_number',{ts'2023-12-04  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUser',26,'4','passeger','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651292;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.乘客姓名',' ',1804382278080651292,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].passenger_member_name',{ts'2023-12-04  00:00:00'},' ',27,'1','passegername','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651296;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.出发车站',' ',1804382278080651296,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].from_station_name',{ts'2023-12-04  00:00:00'},' ',30,'1','departaddress','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651297;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.到达车站',' ',1804382278080651297,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].to_station_name',{ts'2023-12-04  00:00:00'},' ',31,'1','arriveaddress','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651298;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.出发时间',' ',1804382278080651298,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].start_time',{ts'2023-12-04  00:00:00'},' ',32,'1','departtime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651299;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.到达时间',' ',1804382278080651299,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].end_time',{ts'2023-12-04  00:00:00'},' ',33,'1','arrivetime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651300;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.车次',' ',1804382278080651300,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].train_code',{ts'2023-12-04  00:00:00'},' ',34,'1','vendorname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651307;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.申请人公司',' ',1804382278080651307,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].out_requisition_id',{ts'2023-12-04  00:00:00'},'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getReqCompanyId',38,'4','company','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651312;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.申请人部门',' ',1804382278080651312,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].out_requisition_id',{ts'2023-12-04  00:00:00'},'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getReqCompanyId',39,'4','org','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651322;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.结算批次号',' ',1804382278080651322,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].bill_id',{ts'2023-12-04  00:00:00'},'kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getBillIdByJsonValue',49,'4','batchno','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651323;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.单据编号',' ',1804382278080651323,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].bill_id',{ts'2023-12-04  00:00:00'},'kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getBillIdByJsonValue',50,'4','checkingbillnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651266;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.订单号',' ',1804382278080651266,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].order_id',{ts'2023-12-04  00:00:00'},'data.orders.[0].order_id+ ''-'' +  data.orders.[0].booking_member_number +''-''+(IF(data.orders.[0].transaction_type= ''出票'',''O'',  IF(data.orders.[0].transaction_type= ''改签单'',''G'',''T'')))',1,'3','ordernum','1');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651269;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.订单类型',' ',1804382278080651269,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-04  00:00:00'},'IF(data.orders.[0].transaction_type= ''出票'',''O'',  IF(data.orders.[0].transaction_type= ''改签单'',''G'',''T'') )',4,'3','ordertype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651277;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.结算类型',' ',1804382278080651277,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-04  00:00:00'},'IF(data.orders.[0].pay_type  = ''企业支付'',1,2)',11,'3','producttype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651278;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.订单状态',' ',1804382278080651278,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-12-04  00:00:00'},'IF(data.orders.[0].transaction_type =''出票'',1, IF(data.orders.[0].transaction_type =''改签'',2,3) )',12,'3','orderstatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651289;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.服务费结算类型',' ',1804382278080651289,'1',{ts'2023-10-26  00:00:00'},'1',{ts'2023-12-05  00:00:00'},' ',24,'2','servicefeepaytype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651294;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.出发城市',' ',1804382278080651294,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].from_city_name',{ts'2023-12-05  00:00:00'},' ',28,'1','departcity','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651295;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.到达城市',' ',1804382278080651295,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].to_city_name',{ts'2023-12-05  00:00:00'},' ',29,'1','arrivecity','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651288;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.订单性质',' ',1804382278080651288,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-11-03  00:00:00'},'1',23,'2','isbusiness','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651284;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.火车票价',' ',1804382278080651284,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].stub_pay',{ts'2023-12-04  00:00:00'},' ',19,'1','ticketprice','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651272;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.预订人姓名',' ',1804382278080651272,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].booking_member_number',{ts'2023-12-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUserName',7,'1','bookedname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651285;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.保险费',' ',1804382278080651285,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-11-03  00:00:00'},'0',20,'2','assuranceamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1859490858852939776;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.单据编号',' ',1859490858852939776,'1',{ts'2024-01-10  00:00:00'},'data.orders.[0].order_id',{ts'2024-01-10  00:00:00'},'data.orders.[0].order_id+ ''-'' +  data.orders.[0].booking_member_number +''-''+(IF(data.orders.[0].transaction_type= ''出票'',''O'',  IF(data.orders.[0].transaction_type= ''改签单'',''G'',''T'')))',57,'3','billno','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651286;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.火车票车票号',' ',1804382278080651286,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-11-03  00:00:00'},' ',21,'2','trainticketnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651275;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.业务类型',' ',1804382278080651275,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-11-15  00:00:00'},'6',9,'2','operationtype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651276;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.订单分类',' ',1804382278080651276,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-11-03  00:00:00'},'1',10,'2','ordersort','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651280;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.报销状态',' ',1804382278080651280,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-11-03  00:00:00'},'A',15,'2','reimbursestatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651281;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.币种',' ',1804382278080651281,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-11-03  00:00:00'},'kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getCheckingCurrency',16,'4','currency','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804389441532452864;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.期间',' ',1804389441532452864,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-11-07  00:00:00'},'kd.fi.er.business.trip.v2.plugin.TimePlugin#getPeriod',14,'4','period','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651304;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.申请单表单id',' ',1804382278080651304,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-11-03  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrderPlugin#getOabillformid',36,'4','oabillformid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651317;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.服务费税额',' ',1804382278080651317,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-11-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getServiceamounttax',44,'4','serviceamounttax','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651318;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.服务费税率(%)',' ',1804382278080651318,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-11-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getServicedeductrate',45,'4','servicedeductrate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651305;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.费用承担部门',' ',1804382278080651305,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-11-03  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrgPlugin#getSettleMain',37,'4','settledept','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651313;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.是否对平',' ',1804382278080651313,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-11-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getIsbalance',40,'4','isbalance','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651314;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.可抵扣',' ',1804382278080651314,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-11-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getIsdeductible',41,'4','isdeductible','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651315;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.票价税额',' ',1804382278080651315,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-11-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getOrderamounttax',42,'4','orderamounttax','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651316;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.票价税率(%)',' ',1804382278080651316,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-11-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getOrderdeductrate',43,'4','orderdeductrate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651319;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.可抵扣税额',' ',1804382278080651319,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-11-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getTotaltax',46,'4','totaltax','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651320;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.是否对账',' ',1804382278080651320,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-11-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getIsreconciliation',47,'4','isreconciliation','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651321;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.订单总表数据',' ',1804382278080651321,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-11-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#allOrderId',48,'4','allorderbase','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651324;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.表单ID',' ',1804382278080651324,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-11-08  00:00:00'},'er_traincheckingbill',51,'2','formid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651308;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.创建人',' ',1804382278080651308,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-11-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserId',53,'4','creator','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651309;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.创建时间',' ',1804382278080651309,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-11-08  00:00:00'},'NOW()',54,'3','createtime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651310;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.修改人',' ',1804382278080651310,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-11-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserId',55,'4','modifier','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651311;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.修改时间',' ',1804382278080651311,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-11-08  00:00:00'},'NOW()',56,'3','modifytime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1813899160265433088;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.单据状态',' ',1813899160265433088,'1',{ts'2023-11-08  00:00:00'},' ',{ts'2023-11-15  00:00:00'},'A',52,'2','billstatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651301;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.席位',' ',1804382278080651301,'1',{ts'2023-10-26  00:00:00'},'data.orders.[0].seat_level',{ts'2023-12-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.EnumPlugin#getEnum',35,'4','trainseat','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1804382278080651268;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1804382278055487488,' ','1',' ',' ','单据头.服务商',' ',1804382278080651268,'1',{ts'2023-10-26  00:00:00'},' ',{ts'2023-10-26  00:00:00'},'DIDI',3,'2','server','0');
