| 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 | 68 | PREF1 | First Preference for Car Rental Company | nvarchar | 3 | 0 | | |
| 2 | FTPT_CAR_PREF | Rental car service preferences of a travel plan | 14 | PREF1 | First Preference for Car Rental Company | nvarchar | 3 | 0 | | |
| 3 | FTPT_HOTEL | Travel Request Item - Hotel Service | 70 | PREF1 | Hotel Chain - First Preference | nvarchar | 3 | 0 | | |
| 4 | FTPT_HOTEL_PREF | Hotel service preferences of a travel plan | 13 | PREF1 | Hotel Chain - First Preference | nvarchar | 3 | 0 | | |
| 5 | PA0471 | HR master record infotype 0471 (flight preferences) | 34 | PREF1 | First preference airline | nvarchar | 3 | 0 | | |
| 6 | PA0472 | HR master record infotype 0472 (hotel preferences) | 28 | PREF1 | Hotel Chain - First Preference | nvarchar | 3 | 0 | | |
| 7 | PA0473 | HR master record infotype 0473 (rental car preferences) | 29 | PREF1 | First Preference for Car Rental Company | nvarchar | 3 | 0 | | |
