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
| 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. |