CT_MERCHANT_CODE Table - Data Element Index   Tables and Data Elements   Travel & Expense Management Home   Data Warehouse Home

CT_MERCHANT_CODE Table

Explanation
CT_MERCHANT_CODE is a reference table for vendors in Concur, containing merchant codes and their descriptions.

Common Uses
Displaying the merchant description, rather than code that appears in a related table.

MC_CODE

EXP_KEY
MC_CODE

CT_EXPENSE_TYPE (DWGL)
TEM_SAE_DETAIL (DWGL)

Cautions

• The CT_MERCHANT_CODE table is stored in the DWGL schema in the Data Warehouse.

Source

Concur Expense, in use at Penn since 2013.

CT_MERCHANT_CODE Table - Data Element Index   Tables and Data Elements   Travel & Expense Management Home   Data Warehouse Home