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