| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPTravel Planning |
1 | TA20NEGOF | Negotiated Flight Fares (Corporate Nego Fares) | 4 | GEOORG | Geographical Origin | nvarchar | 3 | 0 | | |
2 | TA20NEGOF1 | Negotiated Flight Fares (Language-Dependent) | 5 | GEOORG | Geographical Origin | nvarchar | 3 | 0 | | |
3 | TA20PIF | Flight Trip Rule | 5 | GEOORG | Geographical Origin | nvarchar | 3 | 0 | | |
4 | TA20PVP | Setting for Lowest Fare Availability Search | 5 | GEOORG | Geographical Origin | nvarchar | 3 | 0 | | |
5 | TA20REBF | Discount Agreement for Flights | 4 | GEOORG | Geographical Origin | nvarchar | 3 | 0 | | |
6 | TA20RTG_G | Geographical Description of a Route Segment | 7 | GEOORG | Geographical Origin | nvarchar | 3 | 0 | | |
7 | TA22CEXC | RBD Assignment of Airline Exceptions | 5 | GEOORG | Geographical Origin | nvarchar | 3 | 0 | | |
8 | TA23CEXC | RBD assignment of airline exceptions | 7 | GEOORG | Geographical Origin | nvarchar | 3 | 0 | | |
9 | TA23PAF_CONN | Assignment of Airline Programs Corporate Cust. - Route/Class | 4 | GEOORG | Geographical Origin | nvarchar | 3 | 0 | | |
10 | TA23PIF | Flight Trip Rule (Filter before Availability Query) | 4 | GEOORG | Geographical Origin | nvarchar | 3 | 0 | | |
11 | TA23PIFT | Trip Rule for Mandatory Combined Display of Flights/Rail | 4 | GEOORG | Geographical Origin | nvarchar | 3 | 0 | | |
12 | TA23PIT | Flight Trip Rule | 5 | GEOORG | Geographical Origin | nvarchar | 3 | 0 | | |
13 | TA23_PAPTF | Additional Airport for Availability Query | 4 | GEOORG | Geographical Origin | nvarchar | 3 | 0 | | |