TripBookingSegmentSeats
Query all the seats for a trip.
Table Specific Information
Select
The component uses the SAP Concur APIs to process filters that refer to TripId and BookingRecordLocator. The component processes other filters client-side within the component.
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 |
Trips.Id | 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. | |
| 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. |