| Data element |
Definition |
CARRIER
Format VARCHAR2(13)
Indexed? No
May be Null? Yes |
The code share carrier code for this stored fare segment |
CLASS_OF_SERVICE
Format VARCHAR2(13)
Indexed? No
May be Null? Yes |
The class of service code for this stored fare segment |
DEPARTURE_AIRPORT_CODE
Format VARCHAR2(3)
Indexed? No
May be Null? Yes |
The departure stored fareport IATA code for this stored fare segment. |
DEPARTURE_AIRPORT_COUNTRY
Format VARCHAR2(1000)
Indexed? No
May be Null? Yes |
The two character departure stored fareport country code for this stored fare segment. |
DEPARTURE_AIRPORT_COUNTRY_CODE
Format VARCHAR2(2)
Indexed? No
May be Null? Yes |
The departure country for this stored fare segment. |
DEPARTURE_AIRPORT_NAME
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The departure name for this stored fare segment. |
DEPARTURE_DATE_TIME
Format DATE
Indexed? No
May be Null? Yes |
The departure date/time for this stored fare segment. |
FARE_BASIS
Format VARCHAR2(13)
Indexed? No
May be Null? Yes |
|
FLIGHT_NUMBER
Format VARCHAR2(13)
Indexed? No
May be Null? Yes |
The stored fare number for this stored fare segment. |
PNR_ID
Format VARCHAR2(16)
Indexed? Yes
May be Null? No |
The Passenger Name Record (PNR) associated with this stored fare. |
PNR_LAST_UPDATED_DATE
Format DATE
Indexed? Yes
May be Null? No |
The the date that the Passenger Name Record (PNR) associated with this stored fare record was last updated. |
SEGMENT_NUMBER
Format VARCHAR2(2)
Indexed? Yes
May be Null? Yes |
A numeric value specifying the itinerary segment number for this stored fare. |
STORED_FARE_ID
Format VARCHAR2(30)
Indexed? Yes
May be Null? Yes |
|
TICKET_DESIGNATOR
Format VARCHAR2(13)
Indexed? No
May be Null? Yes |
|
