-- 滴滴国际酒店订单和结算单字段映射
DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 2210297080151697408;
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 (2210297080151697408,1015862345630818304,'{
	"errno":0,
	"total":1,
	"data":{
		"last_id":"1125929405584475-11125929405579328",
		"detail_list":[
			{
				"reason":"",
				"rank_name":"",
				"approval_second":"",
				"budget_center_name":"",
				"booking_dep_code":"1",
				"approval_history":"",
				"passenger_member_id":0,
				"order_status":"已取消预订",
				"es_diff_tax_fee":0,
				"approval_first":"",
				"approval_third":"",
				"company_coupon_cost":0,
				"ex_info_01_code":"",
				"cost_discount_before":10,
				"original_check_out_date":"2024-02-24",
				"company_real_amount":9,
				"ex_info_02_code":"",
				"check_in_member_numbers":"",
				"hotel_name":"马尔代夫库鲁巴酒店1",
				"travel_purpose":"",
				"project_ext_info":"",
				"ex_info_02":"",
				"ex_info_01":"",
				"ex_info_04":"",
				"ex_info_03":"",
				"check_in_names":"WANG/JIAXIN",
				"ex_info_06":"",
				"is_vat":"否",
				"ex_info_05":"",
				"ex_info_08":"",
				"ex_info_07":"",
				"order_id":"1125929217352616",
				"trip_reason":"",
				"personal_real_refund":0,
				"legal_entity_id":0,
				"travel_description":"",
				"ex_info_03_code":"",
				"check_in_dep_code":"",
				"total_nights":1,
				"booking_parent_path_dep_name":"财税测试公司glm01",
				"out_legal_entity_id":"",
				"company_pay_type":"消费",
				"currency":"人民币",
				"approval_normal_history":"",
				"out_requisition_id":"",
				"rc_level":"",
				"check_in_date":"2024-02-23",
				"ex_info_06_code":"",
				"rooms":"豪华别墅-带独立泳池",
				"check_out_date":"2024-02-24",
				"personal_real_pay":1,
				"invoice_tax_ratio":"6%",
				"check_in_path_dep_name":"",
				"book_day_number":1,
				"institution_id":0,
				"room_num":1,
				"ex_info_07_code":"",
				"order_type":"预订",
				"unique_key":"1125929217352616-11125929217376800",
				"tax_ratio":"",
				"budget_center_id":"0",
				"budget_center_parent_path_name":"",
				"booking_member_name":"00016201591",
				"ex_info_05_code":"",
				"tax_supplement_service_fee":0,
				"booking_dep_name":"财税测试公司glm01",
				"rc_agreed_price":"",
				"budget_center_code":"",
				"passenger_legal_entity_name":"",
				"booking_dep_id":"1125925504805128",
				"city_id":"1003880",
				"rc_low_price":"",
				"passenger_legal_entity_id":0,
				"booking_date":"2024-02-23 11:06:14",
				"booking_member_number":"",
				"remark":"",
				"institution_name":"酒店企业支付",
				"check_in_dep_name":"",
				"city_name":"马尔代夫",
				"personal_coupon_cost":0,
				"ex_info_04_code":"",
				"ex_info_08_code":"",
				"invoice_type":"专票",
				"pay_type":"混合支付",
				"department":"",
				"member_id":"",
				"amount":9,
				"checkin_names_cn":"00016201591",
				"rc_book":"",
				"service_fee":0,
				"country_name_cn":"马尔代夫",
				"passenger_name":"WANG/JIAXIN",
				"settle_time":"2024-02-23 11:06:14",
				"requisition_id":"",
				"check_in_dep_id":"0",
				"order_source":"企业APP",
				"hotel_type":"会员酒店",
				"check_in_member_departments":"",
				"legal_entity_name":""
			}
		]
	},
	"errmsg":"SUCCESS",
	"request_id":"+xvHWIzBGl0Nk2ZBzRSb87XiuHUuOzoyqM9M7hul4SQlXoHpQgwE12KbcJhYrlHM"
}','https://api.es.xiaojukeji.com/river/Bill/getNotGeneratedBillDetail','1',2210297080151697408,'GET','C','D_SyncHotelOrder_List_Inter','滴滴-酒店订单同步-国际',' ','已录入参数。',{ts'2025-05-08  00:00:00'},'pull','0',1925266062056993792,'er_hotelbill',{ts'2025-05-08  00:00:00'},'{
	"access_token":"611344",
	"end_date":"4",
	"company_id":"car_lixingffcamia1",
	"last_id":"4",
	"business_type":201,
	"sign":"car_lixingffcamia1",
	"client_id":1,
	"timestamp":"364537D769162754A9142BCA53F1C7D2",
	"start_date":5
}','kd.fi.er.business.trip.v2.server.dtrip.DtripSyncOrderInvoke#execute',1925266062056993792,'已录入参数');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '4YHAI/V06IY2';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (2210297080151697408,'4YHAI/V06IY2','zh_CN','滴滴-酒店订单同步-国际');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2210297080873117696;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2210297080151697408,'=',' ',' ',2210297080873117696,'D_Token',' ','1',{ts'2025-05-08  00:00:00'},{ts'2025-05-08  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 = 2210297080873117697;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2210297080151697408,'=',' ',' ',2210297080873117697,' ',' ','1',{ts'2025-05-08  00:00:00'},{ts'2025-05-08  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 = 2210297080873117698;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2210297080151697408,'=',' ',' ',2210297080873117698,' ',' ','1',{ts'2025-05-08  00:00:00'},{ts'2025-05-08  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 = 2210297080873117699;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2210297080151697408,'=',' ',' ',2210297080873117699,' ',' ','1',{ts'2025-05-08  00:00:00'},{ts'2025-05-08  00:00:00'},'sign',' ',4,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getReservedfield1');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2210297080873117700;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2210297080151697408,'=',' ',' ',2210297080873117700,' ',' ','1',{ts'2025-05-08  00:00:00'},{ts'2025-05-08  00:00:00'},'timestamp',' ',5,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getNowTime');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2210297080873117701;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2210297080151697408,'=',' ',' ',2210297080873117701,'204',' ','1',{ts'2025-05-08  00:00:00'},{ts'2025-05-08  00:00:00'},'business_type',' ',6,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2210297080873117702;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2210297080151697408,'=',' ',' ',2210297080873117702,'3',' ','1',{ts'2025-05-08  00:00:00'},{ts'2025-05-08  00:00:00'},'start_date','值表示当前时间，往前递减的天数',7,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getShortStartDate');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2210297080873117703;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2210297080151697408,'=',' ',' ',2210297080873117703,' ',' ','1',{ts'2025-05-08  00:00:00'},{ts'2025-05-08  00:00:00'},'end_date','值表示当前时间，往前递减的天数',8,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getShortEndDate');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2210297080873117704;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2210297080151697408,'=',' ',' ',2210297080873117704,'0',' ','1',{ts'2025-05-08  00:00:00'},{ts'2025-05-08  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 = 2210297080873126914;
INSERT INTO T_ER_TRIP_FILTERENTRY(FID,FFILTERSTATUS,FFILTERCONDITION,FFILTERFIELD,FFILTERVALUE,FFILTERISDEFAULT,FENTRYID,FFILTERDESC,FFILTERMODIFYTIME,FFILTERLOGIC,FFILTERCREATETIME,FFILTERLEFTBRACKET,FSEQ,FFILTERRIGHTBRACKET) VALUES (2210297080151697408,'1','in','data.detail_list.[0].order_status','预订成功,已入住,已完成,已取消预订,预订未到,用户已支付','1',2210297080873126914,' ',{ts'2025-05-08  00:00:00'},'and',{ts'2025-05-08  00:00:00'},' ',1,' ');
DELETE FROM T_ER_TRIP_FILTERENTRY WHERE FENTRYID = 2210297080873126915;
INSERT INTO T_ER_TRIP_FILTERENTRY(FID,FFILTERSTATUS,FFILTERCONDITION,FFILTERFIELD,FFILTERVALUE,FFILTERISDEFAULT,FENTRYID,FFILTERDESC,FFILTERMODIFYTIME,FFILTERLOGIC,FFILTERCREATETIME,FFILTERLEFTBRACKET,FSEQ,FFILTERRIGHTBRACKET) VALUES (2210297080151697408,'1','!=','data.detail_list.[0].pay_type','个人支付','1',2210297080873126915,' ',{ts'2025-05-08  00:00:00'},'and',{ts'2025-05-08  00:00:00'},' ',2,' ');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283520;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.订单号',' ',2210297080898283520,'1',{ts'2025-05-08  00:00:00'},'data.detail_list.[0].order_id',{ts'2025-05-08  00:00:00'},'data.detail_list.[0].order_id  + ''-'' +RIGHT(data.detail_list.[0].unique_key,4) + ''-''+ data.detail_list.[0].check_in_names  + ''-'' + IF(STRING(data.detail_list.[0].order_type)= ''预订'',''O'', ''T'')',1,'3','ordernum','1');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283521;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.父订单号',' ',2210297080898283521,'1',{ts'2025-05-08  00:00:00'},'data.detail_list.[0].order_id',{ts'2025-05-08  00:00:00'},' ',2,'1','parentordernum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283522;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.服务商',' ',2210297080898283522,'1',{ts'2025-05-08  00:00:00'},' ',{ts'2025-05-08  00:00:00'},'DIDI',3,'2','server','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283523;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.订单类型',' ',2210297080898283523,'1',{ts'2025-05-08  00:00:00'},' ',{ts'2025-05-08  00:00:00'},'IF(STRING(data.detail_list.[0].order_type)= ''预订'',''O'', ''T'')',4,'3','ordertype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283524;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.订单日期',' ',2210297080898283524,'1',{ts'2025-05-08  00:00:00'},'data.detail_list.[0].booking_date',{ts'2025-05-08  00:00:00'},' ',5,'1','orderdate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283525;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.预订人',' ',2210297080898283525,'1',{ts'2025-05-08  00:00:00'},'data.detail_list.[0].booking_member_number',{ts'2025-05-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUser',6,'4','sourcebookedid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283526;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.预订人姓名',' ',2210297080898283526,'1',{ts'2025-05-08  00:00:00'},'data.detail_list.[0].booking_member_number',{ts'2025-05-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUserName',7,'4','bookedname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283527;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.预订人部门',' ',2210297080898283527,'1',{ts'2025-05-08  00:00:00'},' ',{ts'2025-05-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getBookUserDept',8,'4','bookeddept','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283528;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.出差申请/用车申请单号',' ',2210297080898283528,'1',{ts'2025-05-08  00:00:00'},'data.detail_list.[0].out_requisition_id',{ts'2025-05-08  00:00:00'},' ',9,'1','oabillnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283530;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.订单分类',' ',2210297080898283530,'1',{ts'2025-05-08  00:00:00'},' ',{ts'2025-05-08  00:00:00'},'2',11,'2','ordersort','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283531;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.结算类型',' ',2210297080898283531,'1',{ts'2025-05-08  00:00:00'},' ',{ts'2025-05-08  00:00:00'},'IF(STRING(data.detail_list.[0].pay_type)= ''企业支付''  OR STRING(data.detail_list.[0].pay_type)= ''企业钱包支付''  OR STRING(data.detail_list.[0].pay_type)= ''混合支付'',''1'',''2'')',12,'3','producttype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283532;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.订单状态',' ',2210297080898283532,'1',{ts'2025-05-08  00:00:00'},'data.detail_list.[0].order_status',{ts'2025-05-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.EnumPlugin#getEnum',13,'4','orderstatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283534;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.报销状态',' ',2210297080898283534,'1',{ts'2025-05-08  00:00:00'},' ',{ts'2025-05-08  00:00:00'},'A',15,'2','reimbursestatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283535;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.币别',' ',2210297080898283535,'1',{ts'2025-05-08  00:00:00'},' ',{ts'2025-05-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getCheckingCurrency',16,'4','currency','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283536;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.服务费',' ',2210297080898283536,'1',{ts'2025-05-08  00:00:00'},'data.detail_list.[0].service_fee',{ts'2025-05-08  00:00:00'},' ',17,'1','servicefee','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283537;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.订单金额',' ',2210297080898283537,'1',{ts'2025-05-08  00:00:00'},'data.detail_list.[0].company_real_amount',{ts'2025-05-08  00:00:00'},' ',18,'1','totalamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283538;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.退订费',' ',2210297080898283538,'1',{ts'2025-05-08  00:00:00'},' ',{ts'2025-05-08  00:00:00'},'0',19,'2','unbookfee','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283539;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.订单性质',' ',2210297080898283539,'1',{ts'2025-05-08  00:00:00'},' ',{ts'2025-05-08  00:00:00'},'1',20,'2','isbusiness','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283540;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.服务费结算类型',' ',2210297080898283540,'1',{ts'2025-05-08  00:00:00'},' ',{ts'2025-05-08  00:00:00'},'IF(STRING(data.detail_list.[0].pay_type)= ''企业支付''  OR STRING(data.detail_list.[0].pay_type)= ''企业钱包支付''  OR STRING(data.detail_list.[0].pay_type)= ''混合支付'',''1'',''2'')',21,'3','servicefeepaytype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283541;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.个人支付金额',' ',2210297080898283541,'1',{ts'2025-05-08  00:00:00'},'data.detail_list.[0].personal_real_pay',{ts'2025-05-08  00:00:00'},' ',22,'1','personalfee','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283542;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.入住人工号',' ',2210297080898283542,'1',{ts'2025-05-08  00:00:00'},'data.detail_list.[0].check_in_member_numbers',{ts'2025-05-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUser',23,'4','sourcetravelerid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283543;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.入住人',' ',2210297080898283543,'1',{ts'2025-05-08  00:00:00'},'data.detail_list.[0].check_in_names',{ts'2025-05-08  00:00:00'},' ',24,'1','travelername','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283544;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.入住人部门',' ',2210297080898283544,'1',{ts'2025-05-08  00:00:00'},' ',{ts'2025-05-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getPassegerUserDept',25,'4','travelerdept','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283545;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.城市',' ',2210297080898283545,'1',{ts'2025-05-08  00:00:00'},'data.detail_list.[0].city_name',{ts'2025-05-08  00:00:00'},' ',26,'1','cityname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283546;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.酒店名称',' ',2210297080898283546,'1',{ts'2025-05-08  00:00:00'},'data.detail_list.[0].hotel_name',{ts'2025-05-08  00:00:00'},' ',27,'1','hotelname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283547;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.酒店地址',' ',2210297080898283547,'1',{ts'2025-05-08  00:00:00'},' ',{ts'2025-05-08  00:00:00'},' ',28,'2','hoteladdress','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283548;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.入住日期',' ',2210297080898283548,'1',{ts'2025-05-08  00:00:00'},'data.detail_list.[0].check_in_date',{ts'2025-05-08  00:00:00'},' ',29,'1','checkindate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283549;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.离店日期',' ',2210297080898283549,'1',{ts'2025-05-08  00:00:00'},' ',{ts'2025-05-08  00:00:00'},'IF(data.detail_list.[0].check_out_date  <>  null  AND data.detail_list.[0].check_out_date  <> '''' ,data.detail_list.[0].check_out_date ,data.detail_list.[0].original_check_out_date )',30,'3','checkoutdate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283550;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.房型',' ',2210297080898283550,'1',{ts'2025-05-08  00:00:00'},'data.detail_list.[0].rooms',{ts'2025-05-08  00:00:00'},' ',31,'1','roomstylename','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283551;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.订房间数',' ',2210297080898283551,'1',{ts'2025-05-08  00:00:00'},'data.detail_list.[0].room_num',{ts'2025-05-08  00:00:00'},' ',32,'1','roomcount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283552;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.房价',' ',2210297080898283552,'1',{ts'2025-05-08  00:00:00'},' ',{ts'2025-05-08  00:00:00'},' ',33,'2','roomamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283553;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.超标理由',' ',2210297080898283553,'1',{ts'2025-05-08  00:00:00'},' ',{ts'2025-05-08  00:00:00'},'IF(data.detail_list.[0].rc_low_price   <> null  AND data.detail_list.[0].rc_low_price  <> '''',data.detail_list.[0].rc_low_price ,data.detail_list.[0].rc_agreed_price )',34,'3','overdesc','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283554;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ','该字段建议放置在字段映射排序靠后，它依赖一些基本信息判断，例如申请单号，出发地，目的地城市，乘车人。','单据头.出差行程ID',' ',2210297080898283554,'1',{ts'2025-05-08  00:00:00'},' ',{ts'2025-05-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrderPlugin#getTripId',35,'4','tripid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283555;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.申请单表单id',' ',2210297080898283555,'1',{ts'2025-05-08  00:00:00'},' ',{ts'2025-05-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrderPlugin#getOabillformid',36,'4','oabillformid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283556;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.费用承担公司',' ',2210297080898283556,'1',{ts'2025-05-08  00:00:00'},'data.detail_list.[0].extend_info',{ts'2025-05-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrgPlugin#getSettleMain',37,'4','expcommitcomnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283557;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.费用承担部门',' ',2210297080898283557,'1',{ts'2025-05-08  00:00:00'},'data.detail_list.[0].extend_info',{ts'2025-05-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrgPlugin#getSettleDept',38,'4','expcommitdepnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283558;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.申请人公司',' ',2210297080898283558,'1',{ts'2025-05-08  00:00:00'},'data.detail_list.[0].extend_info',{ts'2025-05-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getReqCompanyId',39,'4','company','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283559;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.原单订单号',' ',2210297080898283559,'1',{ts'2025-05-08  00:00:00'},'data.detail_list.[0].origin_order_id',{ts'2025-05-08  00:00:00'},' ',40,'1','oriordernum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283560;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.创建人',' ',2210297080898283560,'1',{ts'2025-05-08  00:00:00'},' ',{ts'2025-05-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserId',41,'4','creator','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283561;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.创建时间',' ',2210297080898283561,'1',{ts'2025-05-08  00:00:00'},' ',{ts'2025-05-08  00:00:00'},'NOW()',42,'3','createtime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283562;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.修改人',' ',2210297080898283562,'1',{ts'2025-05-08  00:00:00'},' ',{ts'2025-05-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserId',43,'4','modifier','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283563;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.修改时间',' ',2210297080898283563,'1',{ts'2025-05-08  00:00:00'},' ',{ts'2025-05-08  00:00:00'},'NOW()',44,'3','modifytime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283564;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.票价开票类型',' ',2210297080898283564,'1',{ts'2025-05-08  00:00:00'},' ',{ts'2025-05-08  00:00:00'},'IF(STRING(data.detail_list.[0].invoice_type)  = ''普票'',1,IF(STRING(data.detail_list.[0].invoice_type)  = ''专票'',2,9999))',45,'3','pricebillingtype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283566;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.单据编号',' ',2210297080898283566,'1',{ts'2025-05-08  00:00:00'},'data.detail_list.[0].order_id',{ts'2025-05-08  00:00:00'},'data.detail_list.[0].order_id  + ''-'' +RIGHT(data.detail_list.[0].unique_key,4) + ''-''+ data.detail_list.[0].check_in_names  + ''-'' + IF(STRING(data.detail_list.[0].order_type)= ''预订'',''O'', ''T'')',47,'3','billno','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283567;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.项目',' ',2210297080898283567,'1',{ts'2025-05-08  00:00:00'},' ',{ts'2025-05-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrderPlugin#getProject',48,'4','std_project','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283568;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.成本中心',' ',2210297080898283568,'1',{ts'2025-05-08  00:00:00'},'data.detail_list.[0].extend_info',{ts'2025-05-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getReqCostcenter',49,'4','std_costcenter','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283565;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.订单状态名称',' ',2210297080898283565,'1',{ts'2025-05-08  00:00:00'},' ',{ts'2025-05-08  00:00:00'},'IF(STRING(data.detail_list.[0].order_status) =''预订成功'',''已确认'', IF(STRING(data.detail_list.[0].order_status) =''已完成''  OR STRING(data.detail_list.[0].order_status) =''已入住'' ,''已离店'', IF(STRING(data.detail_list.[0].order_status) =''已取消预订''  OR  STRING(data.detail_list.[0].order_status) =''预订未到''  OR STRING(data.detail_list.[0].order_status) =''已取消订单'',''已退订'','' '') ) )',46,'3','orderstatusname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210301617147111424;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.外部系统订单号',' ',2210301617147111424,'1',{ts'2025-05-08  00:00:00'},'data.detail_list.[0].order_id',{ts'2025-05-08  00:00:00'},' ',50,'1','outordernum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283533;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.费用发生时间',' ',2210297080898283533,'1',{ts'2025-05-08  00:00:00'},'data.detail_list.[0].settle_time',{ts'2025-05-08  00:00:00'},' ',14,'1','happenddate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210297080898283529;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.业务类型',' ',2210297080898283529,'1',{ts'2025-05-08  00:00:00'},' ',{ts'2025-05-08  00:00:00'},'5',10,'2','operationtype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210362675291393024;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210297080151697408,' ','1',' ',' ','单据头.可抵扣',' ',2210362675291393024,'1',{ts'2025-05-08  00:00:00'},' ',{ts'2025-05-08  00:00:00'},'IF(STRING(data.detail_list.[0].invoice_type)=''专票'',1,0)',51,'3','isdeductible','0');
--  国际酒店结算单
DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 2211032280128824320;
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 (2211032280128824320,1015862345630818304,'{
	"errno":0,
	"total":1,
	"data":{
		"is_last":false,
		"last_id":"1125929405584475-11125929405579328",
		"orders":[
			{
				"reason":"",
				"rank_name":"",
				"approval_second":"",
				"budget_center_name":"",
				"booking_dep_code":"1",
				"approval_history":"",
				"passenger_member_id":0,
				"order_status":"已取消预订",
				"es_diff_tax_fee":0,
				"approval_first":"",
				"approval_third":"",
				"company_coupon_cost":0,
				"ex_info_01_code":"",
				"bill_id":1125929610068518,
				"cost_discount_before":10,
				"original_check_out_date":"2024-02-24",
				"company_real_amount":9,
				"ex_info_02_code":"",
				"check_in_member_numbers":"",
				"hotel_name":"马尔代夫库鲁巴酒店1",
				"travel_purpose":"",
				"project_ext_info":"",
				"ex_info_02":"",
				"ex_info_01":"",
				"ex_info_04":"",
				"ex_info_03":"",
				"check_in_names":"WANG/JIAXIN",
				"ex_info_06":"",
				"is_vat":"否",
				"ex_info_05":"",
				"ex_info_08":"",
				"ex_info_07":"",
				"order_id":"1125929217352616",
				"trip_reason":"",
				"personal_real_refund":0,
				"legal_entity_id":0,
				"travel_description":"",
				"ex_info_03_code":"",
				"check_in_dep_code":"",
				"total_nights":1,
				"booking_parent_path_dep_name":"财税测试公司glm01",
				"out_legal_entity_id":"",
				"company_pay_type":"消费",
				"currency":"人民币",
				"approval_normal_history":"",
				"out_requisition_id":"",
				"rc_level":"",
				"check_in_date":"2024-02-23",
				"ex_info_06_code":"",
				"rooms":"豪华别墅-带独立泳池",
				"check_out_date":"2024-02-24",
				"personal_real_pay":1,
				"invoice_tax_ratio":"6%",
				"check_in_path_dep_name":"",
				"book_day_number":1,
				"institution_id":0,
				"room_num":1,
				"ex_info_07_code":"",
				"order_type":"预订",
				"unique_key":"1125929217352616-11125929217376800",
				"tax_ratio":"",
				"budget_center_id":"0",
				"budget_center_parent_path_name":"",
				"booking_member_name":"00016201591",
				"ex_info_05_code":"",
				"tax_supplement_service_fee":0,
				"booking_dep_name":"财税测试公司glm01",
				"rc_agreed_price":"",
				"budget_center_code":"",
				"passenger_legal_entity_name":"",
				"booking_dep_id":"1125925504805128",
				"city_id":"1003880",
				"rc_low_price":"",
				"passenger_legal_entity_id":0,
				"booking_date":"2024-02-23 11:06:14",
				"booking_member_number":"",
				"remark":"",
				"institution_name":"酒店企业支付",
				"check_in_dep_name":"",
				"city_name":"马尔代夫",
				"personal_coupon_cost":0,
				"ex_info_04_code":"",
				"ex_info_08_code":"",
				"invoice_type":"专票",
				"pay_type":"混合支付",
				"department":"",
				"member_id":"",
				"amount":9,
				"checkin_names_cn":"00016201591",
				"rc_book":"",
				"service_fee":0,
				"country_name_cn":"马尔代夫",
				"passenger_name":"WANG/JIAXIN",
				"settle_time":"2024-02-23 11:06:14",
				"extra_info":"",
				"requisition_id":"",
				"check_in_dep_id":"0",
				"order_source":"企业APP",
				"hotel_type":"会员酒店",
				"check_in_member_departments":"",
				"legal_entity_name":""
			}
		]
	},
	"errmsg":"SUCCESS"
}','https://api.es.xiaojukeji.com/river/Bill/detail','1',2211032280128824320,'GET','C','D_SyncHotelChecking_List_Inter','滴滴-酒店结算单同步-国际',' ','已录入参数。',{ts'2025-05-09  00:00:00'},'pull','0',1925266062056993792,'er_hotelcheckingbill',{ts'2025-05-09  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',1925266062056993792,'已录入参数');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '4YKUWDV2H4B2';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (2211032280128824320,'4YKUWDV2H4B2','zh_CN','滴滴-酒店结算单同步-国际');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2211032280162378752;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2211032280128824320,'=',' ',' ',2211032280162378752,'D_Token',' ','1',{ts'2025-05-09  00:00:00'},{ts'2025-05-09  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 = 2211032280162378753;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2211032280128824320,'=',' ',' ',2211032280162378753,' ',' ','1',{ts'2025-05-09  00:00:00'},{ts'2025-05-09  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 = 2211032280162378754;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2211032280128824320,'=',' ',' ',2211032280162378754,' ',' ','1',{ts'2025-05-09  00:00:00'},{ts'2025-05-09  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 = 2211032280162378755;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2211032280128824320,'=',' ',' ',2211032280162378755,' ',' ','1',{ts'2025-05-09  00:00:00'},{ts'2025-05-09  00:00:00'},'sign',' ',4,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getReservedfield1');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2211032280162378756;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2211032280128824320,'=',' ',' ',2211032280162378756,' ',' ','1',{ts'2025-05-09  00:00:00'},{ts'2025-05-09  00:00:00'},'timestamp',' ',5,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getNowTime');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2211032280162378757;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2211032280128824320,'=',' ',' ',2211032280162378757,'204',' ','1',{ts'2025-05-09  00:00:00'},{ts'2025-05-09  00:00:00'},'business_type',' ',6,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2211032280162378758;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2211032280128824320,'=',' ',' ',2211032280162378758,'100',' ','1',{ts'2025-05-09  00:00:00'},{ts'2025-05-09  00:00:00'},'length',' ',7,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2211032280162378759;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2211032280128824320,'=',' ',' ',2211032280162378759,' ',' ','1',{ts'2025-05-09  00:00:00'},{ts'2025-05-09  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 = 2211032280162378760;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2211032280128824320,'=',' ',' ',2211032280162378760,'0',' ','1',{ts'2025-05-09  00:00:00'},{ts'2025-05-09  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 = 2211032280162377730;
INSERT INTO T_ER_TRIP_FILTERENTRY(FID,FFILTERSTATUS,FFILTERCONDITION,FFILTERFIELD,FFILTERVALUE,FFILTERISDEFAULT,FENTRYID,FFILTERDESC,FFILTERMODIFYTIME,FFILTERLOGIC,FFILTERCREATETIME,FFILTERLEFTBRACKET,FSEQ,FFILTERRIGHTBRACKET) VALUES (2211032280128824320,'1','in','data.orders.[0].order_status','预订成功,已入住,已完成,已取消预订,预订未到,用户已支付','1',2211032280162377730,' ',{ts'2025-05-09  00:00:00'},'and',{ts'2025-05-09  00:00:00'},' ',1,' ');
DELETE FROM T_ER_TRIP_FILTERENTRY WHERE FENTRYID = 2211032280162377731;
INSERT INTO T_ER_TRIP_FILTERENTRY(FID,FFILTERSTATUS,FFILTERCONDITION,FFILTERFIELD,FFILTERVALUE,FFILTERISDEFAULT,FENTRYID,FFILTERDESC,FFILTERMODIFYTIME,FFILTERLOGIC,FFILTERCREATETIME,FFILTERLEFTBRACKET,FSEQ,FFILTERRIGHTBRACKET) VALUES (2211032280128824320,'1','in','data.orders.[0].pay_type','企业支付,企业钱包支付,混合支付','1',2211032280162377731,' ',{ts'2025-05-09  00:00:00'},'and',{ts'2025-05-09  00:00:00'},' ',2,' ');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378761;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.订单号',' ',2211032280162378761,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].order_id',{ts'2025-05-09  00:00:00'},'data.orders.[0].order_id  + ''-'' +RIGHT(data.orders.[0].unique_key,4) + ''-''+ data.orders.[0].check_in_names  + ''-'' + IF(STRING(data.orders.[0].order_type)= ''预订'',''O'', ''T'')',1,'3','ordernum','1');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378762;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.父订单号',' ',2211032280162378762,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].order_id',{ts'2025-05-09  00:00:00'},' ',2,'1','parentordernum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378763;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.服务商',' ',2211032280162378763,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'DIDI',3,'2','server','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378764;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.订单类型',' ',2211032280162378764,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'IF(STRING(data.orders.[0].order_type)= ''预订'',''O'', ''T'')',4,'3','ordertype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378765;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.订单日期',' ',2211032280162378765,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].booking_date',{ts'2025-05-09  00:00:00'},' ',5,'1','orderdate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378767;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.单据编号',' ',2211032280162378767,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].bill_id',{ts'2025-05-09  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 = 2211032280162378768;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.结算批次号',' ',2211032280162378768,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].bill_id',{ts'2025-05-09  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 = 2211032280162378769;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.申请单号',' ',2211032280162378769,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].out_requisition_id',{ts'2025-05-09  00:00:00'},' ',9,'1','oabillnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378770;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.申请单表单id',' ',2211032280162378770,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrderPlugin#getOabillformid',10,'4','oabillformid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378772;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.结算类型',' ',2211032280162378772,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'IF(STRING(data.orders.[0].pay_type)= ''企业支付''  OR STRING(data.orders.[0].pay_type)= ''企业钱包支付''  OR STRING(data.orders.[0].pay_type)= ''混合支付'',''1'',''2'')',12,'3','producttype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378773;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.订单状态',' ',2211032280162378773,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].order_status',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.EnumPlugin#getEnum',13,'4','orderstatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378774;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.结算发生时间',' ',2211032280162378774,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].settle_time',{ts'2025-05-09  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 = 2211032280162378775;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.期间',' ',2211032280162378775,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.TimePlugin#getPeriod',15,'4','period','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378776;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.报销状态',' ',2211032280162378776,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'A',16,'2','reimbursestatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378777;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.币别',' ',2211032280162378777,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getCheckingCurrency',17,'4','currency','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378778;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.服务费',' ',2211032280162378778,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].service_fee',{ts'2025-05-09  00:00:00'},' ',18,'1','servicefee','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378779;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.结算金额',' ',2211032280162378779,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].company_real_amount',{ts'2025-05-09  00:00:00'},' ',19,'1','totalamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378780;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.退订费',' ',2211032280162378780,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'0',20,'2','unbookfee','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378781;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.订单性质',' ',2211032280162378781,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].pay_type',{ts'2025-05-09  00:00:00'},'IF(STRING(data.orders.[0].pay_type)= ''企业支付''  OR STRING(data.orders.[0].pay_type)= ''企业钱包支付''  OR STRING(data.orders.[0].pay_type)= ''混合支付'',''1'',''2'')',21,'3','isbusiness','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378782;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.服务费结算类型',' ',2211032280162378782,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'1',22,'2','servicefeepaytype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378783;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.订单总表数据',' ',2211032280162378783,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#allOrderId',23,'4','allorderbase','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378784;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.入住人工号',' ',2211032280162378784,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].check_in_member_numbers',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUser',24,'4','sourcetravelerid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378785;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.入住人',' ',2211032280162378785,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].check_in_names',{ts'2025-05-09  00:00:00'},' ',25,'1','travelername','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378786;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.预订人工号',' ',2211032280162378786,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].booking_member_number',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUser',26,'4','sourcebookedid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378787;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.预订人姓名',' ',2211032280162378787,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].booking_member_number',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUserName',27,'4','bookedname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378788;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.票价开票类型',' ',2211032280162378788,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'IF(STRING( data.orders.[0].invoice_type)  = ''普票'',1,IF(STRING( data.orders.[0].invoice_type)  = ''专票'',2,9999))',28,'3','pricebillingtype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378789;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.城市',' ',2211032280162378789,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].city_name',{ts'2025-05-09  00:00:00'},' ',29,'1','cityname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378790;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.酒店名称',' ',2211032280162378790,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].hotel_name',{ts'2025-05-09  00:00:00'},' ',30,'1','hotelname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378791;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.入住日期',' ',2211032280162378791,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].check_in_date',{ts'2025-05-09  00:00:00'},' ',31,'1','checkindate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378793;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.房型',' ',2211032280162378793,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].rooms',{ts'2025-05-09  00:00:00'},' ',33,'1','roomstylename','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378794;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.订房间数',' ',2211032280162378794,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].room_num',{ts'2025-05-09  00:00:00'},' ',34,'1','roomcount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378796;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.费用承担公司',' ',2211032280162378796,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].extend_info',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrgPlugin#getSettleMain',36,'4','settlemain','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378797;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.费用承担部门',' ',2211032280162378797,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].extend_info',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrgPlugin#getSettleDept',37,'4','settledept','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378798;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.申请人公司',' ',2211032280162378798,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].extend_info',{ts'2025-05-09  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 = 2211032280162378799;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.申请人部门',' ',2211032280162378799,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].extend_info',{ts'2025-05-09  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 = 2211032280162378800;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.个人支付金额',' ',2211032280162378800,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].personal_real_pay',{ts'2025-05-09  00:00:00'},' ',40,'1','personalfee','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378801;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.是否对平',' ',2211032280162378801,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getIsbalance',41,'4','isbalance','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378802;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.可抵扣',' ',2211032280162378802,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getIsdeductible',42,'4','isdeductible','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378803;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.票价税额',' ',2211032280162378803,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getOrderamounttax',43,'4','orderamounttax','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378804;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.票价税率(%)',' ',2211032280162378804,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getOrderdeductrate',44,'4','orderdeductrate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378805;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.服务费税额',' ',2211032280162378805,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getServiceamounttax',45,'4','serviceamounttax','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378806;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.服务费税率(%)',' ',2211032280162378806,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getServicedeductrate',46,'4','servicedeductrate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378807;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.可抵扣税额',' ',2211032280162378807,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getTotaltax',47,'4','totaltax','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378808;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.是否对账',' ',2211032280162378808,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getIsreconciliation',48,'4','isreconciliation','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378809;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.创建人',' ',2211032280162378809,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserId',49,'4','creator','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378810;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.单据状态',' ',2211032280162378810,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'A',50,'2','billstatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378811;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.创建时间',' ',2211032280162378811,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'NOW()',51,'3','createtime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378812;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.修改人',' ',2211032280162378812,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserId',52,'4','modifier','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378813;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.修改时间',' ',2211032280162378813,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'NOW()',53,'3','modifytime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378814;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.表单ID',' ',2211032280162378814,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'er_hotelcheckingbill',54,'2','formid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378815;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.单据编号',' ',2211032280162378815,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].order_id',{ts'2025-05-09  00:00:00'},'data.orders.[0].order_id  + ''-'' +RIGHT(data.orders.[0].unique_key,4) + ''-''+ data.orders.[0].check_in_names  + ''-'' + IF(STRING(data.orders.[0].order_type)= ''预订'',''O'', ''T'')',55,'3','billno','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378816;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.项目',' ',2211032280162378816,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrderPlugin#getProject',56,'4','std_project','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378817;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.成本中心',' ',2211032280162378817,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].extend_info',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getReqCostcenter',57,'4','std_costcenter','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211043851332756480;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.外部系统结算单号',' ',2211043851332756480,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].order_id',{ts'2025-05-09  00:00:00'},' ',58,'1','outsettlementnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378766;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.业务类型',' ',2211032280162378766,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'5',6,'2','operationtype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378771;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.订单分类',' ',2211032280162378771,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'2',11,'2','ordersort','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378795;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.房价',' ',2211032280162378795,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},' ',35,'2','roomamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211032280162378792;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2211032280128824320,' ','1',' ',' ','单据头.离店日期',' ',2211032280162378792,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].original_check_out_date',{ts'2025-05-09  00:00:00'},' ',32,'2','checkoutdate','0');
