DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 2076207175268571136;
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 (2076207175268571136,2046351792677283840,'{
	"traceId":"56a0af18ae30a168d4006c7c",
	"msg":"同步成功",
	"data":[
		{
			"result":0,
			"externalApplyNo":"xxx-test-4",
			"applyNo":"33006",
			"itemMsg":"同步成功!"
		}
	],
	"status":0
}','https://bep-openapi.meituan.com/api/sqt/open/trip/applySync','1',2076207175268571136,'POST','C','MT_SyncReq_More ','美团商企通-出差申请单','1','已录入参数。',{ts'2024-11-04  00:00:00'},'push','1',1924580445052322816,'er_tripreqbill',{ts'2024-11-19  00:00:00'},'{
	"accessKey":"B",
	"content":{
		"entId":1,
		"externalApplyList":[
			{
				"projectList":[
					{
						"projectNo":"编码",
						"projectName":"名称"
					}
				],
				"reason":"测试",
				"costCenterList":[
					{
						"costName":"名称",
						"costNo":"编码"
					}
				],
				"externalApplyNo":"t-4",
				"tripSubsidy":"100",
				"tripList":[
					{
						"departureCityList":[
							{
								"cityName":"北京",
								"cityId":"110000"
							}
						],
						"tripType":0,
						"arrivalTimeStr":"2024-10-01",
						"arrivalCityList":[
							{
								"cityName":"天津",
								"cityId":"120000"
							}
						],
						"externalTripId":"1",
						"departureTimeStr":"2024-10-01"
					}
				],
				"passengerList":[
					{
						"staffName":"张三",
						"staffIdentifier":"18413433760"
					}
				],
				"applyStatus":1,
				"submitStaff":{
					"staffName":"张三",
					"staffIdentifier":"18413433760"
				}
			}
		],
		"ts":1617085650321
	}
}','kd.fi.er.business.trip.v2.server.mttrip.MTtripPushCommonInvoke#execute',1924580445052322816,'已录入参数。');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '4I/XD5PA/2VY';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (2076207175268571136,'4I/XD5PA/2VY','zh_CN','美团商企通-出差申请单');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2076207175302125568;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2076207175268571136,'=',' ',' ',2076207175302125568,' ',' ','1',{ts'2024-11-04  00:00:00'},{ts'2024-11-18  00:00:00'},'billno',' ',1,'1','and','kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getValueByParams');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2076207175302126594;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076207175268571136,' ','1',' ',' ',' ',' ',2076207175302126594,'1',{ts'2024-11-04  00:00:00'},' ',{ts'2024-11-04  00:00:00'},'kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getAppKey',1,'4','accessKey','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2076207175302126595;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076207175268571136,' ','1',' ',' ',' ',' ',2076207175302126595,'1',{ts'2024-11-04  00:00:00'},' ',{ts'2024-11-04  00:00:00'},'kd.fi.er.business.trip.v2.plugin.TimePlugin#getNowTime',2,'4','content.ts','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2076207175302126596;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076207175268571136,' ','1',' ',' ',' ',' ',2076207175302126596,'1',{ts'2024-11-04  00:00:00'},' ',{ts'2024-11-04  00:00:00'},'kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getOrationid',3,'4','content.entId','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2076207175302126597;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076207175268571136,' ','1',' ','单据头.单据编号',' ',' ',2076207175302126597,'1',{ts'2024-11-04  00:00:00'},'billno',{ts'2024-11-04  00:00:00'},' ',4,'1','content.externalApplyList.[0].externalApplyNo','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2076207175302126598;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076207175268571136,' ','1',' ','number',' ',' ',2076207175302126598,'1',{ts'2024-11-04  00:00:00'},'creator.number',{ts'2024-11-04  00:00:00'},' ',5,'1','content.externalApplyList.[0].submitStaff.staffIdentifier','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2076207175302126599;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076207175268571136,' ','1',' ','name',' ',' ',2076207175302126599,'1',{ts'2024-11-04  00:00:00'},'creator.name',{ts'2024-11-04  00:00:00'},' ',6,'1','content.externalApplyList.[0].submitStaff.staffName','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2076207175302126600;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076207175268571136,' ','1',' ',' ',' ',' ',2076207175302126600,'1',{ts'2024-11-04  00:00:00'},' ',{ts'2024-11-04  00:00:00'},'kd.fi.er.business.trip.v2.plugin.mttrip.MTtripPlugin#getStatusByParams',7,'4','content.externalApplyList.[0].applyStatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2076207175302126601;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076207175268571136,' ','1',' ','单据头.费用承担公司',' ',' ',2076207175302126601,'1',{ts'2024-11-04  00:00:00'},'costcompany',{ts'2024-11-04  00:00:00'},'kd.fi.er.business.trip.v2.plugin.BillPlugin#getCostCompanyTaxNum',8,'4','content.externalApplyList.[0].invoiceTitle','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2076207175302126602;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076207175268571136,' ','1',' ','行程信息.出差人',' ',' ',2076207175302126602,'1',{ts'2024-11-04  00:00:00'},'tripentry.travelers',{ts'2024-11-04  00:00:00'},'kd.fi.er.business.trip.v2.plugin.mttrip.MTtripPlugin#repastPersonList',9,'4','content.externalApplyList.[0].passengerList','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2076207175302126603;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076207175268571136,' ','1',' ','单据头.id',' ',' ',2076207175302126603,'1',{ts'2024-11-04  00:00:00'},'tripentry.id',{ts'2024-11-04  00:00:00'},' ',10,'1','content.externalApplyList.[0].tripList.[0].externalTripId','1');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2076207175302126604;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076207175268571136,' ','1',' ',' ',' ',' ',2076207175302126604,'1',{ts'2024-11-04  00:00:00'},' ',{ts'2024-11-04  00:00:00'},'2',11,'2','content.externalApplyList.[0].tripList.[0].tripType','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2076207175302126605;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076207175268571136,' ','1',' ',' ',' ',' ',2076207175302126605,'1',{ts'2024-11-04  00:00:00'},'tripentry.startdate',{ts'2024-11-19  00:00:00'},'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getStartTime',12,'4','content.externalApplyList.[0].tripList.[0].departureTimeStr','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2076207175302126606;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076207175268571136,' ','1',' ',' ',' ',' ',2076207175302126606,'1',{ts'2024-11-04  00:00:00'},'tripentry.enddate',{ts'2024-11-19  00:00:00'},'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getEndTime',13,'4','content.externalApplyList.[0].tripList.[0].arrivalTimeStr','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2076207175302126607;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076207175268571136,' ','1',' ','areacode',' ',' ',2076207175302126607,'1',{ts'2024-11-04  00:00:00'},'tripentry.from.areacode',{ts'2024-11-18  00:00:00'},' ',14,'1','content.externalApplyList.[0].tripList.[0].departureCityList.[0].cityId','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2076207175302126608;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076207175268571136,' ','1',' ',' ',' ',' ',2076207175302126608,'1',{ts'2024-11-04  00:00:00'},'tripentry.to.areacode',{ts'2024-11-18  00:00:00'},' ',16,'1','content.externalApplyList.[0].tripList.[0].arrivalCityList.[0].cityId','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2076209648616086528;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076207175268571136,' ','1',' ',' ',' ',' ',2076209648616086528,'1',{ts'2024-11-04  00:00:00'},'costcompany.number',{ts'2024-11-18  00:00:00'},' ',18,'1','content.externalApplyList.[0].costCenterList.[0].costNo','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2076209648616086529;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076207175268571136,' ','1',' ',' ',' ',' ',2076209648616086529,'1',{ts'2024-11-04  00:00:00'},'costcompany.name',{ts'2024-11-18  00:00:00'},' ',19,'1','content.externalApplyList.[0].costCenterList.[0].costName','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2076250848828099584;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076207175268571136,' ','1',' ','单据头.事由',' ',' ',2076250848828099584,'1',{ts'2024-11-04  00:00:00'},'description',{ts'2024-11-18  00:00:00'},' ',20,'1','content.externalApplyList.[0].reason','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2086393501339230208;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076207175268571136,' ','1',' ','name',' ',' ',2086393501339230208,'1',{ts'2024-11-18  00:00:00'},'tripentry.from.name',{ts'2024-11-18  00:00:00'},' ',15,'1','content.externalApplyList.[0].tripList.[0].departureCityList.[0].cityName','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2086393501339230209;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076207175268571136,' ','1',' ','name',' ',' ',2086393501339230209,'1',{ts'2024-11-18  00:00:00'},'tripentry.to.name',{ts'2024-11-18  00:00:00'},' ',17,'1','content.externalApplyList.[0].tripList.[0].arrivalCityList.[0].cityName','0');
DELETE FROM T_ER_TRIP_IGNOREEXENTRY WHERE FENTRYID = 2076207175302125569;
INSERT INTO T_ER_TRIP_IGNOREEXENTRY(FID,FEXDESC,FEXISDEFAULT,FEXNUMBER,FEXCREATETIME,FEXFIELD,FENTRYID,FEXSTATUS,FSEQ,FEXMODIFYTIME) VALUES (2076207175268571136,' ','1','0',{ts'2024-11-04  00:00:00'},'status',2076207175302125569,'1',1,{ts'2024-11-18  00:00:00'});
