Penn Computing

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

CT_MERCHANT_CODE Table - Data Element Index

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



Data element Definition
EXP_KEY

Indexed - yes
Format - char(5)
May be null? yes
Unique system-assigned key that identifies the expense type associated with the merchant.
MC_CODE

Indexed - yes
Format - varchar2(5)
May be null? no
Unique code that identifies a merchant within Concur.
MC_CODE_LAST_MODIFIED

Indexed - no
Format - date
May be null? yes
Date on which the merchant code was last modified.
MC_DESC_LAST_MODIFIED

Indexed - no
Format - date
May be null? yes
Date on which the merchant description was lat modified.
MC_DESCRIPTION

Indexed - no
Format - varchar2(40)
May be null? yes
Merchant description.

CT_MERCHANT_CODE 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