TripBookingSegmentSeats
Query all the seats for a trip.
Table Specific Information
Select
The driver uses the SAP Concur APIs to process filters that refer to TripId and BookingRecordLocator. The driver processes other filters client-side within the driver.
For example, the following queries are processed server side:
SELECT * FROM TripBookingSegmentSeats WHERE TripId ='sampleTripId' AND BookingRecordLocator = 'sampleBookingRecordLocator'You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.
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. |