delete from t_er_trip_fieldmapping where fid in (1722659154818297856,1722533640959084544,1723224314289243136,1723116565907792896,1726230772362271744);
delete from t_er_trip_fieldmapping_l where fid in (1722659154818297856,1722533640959084544,1723224314289243136,1723116565907792896,1726230772362271744);
delete from t_er_trip_queryentry where fid in (1722659154818297856,1722533640959084544,1723224314289243136,1723116565907792896,1726230772362271744);
delete from t_er_trip_filterentry where fid in (1722659154818297856,1722533640959084544,1723224314289243136,1723116565907792896,1726230772362271744);
delete from t_er_trip_fieldmapentry where fid in (1722659154818297856,1722533640959084544,1723224314289243136,1723116565907792896,1726230772362271744);
delete from t_er_trip_ignoreexentry where fid in (1722659154818297856,1722533640959084544,1723224314289243136,1723116565907792896,1726230772362271744);

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 (1723116565907792896,721690360459303936,'{
	"errcode":"0",
	"data":{
		"access_token":"aa8a8a83-b997-4806-a7fe-4c7134356e90",
		"expires_in":"86400"
	},
	"errmsg":"成功"
}','https://openapi.517la.com/api/token/getToken','1',1723116565907792896,'POST','C','T_Token','差旅壹号Token',' ','已录入参数',{ts'2023-07-06  00:00:00'},'push','1',1231170494321995776,'er_biz_info',{ts'2023-07-06  00:00:00'},'{
	"data":{
		"appid":"20224595956565777",
		"appsecret":"202245957778secret"
	},
	"requestid":"20220923112955089",
	"version":"0.0.1"
}','kd.fi.er.business.trip.v2.function.PushInvoke#execute',1231170494321995776,'已录入参数');
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 (1723224314289243136,721690360459303936,'{
	"errcode":"0",
	"data":{
		"applyNo":"23070516085117600099sq1738",
		"thirdApplyNo":"202307030007111XXX12"
	},
	"requestid":"20180616112955089",
	"success":true,
	"errmsg":"成功"
}','https://openapi.517la.com/api/approval/revokeMeetingOrEntertainApply','1',1723224314289243136,'POST','C','T_UnauditMettOrEntertain','差旅壹号-招待费/会议费反审核',' ','已录入参数',{ts'2023-07-06  00:00:00'},'push','1',1231170494321995776,'er_dailyapplybill',{ts'2023-07-07  00:00:00'},'{
	"access_token":"c5363a4a-2e3b-4bb6-b373-9ac41a91dff7",
	"data":{
		"revokeReason":"string",
		"staffinfo":{
			"staffCode":"yongjia",
			"staffName":"蓝浅"
		},
		"revokeTime":"2023-06-30T08:52:32.171Z",
		"applyFormType":2,
		"thirdApplyNo":"2023070100004"
	},
	"requestid":"20180616112955089",
	"version":"0.0.1"
}','kd.fi.er.business.trip.v2.function.PushInvoke#execute',1231170494321995776,'已录入参数');
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 (1722533640959084544,721690360459303936,'{
	"errcode":"0",
	"data":{
		"applyNo":"23070516085117600099sq1738",
		"thirdApplyNo":"202307030007111XXX12"
	},
	"requestid":"20180616112955089",
	"success":true,
	"errmsg":"成功"
}','https://openapi.517la.com/api/approval/addMeetingApply','1',1722533640959084544,'POST','C','T_MettingApply','差旅壹号-会议费申请单新增同步','1','已录入参数',{ts'2023-07-05  00:00:00'},'push','1',1231170494321995776,'er_dailyapplybill',{ts'2023-07-07  00:00:00'},'{
	"access_token":"b80f00c0-7b7e-4949-b987-7f0ce63611a9",
	"data":{
		"submitStaffName":"煜月",
		"orderStaffs":[
			{
				"staffCode":"132132132",
				"staffName":"煜月"
			}
		],
		"remark":"",
		"meetingSubject":"测试会议",
		"meetingType":0,
		"meetingLevel":1,
		"thirdApplyNo":"202306200001",
		"applyAmount":4000,
		"applyLocalCurrencyAmount":"",
		"meetingName":"测试会议",
		"LeaveTime":"18:30",
		"exchangeRate":0,
		"meetingCity":{
			"area":"海淀区",
			"address":"XXXXXX",
			"province":"北京市",
			"city":"北京市",
			"cityCode":"010"
		},
		"peopleCount":2,
		"applyStaffName":"煜月",
		"paymentAllocationDetail":[
			{
				"costCenterCode":"2023NFNKXQCPTYF",
				"profitCenterId":"",
				"payingDepartmentName":"",
				"supplierId":"",
				"customerCode":"",
				"expenseTypeCode":"",
				"budgetProjectName":"",
				"supplierCode":"",
				"corpOrgnazationCode":"",
				"profitCenterName":"",
				"settlementUnitName":"",
				"budgetProjectCode":"",
				"expenseAmount":4000,
				"dutyCenterId":"",
				"costCenterId":"",
				"projectCode":"",
				"expenseRate":1,
				"customerId":"",
				"dutyCenterName":"",
				"payingDepartmentId":"",
				"expenseStaffCode":"",
				"supplierName":"",
				"staffCode":"132132132",
				"expenseStaffName":"",
				"expenseTypeName":"",
				"payingDepartmentCode":"",
				"profitCenterCode":"",
				"businessOpportunity":"",
				"customerName":"",
				"dutyCenterCode":"",
				"corpOrgnazationId":"",
				"businessOpportunityId":"",
				"businessOpportunityCode":"",
				"corpOrgnazationName":"",
				"costCenterName":"技术部",
				"expenseTypeId":"",
				"projectName":"",
				"expenseStaffId":"",
				"projectId":"",
				"settlementUnitCode":""
			}
		],
		"applyStaffCode":"132132132",
		"currency":0,
		"beginTime":"2023-06-26 00:00:00",
		"endTime":"2023-06-30 23:59:59",
		"submitStaffCode":"132132132",
		"paymentRangeDetail":[
			{
				"costSubjectCode":"zs",
				"costSubjectName":"住宿费",
				"applyAmount":2000
			},
			{
				"costSubjectCode":"jt",
				"costSubjectName":"交通费",
				"applyAmount":2000
			}
		],
		"CheckInTime":"08:00",
		"lastingDay":5
	},
	"requestid":"20180616112955089",
	"version":"0.0.1"
}','kd.fi.er.business.trip.v2.function.PushInvoke#execute',1231170494321995776,'已录入参数');
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 (1722659154818297856,721690360459303936,'{
	"errcode":"0",
	"data":{
		"applyNo":"23070516085117600099sq1738",
		"thirdApplyNo":"202307030007111XXX12"
	},
	"requestid":"20180616112955089",
	"success":true,
	"errmsg":"成功"
}','https://openapi.517la.com/api/approval/addEntertainApply','1',1722659154818297856,'POST','C','T_EntertainApply','差旅壹号-招待费申请单新增同步','1','已录入参数',{ts'2023-07-05  00:00:00'},'push','1',1231170494321995776,'er_dailyapplybill',{ts'2023-07-07  00:00:00'},'{
	"access_token":"c5363a4a-2e3b-4bb6-b373-9ac41a91dff7",
	"data":{
		"submitStaffName":"蓝浅",
		"isSpecialApproved":0,
		"hotelRoomCount":0,
		"consumeCity":{
			"area":"雨城区",
			"province":"四川省",
			"city":"雅安市"
		},
		"giftCount":0,
		"accompanyPeopleCount":3,
		"remark":"",
		"thirdApplyNo":"2023070100004",
		"applyAmount":1000,
		"hotelStandardAmount":0,
		"exchangeRate":0,
		"applyStaffCode":"yongjia",
		"treatType":0,
		"currency":"",
		"paymentRangeDetail":[
			{
				"costSubjectCode":"0000",
				"costSubjectName":"住宿费",
				"applyAmount":1000
			}
		],
		"mealStandardAmount":0,
		"applyReason":"招待费撤销测试070104",
		"cityLevel":1,
		"orderStaffs":[
			{
				"staffCode":"yongjia",
				"staffName":"蓝浅"
			}
		],
		"planDate":"2023-07-28 00:00:00",
		"treatLevel":"0",
		"applyLocalCurrencyAmount":0,
		"giftStandardAmount":0,
		"treatPeopleCount":2,
		"hostStaffs":"甲乙",
		"applyStaffName":"蓝浅",
		"paymentAllocationDetail":[
			{
				"costCenterCode":"2023NFNKXQCPTYF",
				"profitCenterId":"",
				"payingDepartmentName":"",
				"supplierId":"",
				"customerCode":"",
				"expenseTypeCode":"",
				"budgetProjectName":"",
				"supplierCode":"",
				"expensePercent":1,
				"corpOrgnazationCode":"",
				"profitCenterName":"",
				"settlementUnitName":"",
				"budgetProjectCode":"",
				"expenseAmount":0,
				"dutyCenterId":"",
				"costCenterId":"",
				"projectCode":"",
				"expenseRate":0,
				"customerId":"",
				"dutyCenterName":"",
				"payingDepartmentId":"",
				"expenseStaffCode":"",
				"supplierName":"",
				"amount":1000,
				"staffCode":"",
				"expenseStaffName":"",
				"expenseTypeName":"",
				"payingDepartmentCode":"",
				"profitCenterCode":"",
				"businessOpportunity":"",
				"customerName":"",
				"dutyCenterCode":"",
				"corpOrgnazationId":"",
				"businessOpportunityId":"",
				"businessOpportunityCode":"",
				"corpOrgnazationName":"",
				"costCenterName":"技术部",
				"expenseTypeId":"",
				"projectName":"",
				"expenseStaffId":"",
				"projectId":"",
				"settlementUnitCode":""
			}
		],
		"standardPerCapita":200,
		"submitStaffCode":"yongjia"
	},
	"requestid":"20180616112955089",
	"version":"0.0.1"
}','kd.fi.er.business.trip.v2.function.PushInvoke#execute',1231170494321995776,'已录入参数');
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 (1726230772362271744,721690360459303936,'{
	"errcode":"0",
	"data":{
		"applyNo":"23071016395029370199sq8000",
		"thirdApplyNo":"FYSQ-230710-000002"
	},
	"hasNextPage":null,
	"requestid":"1688978389644",
	"success":true,
	"errmsg":"成功",
	"successful":true
}','https://openapi.517la.com/api/approval/validMeetingOrEntertainApply','1',1726230772362271744,'POST','C','T_UpdateMeetOrEntertain','差旅壹号-招待费/会议费更新状态','2','已录入参数',{ts'2023-07-10  00:00:00'},'push','1',1231170494321995776,'er_dailyapplybill',{ts'2023-07-11  00:00:00'},'{
	"access_token":"c5363a4a-2e3b-4bb6-b373-9ac41a91dff7",
	"data":{
		"staffinfo":{
			"staffCode":"yongjia",
			"staffName":"蓝浅"
		},
		"validReason":"关闭原因",
		"validStatus":1,
		"validTime":"2023-06-30T08:52:32.171Z",
		"applyFormType":2,
		"thirdApplyNo":"2023070100004"
	},
	"requestid":"20180616112955089",
	"version":"0.0.1"
}','kd.fi.er.business.trip.v2.function.PushInvoke#execute',1231170494321995776,'已录入参数');


