DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 1869623235587811328;
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 (1869623235587811328,139500340868311041,'{
	"SetApprovalResult":{
		"Status":{
			"Message":"",
			"ErrorCode":0,
			"Success":true
		}
	}
}','https://ct.ctrip.com/switchapi/approval.svc/rest/setapproval','1',1869623235587811328,'POST','C','C_req_more','携程-出差申请单多行程同步','1','已录入参数',{ts'2024-01-24  00:00:00'},'push','0',1205612035459523584,'er_tripreqbill',{ts'2024-03-22  00:00:00'},'{
	"request":{
		"Status":1,
		"ExtendFieldList":[
			{
				"FieldValue":"",
				"FieldName":"",
				"FieldType":""
			}
		],
		"Auth":{
			"Ticket":"*",
			"AppKey":"*"
		},
		"ExpiredTime":"",
		"TravelPlanEndorsementDetails":[
			{
				"TravelEndDate":"",
				"TravelStartDate":"",
				"DepartCities":"",
				"PassengerList":[
					{
						"EID":"X",
						"Name":"张三"
					}
				],
				"ArriveCities":""
			}
		],
		"ApprovalNumber":"",
		"EmployeeID":""
	}
}','kd.fi.er.business.trip.v2.server.ctrip.CtripReqInvoke#execute',1205612035459523584,'已录入参数');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '3VN61IVUL505';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1869623235587811328,'3VN61IVUL505','zh_CN','携程-出差申请单多行程同步');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '3VN61IVUL506';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1869623235587811328,'3VN61IVUL506','zh_TW','攜程-出差申請單多行程同步');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1869623235705251840;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1869623235587811328,'=',' ',' ',1869623235705251840,' ',' ','1',{ts'2024-01-24  00:00:00'},{ts'2024-01-24  00:00:00'},'billno','单据头.编号',1,'1','and','kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getValueByParams');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1869623235705127944;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869623235587811328,' ','1',' ',' ',' ',' ',1869623235705127944,'1',{ts'2024-01-24  00:00:00'},' ',{ts'2024-03-07  00:00:00'},'kd.fi.er.business.trip.v2.plugin.ctrip.CtripPlugin#getStatusByParams',7,'4','request.Status','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1869623235705127950;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869623235587811328,' ','1',' ','number','出行人列表',' ',1869623235705127950,'1',{ts'2024-01-24  00:00:00'},'tripentry.travelers',{ts'2024-03-12  00:00:00'},'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getTripPassengerList',13,'4','request.TravelPlanEndorsementDetails.[0].PassengerList','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1908646718720072705;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869623235587811328,' ','1',' ',' ',' ',' ',1908646718720072705,'1',{ts'2024-03-18  00:00:00'},' ',{ts'2024-03-22  00:00:00'},'DOMESTIC_HOTEL',15,'2','request.TravelPlanEndorsementDetails.[0].AllowProductTypes.[1]','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1908646718720072706;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869623235587811328,' ','1',' ',' ',' ',' ',1908646718720072706,'1',{ts'2024-03-18  00:00:00'},' ',{ts'2024-03-22  00:00:00'},'TRAIN',16,'2','request.TravelPlanEndorsementDetails.[0].AllowProductTypes.[2]','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1910944375824185346;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869623235587811328,' ','1',' ',' ',' ',' ',1910944375824185346,'1',{ts'2024-03-21  00:00:00'},' ',{ts'2024-03-22  00:00:00'},'CAR_QUICK',19,'2','request.TravelPlanEndorsementDetails.[0].AllowProductTypes.[5]','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1908646718720072704;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869623235587811328,' ','1',' ',' ',' ',' ',1908646718720072704,'1',{ts'2024-03-18  00:00:00'},' ',{ts'2024-03-22  00:00:00'},'DOMESTIC_FLIGHT',14,'2','request.TravelPlanEndorsementDetails.[0].AllowProductTypes.[0]','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1910944375824185344;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869623235587811328,' ','1',' ',' ',' ',' ',1910944375824185344,'1',{ts'2024-03-21  00:00:00'},' ',{ts'2024-03-22  00:00:00'},'INTERNATIONAL_FLIGHT',17,'2','request.TravelPlanEndorsementDetails.[0].AllowProductTypes.[3]','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1910944375824185345;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869623235587811328,' ','1',' ',' ',' ',' ',1910944375824185345,'1',{ts'2024-03-21  00:00:00'},' ',{ts'2024-03-22  00:00:00'},'OVERSEA_HOTEL',18,'2','request.TravelPlanEndorsementDetails.[0].AllowProductTypes.[4]','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1911639179679679488;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869623235587811328,' ','1',' ',' ',' ',' ',1911639179679679488,'1',{ts'2024-03-22  00:00:00'},' ',{ts'2024-03-22  00:00:00'},'false',20,'2','request.TravelPlanEndorsementDetails.[0].validateProductMatch','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1869623235705127938;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869623235587811328,' ','1',' ',' ','token',' ',1869623235705127938,'1',{ts'2024-01-24  00:00:00'},' ',{ts'2024-01-24  00:00:00'},'C_ticket',1,'5','request.Auth.Ticket','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1869623235705127939;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869623235587811328,' ','1',' ',' ','扩展字段列表',' ',1869623235705127939,'1',{ts'2024-01-24  00:00:00'},' ',{ts'2024-01-24  00:00:00'},'CostCenter1',2,'2','request.ExtendFieldList.[0].FieldName','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1869623235705127940;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869623235587811328,' ','1',' ','name','费用承担公司',' ',1869623235705127940,'1',{ts'2024-01-24  00:00:00'},'costcompany.name',{ts'2024-01-24  00:00:00'},' ',3,'1','request.ExtendFieldList.[0].FieldValue','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1869623235705127941;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869623235587811328,' ','1',' ',' ',' ',' ',1869623235705127941,'1',{ts'2024-01-24  00:00:00'},' ',{ts'2024-01-24  00:00:00'},'String',4,'2','request.ExtendFieldList.[0].FieldType','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1869623235705127943;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869623235587811328,' ','1',' ','单据头.单据编号','审批单号',' ',1869623235705127943,'1',{ts'2024-01-24  00:00:00'},'billno',{ts'2024-01-24  00:00:00'},' ',6,'1','request.ApprovalNumber','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1869623235705127945;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869623235587811328,' ','1',' ',' ',' ',' ',1869623235705127945,'1',{ts'2024-01-24  00:00:00'},' ',{ts'2024-01-24  00:00:00'},'kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getAppKey',8,'4','request.Auth.AppKey','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1869623235705127942;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869623235587811328,' ','1',' ','number','员工工号',' ',1869623235705127942,'1',{ts'2024-01-24  00:00:00'},'applier.number',{ts'2024-02-27  00:00:00'},'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getEmployeeIDByBill',5,'4','request.EmployeeID','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1869623235705127948;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869623235587811328,' ','1',' ',' ','出发城市',' ',1869623235705127948,'1',{ts'2024-01-24  00:00:00'},'tripentry.from.id',{ts'2024-02-27  00:00:00'},'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getCIds',11,'4','request.TravelPlanEndorsementDetails.[0].DepartCities','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1869623235705127949;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869623235587811328,' ','1',' ',' ','到达城市',' ',1869623235705127949,'1',{ts'2024-01-24  00:00:00'},'tripentry.to.id',{ts'2024-02-27  00:00:00'},'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getCIds',12,'4','request.TravelPlanEndorsementDetails.[0].ArriveCities','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1869623235705127946;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869623235587811328,' ','1',' ','行程信息.开始日期','出发日期',' ',1869623235705127946,'1',{ts'2024-01-24  00:00:00'},'tripentry.startdate',{ts'2024-02-27  00:00:00'},'kd.fi.er.business.trip.v2.plugin.TimePlugin#getShortDateByBillValue',9,'4','request.TravelPlanEndorsementDetails.[0].TravelStartDate','1');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1869623235705127947;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869623235587811328,' ','1',' ','行程信息.结束日期','到达日期',' ',1869623235705127947,'1',{ts'2024-01-24  00:00:00'},'tripentry.enddate',{ts'2024-02-27  00:00:00'},'kd.fi.er.business.trip.v2.plugin.TimePlugin#getShortDateByBillValue',10,'4','request.TravelPlanEndorsementDetails.[0].TravelEndDate','0');
DELETE FROM T_ER_TRIP_IGNOREEXENTRY WHERE FENTRYID = 1869623235705251842;
INSERT INTO T_ER_TRIP_IGNOREEXENTRY(FID,FEXDESC,FEXISDEFAULT,FEXNUMBER,FEXCREATETIME,FEXFIELD,FENTRYID,FEXSTATUS,FSEQ,FEXMODIFYTIME) VALUES (1869623235587811328,' ','1','true',{ts'2024-01-24  00:00:00'},'SetApprovalResult.Status.Success',1869623235705251842,'1',1,{ts'2024-01-24  00:00:00'});
