# DW_PURCHASE_ORDER_CHANGE_HEADERS_CF

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

## Details

Module: Purchasing

## Key Columns

FROM_CHANGE_ORDER_SEQUENCE, PO_HEADER_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
PO_HEADER_ID | NUMBER | 38 | 0 | True | Purchase Order 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) |  |
PO_VERSION_ID | NUMBER | 38 | 0 |  | Purchase Order Version identifier |  |
CHANGE_ORDER_NUMBER | VARCHAR2 | 128 |  |  | Change Order Number |  |
PURCHASE_ORDER_NUMBER | VARCHAR2 | 32 |  |  | Purchase Order Number |  |
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 modified from previous version |  |
PURCHASE_ORDER_DESCRIPTION | VARCHAR2 | 256 |  |  | Purchase Order Description |  |
PREVIOUS_PURCHASE_ORDER_DESCRIPTION | VARCHAR2 | 256 |  |  | Purchase Order Description of previous version |  |
PURCHASE_ORDER_DESCRIPTION_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Purchase Order Description 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 document | 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 purchase order will be paid upon receipt |  |
PREVIOUS_PAY_ON_RECEIPT_INDICATOR | VARCHAR2 | 16 |  |  | Indicator of whether the purchase order 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 |  |
BILL_TO_LOCATION_ID | NUMBER | 38 | 0 |  | Bill-to location unique identifier | DW_WORKER_LOCATION_D | LOCATION_ID
PREVIOUS_BILL_TO_LOCATION_ID | NUMBER | 38 | 0 |  | Bill-to location unique identifier of previous version | DW_WORKER_LOCATION_D | LOCATION_ID
BILL_TO_LOCATION_ID_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Bill-to location modified from previous 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.