DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 1869605504276703232;
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 (1869605504276703232,139500340868311041,'{
	"SetApprovalResult":{
		"Status":{
			"Message":"",
			"ErrorCode":0,
			"Success":true
		}
	}
}','https://ct.ctrip.com/switchapi/approval.svc/rest/setapproval','1',1869605504276703232,'POST','C','C_req_one','携程-出差申请单单行程同步','1','已录入参数',{ts'2024-01-24  00:00:00'},'push','0',1205612035459523584,'er_tripreqbill',{ts'2024-03-07  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 = '3VN2RAU1FCXS';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1869605504276703232,'3VN2RAU1FCXS','zh_CN','携程-出差申请单单行程同步');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '3VN2RAU1FCXT';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1869605504276703232,'3VN2RAU1FCXT','zh_TW','攜程-出差申請單單行程同步');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1869605504595470336;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1869605504276703232,'=',' ',' ',1869605504595470336,' ',' ','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 = 1869605504595346476;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869605504276703232,' ','1',' ',' ','token',' ',1869605504595346476,'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 = 1869605504595346477;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869605504276703232,' ','1',' ',' ','扩展字段列表',' ',1869605504595346477,'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 = 1869605504595346478;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869605504276703232,' ','1',' ','name','费用承担公司',' ',1869605504595346478,'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 = 1869605504595346479;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869605504276703232,' ','1',' ',' ',' ',' ',1869605504595346479,'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 = 1869605504595346481;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869605504276703232,' ','1',' ','单据头.单据编号','审批单号',' ',1869605504595346481,'1',{ts'2024-01-24  00:00:00'},'billno',{ts'2024-01-24  00:00:00'},' ',6,'1','request.ApprovalNumber','1');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1869605504595346482;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869605504276703232,' ','1',' ',' ',' ',' ',1869605504595346482,'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 = 1869605504595346484;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869605504276703232,' ','1',' ',' ',' ',' ',1869605504595346484,'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 = 1869612761034867712;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869605504276703232,' ','1',' ','行程信息.开始日期','出发日期',' ',1869612761034867712,'1',{ts'2024-01-24  00:00:00'},'tripentry.startdate',{ts'2024-01-24  00:00:00'},'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getStartTime',9,'4','request.TravelPlanEndorsementDetails.[0].TravelStartDate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1869612761034867713;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869605504276703232,' ','1',' ','行程信息.结束日期','到达日期',' ',1869612761034867713,'1',{ts'2024-01-24  00:00:00'},'tripentry.enddate',{ts'2024-01-24  00:00:00'},'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getEndTime',10,'4','request.TravelPlanEndorsementDetails.[0].TravelEndDate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1869612761034867715;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869605504276703232,' ','1',' ',' ','到达城市',' ',1869612761034867715,'1',{ts'2024-01-24  00:00:00'},'tripentry.to.id',{ts'2024-01-24  00:00:00'},'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getCIdStrByBill',12,'4','request.TravelPlanEndorsementDetails.[0].ArriveCities','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1869612761034867716;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869605504276703232,' ','1',' ',' ','出行人列表',' ',1869612761034867716,'1',{ts'2024-01-24  00:00:00'},'tripentry.travelers',{ts'2024-01-24  00:00:00'},'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getTPassengerList',13,'4','request.TravelPlanEndorsementDetails.[0].PassengerList','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1869612761034867714;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869605504276703232,' ','1',' ',' ','出发城市',' ',1869612761034867714,'1',{ts'2024-01-24  00:00:00'},'tripentry.from.id',{ts'2024-01-24  00:00:00'},'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getCIdStrByBill',11,'4','request.TravelPlanEndorsementDetails.[0].DepartCities','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1869605504595346480;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1869605504276703232,' ','1',' ','number','员工工号',' ',1869605504595346480,'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_IGNOREEXENTRY WHERE FENTRYID = 1869605504595470338;
INSERT INTO T_ER_TRIP_IGNOREEXENTRY(FID,FEXDESC,FEXISDEFAULT,FEXNUMBER,FEXCREATETIME,FEXFIELD,FENTRYID,FEXSTATUS,FSEQ,FEXMODIFYTIME) VALUES (1869605504276703232,' ','1','true',{ts'2024-01-24  00:00:00'},'SetApprovalResult.Status.Success',1869605504595470338,'1',1,{ts'2024-01-24  00:00:00'});
