XM_CREDIT_CARD_TRANSACTION

Entity Name XM_CREDIT_CARD_TRANSACTION
Entity Type Independent
Definition Includes information on all downloaded credit card transactions

Attributes

Attribute Datatype Width Definition
CREDIT_CARD_TRANSACTION_ID Integer 11 PK
CREDIT_CARD_ID Integer 11 FK into CREDIT_CARD table
MERCHANT_NAME Varchar 40 Merchant name
MERCHANT_CITY Varchar 31 Merchant city
MERCHANT_STATE Varchar 3 Merchant state
MERCHANT_COUNTRY Varchar 22 Merchant country
MERCHANT_GIVEN_SIC_CODE Varchar 20 Merchant given sic code
MERCHANT_STD_SIC_CODE Varchar 4 Merchant Std Sic Code
MERCHANT_VAT_NUMBER Varchar 20 Merchant Vat Number
VENDOR_NAME Varchar 255 Vendor Name
TRANSACTION_REFERENCE Varchar 43 CC company's reference number. Not guaranteed unique, but almost always will be.
TRANSACTION_TYPE Integer 1 1 = debit, 2 = credit
DUE_CC_CO_AMOUNT Float 10 Due cc co amount
DUE_CC_CO_AMOUNT_CURRENCY Varchar 3 Due cc co amount currency
POSTING_DATE DateTime The date the transaction was posted.
TRANSACTION_DATE DateTime The date the transaction was actually made.
VAT_AMOUNT Float 3 VAT amount in native currency
VAT_AMOUNT_CURRENCY Varchar 3 Vat amount currency
TRANSACTION_AMOUNT Float 10 The amount of the transaction.
TRANSACTION_AMOUNT_CURRENCY Varchar 3 Transaction amount currency
TRANSACTION_STATUS Integer 1 Flag to indicate if this row of data is currently active for application.
IMPORT_DATE DateTime The date and time the transaction was imported into the Extensity database from the credit card feed.
DOCUMENT_ID Integer 11 Document id
AIRLINE_DEPARTURE_DATE DateTime Air departure date
AIRLINE_ROUTING Varchar 35 Airline routing
AIRLINE_CLASS_OF_SERVICE Varchar 11 Airline class of service
AIRLINE_TRAVEL_AGENCY Varchar 40 Airline travel agency
AIRLINE_TICKET_NUMBER Varchar 15 Airline ticket number
CAR_RENTAL_AGREEMENT_NUMBER Varchar 14 Car rental agreement
HOTEL_ARRIVAL_DATE DateTime Hotel arrival date
HOTEL_DEPARTURE_DATE DateTime Hotel departure date
HOTEL_STAY_DURATION Integer 3 Hotel stay duration
HOTEL_FOLIO_REF_NUMBER Varchar 10 Hotel folio reference number
HOTEL_ROOM_TYPE Varchar 30 Hotel room type
HOTEL_ROOM_AMOUNT Float 7 Hotel room amount
HOTEL_CURRENCY Varchar 3 Hotel currency
HOTEL_ROOM_TAX_1 Float 5 Hotel room tax 1
HOTEL_ROOM_TAX_2 Float 3 Hotel room tax 2
HOTEL_PHONE_AMOUNT Float 5 Hotel phone amount
HOTEL_PHONE_TAX_1 Float 3 Hotel phone tax 1
HOTEL_PHONE_TAX_2 Float 3 Hotel phone tax 2
HOTEL_RESTAURANT_AMOUNT Float 6 Hotel restaurant amount
HOTEL_RESTAURANT_TAX_1 Float 3 Hotel restaurant tax 1
HOTEL_RESTAURANT_TAX_2 Float 3 Hotel restaurant tax 2
HOTEL_ROOM_SERVICE_AMOUNT Float 3 Hotel room service amount
HOTEL_ROOM_SERVICE_TAX_1 Float 3 Hotel room service tax 1
HOTEL_ROOM_SERVICE_TAX_2 Float 3 Hotel room service tax 2
HOTEL_TIP_AMOUNT_1 Float 3 Hotel tip amount 1
HOTEL_TIP_AMOUNT_2 Float 3 Hotel tip amount 2
HOTEL_OTHERS_AMOUNT Float 6 Hotel others amount
HOTEL_OTHERS_TAX_1 Float 3 Hotel others tax 1
HOTEL_OTHERS_TAX_2 Float 3 Hotel other tax 2
HOTEL_ROOM_RATE Float 7 Hotel room rate
HOTEL_ROOM_TAX_DIALY Float 3 Hotel room tax daily
HOTEL_LAUNDRY_AMOUNT Float 3 Hotel laundry amount
HOTEL_GIFT_SHOP_AMOUNT Float 3 Hotel gift shop amount
HOTEL_MOVIE_AMOUNT Float 3 Hotel movie amount
HOTEL_BUS_CENTER_AMOUNT Float 3 Hotel bus center amount
HOTEL_HEALTH_CLUB_AMOUNT Float 3 Hotel health club amount
HOTEL_TOTAL_TAX Float 3 Hotel total tax
ORIGIN_AIRPORT Varchar 3 Original airport
DESTINATION_AIRPORT Varchar 3 Destination airport
CHANGE_TIMESTAMP DateTime Change timestamp
TRANSACTION_DESCRIPTION Varchar 235 Transaction description
TRANSACTION_STATUS_INT Integer 1 Used to indicate to the user whether this transaction has been attached to an expense report.
TRANSACTION_SEQUENCE_NUM Integer 6 Stores the sequence number used by the VCF40 (VISA) feed. It is used as part of the combination key to uniquely identify a transaction.
TRANSACTION_STATEMENT_DATE DateTime The date of the statement this transaction belongs to
PRIMARY_ISO_CURRENCY_CODE Integer 3 Primary ISO Currency Code. Used in Amex global remittance.
GLOBAL_CLIENT_ORIGIN_ID Integer 15 A number used to represent a Corporate client. Used in Amex global remittance.
TRANSACTION_TYPE_CODE Integer 4 Transaction type code. Sometimes called MIS industry code.
TAX1 Float 7 Tax 1
TAX1_CURRENCY Varchar 3 Currency for tax1
TAX2 Float 7 Tax 2
TAX2_CURRENCY Varchar 3 Currency for tax2
TAX1_INCLUDED Integer 1 1 if tax1 is included; 0 or null otherwise
TAX2_INCLUDED Integer 1 1 if tax2 is included; 0 or null otherwise
MERCHANT_ADDRESS Varchar 38 Merchant address. If there is more than one address line in the feed, this is the first line.
ASSIGNED_TRANSACTION_USER_ID Integer 1 Assigned transaction user id