Expense types dimension
Module: Expenses
EXPENSE_TYPE_ID
| 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.