• CHECKDIGIT
• COMMISSIONONEXCHGTICKETAMT
• COMMISSIONONPENALTY
• CREDITVOUCHER
• EXCHANGEINFOID
• FORFEITAMOUNT
• FORMOFPAYMENTADDCOLLECTAMOUNT
• ISSUEDATE
• ISSUINGCITY
• ISSUINGIATA
• NEWTICKETCOMMISSION
• ORIGINAL_TICKET_COMMISSION
• ORIGINAL_TICKET_NUMBER
• ORIGINAL_TICKET_TYPE
• ORIGINALBOARDCITY
• ORIGINALFORMOFPAYMENT
• ORIGINALOFFCITY
• ORIGINALTICKETAMOUNT
• PENALTIES_TO_BE_DEDUCTED
• PNR_ID
• PNR_LAST_UPDATED_DATE
• REFUND_AMOUNT
• REFUND_INFORM_OF_MCO
• STORED_FARE_NUMBER
• TOTAL_ADD_COLLECT_AMOUNT
• TYPE
• UNUSED_PFCS

CHECKDIGIT

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

COMMISSIONONEXCHGTICKETAMT

Format NUMBER

Indexed? No

May be Null? Yes

COMMISSIONONPENALTY

Format NUMBER

Indexed? No

May be Null? Yes

CREDITVOUCHER

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

EXCHANGEINFOID

Format VARCHAR2(30)

Indexed? Yes

May be Null? Yes

FORFEITAMOUNT

Format NUMBER

Indexed? No

May be Null? Yes

FORMOFPAYMENTADDCOLLECTAMOUNT

Format NUMBER

Indexed? No

May be Null? Yes

ISSUEDATE

Format DATE

Indexed? No

May be Null? Yes

ISSUINGCITY

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

ISSUINGIATA

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

NEWTICKETCOMMISSION

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

ORIGINAL_TICKET_COMMISSION

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

ORIGINAL_TICKET_NUMBER

Format VARCHAR2(30)

Indexed? Yes

May be Null? Yes

ORIGINAL_TICKET_TYPE

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

ORIGINALBOARDCITY

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

ORIGINALFORMOFPAYMENT

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

ORIGINALOFFCITY

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

ORIGINALTICKETAMOUNT

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

PENALTIES_TO_BE_DEDUCTED

Format NUMBER

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 exchange info 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 exchange info record was last updated. 

REFUND_AMOUNT

Format NUMBER

Indexed? No

May be Null? Yes

REFUND_INFORM_OF_MCO

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

STORED_FARE_NUMBER

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

TOTAL_ADD_COLLECT_AMOUNT

Format NUMBER

Indexed? No

May be Null? Yes

TYPE

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

UNUSED_PFCS

Format VARCHAR2(30)

Indexed? No

May be Null? Yes