| Data element |
Definition |
APPROVER
Format VARCHAR(8)
Indexed? No
May be Null? Yes |
|
BASE_RATE_AMT
Format VARCHAR(6)
Indexed? No
May be Null? Yes |
The base rental rate amount for this car segment. |
BASE_RATE_CURR_CODE
Format VARCHAR(3)
Indexed? No
May be Null? Yes |
The base rental rate currency code for this car segment. |
CAR_COMPANY
Format VARCHAR(2)
Indexed? No
May be Null? Yes |
The two character rental car company code for this car segment. |
CAR_COMPANY_NAME
Format VARCHAR(1000)
Indexed? No
May be Null? Yes |
The rental car company name for this car segment. |
CAR_RATE_CATEGORY
Format VARCHAR(7)
Indexed? No
May be Null? Yes |
The rental rate category for this car segment.
Values: |
CAR_SEGMENT_ID
Format VARCHAR2(30)
Indexed? No
May be Null? Yes |
|
CD_NUMBER
Format VARCHAR(9)
Indexed? No
May be Null? Yes |
|
CONFIRMATION
Format VARCHAR(15)
Indexed? No
May be Null? Yes |
The confirmation number for this car segment. |
DECLINED_AMT
Format NUMBER
Indexed? No
May be Null? Yes |
|
DECLINED_VENDOR_CODE
Format VARCHAR(7)
Indexed? No
May be Null? Yes |
|
DROPOFF_CITY_CODE
Format VARCHAR(3)
Indexed? Yes
May be Null? Yes |
The dropoff city IATA code for this car segment. |
DROPOFF_CITY_NAME
Format VARCHAR(1000)
Indexed? No
May be Null? Yes |
The dropoff city name for this car segment. |
DROPOFF_COUNTRY
Format VARCHAR2(1000)
Indexed? No
May be Null? Yes |
The dropoff country name for this car segment. |
DROPOFF_COUNTRY_CODE
Format VARCHAR2(2)
Indexed? Yes
May be Null? Yes |
The two character dropoff country code for this car segment. |
DROPOFF_DATE_TIME
Format DATE
Indexed? Yes
May be Null? Yes |
The dropoff date/time for this car segment. |
DROPOFF_LOCATION_CODE
Format VARCHAR(9)
Indexed? Yes
May be Null? Yes |
|
EXCEPTION_CODE
Format VARCHAR2(30)
Indexed? No
May be Null? Yes |
|
ID_NUMBER
Format VARCHAR(11)
Indexed? No
May be Null? Yes |
|
IN_POLICY
Format VARCHAR(1)
Indexed? No
May be Null? Yes |
|
MISC_1
Format VARCHAR(200)
Indexed? No
May be Null? Yes |
|
MISC_2
Format VARCHAR(200)
Indexed? No
May be Null? Yes |
|
PHONE_NUMBER
Format VARCHAR(12)
Indexed? No
May be Null? Yes |
|
PICKUP_CITY_CODE
Format VARCHAR(3)
Indexed? Yes
May be Null? Yes |
The pickup city IATA code for this car segment. |
PICKUP_CITY_NAME
Format VARCHAR(1000)
Indexed? No
May be Null? Yes |
The pickup city name for this car segment. |
PICKUP_COUNTRY
Format VARCHAR2(1000)
Indexed? No
May be Null? Yes |
The pickup country name for this car segment. |
PICKUP_COUNTRY_CODE
Format VARCHAR2(2)
Indexed? Yes
May be Null? Yes |
The two character pickup country code for this car segment. |
PICKUP_DATE_TIME
Format DATE
Indexed? Yes
May be Null? Yes |
The pickup date/time for this car segment. |
PICKUP_LOCATION_CODE
Format VARCHAR(25)
Indexed? Yes
May be Null? Yes |
|
PNR_ID
Format VARCHAR2(16)
Indexed? Yes
May be Null? No |
The Passenger Name Record (PNR) associated with this car segment record. |
PNR_LAST_UPDATED_DATE
Format DATE
Indexed? Yes
May be Null? No |
The the date that the Passenger Name Record (PNR) associated with this car segment record was last updated. |
POLICY_EXCEPTION_RMK
Format VARCHAR(200)
Indexed? No
May be Null? Yes |
|
POLICY_THRESHOLD
Format VARCHAR2(30)
Indexed? No
May be Null? Yes |
|
POLICY_VIOLATION_CODE
Format VARCHAR2(30)
Indexed? No
May be Null? Yes |
|
RATE_CODE
Format VARCHAR(6)
Indexed? No
May be Null? Yes |
|
RATE_TEXT
Format VARCHAR(200)
Indexed? No
May be Null? Yes |
|
SEGMENT_NUMBER
Format NUMBER
Indexed? Yes
May be Null? No |
A numeric value specifying the itinerary segment number for this car segment. |
STATUS
Format VARCHAR(2)
Indexed? No
May be Null? Yes |
The two character status code for this car segment.
Values: Unknown |
VEHICLE_CODE
Format VARCHAR(4)
Indexed? No
May be Null? Yes |
|
