TripBookings
Query all the bookings for a trip.
Table Specific Information
Select
The connector uses the SAP Concur APIs to process filters that refer to TripId. The connector processes other filters client-side within the connector.
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. |