ODBC Driver for SAP Concur

Build 24.0.9060

TripBookings

Query all the bookings for a trip.

Table Specific Information

Select

The driver uses the SAP Concur APIs to process filters that refer to TripId. The driver processes other filters client-side within the driver. 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060