UPDATE T_ER_TRIP_FIELDMAPPING SET fparamsjson_tag = '{
	"request": {
		"Status": 1,
		"TrainEndorsementDetails": [{
			"DepartDateBegin": "",
			"ProductType": "",
			"ToCities": [""],
			"TrainSkipFields": "",
			"TravelerCount": "",
			"Price": "",
			"TripType": "",
			"Currency": "",
			"DepartCityCodes": [""],
			"SeatType": [""],
			"ArrivalCityCodes": [""],
			"FromCities": [""],
			"PassengerList": [{
				"EID": "X",
				"Name": "张三"
			}],
			"DepartDateEnd": ""
		}],
		"ExtendFieldList": [{
			"FieldValue": "",
			"FieldName": "",
			"FieldType": ""
		}],
		"CarPickUpEndorsementDetails": [{
			"PatternType": 17,
			"SkipFields": 0,
			"Price": 1000.0,
			"PickUpBeginDate": "",
			"Currency": 2,
			"ProductType": 6,
			"DropOffEndDate": "",
			"DropOffBeginDate": "",
			"PassengerList": [{
				"EID": "X",
				"Name": "张三"
			}],
			"Cities": "1002"
		}],
		"Auth": {
			"Ticket": "*",
			"AppKey": "*"
		},
		"ExpiredTime":"",
		"ApprovalNumber":"",
		"CarQuickEndorsementDetails":[
			{
				"SkipFields":0,
				"Price":"",
				"Currency":"",
				"ProductType":"",
				"BeginUseDate":"",
				"PassengerList":[
					{
						"EID":"",
						"Name":""
					}
				],
				"Cities":"",
				"EndUseDate":"",
				"VehicleGroup":""
			}
		],
		"FlightEndorsementDetails":[
			{
				"DepartDateBegin":"",
				"Discount":"",
				"Airline":"",
				"ReturnDateEnd":"",
				"ProductType":"",
				"FlightWay":"",
				"DepartCityIds":[
					""
				],
				"SeatClass":"",
				"ReturnDateBegin":"",
				"SkipFields":"",
				"TravelerCount":"",
				"Price":"",
				"ArrivalCityIds":[
					"1"
				],
				"Currency":"",
				"DepartCityCodes":[
					""
				],
				"ArrivalCityCodes":[
					""
				],
				"PassengerList":[
					{
						"EID":"",
						"Name":""
					}
				],
				"CurrencyType":"",
				"DepartDateEnd":""
			},
			{
				"DepartDateBegin":"",
				"Discount":"",
				"Airline":"",
				"ReturnDateEnd":"",
				"ProductType":"",
				"FlightWay":"",
				"SeatClass":"",
				"ReturnDateBegin":"",
				"TravelerCount":"",
				"Price":"",
				"Currency":"",
				"DepartCityCodes":[
					""
				],
				"ArrivalCityCodes":[
					""
				],
				"PassengerList":[
					{
						"EID":"",
						"Name":""
					}
				],
				"DepartDateEnd":""
			}
		],
		"EmployeeID":"",
		"HotelEndorsementDetails":[
			{
				"MaxStarRating":"",
				"CheckInDateEnd":"",
				"ProductType":"",
				"MinPrice":"",
				"AveragePrice":"",
				"MinStarRating":"",
				"CheckInDateBegin":"",
				"SkipFields":"1",
				"RoomCount":"1",
				"TotalRoomNightCount":"",
				"Currency":"1",
				"CheckOutDateBegin":"",
				"CheckInCityCodes":[
					"1"
				],
				"PassengerList":[
					{
						"EID":"",
						"Name":""
					}
				],
				"MaxPrice":"",
				"CheckOutDateEnd":"",
				"CurrencyType":""
			},
			{
				"MaxStarRating":"5",
				"CheckInDateEnd":"",
				"ProductType":"",
				"MinPrice":"",
				"AveragePrice":"",
				"MinStarRating":"",
				"CheckInDateBegin":"",
				"TotalRoomNightCount":"",
				"Currency":"",
				"CheckOutDateBegin":"",
				"CheckInCityCodes":[
					"1"
				],
				"PassengerList":[
					{
						"EID":"",
						"Name":""
					},
					{
						"EID":"",
						"Name":""
					}
				],
				"MaxPrice":"",
				"CheckOutDateEnd":""
			}
		]
	}
}' where fid = 1673248652011141120;

UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPTARGETFIELD='request.FlightEndorsementDetails.[0].DepartCityCodes' WHERE FENTRYID=1685532941477888000;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPTARGETFIELD='request.FlightEndorsementDetails.[0].ArrivalCityCodes' WHERE FENTRYID=1685532941477888001;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPTARGETFIELD='request.FlightEndorsementDetails.[0].DepartCityIds' WHERE FENTRYID=1685532941477888002;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPTARGETFIELD='request.FlightEndorsementDetails.[0].ArrivalCityIds' WHERE FENTRYID=1685532941477888003;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPTARGETFIELD='request.HotelEndorsementDetails.[0].CheckInCityCodes' WHERE FENTRYID=1685542971753250820;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPTARGETFIELD='request.TrainEndorsementDetails.[0].FromCities' WHERE FENTRYID=1685548207964308486;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPTARGETFIELD='request.TrainEndorsementDetails.[0].ToCities' WHERE FENTRYID=1685548207964308487;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPTARGETFIELD='request.TrainEndorsementDetails.[0].ArrivalCityCodes' WHERE FENTRYID=1685550363182252032;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPTARGETFIELD='request.TrainEndorsementDetails.[0].DepartCityCodes' WHERE FENTRYID=1685550363182252033;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPTARGETFIELD='request.FlightEndorsementDetails.[0].PassengerList',FMAPSOURCEFIELD='tripentry.travelers'  WHERE FENTRYID=1685535059970506757;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPTARGETFIELD='request.HotelEndorsementDetails.[0].PassengerList',FMAPSOURCEFIELD='tripentry.travelers' WHERE FENTRYID=1685545990318343169;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPTARGETFIELD='request.CarQuickEndorsementDetails.[0].PassengerList',FMAPSOURCEFIELD='tripentry.travelers' WHERE FENTRYID=1685547233719763973;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPTARGETFIELD='request.TrainEndorsementDetails.[0].PassengerList',FMAPSOURCEFIELD='tripentry.travelers' WHERE FENTRYID=1685548207964308485;

UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPTYPE='4',FMAPDESIGN='kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getEmployeeID' WHERE FENTRYID = 1685550363182252039
