DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 2047219817840486400;
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 (2047219817840486400,2046351792677283840,'{
	"traceId":"56a0af18ae30a168d4006c7c",
	"data":[
		{
			"result":0,
			"staffEmail":null,
			"staffPhone":null,
			"staffNum":"D0920150125",
			"itemMsg":"成功",
			"staffId":6877151
		},
		{
			"result":0,
			"staffEmail":"",
			"staffPhone":"184****2232",
			"staffNum":"",
			"itemMsg":"成功",
			"staffId":397375
		},
		{
			"result":0,
			"staffEmail":"",
			"staffPhone":"182****2433",
			"staffNum":"",
			"itemMsg":"成功",
			"staffId":397376
		}
	],
	"status":0
}','https://bep-openapi.meituan.com/api/sqt/open/staff/batch/save','1',2047219817840486400,'POST','C','MT_SyncUser_ByOrg','美团商企通-人员同步-按组织',' ','已录入参数。',{ts'2024-09-25  00:00:00'},'push','1',1924580445052322816,'bos_user',{ts'2024-11-13  00:00:00'},'{
	"accessKey":"B3KSWLDSKSKDMJ",
	"content":{
		"entId":100746,
		"staffInfoList":[
			{
				"costCenterList":[
					{
						"costName":"name",
						"costNo":"id"
					}
				],
				"gender":"wan",
				"staffStatus":"2",
				"staffName":"wan",
				"parentIdentifier":"wan",
				"staffPhone":"187****2611",
				"staffOrgInfoList":[
					{
						"externalOrgId":"id"
					}
				],
				"staffNum":"wan",
				"invoiceNum":"wan",
				"staffLevel":"wan"
			}
		],
		"ts":123123
	}
}','kd.fi.er.business.trip.v2.server.mttrip.MTTripSyncUserInvoke#execute',1924580445052322816,'已录入参数。');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '4EG07SZ=X=PB';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (2047219817840486400,'4EG07SZ=X=PB','zh_CN','美团商企通-人员同步-按组织');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2047219817882429442;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2047219817840486400,'=',' ',' ',2047219817882429442,'20',' ','1',{ts'2024-09-25  00:00:00'},{ts'2024-09-25  00:00:00'},'pageSize',' ',3,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2047219817882429443;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2047219817840486400,'in',' ',' ',2047219817882429443,'1',' ','1',{ts'2024-09-25  00:00:00'},{ts'2024-11-13  00:00:00'},'usertypes.id',' ',4,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2047219817882429444;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2047219817840486400,'is not null',' ',' ',2047219817882429444,' ',' ','1',{ts'2024-09-25  00:00:00'},{ts'2024-09-25  00:00:00'},'number','单据头.工号',5,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2047219817882429440;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2047219817840486400,'>=',' ',' ',2047219817882429440,' ',' ','1',{ts'2024-09-25  00:00:00'},{ts'2024-09-25  00:00:00'},'modifytime',' ',1,'1','and','kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getValueByParams');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2047219817882429441;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2047219817840486400,'in',' ',' ',2047219817882429441,' ',' ','1',{ts'2024-09-25  00:00:00'},{ts'2024-09-25  00:00:00'},'entryentity.dpt.id',' ',2,'1','and','kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getValueByParams');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2047219817882181634;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2047219817840486400,' ','1',' ',' ',' ',' ',2047219817882181634,'1',{ts'2024-09-25  00:00:00'},' ',{ts'2024-09-25  00:00:00'},'kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getAppKey',1,'4','accessKey','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2047219817882181635;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2047219817840486400,' ','1',' ',' ',' ',' ',2047219817882181635,'1',{ts'2024-09-25  00:00:00'},' ',{ts'2024-09-25  00:00:00'},'kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getOrationid',2,'4','content.entId','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2047219817882181636;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2047219817840486400,' ','1',' ',' ',' ',' ',2047219817882181636,'1',{ts'2024-09-25  00:00:00'},' ',{ts'2024-09-25  00:00:00'},'kd.fi.er.business.trip.v2.plugin.TimePlugin#getNowTime',3,'4','content.ts','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2047219817882181638;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2047219817840486400,' ','1',' ','单据头.姓名',' ',' ',2047219817882181638,'1',{ts'2024-09-25  00:00:00'},'name',{ts'2024-09-25  00:00:00'},' ',5,'1','content.staffInfoList.[0].staffName','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2047219817882181639;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2047219817840486400,' ','1',' ','单据头.性别',' ',' ',2047219817882181639,'1',{ts'2024-09-25  00:00:00'},'gender',{ts'2024-09-25  00:00:00'},' ',6,'1','content.staffInfoList.[0].gender','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2047219817882181643;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2047219817840486400,' ','1',' ',' ',' ',' ',2047219817882181643,'1',{ts'2024-09-25  00:00:00'},' ',{ts'2024-11-01  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getPartJobCostCompanyId',9,'4','content.staffInfoList.[0].costCenterList.[0].costNo','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2047219817882181644;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2047219817840486400,' ','1',' ',' ',' ',' ',2047219817882181644,'1',{ts'2024-09-25  00:00:00'},' ',{ts'2024-11-01  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getPartJobCostCompanyName',10,'4','content.staffInfoList.[0].costCenterList.[0].costName','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2047219817882181645;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2047219817840486400,' ','1',' ',' ',' ',' ',2047219817882181645,'1',{ts'2024-09-25  00:00:00'},' ',{ts'2024-11-01  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getPartJobCompanyId',11,'4','content.staffInfoList.[0].staffOrgInfoList.[0].externalOrgId','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2047219817882181646;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2047219817840486400,' ','1',' ',' ',' ',' ',2047219817882181646,'1',{ts'2024-09-25  00:00:00'},' ',{ts'2024-11-01  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getPartJobCostCompanyTaxregnum',12,'4','content.staffInfoList.[0].invoiceNum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2047219817882181641;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2047219817840486400,' ','1',' ','单据头.数据状态',' ',' ',2047219817882181641,'1',{ts'2024-09-25  00:00:00'},' ',{ts'2024-11-01  00:00:00'},'IF( enable = ''1'' AND isforbidden =false ,2,1)',7,'3','content.staffInfoList.[0].staffStatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2047219817882181642;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2047219817840486400,' ','1',' ','单据头.id',' ',' ',2047219817882181642,'1',{ts'2024-09-25  00:00:00'},' ',{ts'2024-11-01  00:00:00'},'kd.fi.er.business.trip.v2.plugin.mttrip.MTtripPlugin#getPositionLevelName',8,'4','content.staffInfoList.[0].staffLevel','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2047219817882181637;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2047219817840486400,' ','1',' ','单据头.工号',' ',' ',2047219817882181637,'1',{ts'2024-09-25  00:00:00'},'number',{ts'2024-11-01  00:00:00'},' ',4,'1','content.staffInfoList.[0].staffNum','1');
DELETE FROM T_ER_TRIP_IGNOREEXENTRY WHERE FENTRYID = 2047219817882429445;
INSERT INTO T_ER_TRIP_IGNOREEXENTRY(FID,FEXDESC,FEXISDEFAULT,FEXNUMBER,FEXCREATETIME,FEXFIELD,FENTRYID,FEXSTATUS,FSEQ,FEXMODIFYTIME) VALUES (2047219817840486400,' ','1','0',{ts'2024-09-25  00:00:00'},'status',2047219817882429445,'1',1,{ts'2024-10-09  00:00:00'});
