Trips
Query all the trips.
Table Specific Information
Select
The add-in uses the SAP Concur APIs to process filters that refer to any combination of TripStartDate, TripEndDate, and ModifiedDate. The add-in processes other filters client-side within the add-in.
SELECT * FROM Trips WHERE TripStartDate = '2018-01-01 10:00:00' AND TripEndDate = '2018-03-01 10:00:00' AND ModifiedDate = '2018-02-01 10:00:00'
Columns
Name | Type | References | Description |
Id [KEY] | String | The id of the trip. | |
TripName | String | The name of the trip. | |
TravelerFirstName | String | The first name of the traveler. | |
TravelerLastName | String | The last name of the traveler. | |
Passengers | String | A comma separated list of passengers. | |
TripStartDate | Datetime | The start date of the trip. | |
TripEndDate | Datetime | The end date of the trip. | |
ModifiedDate | Datetime | The date when the trip was last modified. | |
RecordLocator | String | The record locator of the trip. | |
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. | |
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. |