| 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 | 70 | PREF3 | Third Preference for Car Rental Company | nvarchar | 3 | 0 | | |
| 2 | FTPT_CAR_PREF | Rental car service preferences of a travel plan | 16 | PREF3 | Third Preference for Car Rental Company | nvarchar | 3 | 0 | | |
| 3 | FTPT_HOTEL | Travel Request Item - Hotel Service | 72 | PREF3 | Hotel Chain - Third Preference | nvarchar | 3 | 0 | | |
| 4 | FTPT_HOTEL_PREF | Hotel service preferences of a travel plan | 15 | PREF3 | Hotel Chain - Third Preference | nvarchar | 3 | 0 | | |
| 5 | PA0471 | HR master record infotype 0471 (flight preferences) | 36 | PREF3 | Third preference airline | nvarchar | 3 | 0 | | |
| 6 | PA0472 | HR master record infotype 0472 (hotel preferences) | 30 | PREF3 | Hotel Chain - Third Preference | nvarchar | 3 | 0 | | |
| 7 | PA0473 | HR master record infotype 0473 (rental car preferences) | 31 | PREF3 | Third Preference for Car Rental Company | nvarchar | 3 | 0 | | |