INSERT INTO t_er_trip_fieldmapping_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1723116565907792896,'3DN9XYO7YU+/','zh_CN','差旅壹号Token');
INSERT INTO t_er_trip_fieldmapping_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1723116565907792896,'3DN9XYO7YU+0','zh_TW','差旅壹號Token');
INSERT INTO t_er_trip_fieldmapping_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1722533640959084544,'3DKH/5TJQR4U','zh_CN','差旅壹号-会议费申请单新增同步');
INSERT INTO t_er_trip_fieldmapping_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1722533640959084544,'3DKH/5TJQR4V','zh_TW','差旅壹號-會議費申請單新增同步');
INSERT INTO t_er_trip_fieldmapping_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1722659154818297856,'3DL2FSTK6SGU','zh_CN','差旅壹号-招待费申请单新增同步');
INSERT INTO t_er_trip_fieldmapping_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1722659154818297856,'3DL2FSTK6SGV','zh_TW','差旅壹號-招待費申請單新增同步');
INSERT INTO t_er_trip_fieldmapping_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1723224314289243136,'3DNT12XL3M86','zh_CN','差旅壹号-招待费/会议费反审核');
INSERT INTO t_er_trip_fieldmapping_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1723224314289243136,'3DNT12XL3M87','zh_TW','差旅壹號-招待費/會議費反審核');
INSERT INTO t_er_trip_fieldmapping_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1726230772362271744,'3E06T346KS6K','zh_CN','差旅壹号-招待费/会议费更新状态');
INSERT INTO t_er_trip_fieldmapping_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1726230772362271744,'3E06T346KS6L','zh_TW','差旅壹號-招待費/會議費更新狀態');


