| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | USERG | Grouping: Travel Planning Control Variant | nvarchar | 2 | 0 | CHAR | (N' ') | No | | TP_CONTROL_TRVUS | Allow NULL? |
| 3 | RFCDEST | Logical RFC Destination to API | nvarchar | 32 | 0 | CHAR | (N' ') | No | RFCDES | RFCDEST_API | Allow NULL? |
| 4 | SUBSCRIPTION | GDS Identification | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | TA20A | SUBSCRIPTION_ID | Allow NULL? |
| 5 | CORPORATE | Corporate Identification | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | TA20A | CORPORATE_ID | Allow NULL? |
| 6 | UNAME_FLAG | Indicator: Use SAP User Name as GDS User User | char | 1 | 0 | CHAR | (N' ') | Yes | | UNAME_FLAG | Allow NULL? |
| 7 | USERID | User Identification | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | USER_ID | Allow NULL? |
| 8 | FDISPLAY | Display strategy of flight availability | char | 1 | 0 | CHAR | (N' ') | Yes | | FLIGHT_DISPLAY_METHOD | Allow NULL? |
| 9 | FFARE_STRAT | Rebooking according to travel profile only | char | 1 | 0 | CHAR | (N' ') | Yes | | FFARE_STRATEGY | Allow NULL? |
| 10 | FFARE_TYPES | Lowest Fare Search | char | 1 | 0 | CHAR | (N' ') | Yes | | FFARE_TYPES | Allow NULL? |
| 11 | HDISPLAY | Display strategy for hotel availability | char | 1 | 0 | CHAR | (N' ') | Yes | | HOTEL_DISPLAY_METHOD | Allow NULL? |
| 12 | HDISPLAY_ROOM | Room list display method | char | 1 | 0 | CHAR | (N' ') | Yes | | ROOMLIST_DISPLAY_METHOD | Allow NULL? |
| 13 | HFARE_STRAT | Apply negotiated hotel rates | char | 1 | 0 | CHAR | (N' ') | Yes | | HFARE_STRATEGY | Allow NULL? |
| 14 | HCTG_ACTIVE | Hotel catalog active | char | 1 | 0 | CHAR | (N' ') | Yes | | HOTEL_CATALOGUE_ACTIVE | Allow NULL? |
| 15 | HCTG_DISPLAY | Hotel catalog display method | char | 1 | 0 | CHAR | (N' ') | Yes | | HOTEL_CATALOGUE_DISPLAY_METHOD | Allow NULL? |
| 16 | HCTG_DISP_ROOM | Hotel catalog room list display method | char | 1 | 0 | CHAR | (N' ') | Yes | | HOTEL_CTG_ROOM_DISPLAY_METHOD | Allow NULL? |
| 17 | HCTG_NEGO_STRAT | Negotiated hotel rates from hotel catalog | char | 1 | 0 | CHAR | (N' ') | Yes | | HOTEL_CATALOGUE_NEGO | Allow NULL? |
| 18 | HCTG_NEGO_CHECK | Ind.: Availability check for negotiated rates | char | 1 | 0 | CHAR | (N' ') | Yes | | HOTEL_CATALOGUE_NEGO_CHECK | Allow NULL? |
| 19 | CDISPLAY | Display strategy for car rental availability | char | 1 | 0 | CHAR | (N' ') | Yes | | CAR_DISPLAY_METHOD | Allow NULL? |
| 20 | CFARE_STRAT | Negotiated car rental rates only (if available) | char | 1 | 0 | CHAR | (N' ') | Yes | | CFARE_STRATEGY | Allow NULL? |
| 21 | CDISPLAY_CAR | Display meth. car rental list | char | 1 | 0 | CHAR | (N' ') | Yes | | CARLIST_DISPLAY_METHOD | Allow NULL? |
| 22 | CDISPLAY_MIX | Provider list with best-price vehicle | char | 1 | 0 | CHAR | (N' ') | Yes | | CAR_DISPLAY_MIX | Allow NULL? |
| 23 | FRT_STRATEGY | Strategy for Round Trip | char | 1 | 0 | CHAR | (N' ') | Yes | | ROUNDTRIP_STRATEGY | Allow NULL? |
| 24 | HOTEL_OPTIONS | Hotel: Optional Parameter Entry | char | 1 | 0 | CHAR | (N' ') | Yes | | HOTEL_OPTIONS | Allow NULL? |
| 25 | CAR_OPTIONS | Rental Car: Extended Search Possible | char | 1 | 0 | CHAR | (N' ') | Yes | | CAR_OPTIONS | Allow NULL? |
| 26 | AUTO_PRICING | Setting: Automatic Airfare Determination | char | 1 | 0 | CHAR | (N' ') | Yes | | FLIGHT_AUTO_PRICING | Allow NULL? |
| 27 | HOTEL_FILTER_CAT | Hotel Availability Query: Catalog before Hotel Chain Limits | char | 1 | 0 | CHAR | (N' ') | Yes | | HOTEL_FILTER_CAT | Allow NULL? |
| 28 | RT_DISPLAY_STRAT | Display Strategy for Round Trip | char | 1 | 0 | CHAR | (N' ') | Yes | | RT_DISPLAY_STRAT | Allow NULL? |
| 29 | F_LOWFARE_LIST | Display Type Fare-driven Flight Availability | char | 1 | 0 | CHAR | (N' ') | Yes | | FLIGHT_LF_LIST | Allow NULL? |
| 30 | FLIGHT_RAIL_LIST | Combined Display of Flight and Rail | char | 1 | 0 | CHAR | (N' ') | Yes | | FLIGHT_RAIL_LIST | Allow NULL? |
