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.