| Data element |
Definition |
BASE_CURR_CODE
Format VARCHAR2(9)
Indexed? No
May be Null? Yes |
The base rental rate currency code for this ticket. |
BASE_FARE
Format NUMBER
Indexed? No
May be Null? Yes |
The base rental rate amount for this ticket. |
COMMISSION
Format NUMBER
Indexed? No
May be Null? Yes |
|
DISCOUNT_MODIFIER
Format VARCHAR2(5)
Indexed? No
May be Null? Yes |
|
ENDORSEMENTS
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
|
ENTERED_TEXT
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
|
IS_ETICKET
Format VARCHAR2(1)
Indexed? No
May be Null? Yes |
E- Ticket Flag.
Values:
0
1 |
ISSUE_DATE_TIME
Format DATE
Indexed? No
May be Null? Yes |
The date/time this was issued. |
ISSUING_CARRIER
Format VARCHAR2(2)
Indexed? Yes
May be Null? Yes |
|
IT_NUMBER
Format VARCHAR2(12)
Indexed? No
May be Null? Yes |
|
PNR_ID
Format VARCHAR2(16)
Indexed? Yes
May be Null? No |
The Passenger Name Record (PNR) associated with this ticket. |
PNR_LAST_UPDATED_DATE
Format DATE
Indexed? Yes
May be Null? No |
The the date that the Passenger Name Record (PNR) associated with this ticket record was last updated. |
SEGMENT_TYPE
Format VARCHAR2(4)
Indexed? No
May be Null? Yes |
|
TICKET_ID
Format VARCHAR2(30)
Indexed? No
May be Null? Yes |
|
TICKET_NUMBER
Format VARCHAR2(13)
Indexed? Yes
May be Null? Yes |
The ticket number. |
TICKET_STATUS
Format VARCHAR2(4)
Indexed? No
May be Null? Yes |
The two character status code for this ticket.
Values: Unknown |
TOTAL_CURR_CODE
Format VARCHAR2(9)
Indexed? No
May be Null? Yes |
The base rental rate currency code for this ticket. |
TOTAL_FARE
Format NUMBER
Indexed? No
May be Null? Yes |
The base rental rate amount for this ticket. |
