| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPTravel Planning |
1 | TA20BH | Displayable Hotel Rates of User Groups | 6 | RATECODE | Hotel rate | nvarchar | 3 | 0 | | |
2 | TA20NC | Negotiated rental car rates (corporate nego rates) | 6 | RATECODE | Negotiated car rental rate | nvarchar | 3 | 0 | | |
3 | TA20NC1 | Negotiated rental car rates (language-dependent) | 7 | RATECODE | Negotiated car rental rate | nvarchar | 3 | 0 | | |
4 | TA20NCR | Negotiated Car Rental Rates | 9 | RATECODE | Code of Negotiated Car Rental Rate | nvarchar | 12 | 0 | | |
5 | TA20NH | Negotiated hotel rates (corporate nego rates) | 9 | RATECODE | Negotiated hotel rate | nvarchar | 3 | 0 | | |
6 | TA20NH1 | Negotiated hotel rates (language-dependent) | 10 | RATECODE | Hotel rate | nvarchar | 3 | 0 | | |
7 | TA20NHC | Negotiated Hotel Rates | 6 | RATECODE | Negotiated hotel rate | nvarchar | 3 | 0 | | |
8 | TA20NHC1 | Negotiated Hotel Rates (Language-Dependent) | 7 | RATECODE | Negotiated hotel rate | nvarchar | 3 | 0 | | |
9 | TA20NHS | Negotiated Hotel Rates (Nego Rates) with Catalog Hotel | 6 | RATECODE | Negotiated hotel rate | nvarchar | 3 | 0 | | |
10 | TA20NRC | Discount Agreement for Rental Car Usage | 6 | RATECODE | Rental car rate | nvarchar | 3 | 0 | | |
11 | TA20NRH | Discount Agreement for Hotel Accommodations | 3 | RATECODE | Hotel rate | nvarchar | 3 | 0 | | |
12 | TA20NRHS | Discount Agreement for Hotels (Individual Hotel) | 3 | RATECODE | Hotel rate | nvarchar | 3 | 0 | | |
13 | TA21CAR | Rental Car Rate | 2 | RATECODE | Rental car rate | nvarchar | 3 | 0 | | |
14 | TA21CAR1 | Car Rental Rates (Language-Dependent) | 3 | RATECODE | Rental car rate | nvarchar | 3 | 0 | | |
15 | TA21H | Hotel Rates | 2 | RATECODE | Hotel rate | nvarchar | 3 | 0 | | |
16 | TA21H1 | Hotel Rates (Language-Dependent) | 3 | RATECODE | Hotel rate | nvarchar | 3 | 0 | | |
TOPUSA |
17 | BRCDTA | BSI-TAX 4.0 BRCDTA | 26 | RATECODE | BSI40: RATECODE | nvarchar | 1 | 0 | | |
18 | BRCGDTA | BSI-TAX 4.0 BRCGDTA | 26 | RATECODE | BSI40: RATECODE | nvarchar | 1 | 0 | | |