DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 2011734810137250816;
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 (2011734810137250816,1950065089466368000,' ','https://btrip.ogeve.com/stdwsapi/extbo/srvrecslelt/rest','1',2011734810137250816,'POST','C','Q_SyncPlaneChecking','企橙-机票结算单获取',' ','已录入参数',{ts'2024-08-07  00:00:00'},'pull','1',1879091968009578496,'er_planecheckingbill',{ts'2024-08-12  00:00:00'},'{
	"currentTime":"2018-02-12 14:45:43",
	"password":"1CDA471AC9E0390959DDA88EA7A4AFE3",
	"method":"settle.findbillorder",
	"data":{
		"lastUpdateDateEnd":"最后更新时间止2018-02-01 00: 00: 00",
		"periodName":"账期时间",
		"orderNum":"结算明细单号",
		"lastUpdateDateStart":"最后更新时间起2011-08-09 15:12:11",
		"billNum":"结算单号",
		"businessType":"业务类型"
	},
	"format":"json",
	"userName":"etc"
}','kd.fi.er.business.trip.v2.server.qtrip.QTripSyncCheckingInvoke#execute',1879091968009578496,'已录入参数');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '4A30/4TSVKFY';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (2011734810137250816,'4A30/4TSVKFY','zh_CN','企橙-机票结算单获取');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2011734810170805248;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2011734810137250816,'=',' ',' ',2011734810170805248,' ',' ','1',{ts'2024-08-07  00:00:00'},{ts'2024-08-07  00:00:00'},'userName',' ',1,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getAppKey');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2011734810170805249;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2011734810137250816,'=',' ',' ',2011734810170805249,'settle.findbillorder',' ','1',{ts'2024-08-07  00:00:00'},{ts'2024-08-07  00:00:00'},'method',' ',2,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2011734810170805250;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2011734810137250816,'=',' ',' ',2011734810170805250,' ',' ','1',{ts'2024-08-07  00:00:00'},{ts'2024-08-07  00:00:00'},'currentTime',' ',3,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getLongNowDate');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2011734810170805251;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2011734810137250816,'=',' ',' ',2011734810170805251,' ',' ','1',{ts'2024-08-07  00:00:00'},{ts'2024-08-07  00:00:00'},'password',' ',4,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getAppsecurity');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2011734810170805252;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2011734810137250816,'=',' ',' ',2011734810170805252,'json',' ','1',{ts'2024-08-07  00:00:00'},{ts'2024-08-07  00:00:00'},'format',' ',5,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2011734810170805253;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2011734810137250816,'=',' ',' ',2011734810170805253,' ',' ','1',{ts'2024-08-07  00:00:00'},{ts'2024-08-07  00:00:00'},'data.lastUpdateDateStart',' ',6,'1','and','kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getStartTimeStrByParams');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2011734810170805254;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2011734810137250816,'=',' ',' ',2011734810170805254,' ',' ','1',{ts'2024-08-07  00:00:00'},{ts'2024-08-07  00:00:00'},'data.lastUpdateDateEnd',' ',7,'1','and','kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getEndTimeStrByParams');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2011734810170805255;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2011734810137250816,'=',' ',' ',2011734810170805255,' ',' ','1',{ts'2024-08-07  00:00:00'},{ts'2024-08-08  00:00:00'},'data.billNum',' ',8,'1','and','kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getCheckingBillNumByParams');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2011734810170805257;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2011734810137250816,'=',' ',' ',2011734810170805257,'DOMAIR',' ','1',{ts'2024-08-07  00:00:00'},{ts'2024-08-08  00:00:00'},'data.businessType',' ',9,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2012410270022162432;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2011734810137250816,'=',' ',' ',2012410270022162432,' ',' ','1',{ts'2024-08-08  00:00:00'},{ts'2024-08-08  00:00:00'},'data.orderNum',' ',10,'1','and','kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getOrderNumByParams');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2011734810171053058;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2011734810137250816,' ','1',' ',' ','单据头.订单号',' ',2011734810171053058,'1',{ts'2024-08-07  00:00:00'},'tripSync.data.[0].ordernum',{ts'2024-08-07  00:00:00'},' ',1,'1','ordernum','1');


DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 2011742631314464768;
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 (2011742631314464768,1950065089466368000,' ','https://btrip.ogeve.com/stdwsapi/extbo/srvrecslelt/rest','1',2011742631314464768,'POST','C','Q_SyncHoteChecking','企橙-酒店结算单获取',' ','已录入参数',{ts'2024-08-07  00:00:00'},'pull','1',1879091968009578496,'er_hotelcheckingbill',{ts'2024-08-12  00:00:00'},'{
	"currentTime":"2018-02-12 14:45:43",
	"password":"1CDA471AC9E0390959DDA88EA7A4AFE3",
	"method":"settle.findbillorder",
	"data":{
		"lastUpdateDateEnd":"最后更新时间止2018-02-01 00: 00: 00",
		"periodName":"账期时间",
		"orderNum":"结算明细单号",
		"lastUpdateDateStart":"最后更新时间起2011-08-09 15:12:11",
		"billNum":"结算单号",
		"businessType":"业务类型"
	},
	"format":"json",
	"userName":"etc"
}','kd.fi.er.business.trip.v2.server.qtrip.QTripSyncCheckingInvoke#execute',1879091968009578496,'已录入参数');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '4A31G4IMLH6L';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (2011742631314464768,'4A31G4IMLH6L','zh_CN','企橙-酒店结算单获取');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2011742631331241984;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2011742631314464768,'=',' ',' ',2011742631331241984,' ',' ','1',{ts'2024-08-07  00:00:00'},{ts'2024-08-07  00:00:00'},'userName',' ',1,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getAppKey');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2011742631331241985;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2011742631314464768,'=',' ',' ',2011742631331241985,'settle.findbillorder',' ','1',{ts'2024-08-07  00:00:00'},{ts'2024-08-07  00:00:00'},'method',' ',2,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2011742631331241986;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2011742631314464768,'=',' ',' ',2011742631331241986,' ',' ','1',{ts'2024-08-07  00:00:00'},{ts'2024-08-07  00:00:00'},'currentTime',' ',3,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getLongNowDate');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2011742631331241987;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2011742631314464768,'=',' ',' ',2011742631331241987,' ',' ','1',{ts'2024-08-07  00:00:00'},{ts'2024-08-07  00:00:00'},'password',' ',4,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getAppsecurity');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2011742631331241988;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2011742631314464768,'=',' ',' ',2011742631331241988,'json',' ','1',{ts'2024-08-07  00:00:00'},{ts'2024-08-07  00:00:00'},'format',' ',5,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2011742631331241989;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2011742631314464768,'=',' ',' ',2011742631331241989,' ',' ','1',{ts'2024-08-07  00:00:00'},{ts'2024-08-07  00:00:00'},'data.lastUpdateDateStart',' ',6,'1','and','kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getStartTimeStrByParams');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2011742631331241990;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2011742631314464768,'=',' ',' ',2011742631331241990,' ',' ','1',{ts'2024-08-07  00:00:00'},{ts'2024-08-07  00:00:00'},'data.lastUpdateDateEnd',' ',7,'1','and','kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getEndTimeStrByParams');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2011742631331241991;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2011742631314464768,'=',' ',' ',2011742631331241991,' ',' ','1',{ts'2024-08-07  00:00:00'},{ts'2024-08-08  00:00:00'},'data.billNum',' ',8,'1','and','kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getCheckingBillNumByParams');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2011742631331241992;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2011742631314464768,'=',' ',' ',2011742631331241992,' ',' ','1',{ts'2024-08-07  00:00:00'},{ts'2024-08-08  00:00:00'},'data.orderNum',' ',9,'1','and','kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getOrderNumByParams');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2011742631331241993;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2011742631314464768,'=',' ',' ',2011742631331241993,'HOTEL',' ','1',{ts'2024-08-07  00:00:00'},{ts'2024-08-07  00:00:00'},'data.businessType',' ',10,'1','and',' ');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2011742631331488770;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2011742631314464768,' ','1',' ',' ','单据头.订单号',' ',2011742631331488770,'1',{ts'2024-08-07  00:00:00'},'tripSync.data.[0].ordernum',{ts'2024-08-07  00:00:00'},' ',1,'1','ordernum','1');


DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 2011744967097443328;
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 (2011744967097443328,1950065089466368000,' ','https://btrip.ogeve.com/stdwsapi/extbo/srvrecslelt/rest','1',2011744967097443328,'POST','C','Q_SyncTrainChecking','企橙-火车结算单获取',' ','已录入参数',{ts'2024-08-07  00:00:00'},'pull','1',1879091968009578496,'er_traincheckingbill',{ts'2024-08-12  00:00:00'},'{
	"currentTime":"2018-02-12 14:45:43",
	"password":"1CDA471AC9E0390959DDA88EA7A4AFE3",
	"method":"settle.findbillorder",
	"data":{
		"lastUpdateDateEnd":"最后更新时间止2018-02-01 00: 00: 00",
		"periodName":"账期时间",
		"orderNum":"结算明细单号",
		"lastUpdateDateStart":"最后更新时间起2011-08-09 15:12:11",
		"billNum":"结算单号",
		"businessType":"业务类型"
	},
	"format":"json",
	"userName":"etc"
}','kd.fi.er.business.trip.v2.server.qtrip.QTripSyncCheckingInvoke#execute',1879091968009578496,'已录入参数');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '4A31X5BJQLJO';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (2011744967097443328,'4A31X5BJQLJO','zh_CN','企橙-火车结算单获取');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2011744967139386368;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2011744967097443328,'=',' ',' ',2011744967139386368,' ',' ','1',{ts'2024-08-07  00:00:00'},{ts'2024-08-07  00:00:00'},'userName',' ',1,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getAppKey');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2011744967139386369;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2011744967097443328,'=',' ',' ',2011744967139386369,'settle.findbillorder',' ','1',{ts'2024-08-07  00:00:00'},{ts'2024-08-07  00:00:00'},'method',' ',2,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2011744967139386370;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2011744967097443328,'=',' ',' ',2011744967139386370,' ',' ','1',{ts'2024-08-07  00:00:00'},{ts'2024-08-07  00:00:00'},'currentTime',' ',3,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getLongNowDate');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2011744967139386371;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2011744967097443328,'=',' ',' ',2011744967139386371,' ',' ','1',{ts'2024-08-07  00:00:00'},{ts'2024-08-07  00:00:00'},'password',' ',4,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getAppsecurity');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2011744967139386372;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2011744967097443328,'=',' ',' ',2011744967139386372,'json',' ','1',{ts'2024-08-07  00:00:00'},{ts'2024-08-07  00:00:00'},'format',' ',5,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2011744967139386373;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2011744967097443328,'=',' ',' ',2011744967139386373,' ',' ','1',{ts'2024-08-07  00:00:00'},{ts'2024-08-07  00:00:00'},'data.lastUpdateDateStart',' ',6,'1','and','kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getStartTimeStrByParams');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2011744967139386374;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2011744967097443328,'=',' ',' ',2011744967139386374,' ',' ','1',{ts'2024-08-07  00:00:00'},{ts'2024-08-07  00:00:00'},'data.lastUpdateDateEnd',' ',7,'1','and','kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getEndTimeStrByParams');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2011744967139386375;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2011744967097443328,'=',' ',' ',2011744967139386375,' ',' ','1',{ts'2024-08-07  00:00:00'},{ts'2024-08-08  00:00:00'},'data.billNum',' ',8,'1','and','kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getCheckingBillNumByParams');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2011744967139386376;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2011744967097443328,'=',' ',' ',2011744967139386376,' ',' ','1',{ts'2024-08-07  00:00:00'},{ts'2024-08-08  00:00:00'},'data.orderNum',' ',9,'1','and','kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getOrderNumByParams');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2011744967139386377;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2011744967097443328,'=',' ',' ',2011744967139386377,'TRAIN',' ','1',{ts'2024-08-07  00:00:00'},{ts'2024-08-07  00:00:00'},'data.businessType',' ',10,'1','and',' ');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2011744967139139586;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2011744967097443328,' ','1',' ',' ','单据头.订单号',' ',2011744967139139586,'1',{ts'2024-08-07  00:00:00'},'tripSync.data.[0].ordernum',{ts'2024-08-07  00:00:00'},' ',1,'1','ordernum','1');


DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 2012463319847589888;
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 (2012463319847589888,1950065089466368000,'{
	"code":"200",
	"message":"出错的信息",
	"tripSync":{
		"method":"er_checkingbill",
		"data":[
			{
				"formid":"er_planecheckingbill",
				"settlemain":453,
				"periodenddate":"2024-07-31 00:00:00",
				"periodstartdate":"2024-07-16 00:00:00",
				"settlementamount":900.0,
				"billstatus":"A",
				"billnum":"3211721973394387",
				"operationtype":"4"
			}
		],
		"service":"QICHENG",
		"sign":"7a908d504c76132e0cbc34ea305ba8e6"
	}
}','https://btrip.ogeve.com/stdwsapi/extbo/srvrecslelt/rest','1',2012463319847589888,'POST','C','Q_SyncCheckingbill','企橙-月结账单获取',' ','已录入参数',{ts'2024-08-08  00:00:00'},'pull','1',1879091968009578496,'er_checkingbill',{ts'2024-08-12  00:00:00'},'{
	"currentTime":"2018-02-12 14:45:43",
	"password":"1CDA471AC9E0390959DDA88EA7A4AFE3",
	"method":"settle.findbill",
	"data":{
		"settleMainCode":"结算主体编码",
		"periodName":"账期时间2018-01-01",
		"settleMainName":"结算主体名称",
		"businessType":"业务类型"
	},
	"format":"json",
	"userName":"etc"
}','kd.fi.er.business.trip.v2.server.qtrip.QTripSyncCheckingBillInvoke#execute',1879091968009578496,'已录入参数');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '4A6I3SQUZUJ7';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (2012463319847589888,'4A6I3SQUZUJ7','zh_CN','企橙-月结账单获取');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2012463320057305088;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2012463319847589888,'=',' ',' ',2012463320057305088,' ',' ','1',{ts'2024-08-08  00:00:00'},{ts'2024-08-08  00:00:00'},'userName',' ',1,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getAppKey');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2012463320057305089;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2012463319847589888,'=',' ',' ',2012463320057305089,'settle.findbill',' ','1',{ts'2024-08-08  00:00:00'},{ts'2024-08-08  00:00:00'},'method',' ',2,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2012463320057305090;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2012463319847589888,'=',' ',' ',2012463320057305090,' ',' ','1',{ts'2024-08-08  00:00:00'},{ts'2024-08-08  00:00:00'},'currentTime',' ',3,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getLongNowDate');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2012463320057305091;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2012463319847589888,'=',' ',' ',2012463320057305091,' ',' ','1',{ts'2024-08-08  00:00:00'},{ts'2024-08-08  00:00:00'},'password',' ',4,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getAppsecurity');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2012463320057305092;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2012463319847589888,'=',' ',' ',2012463320057305092,'json',' ','1',{ts'2024-08-08  00:00:00'},{ts'2024-08-08  00:00:00'},'format',' ',5,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2012463320057305093;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2012463319847589888,'=',' ',' ',2012463320057305093,' ',' ','1',{ts'2024-08-08  00:00:00'},{ts'2024-08-08  00:00:00'},'data.periodName',' ',6,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getDsStartDate');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2012463320057305094;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2012463319847589888,'=',' ',' ',2012463320057305094,' ',' ','1',{ts'2024-08-08  00:00:00'},{ts'2024-08-08  00:00:00'},'data.settleMainCode',' ',7,'1','and','kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getJValueByParamsNoParse');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2012463320057305095;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2012463319847589888,'=',' ',' ',2012463320057305095,' ',' ','1',{ts'2024-08-08  00:00:00'},{ts'2024-08-08  00:00:00'},'data.businessType',' ',8,'1','and','kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getJValueByParamsNoParse');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2012463320057306114;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2012463319847589888,' ','1',' ',' ','单据头.单据编号',' ',2012463320057306114,'1',{ts'2024-08-08  00:00:00'},'tripSync.data.[0].billnum',{ts'2024-08-08  00:00:00'},' ',1,'1','billno','1');
