SSIS Components for SAP Concur

Build 25.0.9434

TripBookings

Query all the bookings for a trip.

テーブル固有の情報

Select

本製品 はSAP Concur API を使用して、TripId を参照するフィルタを処理します。本製品 はクライアント側で本製品 内で他のフィルタを処理します。 例えば、次のクエリはサーバー側で処理されます。

SELECT * FROM TripBookings WHERE TripId = 'sampleTripId'

Columns

Name Type References Description
RecordLocator [KEY] String The record locator of the booking.
TripId [KEY] String

Trips.Id

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

UsersV4.UserName

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) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434