ODBC Driver for SAP Concur

Build 24.0.9062

Opportunities

Gets opportunities for a specified trip or for all trips that fall within a date range.

テーブル固有の情報

Select

本製品 はSAP Concur API を使用して、TripId_p、OpportunityType_p、FromUtc_p、ToUtc_p の任意の組み合わせを参照するフィルタを処理します。本製品 はクライアント側で本製品 内で他のフィルタを処理します。

例えば、次のクエリはサーバー側で処理されます。

SELECT * FROM Opportunities WHERE TripId_p = 'sampleTripId' AND OpportunityType_p = 'Hotel' AND FROMUtc_p = '2018-01-01 13:00:00' AND ToUtc_p = '2018-01-01 13:00:00'  

Columns

Name Type Description
ID [KEY] String The unique identifier of the resource.
TripId [KEY] String The trip id of the associated itinerary
EndCityCode String The city code of the destination city where the opportunity is offered
EndDateLocal Datetime The local end date of the location where the opportunity is offered
EndPostalCode String The postal code of the destination location where the opportunity is offered
IsActive Bool Indicates that the opportunity is currently active
StartCityCode String The city code of the originating city where the opportunity is offered
StartDateLocal Datetime The local start date of the location where the opportunity is offered
StartPostalCode String The postal code of the originating location where the opportunity is offered
Type String The type of opportunity
URI String The URI to the resource.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062