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.