DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 2063042897124744192;
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 (2063042897124744192,139500340868311041,' ','https://ct.ctrip.com/switchAPI/CorpSettlement/corpVoucherQuery','1',2063042897124744192,'POST','C','C_SyncInvoice','携程-在线发票获取',' ','已录入参数。',{ts'2024-10-17  00:00:00'},'pull','1',1996320338723934208,'er_checkingbill',{ts'2024-12-12  00:00:00'},'{
	"batchNo":"",
	"corpId":"*****",
	"voucherType":0,
	"voucherDateOffset":0,
	"auth":{
		"Ticket":"66f900ea152fb0e4c8d60964",
		"AppKey":"obk_*****"
	},
	"requestId":"12242342436251",
	"orderIdList":[
		"352888*****"
	],
	"subBatchNoList":[
		""
	],
	"pageInfoReq":{
		"pageSize":5,
		"pageNum":1
	}
}','kd.fi.er.business.trip.v2.server.ctrip.CtripSyncInvoiceInvoke#execute',1996320338723934208,'已录入参数。'); 
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '4GDUPPS9JPGW';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (2063042897124744192,'4GDUPPS9JPGW','zh_CN','携程-在线发票获取'); 
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2063042953454246912;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2063042897124744192,'=',' ',' ',2063042953454246912,' ',' ','1',{ts'2024-10-17  00:00:00'},{ts'2024-10-19  00:00:00'},'batchNo','结算批次号',1,'1','and','kd.fi.er.business.trip.v2.plugin.ctrip.CtripSyncInvoiceQueryPlugin#getBatchNo'); 
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2063303178216356864;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2063042897124744192,'=',' ',' ',2063303178216356864,' ',' ','1',{ts'2024-10-17  00:00:00'},{ts'2024-10-19  00:00:00'},'subBatchNoList','子批次号集合',2,'1','and','kd.fi.er.business.trip.v2.plugin.ctrip.CtripSyncInvoiceQueryPlugin#getSubBatchNoList'); 
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2063303178216356865;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2063042897124744192,'=',' ',' ',2063303178216356865,'0',' ','1',{ts'2024-10-17  00:00:00'},{ts'2024-10-17  00:00:00'},'voucherType','凭证类型，0：全部凭证类型',3,'1','and',' '); 
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2071214686535383040;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2063042897124744192,'=',' ',' ',2071214686535383040,' ',' ','1',{ts'2024-10-28  00:00:00'},{ts'2024-11-07  00:00:00'},'auth.AppKey','接入账号',4,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getAppKey'); 
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2071214686535383041;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2063042897124744192,'=',' ',' ',2071214686535383041,' ',' ','1',{ts'2024-10-28  00:00:00'},{ts'2024-11-07  00:00:00'},'auth.Ticket','令牌',5,'1','and','kd.fi.er.business.trip.v2.plugin.ctrip.CtripSyncInvoiceQueryPlugin#getTicket'); 
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2071997861851099136;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2063042897124744192,'=',' ',' ',2071997861851099136,' ',' ','1',{ts'2024-10-29  00:00:00'},{ts'2024-11-07  00:00:00'},'corpId','公司id',6,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getOrationid'); 
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2071997861851099137;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2063042897124744192,'=',' ',' ',2071997861851099137,' ',' ','1',{ts'2024-10-29  00:00:00'},{ts'2024-11-07  00:00:00'},'requestId','请求唯一标识，可传UUID',7,'1','and','kd.fi.er.business.trip.v2.plugin.OtherFieldCommonPlugin#getRandom'); 
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2063042953454246913;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2063042897124744192,' ','1',' ',' ','单据头.账单编号',' ',2063042953454246913,'1',{ts'2024-10-17  00:00:00'},'requestTicket',{ts'2024-12-12  00:00:00'},'kd.fi.er.business.trip.v2.plugin.ctrip.CtripSyncInvoiceFieldMappingPlugin#getBillNo',1,'4','billnum','1'); 
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2063319561679363072;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2063042897124744192,' ','1',' ',' ','发票信息.发票信息',' ',2063319561679363072,'1',{ts'2024-10-17  00:00:00'},'invoiceNode',{ts'2024-10-22  00:00:00'},'kd.fi.er.business.trip.v2.plugin.ctrip.CtripSyncInvoiceFieldMappingPlugin#getInvoiceNode',2,'4','invoiceentry','0'); 
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2063320950623255552;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2063042897124744192,' ','1',' ',' ','发票信息.发票信息',' ',2063320950623255552,'1',{ts'2024-10-17  00:00:00'},'itineraryNode',{ts'2024-10-22  00:00:00'},'kd.fi.er.business.trip.v2.plugin.ctrip.CtripSyncInvoiceFieldMappingPlugin#getItineraryNode',3,'4','invoiceentry.[0]','0'); 
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2063323757115825152;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2063042897124744192,' ','1',' ',' ','发票信息.发票信息',' ',2063323757115825152,'1',{ts'2024-10-17  00:00:00'},'electronicItineraryNode',{ts'2024-10-22  00:00:00'},'kd.fi.er.business.trip.v2.plugin.ctrip.CtripSyncInvoiceFieldMappingPlugin#getElectronicItineraryNode',4,'4','invoiceentry.[1]','0'); 