INSERT INTO t_er_trip_queryentry(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1722659154818297856,'=',' ',' ',1722659154860240898,'entertainment',' ','1',{ts'2023-07-05  00:00:00'},{ts'2023-07-05  00:00:00'},'reimbursetype','单据头.申请类型',3,'1','and',' ');
INSERT INTO t_er_trip_queryentry(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1723116565907792896,'=',' ',' ',1723116566436275200,'CHAILVYIHAO',' ','1',{ts'2023-07-06  00:00:00'},{ts'2023-07-06  00:00:00'},'number','单据头.编号',1,'1','and',' ');
INSERT INTO t_er_trip_queryentry(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1723116565907792896,'=',' ',' ',1723116566436275201,'1',' ','1',{ts'2023-07-06  00:00:00'},{ts'2023-07-06  00:00:00'},'enable','单据头.使用状态',2,'1','and',' ');
INSERT INTO t_er_trip_queryentry(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1722533640959084544,'=',' ',' ',1722555337816852480,'E',' ','1',{ts'2023-07-05  00:00:00'},{ts'2023-07-06  00:00:00'},'billstatus','单据头.单据状态',2,'1','and',' ');
INSERT INTO t_er_trip_queryentry(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1722533640959084544,'=',' ',' ',1722555337816852481,'meetting',' ','1',{ts'2023-07-05  00:00:00'},{ts'2023-07-06  00:00:00'},'reimbursetype','单据头.申请类型',3,'1','and',' ');
INSERT INTO t_er_trip_queryentry(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1722533640959084544,'=',' ',' ',1722533641269463040,' ',' ','1',{ts'2023-07-05  00:00:00'},{ts'2023-07-06  00:00:00'},'billno','单据头.单据编号',1,'1','and','kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getValueByParams');
INSERT INTO t_er_trip_queryentry(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1722659154818297856,'=',' ',' ',1722659154860240896,' ',' ','1',{ts'2023-07-05  00:00:00'},{ts'2023-07-06  00:00:00'},'billno',' ',1,'1','and','kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getValueByParams');
INSERT INTO t_er_trip_queryentry(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1722659154818297856,'=',' ',' ',1722659154860240897,'E',' ','1',{ts'2023-07-05  00:00:00'},{ts'2023-07-06  00:00:00'},'billstatus','单据头.单据状态',2,'1','and',' ');
INSERT INTO t_er_trip_queryentry(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1723224314289243136,'=',' ',' ',1723224314733839360,' ',' ','1',{ts'2023-07-06  00:00:00'},{ts'2023-07-06  00:00:00'},'billno','单据头.单据编号',1,'1','and','kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getValueByParams');
INSERT INTO t_er_trip_queryentry(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1723224314289243136,'=',' ',' ',1723224314733839361,'E',' ','1',{ts'2023-07-06  00:00:00'},{ts'2023-07-06  00:00:00'},'billstatus','单据头.单据状态',2,'1','and',' ');
INSERT INTO t_er_trip_queryentry(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1723224314289243136,'in',' ',' ',1723224314733839362,'meetting,entertainment',' ','1',{ts'2023-07-06  00:00:00'},{ts'2023-07-06  00:00:00'},'reimbursetype','单据头.申请类型',3,'1','and',' ');
INSERT INTO t_er_trip_queryentry(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1726230772362271744,'in',' ',' ',1726230772404214785,'meetting,entertainment',' ','1',{ts'2023-07-10  00:00:00'},{ts'2023-07-10  00:00:00'},'reimbursetype','单据头.申请类型',2,'1','and',' ');
INSERT INTO t_er_trip_queryentry(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1726230772362271744,'=',' ',' ',1726230772404214784,' ',' ','1',{ts'2023-07-10  00:00:00'},{ts'2023-07-11  00:00:00'},'billno','单据头.单据编号',1,'1','and','kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getValueByParams');

INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1723116565907792896,' ','1',' ','单据头.接入appkey',' ',' ',1723116566436299778,'1',{ts'2023-07-06  00:00:00'},'appkey',{ts'2023-07-06  00:00:00'},' ',1,'1','data.appid','1');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1723116565907792896,' ','1',' ','单据头.接入app秘钥',' ',' ',1723116566436299779,'1',{ts'2023-07-06  00:00:00'},'appsecurity',{ts'2023-07-06  00:00:00'},' ',2,'1','data.appsecret','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1723116565907792896,' ','1',' ',' ',' ',' ',1723116566436299780,'1',{ts'2023-07-06  00:00:00'},' ',{ts'2023-07-06  00:00:00'},'kd.fi.er.business.trip.v2.plugin.TimePlugin#getNowTime',3,'4','requestid','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1723116565907792896,' ','1',' ',' ',' ',' ',1723116566436299781,'1',{ts'2023-07-06  00:00:00'},' ',{ts'2023-07-06  00:00:00'},'0.01',4,'2','version','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1723224314289243136,' ','1',' ','单据头.单据编号',' ',' ',1723224314733814786,'1',{ts'2023-07-06  00:00:00'},'billno',{ts'2023-07-06  00:00:00'},' ',1,'1','data.thirdApplyNo','1');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1723224314289243136,' ','1',' ','单据头.申请类型',' ',' ',1723224314733814787,'1',{ts'2023-07-06  00:00:00'},' ',{ts'2023-07-06  00:00:00'},'IF(reimbursetype = ''meetting'',1,2)',2,'3','data.applyFormType','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1723224314289243136,' ','1',' ','单据头.申请类型',' ',' ',1723224314733814790,'1',{ts'2023-07-06  00:00:00'},'reimbursetype',{ts'2023-07-06  00:00:00'},'kd.fi.er.business.trip.supplier.travelno1.systemexternal.TravelNoOneSync#getFieldMappingCacheToken',5,'4','access_token','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1723224314289243136,' ','1',' ',' ',' ',' ',1723224314733814791,'1',{ts'2023-07-06  00:00:00'},' ',{ts'2023-07-06  00:00:00'},'kd.fi.er.business.trip.v2.plugin.TimePlugin#getNowTime',6,'4','requestid','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1723224314289243136,' ','1',' ',' ',' ',' ',1723224314733814792,'1',{ts'2023-07-06  00:00:00'},' ',{ts'2023-07-06  00:00:00'},'0.01',7,'2','version','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1723224314289243136,' ','1',' ','单据头.反审核意见',' ',' ',1723245876820030464,'1',{ts'2023-07-06  00:00:00'},'unauditmsg',{ts'2023-07-06  00:00:00'},'kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getValueByParams',8,'4','data.revokeReason','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1723224314289243136,' ','1',' ',' ',' ',' ',1723224314733814788,'1',{ts'2023-07-06  00:00:00'},' ',{ts'2023-07-06  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserNumber',3,'4','data.staffinfo.staffCode','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1723224314289243136,' ','1',' ',' ',' ',' ',1723224314733814789,'1',{ts'2023-07-06  00:00:00'},' ',{ts'2023-07-06  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserName',4,'4','data.staffinfo.staffName','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1723224314289243136,' ','1',' ',' ',' ',' ',1723245876820030465,'1',{ts'2023-07-06  00:00:00'},' ',{ts'2023-07-07  00:00:00'},'kd.fi.er.business.trip.v2.plugin.TimePlugin#getNowData',9,'4','data.revokeTime','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722659154818297856,' ','1',' ','单据头.单据编号',' ',' ',1722659154860362755,'1',{ts'2023-07-05  00:00:00'},'billno',{ts'2023-07-05  00:00:00'},' ',2,'1','data.thirdApplyNo','1');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722659154818297856,' ','1',' ','费用明细.费用发生日期',' ',' ',1722659154860362756,'1',{ts'2023-07-05  00:00:00'},'expenseentryentity.happendate',{ts'2023-07-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.dailyapply.DailyApplyBillPlugin#getBeginTime',3,'4','data.planDate','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722659154818297856,' ','1',' ','单据头.核定金额',' ',' ',1722659154860362757,'1',{ts'2023-07-05  00:00:00'},'approveamount',{ts'2023-07-05  00:00:00'},' ',4,'1','data.applyAmount','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722659154818297856,' ','1',' ','单据头.核定金额',' ',' ',1722659154860362758,'1',{ts'2023-07-05  00:00:00'},'approveamount',{ts'2023-07-05  00:00:00'},' ',5,'1','data.applyLocalCurrencyAmount','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722659154818297856,' ','1',' ','number',' ',' ',1722659154860362759,'1',{ts'2023-07-05  00:00:00'},'creator.number',{ts'2023-07-05  00:00:00'},' ',6,'1','data.submitStaffCode','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722659154818297856,' ','1',' ','name',' ',' ',1722659154860362760,'1',{ts'2023-07-05  00:00:00'},'creator.name',{ts'2023-07-05  00:00:00'},' ',7,'1','data.submitStaffName','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722659154818297856,' ','1',' ',' ',' ',' ',1722659154860362761,'1',{ts'2023-07-05  00:00:00'},' ',{ts'2023-07-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.dailyapply.DailyApplyBillPlugin#getOrderStaffs',8,'4','data.orderStaffs.[0]','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722659154818297856,' ','1',' ','单据头.id',' ',' ',1722659154860362762,'1',{ts'2023-07-05  00:00:00'},'costcompany.id',{ts'2023-07-05  00:00:00'},' ',9,'1','data.paymentAllocationDetail.[0].settlementUnitCode','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722659154818297856,' ','1',' ','name',' ',' ',1722659154860362763,'1',{ts'2023-07-05  00:00:00'},'costcompany.name',{ts'2023-07-05  00:00:00'},' ',10,'1','data.paymentAllocationDetail.[0].settlementUnitName','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722659154818297856,' ','1',' ','单据头.id',' ',' ',1722659154860362764,'1',{ts'2023-07-05  00:00:00'},'costdept.id',{ts'2023-07-05  00:00:00'},' ',11,'1','data.paymentAllocationDetail.[0].corpOrgnazationCode','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722659154818297856,' ','1',' ','name',' ',' ',1722659154860362765,'1',{ts'2023-07-05  00:00:00'},'costdept.name',{ts'2023-07-05  00:00:00'},' ',12,'1','data.paymentAllocationDetail.[0].corpOrgnazationName','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722659154818297856,' ','1',' ','单据头.核定金额',' ',' ',1722659154860362766,'1',{ts'2023-07-05  00:00:00'},'approveamount',{ts'2023-07-05  00:00:00'},' ',13,'1','data.paymentAllocationDetail.[0].expenseAmount','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722659154818297856,' ','1',' ','单据头.申请类型',' ',' ',1722659154860362754,'1',{ts'2023-07-05  00:00:00'},'reimbursetype',{ts'2023-07-06  00:00:00'},'kd.fi.er.business.trip.supplier.travelno1.systemexternal.TravelNoOneSync#getFieldMappingCacheToken',1,'4','access_token','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722659154818297856,' ','1',' ',' ',' ',' ',1724034511869698048,'1',{ts'2023-07-07  00:00:00'},' ',{ts'2023-07-07  00:00:00'},'kd.fi.er.business.trip.v2.plugin.TimePlugin#getNowTime',16,'4','requestid','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722659154818297856,' ','1',' ',' ',' ',' ',1724034511869698049,'1',{ts'2023-07-07  00:00:00'},' ',{ts'2023-07-07  00:00:00'},'0.01',17,'2','version','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722659154818297856,' ','1',' ','number','申请人姓名',' ',1726014487162543104,'1',{ts'2023-07-10  00:00:00'},'applier.number',{ts'2023-07-10  00:00:00'},' ',14,'1','data.applyStaffCode','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722659154818297856,' ','1',' ','name','申请人工号',' ',1726014487162543105,'1',{ts'2023-07-10  00:00:00'},'applier.name',{ts'2023-07-10  00:00:00'},' ',15,'1','data.applyStaffName','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722533640959084544,' ','1',' ','单据头.单据编号',' ',' ',1722533641269338115,'1',{ts'2023-07-05  00:00:00'},'billno',{ts'2023-07-05  00:00:00'},' ',2,'1','data.thirdApplyNo','1');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722533640959084544,' ','1',' ','费用明细.费用发生日期',' ',' ',1722555337816727552,'1',{ts'2023-07-05  00:00:00'},'expenseentryentity.happendate',{ts'2023-07-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.dailyapply.DailyApplyBillPlugin#getBeginTime',3,'4','data.beginTime','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722533640959084544,' ','1',' ','费用明细.费用发生日期',' ',' ',1722573108218748928,'1',{ts'2023-07-05  00:00:00'},'expenseentryentity.happendate',{ts'2023-07-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.dailyapply.DailyApplyBillPlugin#getEndTime',4,'4','data.endTime','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722533640959084544,' ','1',' ','单据头.核定金额',' ',' ',1722628428999653376,'1',{ts'2023-07-05  00:00:00'},'approveamount',{ts'2023-07-05  00:00:00'},' ',5,'1','data.applyAmount','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722533640959084544,' ','1',' ','单据头.核定金额',' ',' ',1722628428999653377,'1',{ts'2023-07-05  00:00:00'},'approveamount',{ts'2023-07-05  00:00:00'},' ',6,'1','data.applyLocalCurrencyAmount','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722533640959084544,' ','1',' ','number',' ',' ',1722628428999653378,'1',{ts'2023-07-05  00:00:00'},'creator.number',{ts'2023-07-05  00:00:00'},' ',7,'1','data.submitStaffCode','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722533640959084544,' ','1',' ','name',' ',' ',1722628428999653379,'1',{ts'2023-07-05  00:00:00'},'creator.name',{ts'2023-07-05  00:00:00'},' ',8,'1','data.submitStaffName','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722533640959084544,' ','1',' ',' ',' ',' ',1722628428999653381,'1',{ts'2023-07-05  00:00:00'},' ',{ts'2023-07-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.dailyapply.DailyApplyBillPlugin#getOrderStaffs',9,'4','data.orderStaffs.[0]','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722533640959084544,' ','1',' ','单据头.id',' ',' ',1722645088045428736,'1',{ts'2023-07-05  00:00:00'},'costcompany.id',{ts'2023-07-05  00:00:00'},' ',10,'1','data.paymentAllocationDetail.[0].settlementUnitCode','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722533640959084544,' ','1',' ','name',' ',' ',1722645088045428737,'1',{ts'2023-07-05  00:00:00'},'costcompany.name',{ts'2023-07-05  00:00:00'},' ',11,'1','data.paymentAllocationDetail.[0].settlementUnitName','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722533640959084544,' ','1',' ','单据头.id',' ',' ',1722645088045428738,'1',{ts'2023-07-05  00:00:00'},'costdept.id',{ts'2023-07-05  00:00:00'},' ',12,'1','data.paymentAllocationDetail.[0].costCenterCode','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722533640959084544,' ','1',' ','name',' ',' ',1722645088045428739,'1',{ts'2023-07-05  00:00:00'},'costdept.name',{ts'2023-07-05  00:00:00'},' ',13,'1','data.paymentAllocationDetail.[0].costCenterName','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722533640959084544,' ','1',' ','单据头.核定金额',' ',' ',1722645088045428740,'1',{ts'2023-07-05  00:00:00'},'approveamount',{ts'2023-07-05  00:00:00'},' ',14,'1','data.paymentAllocationDetail.[0].expenseAmount','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722533640959084544,' ','1',' ','单据头.申请类型',' ',' ',1722533641269338114,'1',{ts'2023-07-05  00:00:00'},'reimbursetype',{ts'2023-07-06  00:00:00'},'kd.fi.er.business.trip.supplier.travelno1.systemexternal.TravelNoOneSync#getFieldMappingCacheToken',1,'4','access_token','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722533640959084544,' ','1',' ',' ',' ',' ',1724034992990166016,'1',{ts'2023-07-07  00:00:00'},' ',{ts'2023-07-07  00:00:00'},'kd.fi.er.business.trip.v2.plugin.TimePlugin#getNowTime',17,'4','requestid','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722533640959084544,' ','1',' ',' ',' ',' ',1724034992990166017,'1',{ts'2023-07-07  00:00:00'},' ',{ts'2023-07-07  00:00:00'},'0.01',18,'2','version','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722533640959084544,' ','1',' ','number',' ',' ',1726017775815646208,'1',{ts'2023-07-10  00:00:00'},'applier.number',{ts'2023-07-10  00:00:00'},' ',15,'1','data.applyStaffCode','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1722533640959084544,' ','1',' ','name',' ',' ',1726017775815646209,'1',{ts'2023-07-10  00:00:00'},'applier.name',{ts'2023-07-10  00:00:00'},' ',16,'1','data.applyStaffName','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1726230772362271744,' ','1',' ',' ',' ',' ',1726915155201221632,'1',{ts'2023-07-11  00:00:00'},' ',{ts'2023-07-11  00:00:00'},'kd.fi.er.business.trip.v2.plugin.TimePlugin#getNowTime',7,'4','requestid','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1726230772362271744,' ','1',' ',' ',' ',' ',1726915155201221633,'1',{ts'2023-07-11  00:00:00'},' ',{ts'2023-07-11  00:00:00'},'0.01',8,'2','version','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1726230772362271744,' ','1',' ',' ',' ',' ',1748446234152513536,'1',{ts'2023-08-10  00:00:00'},' ',{ts'2023-08-10  00:00:00'},'kd.fi.er.business.trip.supplier.travelno1.systemexternal.TravelNoOneSync#getFieldMappingCacheToken',9,'4','access_token','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1726230772362271744,' ','1',' ','单据头.单据编号',' ',' ',1726230772404217858,'1',{ts'2023-07-10  00:00:00'},'billno',{ts'2023-07-10  00:00:00'},' ',1,'1','data.thirdApplyNo','1');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1726230772362271744,' ','1',' ',' ',' ',' ',1726230772404217859,'1',{ts'2023-07-10  00:00:00'},' ',{ts'2023-07-10  00:00:00'},'IF(reimbursetype = ''meetting'',1,2)',2,'3','data.applyFormType','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1726230772362271744,' ','1',' ',' ',' ',' ',1726230772404217860,'1',{ts'2023-07-10  00:00:00'},' ',{ts'2023-07-11  00:00:00'},'kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getJValueByParams',3,'4','data.validStatus','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1726230772362271744,' ','1',' ',' ',' ',' ',1726230772404217861,'1',{ts'2023-07-10  00:00:00'},' ',{ts'2023-07-10  00:00:00'},'kd.fi.er.business.trip.v2.plugin.TimePlugin#getNowData',4,'4','data.validTime','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1726230772362271744,' ','1',' ',' ',' ',' ',1726230772404217863,'1',{ts'2023-07-10  00:00:00'},' ',{ts'2023-07-11  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserNumber',5,'4','data.staffinfo.staffCode','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1726230772362271744,' ','1',' ',' ',' ',' ',1726230772404217864,'1',{ts'2023-07-10  00:00:00'},' ',{ts'2023-07-11  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserName',6,'4','data.staffinfo.staffName','0');


