| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPTravel Planning |
| 1 | FTPT_CAR | Travel Request Item - Car Rental Service | 54 | PNR_NR | Zeilennummer der CAR in der Itinerary | smallint | 5 | 0 | | |
| 2 | FTPT_FLIGHT | Travel Request Item - Flight Service | 27 | PNR_NR | Line Number of Flight in PNR (if PNR available) | smallint | 5 | 0 | | |
| 3 | FTPT_HOTEL | Travel Request Item - Hotel Service | 54 | PNR_NR | Line Number of Hotel in PNR (if PNR available) | smallint | 5 | 0 | | |
| 4 | FTPT_OTHER | Travel Reservation Request Item - Other Service | 10 | PNR_NR | Line Number of Other Service in PNR (if PNR Present) | smallint | 5 | 0 | | |
| 5 | FTPT_PNR | Elements of passenger name records of travel plan variant | 7 | PNR_NR | Line number in PNR | smallint | 5 | 0 | | |
| 6 | FTPT_PNR_ADDRESS | PNR delivery / billing addresses | 7 | PNR_NR | Line number in PNR | smallint | 5 | 0 | | |
| 7 | FTPT_PNR_NAME | Name element of PNR | 7 | PNR_NR | Line number in PNR | smallint | 5 | 0 | | |
| 8 | FTPT_PNR_OSI | Other PNR service information | 7 | PNR_NR | Line number in PNR | smallint | 5 | 0 | | |
| 9 | FTPT_PNR_PHONE | PNR telephone references | 7 | PNR_NR | Line number in PNR | smallint | 5 | 0 | | |
| 10 | FTPT_PNR_REMARKS | PNR remarks | 7 | PNR_NR | Line number in PNR | smallint | 5 | 0 | | |
| 11 | FTPT_PNR_SSR | Special PNR service requests | 7 | PNR_NR | Line number in PNR | smallint | 5 | 0 | | |
