DW_EXM_EXPENSE_TYPES_D

Expense types dimension

Details

Module: Expenses

Key Columns

EXPENSE_TYPE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
EXPENSE_TYPE_ID NUMBER 38 0 True Unique identifier of an expense type in an expense template.    
SOURCE_RECORD_ID NUMBER 38 0   This column is for Oracle Internal use only. Source record identifier    
EXPENSE_TEMPLATE_ID NUMBER 38 0   Identifier of the expense template that contains the expense type. DW_EXM_EXPENSE_TEMPLATES_D EXPENSE_TEMPLATE_ID
NAME VARCHAR2 128     Name of the expense type as appears in the expense report.    
DESCRIPTION VARCHAR2 256     Description of the expense type.    
START_DATE DATE       Date from which the expense template is available for use in expense reports.    
END_DATE DATE       Date from which the expense template can no longer be used.    
CATEGORY_CODE VARCHAR2 32     Expense category assigned to the expense item.    
TAX_CLASSIFICATION_CODE VARCHAR2 32     Default tax code assigned to the expense item.    
RECEIPT_REQUIRED_FLAG VARCHAR2 16     Indicator of whether receipts are required for cash expense lines above a specified amount.    
RECEIPT_THRESHOLD NUMBER       Amount limit, above which a cash expense requires receipt.    
CC_RECEIPT_REQUIRED_FLAG VARCHAR2 16     Indicator of whether receipts are required for corporate card expense lines above a specified limit.    
CC_RECEIPT_THRESHOLD NUMBER       Amount limit, above which a corporate card expense requires receipt.    
NEGATIVE_RCPT_REQ_CODE VARCHAR2 32     Receipt requirement rules are applied to negative expense lines.    
RCPT_REQUIRED_PROJ_FLAG VARCHAR2 16     Indicator of whether a receipt is required for this project-enabled expense type.    
DISP_RCPT_VIOLATION_FLAG VARCHAR2 16     Indicator of whether a receipt missing policy warning is displayed to the user.    
ITEMIZATION_BEHAVIOUR_CODE VARCHAR2 16     Indicator of whether itemization is disabled, enabled, or required for this expense type.    
ITEMIZATION_ONLY_FLAG VARCHAR2 16     Indicator of whether this expense type is used only in itemization.    
DEFAULT_PROJ_EXPEND_TYPE NUMBER 38 0   Project expenditure type that is assigned to an expense type that has not been set up at the project level.    
ENABLE_PROJECTS_FLAG VARCHAR2 16     Indicator of whether the expense type can be used to charge project expenses.    

Copyright © 2019, 2024, Oracle and/or its affiliates.