| Data element |
Definition |
CCT_KEY
Indexed - yes
Format - number
May be null? no |
Unique system-assigned key that identifies a credit card transaction. |
DESTINATION_CITY
Indexed - no
Format - varchar2(64)
May be null? yes |
City in which the purchase occurred. |
DESTINATION_STATE
Indexed - no
Format - varchar2(64)
May be null? yes |
State in which the purchase occurred. |
DISCOUNT_AMT
Indexed - no
Format - number
May be null? yes |
Amount of the purchase that was discounted. |
DUTY_AMT
Indexed - no
Format - number
May be null? yes |
Duty charge for the purchase. |
INVOICE_NUM
Indexed - no
Format - varchar2(30)
May be null? yes |
Invoice number of the purchase. |
LAST_MODIFIED
Indexed - no
Format - date
May be null? yes |
Date on which the credit card purchase transaction record was last modified. |
MERCHANT_ORDER_NUM
Indexed - no
Format - varchar2(30)
May be null? yes |
Supplier’s order reference number. |
NUM_OF_LINE_ITEMS
Indexed - no
Format - number
May be null? yes |
Number of line items in the credit card purchase transaction. |
ORDER_DATE
Indexed - no
Format - date
May be null? yes |
Date on which the purchase was ordered. |
PURCHASE_DATE
Indexed - no
Format - date
May be null? yes |
Date on which the purchase was ordered. |
PURCHASE_DESCRIPTION
Indexed - no
Format - varchar2(50)
May be null? yes |
Description of the credit card purchase transaction. |
SHIP_FROM_ZIP
Indexed - no
Format - varchar2(20)
May be null? yes |
Zip code from which the purchase was shipped. |
SHIP_TO_COUNTRY
Indexed - no
Format - varchar2(64)
May be null? yes |
Country to which the purchase was shipped. |
SHIP_TO_ZIP
Indexed - no
Format - varchar2(20)
May be null? yes |
Zip code to which the purchase was shipped. |
SHIPPING_AMT
Indexed - no
Format - number
May be null? yes |
Shipping amount for the purchase. |
SUPPLIER_STATE
Indexed - no
Format - varchar2(64)
May be null? yes |
State of the purchase supplier. |
SUPPLIER_ZIP
Indexed - no
Format - varchar2(20)
May be null? yes |
Zip code of the purchase supplier. |
