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

CT_JOURNAL Table

Explanation
The CT_JOURNAL table contains references to allocations, cash advances, reports and report entries used to build standard account extract journal entries.

Common Uses
Reviewing allocations, cash advances and expense reports related to journals.

JR_KEY

ACCOUNT_CODE
ACCOUNT_CODE_TYPE
ALLOC_KEY
CA_KEY
EXTRACT_CCT_KEY
JR_KEY
PAYEE_PAT_KEY
PAYER_PAT_KEY
RPE_KEY
RPJ_KEY
RPT_KEY

CT_ALLOCATION (DWGL)
CT_CASH_ADVANCE (DWGL)
CT_PAYMENT_TYPE (DWGL)
CT_REPORT (DWGL)
CT_REPORT_ENTRY (DWGL)
TEM_SAE_DETAIL (DWGL)

Cautions

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

Source

Concur Expense, in use at Penn since 2013.

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