| 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 | 56 | PROFITEM | Trip rule | nvarchar | 8 | 0 | | |
| 2 | FTPT_FLIGHT | Travel Request Item - Flight Service | 33 | PROFITEM | Trip rule | nvarchar | 8 | 0 | | |
| 3 | FTPT_HOTEL | Travel Request Item - Hotel Service | 56 | PROFITEM | Trip rule | nvarchar | 8 | 0 | | |
| 4 | TA20PI | Trip Rule | 3 | PROFITEM | Trip rule | nvarchar | 8 | 0 | | |
| 5 | TA20PI1 | Trip Rule (Language-Dependent) | 4 | PROFITEM | Trip rule | nvarchar | 8 | 0 | | |
| 6 | TA20PIC | Car Rental Trip Rule | 2 | PROFITEM | Trip rule | nvarchar | 8 | 0 | | |
| 7 | TA20PIF | Flight Trip Rule | 2 | PROFITEM | Trip rule | nvarchar | 8 | 0 | | |
| 8 | TA20PIH | Hotel Trip Rule | 2 | PROFITEM | Trip rule | nvarchar | 8 | 0 | | |
| 9 | TA20PPI | Assignment Table of Trip Rules for Travel Profiles | 4 | PROFITEM | Trip rule | nvarchar | 8 | 0 | | |
| 10 | TA20PPT | Assignment Table of Trip Rules for Travel Profiles | 5 | PROFITEM | Trip rule | nvarchar | 8 | 0 | | |
| 11 | TA23PIC | Car Rental Trip Rule (Filter before Availability Query) | 2 | PROFITEM | Trip rule | nvarchar | 8 | 0 | | |
| 12 | TA23PIF | Flight Trip Rule (Filter before Availability Query) | 2 | PROFITEM | Trip rule | nvarchar | 8 | 0 | | |
| 13 | TA23PIFT | Trip Rule for Mandatory Combined Display of Flights/Rail | 2 | PROFITEM | Trip rule | nvarchar | 8 | 0 | | |
| 14 | TA23PIH | Hotel Trip Rule (Filter before Availability Query) | 2 | PROFITEM | Trip rule | nvarchar | 8 | 0 | | |
| 15 | TA23PIT | Flight Trip Rule | 2 | PROFITEM | Trip rule | nvarchar | 8 | 0 | | |
| 16 | TA23_PAPTF | Additional Airport for Availability Query | 2 | PROFITEM | Trip rule | nvarchar | 8 | 0 | | |
