DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 1950109345321091072;
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 (1950109345321091072,1950065089466368000,'{
	"code":200,
	"data":[
		{
			"code":"200",
			"employeeNumber":"100000"
		}
	]
}','https://btrip.ogeve.com/stdwsapi/extbo/srvrecslelt/rest','1',1950109345321091072,'POST','C','Q_SyncUser_ByOrg','企橙-人员同步-按组织',' ','已录入参数',{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 = '43ISJF5O66FM';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1950109345321091072,'43ISJF5O66FM','zh_CN','企橙-人员同步-按组织');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1950109345346256896;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1950109345321091072,'>=',' ',' ',1950109345346256896,' ',' ','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.ParamsPlugin#getValueByParams');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1950109345346256897;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1950109345321091072,'in',' ',' ',1950109345346256897,' ',' ','1',{ts'2024-05-14  00:00:00'},{ts'2024-05-16  00:00:00'},'entryentity.dpt.id',' ',2,'1','and','kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getValueByParams');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1950109345346256898;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1950109345321091072,'=',' ',' ',1950109345346256898,'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 = 1950109345346256899;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1950109345321091072,'in',' ',' ',1950109345346256899,'1',' ','1',{ts'2024-05-14  00:00:00'},{ts'2024-05-16  00:00:00'},'usertypes.id',' ',4,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1950109345346256900;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1950109345321091072,'is not null',' ',' ',1950109345346256900,' ',' ','1',{ts'2024-05-14  00:00:00'},{ts'2024-05-16  00:00:00'},'number','单据头.工号',5,'1','and',' ');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1950109345346255874;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1950109345321091072,' ','1',' ',' ','服务商设置中的接入appkey',' ',1950109345346255874,'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 = 1950109345346255875;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1950109345321091072,' ','1',' ',' ','时间戳',' ',1950109345346255875,'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 = 1950109345346255876;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1950109345321091072,' ','1',' ',' ','签名',' ',1950109345346255876,'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 = 1950109345346255877;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1950109345321091072,' ','1',' ',' ',' ',' ',1950109345346255877,'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 = 1950109345346255878;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1950109345321091072,' ','1',' ',' ',' ',' ',1950109345346255878,'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 = 1950109345346255879;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1950109345321091072,' ','1',' ','单据头.工号','工号',' ',1950109345346255879,'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 = 1950109345346255880;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1950109345321091072,' ','1',' ','单据头.姓名','名称',' ',1950109345346255880,'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 = 1950109345346255881;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1950109345321091072,' ','1',' ','单据头.手机','手机号',' ',1950109345346255881,'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 = 1950109345346255882;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1950109345321091072,' ','1',' ','单据头.邮箱','性别',' ',1950109345346255882,'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 = 1950109345346255884;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1950109345321091072,' ','1',' ',' ','状态',' ',1950109345346255884,'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 = 1950109345346255885;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1950109345321091072,' ','1',' ',' ','报销级别',' ',1950109345346255885,'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 = 1950109345346255886;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1950109345321091072,' ','1',' ',' ','部门',' ',1950109345346255886,'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 = 1989945515907230720;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1950109345321091072,' ','1',' ',' ','核算组织',' ',1989945515907230720,'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 = 1989945515907230721;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1950109345321091072,' ','1',' ',' ','核算组织名称',' ',1989945515907230721,'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 = 1950109345346256901;
INSERT INTO T_ER_TRIP_IGNOREEXENTRY(FID,FEXDESC,FEXISDEFAULT,FEXNUMBER,FEXCREATETIME,FEXFIELD,FENTRYID,FEXSTATUS,FSEQ,FEXMODIFYTIME) VALUES (1950109345321091072,' ','1','200',{ts'2024-05-14  00:00:00'},'data.[0].code',1950109345346256901,'1',1,{ts'2024-05-20  00:00:00'});
