DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 2050709517884431360;
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 (2050709517884431360,2046351792677283840,'{
	"traceId":"56a0af18ae30a168d4006c7c",
	"msg":"同步成功",
	"data":[
		{
			"result":0,
			"externalApplyNo":"5N9D0AD96RY9-1",
			"applyNo":"5NQZ0NBUDZPD",
			"itemMsg":"处理成功"
		},
		{
			"result":0,
			"externalApplyNo":"xxxxxx21-3",
			"applyNo":"5NQZ0OBUFB42",
			"itemMsg":"处理成功"
		}
	],
	"status":0
}','https://bep-openapi.meituan.com/api/sqt/open/repast/applySync','1',2050709517884431360,'POST','C','MT_EntertainApply','美团商企通-招待会议',' ','已录入参数。',{ts'2024-09-30  00:00:00'},'push','1',1924580445052322816,'er_dailyapplybill',{ts'2024-11-15  00:00:00'},'{
	"accessKey":"B3KSWLDSKSKDMJ",
	"content":{
		"entId":100991,
		"externalApplyList":[
			{
				"reason":"测试会议招待事由",
				"invoiceInfo":{
					"invoiceNum":"1213123"
				},
				"buyerList":[
					{
						"staffName":"张三",
						"staffIdentifier":"18"
					}
				],
				"externalApplyNo":"5N",
				"cityIdList":[
					110000
				],
				"submitStaff":{
					"staffName":"张三",
					"staffIdentifier":"189"
				},
				"sceneType":1,
				"externalApplyName":" test",
				"limitAmount":5000,
				"startTime":1673318578000,
				"endTime":1673404978000,
				"repastPersonList":[
					{
						"staffName":"张三",
						"staffIdentifier":"189"
					}
				],
				"restaurantIdList":[
					"80"
				]
			}
		],
		"ts":1617085650321
	}
}','kd.fi.er.business.trip.v2.server.mttrip.MTtripPushCommonInvoke#execute',1924580445052322816,'已录入参数。');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '4EWR95Z16PXE';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (2050709517884431360,'4EWR95Z16PXE','zh_CN','美团商企通-招待会议');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2050709517909597184;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2050709517884431360,'=',' ',' ',2050709517909597184,' ',' ','1',{ts'2024-09-30  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_QUERYENTRY WHERE FENTRYID = 2050709517909597185;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2050709517884431360,'=',' ',' ',2050709517909597185,'E',' ','1',{ts'2024-09-30  00:00:00'},{ts'2024-09-30  00:00:00'},'billstatus',' ',2,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2050709517909597186;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2050709517884431360,'in',' ',' ',2050709517909597186,'meetting,entertainment,meetting_bill,entertainment_bill',' ','1',{ts'2024-09-30  00:00:00'},{ts'2024-09-30  00:00:00'},'reimbursetype','单据头.申请类型',3,'1','and',' ');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2050709517909721090;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2050709517884431360,' ','1',' ',' ',' ',' ',2050709517909721090,'1',{ts'2024-09-30  00:00:00'},' ',{ts'2024-09-30  00:00:00'},'kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getAppKey',1,'4','accessKey','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2050709517909721091;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2050709517884431360,' ','1',' ',' ',' ',' ',2050709517909721091,'1',{ts'2024-09-30  00:00:00'},' ',{ts'2024-09-30  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 = 2050709517909721092;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2050709517884431360,' ','1',' ',' ',' ',' ',2050709517909721092,'1',{ts'2024-09-30  00:00:00'},' ',{ts'2024-09-30  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 = 2050709517909721093;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2050709517884431360,' ','1',' ','单据头.用餐场景',' ',' ',2050709517909721093,'1',{ts'2024-09-30  00:00:00'},' ',{ts'2024-09-30  00:00:00'},'1',4,'2','content.externalApplyList.[0].sceneType','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2050709517909721094;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2050709517884431360,' ','1',' ','单据头.单据编号',' ',' ',2050709517909721094,'1',{ts'2024-09-30  00:00:00'},'billno',{ts'2024-09-30  00:00:00'},' ',5,'1','content.externalApplyList.[0].externalApplyNo','1');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2050709517909721095;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2050709517884431360,' ','1',' ','number',' ',' ',2050709517909721095,'1',{ts'2024-09-30  00:00:00'},'applier.number',{ts'2024-09-30  00:00:00'},' ',6,'1','content.externalApplyList.[0].submitStaff.staffIdentifier','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2050709517909721096;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2050709517884431360,' ','1',' ','name',' ',' ',2050709517909721096,'1',{ts'2024-09-30  00:00:00'},'applier.name',{ts'2024-09-30  00:00:00'},' ',7,'1','content.externalApplyList.[0].submitStaff.staffName','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2050709517909721097;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2050709517884431360,' ','1',' ','单据头.用餐日期.开始',' ',' ',2050709517909721097,'1',{ts'2024-09-30  00:00:00'},' ',{ts'2024-09-30  00:00:00'},'kd.fi.er.business.trip.v2.plugin.TimePlugin#getNowTime',8,'4','content.externalApplyList.[0].startTime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2050709517909721098;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2050709517884431360,' ','1',' ','单据头.用餐日期.结束',' ',' ',2050709517909721098,'1',{ts'2024-09-30  00:00:00'},' ',{ts'2024-09-30  00:00:00'},'kd.fi.er.business.trip.v2.plugin.TimePlugin#getNowTimeExtendByDates',9,'4','content.externalApplyList.[0].endTime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2050709517909721099;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2050709517884431360,' ','1',' ','name',' ',' ',2050709517909721099,'1',{ts'2024-09-30  00:00:00'},'creator.name',{ts'2024-09-30  00:00:00'},' ',10,'1','content.externalApplyList.[0].buyerList.[0].staffName','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2050709517909721100;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2050709517884431360,' ','1',' ',' ',' ',' ',2050709517909721100,'1',{ts'2024-09-30  00:00:00'},'creator.number',{ts'2024-09-30  00:00:00'},' ',11,'1','content.externalApplyList.[0].buyerList.[0].staffIdentifier','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2050709517909721101;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2050709517884431360,' ','1',' ','name',' ',' ',2050709517909721101,'1',{ts'2024-09-30  00:00:00'},'applier.name',{ts'2024-09-30  00:00:00'},' ',12,'1','content.externalApplyList.[0].buyerList.[1].staffName','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2050709517909721102;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2050709517884431360,' ','1',' ','number',' ',' ',2050709517909721102,'1',{ts'2024-09-30  00:00:00'},'applier.number',{ts'2024-09-30  00:00:00'},' ',13,'1','content.externalApplyList.[0].buyerList.[1].staffIdentifier','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2050709517909721104;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2050709517884431360,' ','1',' ','单据头.费用承担公司',' ',' ',2050709517909721104,'1',{ts'2024-09-30  00:00:00'},'costcompany',{ts'2024-09-30  00:00:00'},'kd.fi.er.business.trip.v2.plugin.BillPlugin#getCostCompanyTaxNum',14,'4','content.externalApplyList.[0].invoiceInfo.invoiceNum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2050709517909721105;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2050709517884431360,' ','1',' ','单据头.金额',' ',' ',2050709517909721105,'1',{ts'2024-09-30  00:00:00'},' ',{ts'2024-11-15  00:00:00'},'kd.fi.er.business.trip.v2.plugin.mttrip.MTtripPlugin#limitAmount',16,'4','content.externalApplyList.[0].limitAmount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2050709517909721106;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2050709517884431360,' ','1',' ',' ',' ',' ',2050709517909721106,'1',{ts'2024-09-30  00:00:00'},' ',{ts'2024-11-15  00:00:00'},'SUBSTRING(description,0,100)',17,'3','content.externalApplyList.[0].reason','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2084048504098914304;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2050709517884431360,' ','1',' ','单据头.费用承担公司',' ',' ',2084048504098914304,'1',{ts'2024-11-15  00:00:00'},'costcompany',{ts'2024-11-15  00:00:00'},'kd.fi.er.business.trip.v2.plugin.BillPlugin#getCostCompanyTaxTitle',15,'4','content.externalApplyList.[0].invoiceInfo.invoiceTitle','0');
DELETE FROM T_ER_TRIP_IGNOREEXENTRY WHERE FENTRYID = 2050709517909597187;
INSERT INTO T_ER_TRIP_IGNOREEXENTRY(FID,FEXDESC,FEXISDEFAULT,FEXNUMBER,FEXCREATETIME,FEXFIELD,FENTRYID,FEXSTATUS,FSEQ,FEXMODIFYTIME) VALUES (2050709517884431360,' ','1','0',{ts'2024-09-30  00:00:00'},'status',2050709517909597187,'1',1,{ts'2024-09-30  00:00:00'});
