# DW_PURCHASE_ORDER_CHANGE_DISTRIBUTIONS_CF

Contains details for Purchase Order Distributions 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 distributions 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_DISTRIBUTION_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
PO_DISTRIBUTION_ID | NUMBER | 38 | 0 | True | Document distribution unique 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 |  |
PO_HEADER_ID | NUMBER | 38 | 0 |  | Purchase Order Header identifier |  |
PO_LINE_ID | NUMBER | 38 | 0 |  | Document line unique identifier |  |
PO_SCHEDULE_ID | NUMBER | 38 | 0 |  | Document shipment schedule unique identifier |  |
PURCHASE_ORDER_DISTRIBUTION_NUMBER | NUMBER |  |  |  | Distribution Number |  |
PREVIOUS_PURCHASE_ORDER_DISTRIBUTION_NUMBER | NUMBER |  |  |  | Distribution Number of previous version |  |
PURCHASE_ORDER_DISTRIBUTION_NUMBER_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Distribution Number changed from previous version |  |
REQUESTER_ID | NUMBER | 38 | 0 |  | Requester Identifier | DW_PERSON_NAME_CURRENT_D | PERSON_ID
PREVIOUS_REQUESTER_ID | NUMBER | 38 | 0 |  | Requester Identifier of previous version | DW_PERSON_NAME_CURRENT_D | PERSON_ID
REQUESTER_ID_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Requester Identifier changed from previous version |  |
DELIVER_TO_LOCATION_ID | NUMBER | 38 | 0 |  | Deliver-to location Identifier | DW_WORKER_LOCATION_D | LOCATION_ID
PREVIOUS_DELIVER_TO_LOCATION_ID | NUMBER | 38 | 0 |  | Deliver-to location Identifier of previous version | DW_WORKER_LOCATION_D | LOCATION_ID
DELIVER_TO_LOCATION_ID_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Deliver-to location Identifier changed from previous version |  |
ORDERED_QUANTITY | NUMBER |  |  |  | Ordered quantity |  |
PREVIOUS_ORDERED_QUANTITY | NUMBER |  |  |  | Ordered quantity of previous version |  |
ORDERED_QUANTITY_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Ordered quantity changed from previous version |  |
ORDERED_AMOUNT | NUMBER |  |  |  | Ordered amount |  |
PREVIOUS_ORDERED_AMOUNT | NUMBER |  |  |  | Ordered amount of previous version |  |
ORDERED_AMOUNT_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Ordered amount changed from previous version |  |
CANCELLED_QUANTITY | NUMBER |  |  |  | Cancelled quantity |  |
PREVIOUS_CANCELLED_QUANTITY | NUMBER |  |  |  | Cancelled quantity of previous version |  |
CANCELLED_QUANTITY_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Cancelled quantity changed from previous version |  |
CANCELLED_AMOUNT | NUMBER |  |  |  | Cancelled amount |  |
PREVIOUS_CANCELLED_AMOUNT | NUMBER |  |  |  | Cancelled amount of previous version |  |
CANCELLED_AMOUNT_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Cancelled amount changed from previous version |  |
PO_CHARGE_ACCOUNT_ID | NUMBER | 38 | 0 |  | General Ledger charge account identifier | DW_GL_CODE_COMBINATION_D | CODE_COMBINATION_ID
PREVIOUS_PO_CHARGE_ACCOUNT_ID | NUMBER | 38 | 0 |  | General Ledger charge account identifier of previous version | DW_GL_CODE_COMBINATION_D | CODE_COMBINATION_ID
PO_CHARGE_ACCOUNT_ID_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if General Ledger charge account identifier changed from previous version |  |
PO_VARIANCE_ACCOUNT_ID | NUMBER | 38 | 0 |  | General Ledger variance account identifier | DW_GL_CODE_COMBINATION_D | CODE_COMBINATION_ID
PREVIOUS_PO_VARIANCE_ACCOUNT_ID | NUMBER | 38 | 0 |  | General Ledger variance account identifier of previous version | DW_GL_CODE_COMBINATION_D | CODE_COMBINATION_ID
PO_VARIANCE_ACCOUNT_ID_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if General Ledger variance account identifier changed from previous version |  |
RECOVERABLE_INCLUSIVE_TAX | NUMBER |  |  |  | Recoverable inclusive tax amount |  |
PREVIOUS_RECOVERABLE_INCLUSIVE_TAX | NUMBER |  |  |  | Recoverable inclusive tax amount of previous version |  |
RECOVERABLE_INCLUSIVE_TAX_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Recoverable inclusive tax amount changed from previous version |  |
NONRECOVERABLE_INCLUSIVE_TAX | NUMBER |  |  |  | Non-recoverable inclusive tax amount |  |
PREVIOUS_NONRECOVERABLE_INCLUSIVE_TAX | NUMBER |  |  |  | Non-recoverable inclusive tax amount of previous version |  |
NONRECOVERABLE_INCLUSIVE_TAX_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Non-recoverable inclusive tax amount changed from previous version |  |
RECOVERABLE_EXCLUSIVE_TAX | NUMBER |  |  |  | Recoverable exclusive tax amount |  |
PREVIOUS_RECOVERABLE_EXCLUSIVE_TAX | NUMBER |  |  |  | Recoverable exclusive tax amount of previous version |  |
RECOVERABLE_EXCLUSIVE_TAX_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Recoverable exclusive tax amount changed from previous version |  |
NONRECOVERABLE_EXCLUSIVE_TAX | NUMBER |  |  |  | Non-recoverable exclusive tax amount |  |
PREVIOUS_NONRECOVERABLE_EXCLUSIVE_TAX | NUMBER |  |  |  | Non-recoverable exclusive tax amount of previous version |  |
NONRECOVERABLE_EXCLUSIVE_TAX_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Non-recoverable exclusive tax amount changed 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.