DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1829103203850418176;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1799930397417965568,' ','1',' ',' ','单据头.票价开票类型',' ',1829103203850418176,'1',{ts'2023-11-29  00:00:00'},' ',{ts'2025-03-03  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 = 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'2025-03-03  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_FIELDMAPPING WHERE FID = 1799930397417965568;
INSERT INTO T_ER_TRIP_FIELDMAPPING(FID,FSERVER,FDATAJSON_TAG,FURL,FISDEFAULT,FMASTERID,FMETHOD,FSTATUS,FNUMBER,FNAME,FSYNCTYPE,FDATAJSON,FCREATETIME,FPORTTYPE,FENABLE,FMODIFIERID,FFUNCTION,FMODIFYTIME,FPARAMSJSON_TAG,FCLASSFORNAME,FCREATORID,FPARAMSJSON) VALUES (1799930397417965568,1015862345630818304,'{
	"traceId":"0ab8e2be6377489db661245400000786",
	"errno":0,
	"data":{
		"total":3,
		"last_id":"1125916300327193",
		"detail_list":[
			{
				"rc_low_price":"",
				"rooms":"协议价房型-每天相同价格",
				"check_out_date":"2022-09-09",
				"personal_real_pay":0,
				"booking_member_number":"54074",
				"booking_date":"2022-08-09",
				"remark":"",
				"room_price _average":20,
				"hotel_address":"23",
				"budget_center_name":"测试曹荟萃公司",
				"book_day_number":1,
				"total_nights":1,
				"order_status":"已取消预订",
				"city_name":"黔东南苗族侗族自治州",
				"pay_status":3,
				"room_num":1,
				"personal_coupon_cost":0,
				"origin_order_id":"123",
				"invoice_type":"普票",
				"company_pay_type":"退款",
				"pay_type":"企业支付",
				"company_coupon_cost":0,
				"order_type":"退款",
				"member_id":"",
				"amount":50,
				"cost_discount_before":50,
				"original_check_out_date":"2022-09-10",
				"unique_key":"1125917246267315-11125917246180893",
				"tax_ratio":"0%",
				"service_fee":0,
				"budget_center_id":"1125910975328601",
				"company_real_amount":-50,
				"check_in_member_numbers":"",
				"settle_time":"2022-09-06 14:56:47",
				"hotel_name":"黔东南茉莉的小屋",
				"extra_info":"",
				"requisition_id":"1125915744401713",
				"rc_agreed_price":"",
				"hotel_type":"酒店协议价",
				"check_in_names":"曹一一",
				"is_vat":"否",
				"out_requisition_id":"",
				"check_in_member_departments":"",
				"order_id":"1125916267338512",
				"check_in_date":"2022-09-09",
				"personal_real_refund":0
			}
		]
	},
	"errmsg":"SUCCESS"
}','https://api.es.xiaojukeji.com/river/Bill/getNotGeneratedBillDetail','1',1799930397417965568,'GET','C','D_SyncHotelOrder_List','滴滴-酒店订单同步',' ','已录入参数',{ts'2023-10-19  00:00:00'},'pull','1',1205612035459523584,'er_hotelbill',{ts'2023-11-15  00:00:00'},'{
	"access_token":"611344",
	"end_date":"4",
	"company_id":"car_lixingffcamia1",
	"last_id":"4",
	"business_type":201,
	"sign":"car_lixingffcamia1",
	"client_id":1,
	"timestamp":"364537D769162754A9142BCA53F1C7D2",
	"start_date":5
}','kd.fi.er.business.trip.v2.server.dtrip.DtripSyncOrderInvoke#execute',1205612035459523584,'已录入参数');

DELETE FROM T_ER_TRIP_FIELDMAPPING 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",
				"invoice_type":"普票",
				"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,'已录入参数');