TripBookingSegmentSeats
Query all the seats for a trip.
Table Specific Information
Select
The connector uses the SAP Concur APIs to process filters that refer to TripId and BookingRecordLocator. The connector processes other filters client-side within the connector.
For example, the following queries are processed server side:
SELECT * FROM TripBookingSegmentSeats WHERE TripId = 'sampleTripId' AND BookingRecordLocator = 'sampleBookingRecordLocator'
Columns
| Name | Type | 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. |
| 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. |