| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPTravel Planning |
1 | FTPT_IMR_CAR | IMR - Car Rental | 6 | TATTOO_NUMBER | Amadeus unique identifier for each element stored in PNR | nvarchar | 4 | 0 | | |
2 | FTPT_IMR_FAREELM | IMR: Passenger Information for Price Determination | 6 | TATTOO_NUMBER | Amadeus unique identifier for each element stored in PNR | nvarchar | 4 | 0 | | |
3 | FTPT_IMR_FOP | IMR : Information on Payment Method | 6 | TATTOO_NUMBER | Amadeus unique identifier for each element stored in PNR | nvarchar | 4 | 0 | | |
4 | FTPT_IMR_FQTV | IMR: Customer Programs | 6 | TATTOO_NUMBER | Amadeus unique identifier for each element stored in PNR | nvarchar | 4 | 0 | | |
5 | FTPT_IMR_HTL | IMR - Hotel | 6 | TATTOO_NUMBER | Amadeus unique identifier for each element stored in PNR | nvarchar | 4 | 0 | | |
6 | FTPT_IMR_HTL_DIR | IMR - Hotel (Direct Access) | 6 | TATTOO_NUMBER | Amadeus unique identifier for each element stored in PNR | nvarchar | 4 | 0 | | |
7 | FTPT_IMR_MANUAL | IMR - Manually Created Segments | 6 | TATTOO_NUMBER | Amadeus unique identifier for each element stored in PNR | nvarchar | 4 | 0 | | |
8 | FTPT_IMR_NAMES | IMR : Name | 5 | TATTOO_NUMBER | Amadeus unique identifier for each element stored in PNR | nvarchar | 4 | 0 | | |
9 | FTPT_IMR_SEATS | IMR: Seating Information | 6 | TATTOO_NUMBER | Amadeus unique identifier for each element stored in PNR | nvarchar | 4 | 0 | | |
10 | FTPT_IMR_SSRS | IMR: Information on Special Service Requirements | 6 | TATTOO_NUMBER | Amadeus unique identifier for each element stored in PNR | nvarchar | 4 | 0 | | |
11 | FTPT_IMR_SURFACE | IMR - Other Segments of Trip as Flights | 7 | TATTOO_NUMBER | Amadeus unique identifier for each element stored in PNR | nvarchar | 4 | 0 | | |
12 | FTPT_IMR_TKT | IMR : Ticket Information | 6 | TATTOO_NUMBER | Amadeus unique identifier for each element stored in PNR | nvarchar | 4 | 0 | | |
13 | FTPT_IMR_TRAIN | IMR - Train | 7 | TATTOO_NUMBER | Amadeus unique identifier for each element stored in PNR | nvarchar | 4 | 0 | | |