Trips

Query all the trips.

テーブル固有の情報

本製品は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'


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です。

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.