| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPTravel Planning |
| 1 | FTPT_HOTEL | Travel Request Item - Hotel Service | 17 | ROOMTYPE | Hotel Room Type | nvarchar | 1 | 0 | | |
| 2 | FTPT_QT_HOTEL | Quicktrip Travel Request Item - Flight Service | 13 | ROOMTYPE | Hotel Room Type | nvarchar | 1 | 0 | | |
| 3 | TA20NH | Negotiated hotel rates (corporate nego rates) | 8 | ROOMTYPE | Room type of negotiated rate | nvarchar | 1 | 0 | | |
| 4 | TA20NH1 | Negotiated hotel rates (language-dependent) | 9 | ROOMTYPE | Room type of negotiated rate | nvarchar | 1 | 0 | | |
| 5 | TA20NHS | Negotiated Hotel Rates (Nego Rates) with Catalog Hotel | 5 | ROOMTYPE | Room type of negotiated rate | nvarchar | 1 | 0 | | |
| 6 | TA20NRH | Discount Agreement for Hotel Accommodations | 8 | ROOMTYPE | Room type of negotiated rate | nvarchar | 1 | 0 | | |
| 7 | TA20NRHS | Discount Agreement for Hotels (Individual Hotel) | 4 | ROOMTYPE | Room type of negotiated rate | nvarchar | 1 | 0 | | |
| 8 | TA21HOZ | Assignment Room Category - Class Rule | 3 | ROOMTYPE | Room type | nvarchar | 1 | 0 | | |
