TripBookings
Query all the bookings for a trip.
Table Specific Information
Select
The adapter uses the SAP Concur APIs to process filters that refer to TripId. The adapter processes other filters client-side within the adapter.
For example, the following queries are processed server side:
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
The default value is false. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| 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.
The allowed values are 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. |