Penn Computing

University of Pennsylvania
Penn Computing << go backback
CT_CREDIT_CARD_TRANSACTION Table   Tables and Data Elements   Travel & Expense Management Home    Data Warehouse Home

CT_CREDIT_CARD_TRANSACTION Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

 



Data element Definition
CA_KEY

Indexed - yes
Format - number
May be null? yes
Unique system-assigned key that identifies a cash advance that may have been created by the import of the credit card transaction.
CCA_KEY

Indexed - yes
Format - number
May be null? yes
Unique system-assigned key that identifies the credit card account on which the transaction was charged.
CCT_KEY

Indexed - yes
Format - number
May be null? no
Unique system-assigned key that identifies the credit card transaction.
CCT_TYPE

Indexed - yes
Format - char(3)
May be null? yes

Indicates the type of credit card transaction:
• CHG = Charge
• PAY = Payment
• CAV = Cash Advance
• RPE = Credit

GST_OR_VAT_AMT

Indexed - no
Format - number
May be null? yes
GST or VAT amount.
LAST_MODIFIED

Indexed - no
Format - date
May be null? yes
Date on which the credit card transaction record was last modified.
LOCAL_TAX_AMT

Indexed - no
Format - number
May be null? yes
Local tax amount.
MC_CODE

Indexed - yes
Format - varchar2(5)
May be null? yes
Code that identifies the merchant, or vendor, with whom the transaction was conducted.
MERCHANT_CITY

Indexed - no
Format - varchar2(32)
May be null? yes
City or location where the merchant is located.
MERCHANT_CTRY_CODE

Indexed - yes
Format - char(2)
May be null? yes
Country where the merchant is located.
MERCHANT_NAME

Indexed - no
Format - varchar2(32)
May be null? yes
Name of the merchant, or vendor, with whom the transaction was conducted. Note that Merchant Name on the credit card transaction may differ from the Vendor Description at the Report Entry level, depending on how the merchant is represented in the credit card feed to Concur.
MERCHANT_STATE

Indexed - no
Format - varchar2(32)
May be null? yes
State, province, or region where the merchant is located.
MERCHANT_ZIP

Indexed - no
Format - varchar2(20)
May be null? yes
Postal code that applies to the merchant location.
OTHER_TAX_AMT

Indexed - no
Format - number
May be null? yes
Other tax amount.
POSTED_AMOUNT

Indexed - no
Format - number
May be null? yes
Transaction amount.
POSTED_DATE

Indexed - no
Format - date
May be null? yes
Date the transaction was incurred.
REF_NO

Indexed - no
Format - varchar2(50)
May be null? yes
Reference number that identifies the transaction for the merchant.
SALES_TAX_AMT

Indexed - no
Format - number
May be null? yes
Sales tax amount.
TAX_AMOUNT

Indexed - no
Format - number
May be null? yes
Tax amount.
TRANSACTION_AMOUNT

Indexed - no
Format - number
May be null? yes
Amount of the transaction in the currency in which the transaction was incurred.
TRANSACTION_DATE

Indexed - no
Format - date
May be null? yes
Date the transaction was posted to the credit card's systems.
TRANSACTION_DESCRIPTION

Indexed - no
Format - varchar2(32)
May be null? yes
Further description of the transaction.
TRANSACTION_ID

Indexed - no
Format - varchar2(32)
May be null? yes
Unique number that identifies the credit card transaction.
TRANSACTION_STATUS

Indexed - no
Format - char(2)
May be null? yes

Code that indicates the availability status of the credit card transaction:
• AS = Assigned to report
• BA = Prior to card assignment
• CH = Configuration hidden
• ED = Prior to effective date
• HD = User hidden
• PD = Potential duplicate
• PH = Payment hidden
• UN = Unassigned to report.


CT_CREDIT_CARD_TRANSACTION Table   Tables and Data Elements   Travel & Expense Management Home    Data Warehouse Home


Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania