DW_EXM_EXPENSE_TEMPLATES_D

Expense template dimension

Details

Module: Expenses

Key Columns

EXPENSE_TEMPLATE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
EXPENSE_TEMPLATE_ID NUMBER 38 0 True Unique identifier of an expense report template.
SOURCE_RECORD_ID NUMBER 38 0 This column is for Oracle Internal use only. Source record identifier
NAME VARCHAR2 128 Name of the expense report template.
DESCRIPTION VARCHAR2 256 Description of the expense report template.
START_DATE DATE Date from which the expense type is available for use in expense reports.
INACTIVE_DATE DATE Date from which the expense type can no longer be used.
DFLT_CC_EXP_TYPE_ID NUMBER 38 0 Expense type assigned to a credit card transaction if mapping has not been defined.
ENABLE_CC_MAPPING_FLAG VARCHAR2 16 Indicator of whether the lookup codes from the charge file are associated with the company's expense types.
CASH_RECEIPT_REQ_FLAG VARCHAR2 16 Indicator of whether receipts are required for cash expense lines above a specified amount.
CASH_RECEIPT_REQ_LIMIT NUMBER Amount limit, above which a cash expense requires receipt.
CC_RECEIPT_REQ_FLAG VARCHAR2 16 Indicator of whether receipts are required for corporate card expense lines above a specified limit.
CC_RECEIPT_REQ_LIMIT NUMBER Amount limit, above which a corporate card expense requires receipt.
NEGATIVE_RCPT_REQ_FLAG VARCHAR2 16 Indicator of whether receipt requirement rules are applied to negative expense lines.
ALLOW_RCPT_MISSING_FLAG VARCHAR2 16 Indicator of whether individuals can indicate that receipts are missing when they submit their expense report.
DISP_RCPT_VIOLATION_FLAG VARCHAR2 16 Indicator of whether a receipt missing policy warning is displayed to the user.