| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPTravel Planning |
| 1 | TA20HH | Maximum Rates for Hotel Stay | 3 | LOCATIONTYPE | Geographical Location Type | nvarchar | 1 | 0 | | |
| 2 | TA20HH1 | Maximum Rates for Hotel Stay | 4 | LOCATIONTYPE | Geographical area type | nvarchar | 1 | 0 | | |
| 3 | TA20NC | Negotiated rental car rates (corporate nego rates) | 3 | LOCATIONTYPE | Geographical area type | nvarchar | 1 | 0 | | |
| 4 | TA20NC1 | Negotiated rental car rates (language-dependent) | 4 | LOCATIONTYPE | Geographical area type | nvarchar | 1 | 0 | | |
| 5 | TA20NCR | Negotiated Car Rental Rates | 3 | LOCATIONTYPE | Geographical area type | nvarchar | 1 | 0 | | |
| 6 | TA20NCR1 | Negotiated Car Rental Rates (Language-Dependent) | 4 | LOCATIONTYPE | Geographical area type | nvarchar | 1 | 0 | | |
| 7 | TA20NH | Negotiated hotel rates (corporate nego rates) | 3 | LOCATIONTYPE | Geographical area type | nvarchar | 1 | 0 | | |
| 8 | TA20NH1 | Negotiated hotel rates (language-dependent) | 4 | LOCATIONTYPE | Geographical area type | nvarchar | 1 | 0 | | |
| 9 | TA20NHC | Negotiated Hotel Rates | 2 | LOCATIONTYPE | Geographical area type | nvarchar | 1 | 0 | | |
| 10 | TA20NHC1 | Negotiated Hotel Rates (Language-Dependent) | 3 | LOCATIONTYPE | Geographical area type | nvarchar | 1 | 0 | | |
| 11 | TA20NRH | Discount Agreement for Hotel Accommodations | 4 | LOCATIONTYPE | Geographical area type | nvarchar | 1 | 0 | | |
