| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPTravel Planning |
| 1 | TA20NC | Negotiated rental car rates (corporate nego rates) | 10 | PUSE | Private usage permitted | nvarchar | 1 | 0 | | |
| 2 | TA20NCR | Negotiated Car Rental Rates | 10 | PUSE | Private usage permitted | nvarchar | 1 | 0 | | |
| 3 | TA20NEGOF | Negotiated Flight Fares (Corporate Nego Fares) | 15 | PUSE | Private usage permitted | nvarchar | 1 | 0 | | |
| 4 | TA20NF | Negotiated Flight Fares (Corporate Nego Fares) | 12 | PUSE | Private usage permitted | nvarchar | 1 | 0 | | |
| 5 | TA20NH | Negotiated hotel rates (corporate nego rates) | 13 | PUSE | Private usage permitted | nvarchar | 1 | 0 | | |
| 6 | TA20NHC | Negotiated Hotel Rates | 11 | PUSE | Private usage permitted | nvarchar | 1 | 0 | | |
| 7 | TA20NHS | Negotiated Hotel Rates (Nego Rates) with Catalog Hotel | 10 | PUSE | Private usage permitted | nvarchar | 1 | 0 | | |
| 8 | TA20NRC | Discount Agreement for Rental Car Usage | 10 | PUSE | Private usage permitted | nvarchar | 1 | 0 | | |
| 9 | TA20NRF | Discount Agreement for Flights | 12 | PUSE | Private usage permitted | nvarchar | 1 | 0 | | |
| 10 | TA20NRH | Discount Agreement for Hotel Accommodations | 13 | PUSE | Private usage permitted | nvarchar | 1 | 0 | | |
| 11 | TA20NRHS | Discount Agreement for Hotels (Individual Hotel) | 9 | PUSE | Private usage permitted | nvarchar | 1 | 0 | | |
| 12 | TA20REBF | Discount Agreement for Flights | 14 | PUSE | Private usage permitted | nvarchar | 1 | 0 | | |
