This entity contains the latest approval and rejection information of each invoice that passes through the Invoice Approval Workflow process
Module: Payables
INVOICE_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| INVOICE_ID | NUMBER | 38 | 0 | True | Unique identifier for invoice that is undergoing the approval cycle. | ||
| SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. SOURCE_RECORD_ID | ||||
| APPROVAL_HISTORY_ID | NUMBER | 38 | 0 | Identifier for every record created under approval cycle. | |||
| LEDGER_ID | NUMBER | 38 | 0 | Ledger identifier. | DW_LEDGER_D | LEDGER_ID | |
| FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 | Accounting calendar name. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME | ||
| FISCAL_PERIOD_TYPE | VARCHAR2 | 16 | Accounting period type. | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE | ||
| FISCAL_PERIOD_NAME | VARCHAR2 | 64 | Accounting period name. | ||||
| AMOUNT_APPROVED | NUMBER | Invoice amount at time of approver response | |||||
| APPROVER_COMMENTS | VARCHAR2 | 256 | Comments provided by the approver on a given invoice. | ||||
| APPROVER_ID | VARCHAR2 | 999 | Login user name of approver for given invoice. | ||||
| HISTORY_TYPE | VARCHAR2 | 32 | Approval type required on a invoice. | ||||
| HOLD_ID | NUMBER | 38 | 0 | Identifier used to identify the hold applied on an invoice. | |||
| ITERATION | NUMBER | Count of times invoice has passed through the Invoice Approval Workflow process | |||||
| LINE_NUMBER | NUMBER | Invoice line number | |||||
| NOTIFICATION_ORDER | NUMBER | Order that the notifications were sent to approvers | |||||
| OBJECT_VERSION_NUMBER | NUMBER | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |||||
| PAYABLES_BU_ID | NUMBER | 38 | 0 | Indicates the identifier of the business unit associated to the row. | |||
| ORIG_SYSTEM | VARCHAR2 | 32 | Originating system for the approver_id | ||||
| RESPONSE | VARCHAR2 | 64 | Response of the approver on a given invoice. | ||||
| UPPER_APPROVER_ID | VARCHAR2 | 999 | Login user name of approver for given invoice in upper case. | ||||
| ACTION_DATE | TIMESTAMP | The date when an assignee performed an action on a particular workflow task. | |||||
| ACTION_DATE_1 | DATE | The date when an assignee performed an action on a particular workflow task. | |||||
| CREATED_BY_USER_ID | VARCHAR2 | 128 | Who column: indicates the user who created the row. | ||||
| UPDATED_BY_USER_ID | VARCHAR2 | 128 | Who column: indicates the user who last updated the row. | ||||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. |
Copyright © 2019, 2024, Oracle and/or its affiliates.