JDBC Driver for SAP Concur

Build 23.0.8839

TripBookings

Query all the bookings for a trip.

テーブル固有の情報

Select

本製品 はSAP Concur API を使用して、TripId を参照するフィルタを処理します。本製品 はクライアント側で本製品 内で他のフィルタを処理します。 例えば、次のクエリはサーバー側で処理されます。

SELECT * FROM TripBookings WHERE TripId = 'sampleTripId'

Columns

Name Type References Description
RecordLocator [KEY] String The record locator of the booking.
TripId [KEY] String The id of the trip.
BookingOwner String The id of the trip.
Source String The name of the trip.
BookingSource String The record locator of the trip.
BookedDate Datetime The first name of the traveler.
CreatedDate Datetime The last name of the traveler.
ModifiedDate Datetime A comma separated list of passengers.
IsCanceled Boolean The status of the trip

デフォルト値はfalseです。

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
CreatedAfterDate Datetime Date for when the trip was created. The query string will return trips created on or after this date.
CreatedBeforeDate Datetime Date for when the trip was created. The query string will return trips created on or before this date.
BookingType String The trip includes at least one booking of this type.

使用できる値は次のとおりです。Air, Car, Dining, Hotel, Parking, Rail, Ride

IncludeVirtualTrip Boolean Show virtual trips. Virtual trips are segments booked offline through the Travel Request product.
IncludeGuestBookings Boolean Indicates whether to include guest bookings.
LoginId String The login ID of the user who owns the trip. The user must have the Web Services Admin role to use this parameter.

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