INSERT INTO t_er_trip_ignoreexentry(FID,FEXDESC,FEXISDEFAULT,FEXNUMBER,FEXCREATETIME,FEXFIELD,FENTRYID,FEXSTATUS,FSEQ,FEXMODIFYTIME) VALUES (1722533640959084544,' ','1','0',{ts'2023-07-05  00:00:00'},'errcode',1722645088045550592,'1',1,{ts'2023-07-05  00:00:00'});
INSERT INTO t_er_trip_ignoreexentry(FID,FEXDESC,FEXISDEFAULT,FEXNUMBER,FEXCREATETIME,FEXFIELD,FENTRYID,FEXSTATUS,FSEQ,FEXMODIFYTIME) VALUES (1722659154818297856,' ','1','0',{ts'2023-07-05  00:00:00'},'errcode',1722659154860240899,'1',1,{ts'2023-07-05  00:00:00'});
INSERT INTO t_er_trip_ignoreexentry(FID,FEXDESC,FEXISDEFAULT,FEXNUMBER,FEXCREATETIME,FEXFIELD,FENTRYID,FEXSTATUS,FSEQ,FEXMODIFYTIME) VALUES (1723116565907792896,' ','1','0',{ts'2023-07-06  00:00:00'},'errcode',1723116566436275202,'1',1,{ts'2023-07-06  00:00:00'});
INSERT INTO t_er_trip_ignoreexentry(FID,FEXDESC,FEXISDEFAULT,FEXNUMBER,FEXCREATETIME,FEXFIELD,FENTRYID,FEXSTATUS,FSEQ,FEXMODIFYTIME) VALUES (1723224314289243136,' ','1','0',{ts'2023-07-06  00:00:00'},'errcode',1723224314742227968,'1',1,{ts'2023-07-06  00:00:00'});
INSERT INTO t_er_trip_ignoreexentry(FID,FEXDESC,FEXISDEFAULT,FEXNUMBER,FEXCREATETIME,FEXFIELD,FENTRYID,FEXSTATUS,FSEQ,FEXMODIFYTIME) VALUES (1726230772362271744,'成功','1','0',{ts'2023-07-11  00:00:00'},'errcode',1726915155201594368,'1',1,{ts'2023-07-11  00:00:00'});

