DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 1950107256004049920;
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 (1950107256004049920,1950065089466368000,'{
	"code":200,
	"data":[
		{
			"code":"200",
			"employeeNumber":"100000"
		}
	]
}','https://btrip.ogeve.com/stdwsapi/extbo/srvrecslelt/rest','1',1950107256004049920,'POST','C','Q_SyncUser','企橙-人员同步',' ','已录入参数',{ts'2024-05-14  00:00:00'},'push','1',1924580445052322816,'bos_user',{ts'2024-07-10  00:00:00'},'{
	"currentTime":"",
	"password":"",
	"data":[
		{
			"employeeName":"name",
			"mobilePhone":"phone",
			"personnelLevel":"entryentity.dpt.id",
			"identityList":"",
			"enabledFlag":"",
			"email":"email",
			"deptCode":"entryentity.dpt.id",
			"employeeNumber":"number"
		}
	],
	"method":"",
	"format":"",
	"userName":""
}','kd.fi.er.business.trip.v2.server.qtrip.QTripSyncUserInvoke#execute',1924580445052322816,'已录入参数');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '43IS57DTVG48';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1950107256004049920,'43IS57DTVG48','zh_CN','企橙-人员同步');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1950107256037604352;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1950107256004049920,'>=',' ',' ',1950107256037604352,' ',' ','1',{ts'2024-05-14  00:00:00'},{ts'2024-05-16  00:00:00'},'modifytime','单据头.修改时间',1,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getLastSyncUserTime');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1950107256037604353;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1950107256004049920,'in',' ',' ',1950107256037604353,'1',' ','1',{ts'2024-05-14  00:00:00'},{ts'2024-05-16  00:00:00'},'usertypes.id','单据头.id',2,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1950107256037604354;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1950107256004049920,'=',' ',' ',1950107256037604354,'10',' ','1',{ts'2024-05-14  00:00:00'},{ts'2024-05-16  00:00:00'},'pageSize',' ',3,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1950108797544987648;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1950107256004049920,'is not null',' ',' ',1950108797544987648,' ',' ','1',{ts'2024-05-14  00:00:00'},{ts'2024-05-16  00:00:00'},'number',' ',4,'1','and',' ');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1950107256037605389;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1950107256004049920,' ','1',' ',' ','报销级别',' ',1950107256037605389,'1',{ts'2024-05-14  00:00:00'},' ',{ts'2024-05-20  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getPositionLevelName',11,'4','data.[0].personnelLevel','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1950107256037605378;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1950107256004049920,' ','1',' ',' ','服务商设置中的接入appkey',' ',1950107256037605378,'1',{ts'2024-05-14  00:00:00'},' ',{ts'2024-05-16  00:00:00'},'kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getAppKey',1,'4','userName','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1950107256037605379;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1950107256004049920,' ','1',' ',' ','时间戳',' ',1950107256037605379,'1',{ts'2024-05-14  00:00:00'},' ',{ts'2024-05-16  00:00:00'},'kd.fi.er.business.trip.v2.plugin.TimePlugin#getLongNowDate',2,'4','currentTime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1950107256037605380;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1950107256004049920,' ','1',' ',' ','签名',' ',1950107256037605380,'1',{ts'2024-05-14  00:00:00'},' ',{ts'2024-05-16  00:00:00'},'kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getAppsecurity',3,'4','password','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1950107256037605381;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1950107256004049920,' ','1',' ',' ',' ',' ',1950107256037605381,'1',{ts'2024-05-14  00:00:00'},' ',{ts'2024-05-16  00:00:00'},'json',4,'2','format','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1950107256037605382;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1950107256004049920,' ','1',' ',' ',' ',' ',1950107256037605382,'1',{ts'2024-05-14  00:00:00'},' ',{ts'2024-05-16  00:00:00'},'zas.syncemployee',5,'2','method','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1950107256037605383;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1950107256004049920,' ','1',' ','单据头.工号','工号',' ',1950107256037605383,'1',{ts'2024-05-14  00:00:00'},'number',{ts'2024-05-16  00:00:00'},' ',6,'1','data.[0].employeeNumber','1');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1950107256037605384;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1950107256004049920,' ','1',' ','单据头.姓名','名称',' ',1950107256037605384,'1',{ts'2024-05-14  00:00:00'},'name',{ts'2024-05-16  00:00:00'},' ',7,'1','data.[0].employeeName','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1950107256037605385;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1950107256004049920,' ','1',' ','单据头.手机','手机号',' ',1950107256037605385,'1',{ts'2024-05-14  00:00:00'},'phone',{ts'2024-05-16  00:00:00'},' ',8,'1','data.[0].mobilePhone','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1950107256037605386;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1950107256004049920,' ','1',' ','单据头.邮箱','性别',' ',1950107256037605386,'1',{ts'2024-05-14  00:00:00'},' ',{ts'2024-07-10  00:00:00'},'IF( gender  = ''2''     ,''M'',''F'') ',9,'3','data.[0].sex','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1950107256037605388;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1950107256004049920,' ','1',' ',' ','状态',' ',1950107256037605388,'1',{ts'2024-05-14  00:00:00'},' ',{ts'2024-05-16  00:00:00'},'IF( enable = ''0''   OR isforbidden  ,''N'',''Y'')',10,'3','data.[0].enabledFlag','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1950107256037605390;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1950107256004049920,' ','1',' ',' ','组织',' ',1950107256037605390,'1',{ts'2024-05-14  00:00:00'},' ',{ts'2024-07-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getPartJobCompanyId',12,'4','data.[0].deptCode','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1989941342960625664;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1950107256004049920,' ','1',' ',' ','核算组织',' ',1989941342960625664,'1',{ts'2024-07-08  00:00:00'},' ',{ts'2024-07-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getPartJobCostCompanyId',13,'4','data.[0].settleMain','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1989941342960625665;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1950107256004049920,' ','1',' ',' ','核算组织名称',' ',1989941342960625665,'1',{ts'2024-07-08  00:00:00'},' ',{ts'2024-07-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getPartJobCostCompanyName',14,'4','data.[0].settleMainName','0');
DELETE FROM T_ER_TRIP_IGNOREEXENTRY WHERE FENTRYID = 1954477410678416384;
INSERT INTO T_ER_TRIP_IGNOREEXENTRY(FID,FEXDESC,FEXISDEFAULT,FEXNUMBER,FEXCREATETIME,FEXFIELD,FENTRYID,FEXSTATUS,FSEQ,FEXMODIFYTIME) VALUES (1950107256004049920,' ','1','200',{ts'2024-05-20  00:00:00'},'data.[0].code',1954477410678416384,'1',1,{ts'2024-05-20  00:00:00'});
