Expense template dimension
Module: Expenses
EXPENSE_TEMPLATE_ID
| 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. |
Copyright © 2019, 2024, Oracle and/or its affiliates.