| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPTravel Planning |
| 1 | FTPT_IMR | IMR - General Information | 3 | AIR_NUMBER | Air record unique identifier | nvarchar | 12 | 0 | | |
| 2 | FTPT_IMR_CAR | IMR - Car Rental | 3 | AIR_NUMBER | Air record unique identifier | nvarchar | 12 | 0 | | |
| 3 | FTPT_IMR_DETAIL | IMR - Detail Information | 3 | AIR_NUMBER | Air record unique identifier | nvarchar | 12 | 0 | | |
| 4 | FTPT_IMR_FAREDAT | IMR - Price Data Description | 3 | AIR_NUMBER | Air record unique identifier | nvarchar | 12 | 0 | | |
| 5 | FTPT_IMR_FAREELM | IMR: Passenger Information for Price Determination | 3 | AIR_NUMBER | Air record unique identifier | nvarchar | 12 | 0 | | |
| 6 | FTPT_IMR_FELMSEG | IMR: Table for Assignment of Ticket to Flight Segment | 3 | AIR_NUMBER | Air record unique identifier | nvarchar | 12 | 0 | | |
| 7 | FTPT_IMR_FLIGHT | IMR - Flight | 3 | AIR_NUMBER | Air record unique identifier | nvarchar | 12 | 0 | | |
| 8 | FTPT_IMR_FOP | IMR : Information on Payment Method | 3 | AIR_NUMBER | Air record unique identifier | nvarchar | 12 | 0 | | |
| 9 | FTPT_IMR_FOPSEG | IMR: Assignment Table Payment Method to Flight Segments | 3 | AIR_NUMBER | Air record unique identifier | nvarchar | 12 | 0 | | |
| 10 | FTPT_IMR_FQTV | IMR: Customer Programs | 3 | AIR_NUMBER | Air record unique identifier | nvarchar | 12 | 0 | | |
| 11 | FTPT_IMR_FQTVSEG | IMR: Assignment Table Customer Programs to Flight Segments | 3 | AIR_NUMBER | Air record unique identifier | nvarchar | 12 | 0 | | |
| 12 | FTPT_IMR_FSP | IMR: Assignment Table Passengers-Segments-TST | 3 | AIR_NUMBER | Air record unique identifier | nvarchar | 12 | 0 | | |
| 13 | FTPT_IMR_HTL | IMR - Hotel | 3 | AIR_NUMBER | Air record unique identifier | nvarchar | 12 | 0 | | |
| 14 | FTPT_IMR_HTL_DIR | IMR - Hotel (Direct Access) | 3 | AIR_NUMBER | Air record unique identifier | nvarchar | 12 | 0 | | |
| 15 | FTPT_IMR_MANUAL | IMR - Manually Created Segments | 3 | AIR_NUMBER | Air record unique identifier | nvarchar | 12 | 0 | | |
| 16 | FTPT_IMR_NAMES | IMR : Name | 3 | AIR_NUMBER | Air record unique identifier | nvarchar | 12 | 0 | | |
| 17 | FTPT_IMR_RECLOC | IMR - Booking Rate | 3 | AIR_NUMBER | Air record unique identifier | nvarchar | 12 | 0 | | |
| 18 | FTPT_IMR_SEATS | IMR: Seating Information | 3 | AIR_NUMBER | Air record unique identifier | nvarchar | 12 | 0 | | |
| 19 | FTPT_IMR_SEATSEG | IMR: Table for Assignment of Seats to Flight Segments | 3 | AIR_NUMBER | Air record unique identifier | nvarchar | 12 | 0 | | |
| 20 | FTPT_IMR_SSRS | IMR: Information on Special Service Requirements | 3 | AIR_NUMBER | Air record unique identifier | nvarchar | 12 | 0 | | |
| 21 | FTPT_IMR_SSRSEG | IMR: Assignment Table Special Serv.Request to Flight Segment | 3 | AIR_NUMBER | Air record unique identifier | nvarchar | 12 | 0 | | |
| 22 | FTPT_IMR_SURFACE | IMR - Other Segments of Trip as Flights | 3 | AIR_NUMBER | Air record unique identifier | nvarchar | 12 | 0 | | |
| 23 | FTPT_IMR_TKT | IMR : Ticket Information | 3 | AIR_NUMBER | Air record unique identifier | nvarchar | 12 | 0 | | |
| 24 | FTPT_IMR_TKTSEG | IMR: Table for Assignment of Ticket to Flight Segment | 3 | AIR_NUMBER | Air record unique identifier | nvarchar | 12 | 0 | | |
| 25 | FTPT_IMR_TRAIN | IMR - Train | 3 | AIR_NUMBER | Air record unique identifier | nvarchar | 12 | 0 | | |
