| 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 | | |