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   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.