DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 2076199044425718784;
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 (2076199044425718784,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',2076199044425718784,'POST','C','MT_SyncReq_One','美团商企通-出差申请单','1','已录入参数。',{ts'2024-11-04  00:00:00'},'push','1',1924580445052322816,'er_tripreqbill',{ts'2024-11-18  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/VVY01544W';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (2076199044425718784,'4I/VVY01544W','zh_CN','美团商企通-出差申请单');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2076199044635433984;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2076199044425718784,'=',' ',' ',2076199044635433984,' ',' ','1',{ts'2024-11-04  00:00:00'},{ts'2024-11-04  00:00:00'},'billno',' ',1,'1','and','kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getValueByParams');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2076199044635432962;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076199044425718784,' ','1',' ',' ',' ',' ',2076199044635432962,'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 = 2076199044635432963;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076199044425718784,' ','1',' ',' ',' ',' ',2076199044635432963,'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 = 2076199044635432964;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076199044425718784,' ','1',' ',' ',' ',' ',2076199044635432964,'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 = 2076199044635432965;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076199044425718784,' ','1',' ','单据头.单据编号',' ',' ',2076199044635432965,'1',{ts'2024-11-04  00:00:00'},'billno',{ts'2024-11-04  00:00:00'},' ',4,'1','content.externalApplyList.[0].externalApplyNo','1');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2076199044635432966;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076199044425718784,' ','1',' ','number',' ',' ',2076199044635432966,'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 = 2076199044635432967;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076199044425718784,' ','1',' ','name',' ',' ',2076199044635432967,'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 = 2076199044635432968;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076199044425718784,' ','1',' ',' ',' ',' ',2076199044635432968,'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 = 2076199044635432969;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076199044425718784,' ','1',' ','单据头.费用承担公司',' ',' ',2076199044635432969,'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 = 2076199044635432970;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076199044425718784,' ','1',' ','行程信息.出差人',' ',' ',2076199044635432970,'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 = 2076199044635432971;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076199044425718784,' ','1',' ','单据头.id',' ',' ',2076199044635432971,'1',{ts'2024-11-04  00:00:00'},'tripentry.id',{ts'2024-11-04  00:00:00'},'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getFTripId',10,'4','content.externalApplyList.[0].tripList.[0].externalTripId','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2076199044635432972;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076199044425718784,' ','1',' ',' ',' ',' ',2076199044635432972,'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 = 2076199044635432973;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076199044425718784,' ','1',' ',' ',' ',' ',2076199044635432973,'1',{ts'2024-11-04  00:00:00'},'tripentry.startdate',{ts'2024-11-04  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 = 2076199044635432974;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076199044425718784,' ','1',' ',' ',' ',' ',2076199044635432974,'1',{ts'2024-11-04  00:00:00'},'tripentry.enddate',{ts'2024-11-04  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 = 2076199044635432975;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076199044425718784,' ','1',' ',' ',' ',' ',2076199044635432975,'1',{ts'2024-11-04  00:00:00'},'tripentry.from.id',{ts'2024-11-04  00:00:00'},'kd.fi.er.business.trip.v2.plugin.mttrip.MTtripPlugin#getIdStrByBill',14,'4','content.externalApplyList.[0].tripList.[0].departureCityList','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2076199044635432976;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076199044425718784,' ','1',' ',' ',' ',' ',2076199044635432976,'1',{ts'2024-11-04  00:00:00'},'tripentry.to.id',{ts'2024-11-04  00:00:00'},'kd.fi.er.business.trip.v2.plugin.mttrip.MTtripPlugin#getIdStrByBill',15,'4','content.externalApplyList.[0].tripList.[0].arrivalCityList','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2076208490753301504;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076199044425718784,' ','1',' ','number',' ',' ',2076208490753301504,'1',{ts'2024-11-04  00:00:00'},'costcompany.number',{ts'2024-11-04  00:00:00'},' ',16,'1','content.externalApplyList.[0].costCenterList.[0].costNo','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2076208490753301505;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076199044425718784,' ','1',' ','name',' ',' ',2076208490753301505,'1',{ts'2024-11-04  00:00:00'},'costcompany.name',{ts'2024-11-04  00:00:00'},' ',17,'1','content.externalApplyList.[0].costCenterList.[0].costName','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2076250911650383872;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2076199044425718784,' ','1',' ',' ',' ',' ',2076250911650383872,'1',{ts'2024-11-04  00:00:00'},'description',{ts'2024-11-04  00:00:00'},' ',18,'1','content.externalApplyList.[0].reason','0');
DELETE FROM T_ER_TRIP_IGNOREEXENTRY WHERE FENTRYID = 2076206016977968128;
INSERT INTO T_ER_TRIP_IGNOREEXENTRY(FID,FEXDESC,FEXISDEFAULT,FEXNUMBER,FEXCREATETIME,FEXFIELD,FENTRYID,FEXSTATUS,FSEQ,FEXMODIFYTIME) VALUES (2076199044425718784,' ','1','0',{ts'2024-11-04  00:00:00'},'status',2076206016977968128,'1',1,{ts'2024-11-18  00:00:00'});
