| 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 | 6 | VARIANTVRS | Version of travel plan | nvarchar | 2 | 0 | | |
2 | FTPT_CAR_PREF | Rental car service preferences of a travel plan | 6 | VARIANTVRS | Version of travel plan | nvarchar | 2 | 0 | | |
3 | FTPT_FARE_COMP | Rate components | 6 | VARIANTVRS | Version of travel plan | nvarchar | 2 | 0 | | |
4 | FTPT_FARE_NOTE | Rate Rules | 6 | VARIANTVRS | Version of travel plan | nvarchar | 2 | 0 | | |
5 | FTPT_FLIGHT | Travel Request Item - Flight Service | 6 | VARIANTVRS | Version of travel plan | nvarchar | 2 | 0 | | |
6 | FTPT_FLIGHT_FARE | Assignment table: flights <-> rate components | 6 | VARIANTVRS | Version of travel plan | nvarchar | 2 | 0 | | |
7 | FTPT_FLIGHT_FCMP | Assignment table: flights <-> rate components | 6 | VARIANTVRS | Version of travel plan | nvarchar | 2 | 0 | | |
8 | FTPT_FLIGHT_LEG | Leg of flight | 6 | VARIANTVRS | Version of travel plan | nvarchar | 2 | 0 | | |
9 | FTPT_FLIGHT_PREF | Flight service preferences of a travel plan | 6 | VARIANTVRS | Version of travel plan | nvarchar | 2 | 0 | | |
10 | FTPT_FLIGHT_TST | Ticket information | 6 | VARIANTVRS | Version of travel plan | nvarchar | 2 | 0 | | |
11 | FTPT_FLIGHT_TSTK | Ticket Information | 6 | VARIANTVRS | Version of travel plan | nvarchar | 2 | 0 | | |
12 | FTPT_HOTEL | Travel Request Item - Hotel Service | 6 | VARIANTVRS | Version of travel plan | nvarchar | 2 | 0 | | |
13 | FTPT_HOTEL_PREF | Hotel service preferences of a travel plan | 6 | VARIANTVRS | Version of travel plan | nvarchar | 2 | 0 | | |
14 | FTPT_ITEM | Travel Service Request Item | 6 | VARIANTVRS | Version of travel plan | nvarchar | 2 | 0 | | |
15 | FTPT_OTHER | Travel Reservation Request Item - Other Service | 6 | VARIANTVRS | Version of travel plan | nvarchar | 2 | 0 | | |
16 | FTPT_PNR | Elements of passenger name records of travel plan variant | 6 | VARIANTVRS | Version of travel plan | nvarchar | 2 | 0 | | |
17 | FTPT_PNR_ADDRESS | PNR delivery / billing addresses | 6 | VARIANTVRS | Version of travel plan | nvarchar | 2 | 0 | | |
18 | FTPT_PNR_NAME | Name element of PNR | 6 | VARIANTVRS | Version of travel plan | nvarchar | 2 | 0 | | |
19 | FTPT_PNR_OSI | Other PNR service information | 6 | VARIANTVRS | Version of travel plan | nvarchar | 2 | 0 | | |
20 | FTPT_PNR_PHONE | PNR telephone references | 6 | VARIANTVRS | Version of travel plan | nvarchar | 2 | 0 | | |
21 | FTPT_PNR_REMARKS | PNR remarks | 6 | VARIANTVRS | Version of travel plan | nvarchar | 2 | 0 | | |
22 | FTPT_PNR_SSR | Special PNR service requests | 6 | VARIANTVRS | Version of travel plan | nvarchar | 2 | 0 | | |
23 | FTPT_REQUEST | Travel Plan Requests | 6 | VARIANTVRS | Version of travel plan | nvarchar | 2 | 0 | | |
24 | FTPT_SERVICE | General Services | 6 | VARIANTVRS | Version of travel plan | nvarchar | 2 | 0 | | |
25 | FTPT_SYNC_DATA | Data Synchronization: SAP - External System | 6 | VARIANTVRS | Version of travel plan | nvarchar | 2 | 0 | | |
26 | FTPT_TRAIN | Travel Request Item - Train Service | 6 | VARIANTVRS | Version of travel plan | nvarchar | 2 | 0 | | |
27 | FTPT_TRAIN_PREF | Train service preferences of a travel plan | 6 | VARIANTVRS | Version of travel plan | nvarchar | 2 | 0 | | |
28 | FTPT_VARIANT | Table of Travel Plan Variants | 6 | VARIANTVRS | Version of travel plan | nvarchar | 2 | 0 | | |
29 | FTPT_VAR_INFO | Info texts for travel plan variants | 6 | VARIANTVRS | Version of travel plan | nvarchar | 2 | 0 | | |