TripBookingSegmentSeats
Query all the seats for a trip.
Table Specific Information
Select
The provider uses the SAP Concur APIs to process filters that refer to TripId and BookingRecordLocator. The provider processes other filters client-side within the provider.
For example, the following queries are processed server side:
SELECT * FROM TripBookingSegmentSeats WHERE TripId = 'sampleTripId' AND BookingRecordLocator = 'sampleBookingRecordLocator'
Columns
Name | Type | References | Description |
TripId [KEY] | String | The id of the trip. | |
BookingRecordLocator [KEY] | String | The record locator of the booking. | |
SegmentType [KEY] | String | The type of the segment. | |
PassengerRph | String | Which passenger the seat is assigned to. | |
Amenities | String | The amenities for the seat. | |
BerthPosition | String | The berth location of the seat. | |
Deck | String | Which deck the seat is on. | |
FacingForward | String | Whether the seat is facing forward. | |
FareSpaceComfort | String | The space around the seat. | |
SeatNumber | String | The number of the seat. | |
SeatPosition | String | The location of the seat. | |
SpaceType | String | The type of space around the seat. | |
Status | String | The status of the seat booking. | |
WagonNumber | String | The number of the wagon the seat is on. | |
WagonType | String | The type of wagon the seat is on. |