| Data element |
Definition |
CCT_KEY
Indexed - yes
Format - number
May be null? no |
Unique system-assigned key that identifies a credit card transaction. |
BASE_FARE
Indexed - no
Format - number
May be null? yes |
Base fare amount. |
CUSTOMER_CODE
Indexed - yes
Format - varchar2(30)
May be null? yes |
|
DEPARTURE_DATE
Indexed - no
Format - date
May be null? yes |
Date of departure. |
ETICKET_FLAG
Indexed - no
Format - char(1)
May be null? yes |
Indicates whether the ticket was an electronic ticket. |
EXCHANGED_TICKET_AMT
Indexed - no
Format - number
May be null? yes |
Amount of the ticket that was exchanged. |
EXCHANGED_TICKET_NUM
Indexed - no
Format - varchar2(30)
May be null? yes |
Number of the ticket that was exchanged. |
ISSUE_DATE
Indexed - no
Format - date
May be null? yes |
Date of issue of the travel ticket. |
ISSUING_CARRIER
Indexed - no
Format - varchar2(20)
May be null? yes |
Name of the carrier that issued the travel ticket. |
LAST_MODIFIED
Indexed - no
Format - date
May be null? yes |
Date on which the credit card travel transaction record was last modified. |
NUM_OF_LEGS
Indexed - no
Format - number
May be null? yes |
Number of legs associated with the travel transaction. |
PASSENGER_NAME
Indexed - no
Format - varchar2(50)
May be null? yes |
Name of the passenger associated with the travel transaction. |
REFUND_TICKET_NUM
Indexed - no
Format - varchar2(30)
May be null? yes |
Number of the ticket that was refunded. |
RESTRICTED_FLAG
Indexed - no
Format - char(1)
May be null? yes |
|
TICKET_NUM
Indexed - no
Format - varchar2(32)
May be null? yes |
Travel ticket number associated with the transaction. |
TOTAL_FARE
Indexed - no
Format - number
May be null? yes |
Total fare amount. |
TOTAL_FEE
Indexed - no
Format - number
May be null? yes |
Total amount of fees. |
TRAVEL_AGENCY_CODE
Indexed - yes
Format - varchar2(8)
May be null? yes |
Travel agency code. |
TRAVEL_AGENCY_NAME
Indexed - no
Format - varchar2(50)
May be null? yes |
Travel agency code. |
