# DW_AGREEMENT_CHANGE_HEADERS_CF

Contains details for Purchase Agreement Headers for Accepted Agreement Versions. Data for Cancelled Purchase Agreements and Cancelled Change Order Versions will not be available. Also, data will appear only when some changes happen for the Purchase Agreement headers as part of the Agreement Version (Changes may happen for details which are not available on the Fact)

## Details

Module: Purchasing

## Key Columns

FROM_CHANGE_ORDER_SEQUENCE, AGREEMENT_HEADER_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
AGREEMENT_HEADER_ID | NUMBER | 38 | 0 | True | Agreement Header identifier |  |
FROM_CHANGE_ORDER_SEQUENCE | NUMBER |  |  | True | The starting point of the co sequence range within which the record is valid (Inclusive) |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. Source record identifier |  |
TO_CHANGE_ORDER_SEQUENCE | NUMBER |  |  |  | The ending point of the co sequence range within which the record is valid (Exclusive) |  |
AGREEMENT_VERSION_ID | NUMBER | 38 | 0 |  | Agreement Version identifier |  |
CHANGE_ORDER_NUMBER | VARCHAR2 | 128 |  |  | Change Order Number |  |
AGREEMENT_NUMBER | VARCHAR2 | 32 |  |  | Agreement Number |  |
TYPE_LOOKUP_CODE | VARCHAR2 | 32 |  |  | Type of the Document |  |
CURRENCY_CODE | VARCHAR2 | 16 |  |  | Currency Code | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
PREVIOUS_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Currency Code of previous version | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
CURRENCY_CODE_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Currency Code changed from previous version |  |
AGREEMENT_DESCRIPTION | VARCHAR2 | 256 |  |  | Descriptive comments for the document |  |
PREVIOUS_AGREEMENT_DESCRIPTION | VARCHAR2 | 256 |  |  | Descriptive comments of previous version |  |
AGREEMENT_DESCRIPTION_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Descriptive comments for the document changed from previous version |  |
SUPPLIER_SITE_ID | NUMBER | 38 | 0 |  | Supplier site unique identifier | DW_SUPPLIER_SITE_D | SUPPLIER_SITE_ID
PREVIOUS_SUPPLIER_SITE_ID | NUMBER | 38 | 0 |  | Supplier site unique identifier of previous version | DW_SUPPLIER_SITE_D | SUPPLIER_SITE_ID
SUPPLIER_SITE_ID_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Supplier site unique identifier changed from previous version |  |
BUYER_ID | NUMBER | 38 | 0 |  | Buyer unique identifier | DW_PERSON_NAME_CURRENT_D | PERSON_ID
PREVIOUS_BUYER_ID | NUMBER | 38 | 0 |  | Buyer unique identifier of previous version | DW_PERSON_NAME_CURRENT_D | PERSON_ID
BUYER_ID_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Buyer unique identifier changed from previous version |  |
PAYMENT_TERMS_ID | NUMBER | 38 | 0 |  | Payment terms unique identifier | DW_AP_TERMS_D | PAYMENT_TERMS_ID
PREVIOUS_PAYMENT_TERMS_ID | NUMBER | 38 | 0 |  | Payment terms unique identifier of previous version | DW_AP_TERMS_D | PAYMENT_TERMS_ID
PAYMENT_TERMS_ID_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Payment terms unique identifier changed from previous version |  |
CARRIER_ID | NUMBER | 38 | 0 |  | Carrier Identifier | DW_PARTY_D | PARTY_ID
PREVIOUS_CARRIER_ID | NUMBER | 38 | 0 |  | Carrier Identifier of previous version | DW_PARTY_D | PARTY_ID
CARRIER_ID_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Carrier Identifier changed from previous version |  |
MODE_OF_TRANSPORT | VARCHAR2 | 32 |  |  | Mode of Transport |  |
PREVIOUS_MODE_OF_TRANSPORT | VARCHAR2 | 32 |  |  | Mode of Transport of previous version |  |
MODE_OF_TRANSPORT_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Mode of Transport changed from previous version |  |
SERVICE_LEVEL | VARCHAR2 | 32 |  |  | Service Level |  |
PREVIOUS_SERVICE_LEVEL | VARCHAR2 | 32 |  |  | Service Level of previous version |  |
SERVICE_LEVEL_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Service Level changed from previous version |  |
FREIGHT_TERMS_CODE | VARCHAR2 | 32 |  |  | Type of freight terms for the document | DW_FREIGHT_TERMS_LKP_TL | FREIGHT_TERMS_CODE
PREVIOUS_FREIGHT_TERMS_CODE | VARCHAR2 | 32 |  |  | Type of freight terms for the previous version | DW_FREIGHT_TERMS_LKP_TL | FREIGHT_TERMS_CODE
FREIGHT_TERMS_CODE_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if freight terms changed from previous version |  |
FOB_CODE | VARCHAR2 | 32 |  |  | Type of free-on-board terms for the document | DW_FOB_LKP_TL | FOB_CODE
PREVIOUS_FOB_CODE | VARCHAR2 | 32 |  |  | Type of free-on-board terms for the previous version document | DW_FOB_LKP_TL | FOB_CODE
FOB_CODE_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if free-on-board terms changed from previous version |  |
PAY_ON_RECEIPT_INDICATOR | VARCHAR2 | 16 |  |  | Indicator of whether the Agreement will be paid upon receipt |  |
PREVIOUS_PAY_ON_RECEIPT_INDICATOR | VARCHAR2 | 16 |  |  | Indicator of whether the Agreement will be paid upon receipt of previous version |  |
PAY_ON_RECEIPT_INDICATOR_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if paid upon receipt changed from previous version |  |
NOTE_TO_SUPPLIER | VARCHAR2 | 999 |  |  | Short note to supplier |  |
PREVIOUS_NOTE_TO_SUPPLIER | VARCHAR2 | 999 |  |  | Short note to supplier of previous version |  |
NOTE_TO_SUPPLIER_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Short note to supplier changed from previous version |  |
NOTE_TO_RECEIVER | VARCHAR2 | 999 |  |  | Note to receiver |  |
PREVIOUS_NOTE_TO_RECEIVER | VARCHAR2 | 999 |  |  | Note to receiver of previous version |  |
NOTE_TO_RECEIVER_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Note to receiver changed from previous version |  |
COMMUNICATION_METHOD | VARCHAR2 | 32 |  |  | Supplier Notification Method | DW_DOC_COMM_METHOD_D_TL | CODE
PREVIOUS_COMMUNICATION_METHOD | VARCHAR2 | 32 |  |  | Supplier Notification Method of previous version | DW_DOC_COMM_METHOD_D_TL | CODE
COMMUNICATION_METHOD_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Supplier Notification Method changed from pervious version |  |
START_DATE | DATE |  |  |  | Date the document becomes effective |  |
PREVIOUS_START_DATE | DATE |  |  |  | Date the document becomes effective of previous version |  |
START_DATE_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Date the document becomes effective is modified from previous version |  |
END_DATE | DATE |  |  |  | Expiration date of the document |  |
PREVIOUS_END_DATE | DATE |  |  |  | Expiration date of the document of previous version |  |
END_DATE_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Expiration date of the document is modified from previous version |  |
AGREEMENT_AMOUNT | NUMBER |  |  |  | Amount agreed for the agreement |  |
PREVIOUS_AGREEMENT_AMOUNT | NUMBER |  |  |  | Amount agreed for the agreement of previous version |  |
AGREEMENT_AMOUNT_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Amount agreed for the agreement changed from pervious version |  |
MIN_RELEASE_AMOUNT | NUMBER |  |  |  | Minimum amount that can be released against the agreement |  |
PREVIOUS_MIN_RELEASE_AMOUNT | NUMBER |  |  |  | Minimum amount that can be released against the agreement of previous version |  |
MIN_RELEASE_AMOUNT_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Minimum amount that can be released against the agreement changed from pervious version |  |
CREATION_TIMESTAMP | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row. |  |
LAST_UPDATE_TIMESTAMP | TIMESTAMP |  |  |  | Who column: indicates the date and time of the last update of the row. |  |

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