DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 1966762792988292096;
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 (1966762792988292096,1966138761855480832,'{
	"code":"10000",
	"userInfoList":[
		{
			"companyId":"S118022",
			"password":"",
			"OutsidePassengerId":"ak10002",
			"DepName":"研发中心",
			"sessionId":"181290f79eab44fd90a1ee6145264ffd202310110937265250OA",
			"userName":"ak_LiuZhanChao",
			"userId":"P258456",
			"DId":100086
		}
	],
	"description":"请求成功",
	"failList":[
		{
			"passengerName":"刘展超",
			"companyId":"S118022",
			"description":"旅客英文名格式不正确，请修正",
			"outsidePassengerId":"ak10002"
		}
	]
}','http://api.shinetour.com/API.svc/SyncPsgInfoNew','1',1966762792988292096,'POST','C','M_SyncUser','美亚-人员同步',' ','已录入参数',{ts'2024-06-06  00:00:00'},'push','1',1879091968009578496,'bos_user',{ts'2024-06-14  00:00:00'},' ','kd.fi.er.business.trip.v2.server.mytrip.MTripSyncUserInvoke#execute',1879091968009578496,'已录入参数');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '45KK5UBOWGQ3';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1966762792988292096,'45KK5UBOWGQ3','zh_CN','美亚-人员同步');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1966773382733476865;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1966762792988292096,'in',' ',' ',1966773382733476865,'1',' ','1',{ts'2024-06-06  00:00:00'},{ts'2024-06-13  00:00:00'},'usertypes.id',' ',2,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1966773382733476866;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1966762792988292096,'=',' ',' ',1966773382733476866,'1',' ','1',{ts'2024-06-06  00:00:00'},{ts'2024-06-13  00:00:00'},'pageSize',' ',3,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1966773382733476867;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1966762792988292096,'is not null',' ',' ',1966773382733476867,' ',' ','1',{ts'2024-06-06  00:00:00'},{ts'2024-06-13  00:00:00'},'number',' ',4,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1966773382733476864;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1966762792988292096,'>=',' ',' ',1966773382733476864,' ',' ','1',{ts'2024-06-06  00:00:00'},{ts'2024-06-13  00:00:00'},'modifytime','单据头.修改时间',1,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getLastSyncUserTime');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1967473692183358469;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1966762792988292096,' ','1',' ',' ','旅客类型:成人/儿童/婴儿',' ',1967473692183358469,'1',{ts'2024-06-07  00:00:00'},' ',{ts'2024-06-11  00:00:00'},'成人',7,'2','SyncPsgList.[0].PassengerInfo.passengerType','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1967473692183358470;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1966762792988292096,' ','1',' ',' ','公司编码',' ',1967473692183358470,'1',{ts'2024-06-07  00:00:00'},' ',{ts'2024-06-11  00:00:00'},'kd.fi.er.business.trip.v2.plugin.mtrip.MTripPlugin#getCompanyId',8,'4','SyncPsgList.[0].PassengerInfo.companyId','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1967473692183358471;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1966762792988292096,' ','1',' ',' ','性别:男/女；',' ',1967473692183358471,'1',{ts'2024-06-07  00:00:00'},' ',{ts'2024-06-11  00:00:00'},'IF(gender = ''2'',''女'',''男'')',9,'3','SyncPsgList.[0].PassengerInfo.sex','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1967473692183358472;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1966762792988292096,' ','1',' ','单据头.姓名','中文姓名',' ',1967473692183358472,'1',{ts'2024-06-07  00:00:00'},'name',{ts'2024-06-11  00:00:00'},' ',10,'1','SyncPsgList.[0].PassengerInfo.cnName','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1967473692183358474;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1966762792988292096,' ','1',' ','单据头.id','国籍：中国填写 CN',' ',1967473692183358474,'1',{ts'2024-06-07  00:00:00'},'country.id',{ts'2024-06-11  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OtherFieldCommonPlugin#getTwoCountryCode',12,'4','SyncPsgList.[0].PassengerInfo.nationality','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1967473692183358475;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1966762792988292096,' ','1',' ','单据头.手机','手机号码',' ',1967473692183358475,'1',{ts'2024-06-07  00:00:00'},'phone',{ts'2024-06-11  00:00:00'},' ',13,'1','SyncPsgList.[0].PassengerInfo.mobile','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1967473692183358476;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1966762792988292096,' ','1',' ',' ','职称ID;',' ',1967473692183358476,'1',{ts'2024-06-07  00:00:00'},' ',{ts'2024-06-11  00:00:00'},'kd.fi.er.business.trip.v2.plugin.mtrip.MTripPlugin#getPositionLevelName',14,'4','SyncPsgList.[0].PassengerInfo.holderId','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1967473692183358477;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1966762792988292096,' ','1',' ',' ','成本中心名称',' ',1967473692183358477,'1',{ts'2024-06-07  00:00:00'},' ',{ts'2024-06-11  00:00:00'},'kd.fi.er.business.trip.v2.plugin.mtrip.MTripPlugin#getCostCenterName',15,'4','SyncPsgList.[0].PassengerInfo.CostList.[0].costCenterName','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1967473692183358464;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1966762792988292096,' ','1',' ',' ','如果账号重复，默认false-提示重复，true-不提示重复直接按美亚默认旅客编号创建',' ',1967473692183358464,'1',{ts'2024-06-07  00:00:00'},' ',{ts'2024-06-11  00:00:00'},'true',2,'2','SyncPsgList.[0].isCreateLoginDefault','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1967473692183358465;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1966762792988292096,' ','1',' ',' ','是否创建登录账号,初始化创建账号则true',' ',1967473692183358465,'1',{ts'2024-06-07  00:00:00'},' ',{ts'2024-06-11  00:00:00'},'false',3,'2','SyncPsgList.[0].isCreateLoginUser','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1967473692183358466;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1966762792988292096,' ','1',' ',' ','调离职； true = 调为离职； false = 调为在职',' ',1967473692183358466,'1',{ts'2024-06-07  00:00:00'},' ',{ts'2024-06-11  00:00:00'},'IF( enable = ''0''   OR isforbidden,true,false)',4,'3','SyncPsgList.[0].isLeave','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1967473692183358467;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1966762792988292096,' ','1',' ','单据头.工号','对接方系统的旅客编号',' ',1967473692183358467,'1',{ts'2024-06-07  00:00:00'},'number',{ts'2024-06-11  00:00:00'},' ',5,'1','SyncPsgList.[0].PassengerInfo.outsidePassengerId','1');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1967473692183358468;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1966762792988292096,' ','1',' ','单据头.姓名','乘机人姓名',' ',1967473692183358468,'1',{ts'2024-06-07  00:00:00'},'name',{ts'2024-06-13  00:00:00'},' ',6,'1','SyncPsgList.[0].PassengerInfo.passengerName','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1966773382733472768;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1966762792988292096,' ','1',' ','单据头.id','sessionId,login接口返回',' ',1966773382733472768,'1',{ts'2024-06-06  00:00:00'},' ',{ts'2024-06-13  00:00:00'},'kd.fi.er.business.trip.v2.plugin.mtrip.MTripPlugin#getSessionId',1,'4','sessionId','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1967473692183358473;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1966762792988292096,' ','1',' ','单据头.bos_user','部门名称',' ',1967473692183358473,'1',{ts'2024-06-07  00:00:00'},' ',{ts'2024-06-14  00:00:00'},'kd.fi.er.business.trip.v2.plugin.mtrip.MTripPlugin#getUserDeptLongName',11,'4','SyncPsgList.[0].PassengerInfo.dName','0');
DELETE FROM T_ER_TRIP_IGNOREEXENTRY WHERE FENTRYID = 1967308024825948160;
INSERT INTO T_ER_TRIP_IGNOREEXENTRY(FID,FEXDESC,FEXISDEFAULT,FEXNUMBER,FEXCREATETIME,FEXFIELD,FENTRYID,FEXSTATUS,FSEQ,FEXMODIFYTIME) VALUES (1966762792988292096,' ','1','10000',{ts'2024-06-07  00:00:00'},'code',1967308024825948160,'1',1,{ts'2024-06-07  00:00:00'});

DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 1970436938532176896;
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 (1970436938532176896,1966138761855480832,'{
	"code":"10000",
	"userInfoList":[
		{
			"companyId":"S118022",
			"password":"",
			"OutsidePassengerId":"ak10002",
			"DepName":"研发中心",
			"sessionId":"181290f79eab44fd90a1ee6145264ffd202310110937265250OA",
			"userName":"ak_LiuZhanChao",
			"userId":"P258456",
			"DId":100086
		}
	],
	"description":"请求成功",
	"failList":[
		{
			"passengerName":"刘展超",
			"companyId":"S118022",
			"description":"旅客英文名格式不正确，请修正",
			"outsidePassengerId":"ak10002"
		}
	]
}','http://api.shinetour.com/API.svc/SyncPsgInfoNew','1',1970436938532176896,'POST','C','M_SyncUser_ByOrg','美亚-人员同步-按组织',' ','已录入参数',{ts'2024-06-11  00:00:00'},'push','1',1879091968009578496,'bos_user',{ts'2024-06-14  00:00:00'},' ','kd.fi.er.business.trip.v2.server.mytrip.MTripSyncUserInvoke#execute',1879091968009578496,'已录入参数');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '4605O9BAIEE5';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1970436938532176896,'4605O9BAIEE5','zh_CN','美亚-人员同步-按组织');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1970436938641228800;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1970436938532176896,'>=',' ',' ',1970436938641228800,' ',' ','1',{ts'2024-06-11  00:00:00'},{ts'2024-06-11  00:00:00'},'modifytime','单据头.修改时间',1,'1','and','kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getValueByParams');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1970436938641228801;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1970436938532176896,'in',' ',' ',1970436938641228801,' ',' ','1',{ts'2024-06-11  00:00:00'},{ts'2024-06-11  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 = 1970436938641228802;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1970436938532176896,'=',' ',' ',1970436938641228802,'1',' ','1',{ts'2024-06-11  00:00:00'},{ts'2024-06-11  00:00:00'},'pageSize',' ',3,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1970436938641228803;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1970436938532176896,'in',' ',' ',1970436938641228803,'1',' ','1',{ts'2024-06-11  00:00:00'},{ts'2024-06-11  00:00:00'},'usertypes.id',' ',4,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1970436938641228804;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1970436938532176896,'is not null',' ',' ',1970436938641228804,' ',' ','1',{ts'2024-06-11  00:00:00'},{ts'2024-06-11  00:00:00'},'number',' ',5,'1','and',' ');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1970436938641355778;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1970436938532176896,' ','1',' ','单据头.id','sessionId,login接口返回',' ',1970436938641355778,'1',{ts'2024-06-11  00:00:00'},' ',{ts'2024-06-11  00:00:00'},'kd.fi.er.business.trip.v2.plugin.mtrip.MTripPlugin#getSessionId',1,'4','sessionId','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1970436938641355779;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1970436938532176896,' ','1',' ',' ','如果账号重复，默认false-提示重复，true-不提示重复直接按美亚默认旅客编号创建',' ',1970436938641355779,'1',{ts'2024-06-11  00:00:00'},' ',{ts'2024-06-11  00:00:00'},'true',2,'2','SyncPsgList.[0].isCreateLoginDefault','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1970436938641355780;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1970436938532176896,' ','1',' ',' ','是否创建登录账号,初始化创建账号则true',' ',1970436938641355780,'1',{ts'2024-06-11  00:00:00'},' ',{ts'2024-06-11  00:00:00'},'false',3,'2','SyncPsgList.[0].isCreateLoginUser','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1970436938641355781;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1970436938532176896,' ','1',' ',' ','调离职； true = 调为离职； false = 调为在职',' ',1970436938641355781,'1',{ts'2024-06-11  00:00:00'},' ',{ts'2024-06-11  00:00:00'},'IF( enable = ''0''   OR isforbidden,true,false)',4,'3','SyncPsgList.[0].isLeave','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1970436938641355782;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1970436938532176896,' ','1',' ','单据头.工号','对接方系统的旅客编号',' ',1970436938641355782,'1',{ts'2024-06-11  00:00:00'},'number',{ts'2024-06-11  00:00:00'},' ',5,'1','SyncPsgList.[0].PassengerInfo.outsidePassengerId','1');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1970436938641355783;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1970436938532176896,' ','1',' ','单据头.姓名','乘机人姓名',' ',1970436938641355783,'1',{ts'2024-06-11  00:00:00'},'name',{ts'2024-06-11  00:00:00'},' ',6,'1','SyncPsgList.[0].PassengerInfo.passengerName','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1970436938641355784;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1970436938532176896,' ','1',' ',' ','旅客类型:成人/儿童/婴儿',' ',1970436938641355784,'1',{ts'2024-06-11  00:00:00'},' ',{ts'2024-06-11  00:00:00'},'成人',7,'2','SyncPsgList.[0].PassengerInfo.passengerType','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1970436938641355785;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1970436938532176896,' ','1',' ',' ','公司编码',' ',1970436938641355785,'1',{ts'2024-06-11  00:00:00'},' ',{ts'2024-06-11  00:00:00'},'kd.fi.er.business.trip.v2.plugin.mtrip.MTripPlugin#getCompanyId',8,'4','SyncPsgList.[0].PassengerInfo.companyId','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1970436938641355786;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1970436938532176896,' ','1',' ',' ','性别:男/女；',' ',1970436938641355786,'1',{ts'2024-06-11  00:00:00'},' ',{ts'2024-06-11  00:00:00'},'IF(gender = ''2'',''女'',''男'')',9,'3','SyncPsgList.[0].PassengerInfo.sex','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1970436938641355787;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1970436938532176896,' ','1',' ','单据头.姓名','中文姓名',' ',1970436938641355787,'1',{ts'2024-06-11  00:00:00'},'name',{ts'2024-06-11  00:00:00'},' ',10,'1','SyncPsgList.[0].PassengerInfo.cnName','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1970436938641355789;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1970436938532176896,' ','1',' ','单据头.id','国籍：中国填写 CN',' ',1970436938641355789,'1',{ts'2024-06-11  00:00:00'},'country.id',{ts'2024-06-11  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OtherFieldCommonPlugin#getTwoCountryCode',12,'4','SyncPsgList.[0].PassengerInfo.nationality','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1970436938641355790;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1970436938532176896,' ','1',' ','单据头.手机','手机号码',' ',1970436938641355790,'1',{ts'2024-06-11  00:00:00'},'phone',{ts'2024-06-11  00:00:00'},' ',13,'1','SyncPsgList.[0].PassengerInfo.mobile','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1970436938641355791;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1970436938532176896,' ','1',' ',' ','职称ID;',' ',1970436938641355791,'1',{ts'2024-06-11  00:00:00'},' ',{ts'2024-06-11  00:00:00'},'kd.fi.er.business.trip.v2.plugin.mtrip.MTripPlugin#getPositionLevelName',14,'4','SyncPsgList.[0].PassengerInfo.holderId','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1970436938641355792;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1970436938532176896,' ','1',' ',' ','成本中心名称',' ',1970436938641355792,'1',{ts'2024-06-11  00:00:00'},' ',{ts'2024-06-11  00:00:00'},'kd.fi.er.business.trip.v2.plugin.mtrip.MTripPlugin#getCostCenterName',15,'4','SyncPsgList.[0].PassengerInfo.CostList.[0].costCenterName','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1970436938641355788;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1970436938532176896,' ','1',' ','单据头.bos_user','部门名称',' ',1970436938641355788,'1',{ts'2024-06-11  00:00:00'},' ',{ts'2024-06-14  00:00:00'},'kd.fi.er.business.trip.v2.plugin.mtrip.MTripPlugin#getUserDeptLongName',11,'4','SyncPsgList.[0].PassengerInfo.dName','0');
DELETE FROM T_ER_TRIP_IGNOREEXENTRY WHERE FENTRYID = 1970436938641228805;
INSERT INTO T_ER_TRIP_IGNOREEXENTRY(FID,FEXDESC,FEXISDEFAULT,FEXNUMBER,FEXCREATETIME,FEXFIELD,FENTRYID,FEXSTATUS,FSEQ,FEXMODIFYTIME) VALUES (1970436938532176896,' ','1','10000',{ts'2024-06-11  00:00:00'},'code',1970436938641228805,'1',1,{ts'2024-06-11  00:00:00'});
