# DW_AGREEMENT_VERSIONS_CF

This table contains version details of all Submitted Agreements and Change Orders for Agreements

## Details

Module: Purchasing

## Key Columns

AGREEMENT_VERSION_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
AGREEMENT_VERSION_ID | NUMBER | 38 | 0 | True | Agreement Version identifier |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. Source record identifier |  |
AGREEMENT_HEADER_ID | NUMBER | 38 | 0 |  | Agreement Header identifier |  |
AGREEMENT_NUMBER | VARCHAR2 | 32 |  |  | Agreement Number |  |
PROCUREMENT_BU_ID | NUMBER | 38 | 0 |  | Procurement Business Unit identifier | DW_INTERNAL_ORG_D | ORGANIZATION_ID
PROCUREMENT_LEDGER_ID | NUMBER | 38 | 0 |  | Primary Ledger ID of Procurement Business Unit | DW_LEDGER_D | LEDGER_ID
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | Accounting calendar name #1 | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | Accounting period type #1 | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
TYPE_LOOKUP_CODE | VARCHAR2 | 32 |  |  | Type of the document |  |
CHANGE_ORDER_NUMBER | VARCHAR2 | 128 |  |  | Change Order Number |  |
CHANGE_ORDER_SEQUENCE | NUMBER |  |  |  | Change Order Sequence |  |
REVISION_NUMBER | NUMBER |  |  |  | Revision of the document when the change order is applied |  |
CHANGE_ORDER_DESCRIPTION | VARCHAR2 | 999 |  |  | Change Order Description |  |
CHANGE_ORDER_STATUS_CODE | VARCHAR2 | 32 |  |  | Status of the change order | DW_CHANGE_ORDER_STATUS_LKP_TL | CHANGE_ORDER_STATUS_CODE
INITIATING_PARTY_TYPE_CODE | VARCHAR2 | 32 |  |  | Type of the role initiating the change | DW_INITIATING_PARTY_LKP_TL | INITIATING_PARTY_CODE
INITIATING_PERSON_ID | NUMBER | 38 | 0 |  | Identifier of the person initiating the change order | DW_PERSON_NAME_CURRENT_D | PERSON_ID
INITIATING_SUPPLIER_PARTY_ID | NUMBER | 38 | 0 |  | Identifier of the supplier initiating the change order | DW_PARTY_D | PARTY_ID
SUBMITTED_TIMESTAMP | TIMESTAMP |  |  |  | Timestamp when the document version is submitted for approval |  |
SUBMITTED_DATE | DATE |  |  |  | Date when the document version is submitted for approval | DW_DAY_D | CALENDAR_DATE
REJECTED_FLAG | VARCHAR2 | 16 |  |  | Flag indicating whether the document version was rejected |  |
WITHDRAWN_FLAG | VARCHAR2 | 16 |  |  | Flag indicating whether the document version was withdrawn |  |
CANCELED_FLAG | VARCHAR2 | 16 |  |  | Flag indicating whether the document version was canceled |  |
DOCUMENT_CANCELED_FLAG | VARCHAR2 | 16 |  |  | The value is set to Y if the change order is created for canceling the Agreement |  |
APPROVED_TIMESTAMP | TIMESTAMP |  |  |  | Timestamp when the document version is approved by the buyer |  |
APPROVED_DATE | DATE |  |  |  | Date when the document version is approved by the buyer | DW_DAY_D | CALENDAR_DATE
PROCESSED_TIMESTAMP | TIMESTAMP |  |  |  | Timestamp in which the change order is processed |  |
PROCESSED_DATE | DATE |  |  |  | Date in which the change order is processed | DW_DAY_D | CALENDAR_DATE
CREATION_TIMESTAMP | TIMESTAMP |  |  |  | Indicates the date and time of the creation of the row |  |
LAST_UPDATE_TIMESTAMP | TIMESTAMP |  |  |  | Indicates the date and time of the last update of the row |  |

## Notes

#1 In these cases to join with DW_FISCAL_DAY_D apart from FISCAL_PERIOD_TYPE and FISCAL_PERIOD_SET_NAME the relationship should be based on SUBMITTED_DATE column

Copyright © 2019, 2025, Oracle and/or its affiliates.