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

CT_PAYMENT_TYPE Table

Explanation
CT_PAYMENT_TYPE is a reference table for payment type values used in Concur, containing type codes and their descriptions.

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

PAT_KEY

CLEARING_ACCOUNT_CODE
PAT_CODE
PAT_KEY

CT_PAYMENT_CODE (DWGL)
CT_REPORT_ENTRY (DWGL)

Cautions

• Payment Types (e.g., "Cash/Personal Credit Card", "Out of Pocket") may be rolled up into Expense Codes (e.g., "Cash"), which are stored in CT_PAYMENT_CODE.
• The CT_PAYMENT_TYPE table is stored in the DWGL schema in the Data Warehouse.

Source

Concur Expense, in use at Penn since 2013.

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