# DW_AGREEMENT_VERSION_CHANGE_DETAILS_CF

Purchase Agreement Version change details

## Details

Module: Purchasing

## Key Columns

AGREEMENT_HEADER_ID, AGREEMENT_SCHEDULE_ID, AGREEMENT_LINE_ID, 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 |  |
AGREEMENT_HEADER_ID | NUMBER | 38 | 0 | True | Agreement Header identifier |  |
AGREEMENT_LINE_ID | NUMBER | 38 | 0 | True | Agreement Line identifier |  |
AGREEMENT_SCHEDULE_ID | NUMBER | 38 | 0 | True | Agreement Shipment schedule identifier |  |
SOURCE_RECORD_ID | VARCHAR2 | 512 |  |  | This column is for Oracle Internal use only. Source record identifier |  |
CHANGE_ORDER_SEQUENCE | NUMBER |  |  |  | Change Order Sequence |  |
CHANGE_ORDER_NUMBER | VARCHAR2 | 128 |  |  | Change Order Number |  |
AGREEMENT_NUMBER | VARCHAR2 | 32 |  |  | Agreement Number |  |
TYPE_LOOKUP_CODE | VARCHAR2 | 32 |  |  | Type of the Document |  |
H_AVAILABLE_FOR_VERSION_FLAG | VARCHAR2 | 16 |  |  | Set to Y if any changes happened in Header for this version |  |
H_AGREEMENT_VERSION_ID | NUMBER | 38 | 0 |  | Agreement Version identifier for the Header record |  |
H_FROM_CHANGE_ORDER_SEQUENCE | NUMBER |  |  |  | From Change Order Sequence for the Header |  |
H_TO_CHANGE_ORDER_SEQUENCE | NUMBER |  |  |  | Headers The ending point of the co sequence range within which the record is valid (Exclusive) of Agreement Headers |  |
H_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Currency Code | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
H_PREVIOUS_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Currency Code of previous version | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
H_CURRENCY_CODE_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Currency Code changed from previous version |  |
H_AGREEMENT_DESCRIPTION | VARCHAR2 | 256 |  |  | Descriptive comments for the document |  |
H_PREVIOUS_AGREEMENT_DESCRIPTION | VARCHAR2 | 256 |  |  | Descriptive comments of previous version document |  |
H_AGREEMENT_DESCRIPTION_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Descriptive comments for the document changed from previous version |  |
H_SUPPLIER_SITE_ID | NUMBER | 38 | 0 |  | Supplier site unique identifier | DW_SUPPLIER_SITE_D | SUPPLIER_SITE_ID
H_PREVIOUS_SUPPLIER_SITE_ID | NUMBER | 38 | 0 |  | Supplier site unique identifier of previous version | DW_SUPPLIER_SITE_D | SUPPLIER_SITE_ID
H_SUPPLIER_SITE_ID_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Supplier site unique identifier changed from previous version |  |
H_BUYER_ID | NUMBER | 38 | 0 |  | Buyer unique identifier | DW_PERSON_NAME_CURRENT_D | PERSON_ID
H_PREVIOUS_BUYER_ID | NUMBER | 38 | 0 |  | Buyer unique identifier of previous version | DW_PERSON_NAME_CURRENT_D | PERSON_ID
H_BUYER_ID_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Buyer unique identifier changed from previous version |  |
H_PAYMENT_TERMS_ID | NUMBER | 38 | 0 |  | Payment terms unique identifier | DW_AP_TERMS_D | PAYMENT_TERMS_ID
H_PREVIOUS_PAYMENT_TERMS_ID | NUMBER | 38 | 0 |  | Payment terms unique identifier of previous version | DW_AP_TERMS_D | PAYMENT_TERMS_ID
H_PAYMENT_TERMS_ID_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Payment terms unique identifier changed from previous version |  |
H_CARRIER_ID | NUMBER | 38 | 0 |  | Carrier Identifier | DW_PARTY_D | PARTY_ID
H_PREVIOUS_CARRIER_ID | NUMBER | 38 | 0 |  | Carrier Identifier of previous version | DW_PARTY_D | PARTY_ID
H_CARRIER_ID_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Carrier Identifier changed from previous version |  |
H_MODE_OF_TRANSPORT | VARCHAR2 | 32 |  |  | Mode of Transport |  |
H_PREVIOUS_MODE_OF_TRANSPORT | VARCHAR2 | 32 |  |  | Mode of Transport of previous version |  |
H_MODE_OF_TRANSPORT_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Mode of Transport changed from previous version |  |
H_SERVICE_LEVEL | VARCHAR2 | 32 |  |  | Service Level |  |
H_PREVIOUS_SERVICE_LEVEL | VARCHAR2 | 32 |  |  | Service Level of previous version |  |
H_SERVICE_LEVEL_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Service Level changed from previous version |  |
H_FREIGHT_TERMS_CODE | VARCHAR2 | 32 |  |  | Type of freight terms for the document | DW_FREIGHT_TERMS_LKP_TL | FREIGHT_TERMS_CODE
H_PREVIOUS_FREIGHT_TERMS_CODE | VARCHAR2 | 32 |  |  | Type of freight terms for the previous version document | DW_FREIGHT_TERMS_LKP_TL | FREIGHT_TERMS_CODE
H_FREIGHT_TERMS_CODE_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if freight terms changed from previous version |  |
H_FOB_CODE | VARCHAR2 | 32 |  |  | Type of free-on-board terms for the document | DW_FOB_LKP_TL | FOB_CODE
H_PREVIOUS_FOB_CODE | VARCHAR2 | 32 |  |  | Type of free-on-board terms for the previous version document | DW_FOB_LKP_TL | FOB_CODE
H_FOB_CODE_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if free-on-board terms changed from previous version |  |
H_PAY_ON_RECEIPT_INDICATOR | VARCHAR2 | 16 |  |  | Indicator of whether the Agreement will be paid upon receipt |  |
H_PREVIOUS_PAY_ON_RECEIPT_INDICATOR | VARCHAR2 | 16 |  |  | Indicator of whether the Agreement will be paid upon receipt of previous version |  |
H_PAY_ON_RECEIPT_INDICATOR_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if paid upon receipt changed from previous version |  |
H_NOTE_TO_SUPPLIER | VARCHAR2 | 999 |  |  | Short note to supplier |  |
H_PREVIOUS_NOTE_TO_SUPPLIER | VARCHAR2 | 999 |  |  | Short note to supplier of previous version |  |
H_NOTE_TO_SUPPLIER_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Short note to supplier changed from previous version |  |
H_NOTE_TO_RECEIVER | VARCHAR2 | 999 |  |  | Note to receiver |  |
H_PREVIOUS_NOTE_TO_RECEIVER | VARCHAR2 | 999 |  |  | Note to receiver of previous version |  |
H_NOTE_TO_RECEIVER_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Note to receiver changed from previous version |  |
H_COMMUNICATION_METHOD | VARCHAR2 | 32 |  |  | Supplier Notification Method | DW_DOC_COMM_METHOD_D_TL | CODE
H_PREVIOUS_COMMUNICATION_METHOD | VARCHAR2 | 32 |  |  | Supplier Notification Method of previous version | DW_DOC_COMM_METHOD_D_TL | CODE
H_COMMUNICATION_METHOD_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Supplier Notification Method changed from pervious version |  |
H_START_DATE | DATE |  |  |  | Date the document becomes effective |  |
H_PREVIOUS_START_DATE | DATE |  |  |  | Date the document becomes effective of previous version |  |
H_START_DATE_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Date the document becomes effective is modified from previous version |  |
H_END_DATE | DATE |  |  |  | Expiration date of the document |  |
H_PREVIOUS_END_DATE | DATE |  |  |  | Expiration date of the document of previous version |  |
H_END_DATE_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Expiration date of the document is modified from previous version |  |
H_AGREEMENT_AMOUNT | NUMBER |  |  |  | Amount agreed for the agreement |  |
H_PREVIOUS_AGREEMENT_AMOUNT | NUMBER |  |  |  | Amount agreed for the agreement of previous version |  |
H_AGREEMENT_AMOUNT_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Amount agreed for the agreement changed from pervious version |  |
H_MIN_RELEASE_AMOUNT | NUMBER |  |  |  | Minimum amount that can be released against the agreement |  |
H_PREVIOUS_MIN_RELEASE_AMOUNT | NUMBER |  |  |  | Minimum amount that can be released against the agreement of previous version |  |
H_MIN_RELEASE_AMOUNT_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Minimum amount that can be released against the agreement changed from pervious version |  |
L_AVAILABLE_FOR_VERSION_FLAG | VARCHAR2 | 16 |  |  | Set to Y if any changes happened in Line for this version |  |
L_AGREEMENT_VERSION_ID | NUMBER | 38 | 0 |  | Agreement Version identifier for the Line record |  |
L_FROM_CHANGE_ORDER_SEQUENCE | NUMBER |  |  |  | From Change Order Sequence for the Line |  |
L_TO_CHANGE_ORDER_SEQUENCE | NUMBER |  |  |  | Headers The ending point of the co sequence range within which the record is valid (Exclusive) of Agreement Lines |  |
L_TRANSACTION_UOM_CODE | VARCHAR2 | 16 |  |  | Transaction unit of measure | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
L_AGREEMENT_LINE_NUMBER | NUMBER |  |  |  | Agreement Line Number |  |
L_PREVIOUS_AGREEMENT_LINE_NUMBER | NUMBER |  |  |  | Agreement Line Number of previous version |  |
L_AGREEMENT_LINE_NUMBER_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Agreement Line Number changed from previous version |  |
L_LINE_DESCRIPTION | VARCHAR2 | 256 |  |  | Line Item description |  |
L_PREVIOUS_LINE_DESCRIPTION | VARCHAR2 | 256 |  |  | Line Item description of previous version |  |
L_LINE_DESCRIPTION_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Line Item description changed from previous version |  |
L_SUPPLIER_ITEM | VARCHAR2 | 512 |  |  | Supplier product number |  |
L_PREVIOUS_SUPPLIER_ITEM | VARCHAR2 | 512 |  |  | Supplier product number of previous version |  |
L_SUPPLIER_ITEM_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Supplier product number changed from previous version |  |
L_UNIT_PRICE | NUMBER |  |  |  | Unit price for the line |  |
L_PREVIOUS_UNIT_PRICE | NUMBER |  |  |  | Unit price for the line of previous version |  |
L_UNIT_PRICE_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Unit price for the line changed from previous version |  |
L_EXPIRATION_DATE | DATE |  |  |  | Expiration Date For Catalog Lines |  |
L_PREVIOUS_EXPIRATION_DATE | DATE |  |  |  | Expiration Date For Catalog Lines of previous version |  |
L_EXPIRATION_DATE_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Expiration Date For Catalog Lines changed from previous version |  |
L_PRICE_BREAK_CODE | VARCHAR2 | 32 |  |  | Describes the pricing scheme for blanket agreement line price breaks | DW_PRICE_BREAK_TYPE_D_TL | CODE
L_PREVIOUS_PRICE_BREAK_CODE | VARCHAR2 | 32 |  |  | Describes the pricing scheme for blanket agreement line price breaks | DW_PRICE_BREAK_TYPE_D_TL | CODE
L_PRICE_BREAK_CODE_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Price Breakup Code changed from previous version |  |
L_AGREEMENT_QUANTITY | NUMBER |  |  |  | Quantity agreed for an agreement line |  |
L_PREVIOUS_AGREEMENT_QUANTITY | NUMBER |  |  |  | Quantity agreed for an agreement line of previous version |  |
L_AGREEMENT_QUANTITY_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Quantity agreed for an agreement line changed from previous version |  |
L_AGREEMENT_AMOUNT | NUMBER |  |  |  | Amount agreed for an agreement line |  |
L_PREVIOUS_AGREEMENT_AMOUNT | NUMBER |  |  |  | Amount agreed for an agreement line of previous version |  |
L_AGREEMENT_AMOUNT_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Quantity agreed for an agreement line changed from previous version |  |
L_MIN_RELEASE_AMOUNT | NUMBER |  |  |  | Minimum amount that can be released |  |
L_PREVIOUS_MIN_RELEASE_AMOUNT | NUMBER |  |  |  | Minimum amount that can be released of previous version |  |
L_MIN_RELEASE_AMOUNT_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Minimum amount that can be released changed from previous version |  |
L_NOTE_TO_SUPPLIER | VARCHAR2 | 999 |  |  | Short note to supplier |  |
L_PREVIOUS_NOTE_TO_SUPPLIER | VARCHAR2 | 999 |  |  | Short note to supplier of previous version |  |
L_NOTE_TO_SUPPLIER_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Short note to supplier changed from previous version |  |
LO_AVAILABLE_FOR_VERSION_FLAG | VARCHAR2 | 16 |  |  | Set to Y if any changes happened in Schedule for this version |  |
LO_AGREEMENT_VERSION_ID | NUMBER | 38 | 0 |  | Agreement Version identifier for the Schedule record |  |
LO_FROM_CHANGE_ORDER_SEQUENCE | NUMBER |  |  |  | From Change Order Sequence for the Schedule |  |
LO_TO_CHANGE_ORDER_SEQUENCE | NUMBER |  |  |  | The ending point of the co sequence range within which the record is valid (Exclusive) of Agreement Line Locations |  |
LO_TRANSACTION_UOM_CODE | VARCHAR2 | 16 |  |  | Transaction unit of measure | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
LO_AGREEMENT_SCHEDULE_NUMBER | NUMBER |  |  |  | Agreement Schedule Number |  |
LO_PREVIOUS_AGREEMENT_SCHEDULE_NUMBER | NUMBER |  |  |  | Agreement Schedule Number of previous version |  |
LO_AGREEMENT_SCHEDULE_NUMBER_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Agreement Schedule Number changed from previous version |  |
LO_PRICE | NUMBER |  |  |  | Price for the Agreement |  |
LO_PREVIOUS_PRICE | NUMBER |  |  |  | Price for the Agreement of previous version |  |
LO_PRICE_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Price for the Agreement changed from previous version |  |
LO_QUANTITY | NUMBER |  |  |  | Quantity for the Agreement |  |
LO_PREVIOUS_QUANTITY | NUMBER |  |  |  | Quantity for the Agreement of previous version |  |
LO_QUANTITY_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Quantity for the Agreement changed from previous version |  |
LO_START_DATE | DATE |  |  |  | Effective date of the price |  |
LO_PREVIOUS_START_DATE | DATE |  |  |  | Effective date of the price of previous version |  |
LO_START_DATE_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Effective date of the price changed from previous version |  |
LO_SHIP_TO_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Ship-to organization unique identifier | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LO_PREVIOUS_SHIP_TO_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Ship-to organization unique identifier of previous version | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LO_SHIP_TO_ORGANIZATION_ID_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Ship-to organization unique identifier changed from previous version |  |

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