| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPTravel Planning |
| 1 | TA20NHS | Negotiated Hotel Rates (Nego Rates) with Catalog Hotel | 2 | HOTEL_ID | Hotel Catalog Item (enterprise-specific) | nvarchar | 8 | 0 | | |
| 2 | TA20NRHS | Discount Agreement for Hotels (Individual Hotel) | 2 | HOTEL_ID | Hotel Catalog Item (enterprise-specific) | nvarchar | 8 | 0 | | |
| 3 | TA20PHC | Assignment Table of Hotel Catalog Items for Travel Profiles | 5 | HOTEL_ID | Hotel Catalog Item (enterprise-specific) | nvarchar | 8 | 0 | | |
| 4 | TA21PH | Customer-Specific Hotel Catalog | 2 | HOTEL_ID | Hotel Catalog Item (enterprise-specific) | nvarchar | 8 | 0 | | |
| 5 | TA21PHC | Hotel Codes of a Catalog Hotel in Reservation System | 2 | HOTEL_ID | Hotel Catalog Item (enterprise-specific) | nvarchar | 8 | 0 | | |
