# DW_AP_INV_APPROVAL_D

This entity contains the latest approval and rejection information of each invoice that passes through the Invoice Approval Workflow process

## Details

Module: Payables

## Key Columns

INVOICE_ID

## Columns

Columns
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, 2025, Oracle and/or its affiliates.