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. |