• ACCEPTED_CURR_CODE
• ACCEPTED_FARE
• BASE_CURR_CODE
• BASE_FARE
• COMMISSION
• DISCOUNT_MODIFIER
• ENDORSEMENTS
• HIGH_CURR_CODE
• HIGH_FARE
• IT_NUMBER
• LAST_DATE_TO_TICKET
• LOW_CURR_CODE
• LOW_FARE
• LOW_FARE_REASON
• PNR_ID
• PNR_LAST_UPDATED_DATE
• QUOTE_DATE_TIME
• STORED_FARE_ID
• TOTAL_CURR_CODE
• TOTAL_FARE

ACCEPTED_CURR_CODE

Format VARCHAR2(9)

Indexed? No

May be Null? Yes

ACCEPTED_FARE

Format NUMBER

Indexed? No

May be Null? Yes

BASE_CURR_CODE

Format VARCHAR2(9)

Indexed? No

May be Null? Yes

BASE_FARE

Format NUMBER

Indexed? No

May be Null? Yes

COMMISSION

Format NUMBER

Indexed? No

May be Null? Yes

DISCOUNT_MODIFIER

Format VARCHAR2(9)

Indexed? No

May be Null? Yes

ENDORSEMENTS

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

HIGH_CURR_CODE

Format VARCHAR2(3)

Indexed? No

May be Null? Yes

HIGH_FARE

Format NUMBER

Indexed? No

May be Null? Yes

IT_NUMBER

Format VARCHAR2(12)

Indexed? No

May be Null? Yes

LAST_DATE_TO_TICKET

Format DATE

Indexed? No

May be Null? Yes

LOW_CURR_CODE

Format VARCHAR2(3)

Indexed? No

May be Null? Yes

LOW_FARE

Format NUMBER

Indexed? No

May be Null? Yes

LOW_FARE_REASON

Format VARCHAR2(2)

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 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. 

QUOTE_DATE_TIME

Format DATE

Indexed? No

May be Null? Yes

STORED_FARE_ID

Format VARCHAR2(30)

Indexed? Yes

May be Null? Yes

TOTAL_CURR_CODE

Format VARCHAR2(9)

Indexed? No

May be Null? Yes

TOTAL_FARE

Format NUMBER

Indexed? No

May be Null? Yes