JDBC Driver for SAP Concur

Build 23.0.8839

Trips

Query all the trips.

テーブル固有の情報

Select

本製品 はSAP Concur API を使用して、TripStartDate、TripEndDate、ModifiedDate の任意の組み合わせを参照するフィルタを処理します。本製品 はクライアント側で本製品 内で他のフィルタを処理します。

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

デフォルト値はfalseです。

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

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.

使用できる値は次のとおりです。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.

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