DW_PURCHASE_ORDER_CHANGE_LINES_CF

Contains details for Purchase Order Lines 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 Lines as part of the Purchase Order Version (Changes may happen for details which are not available on the Fact)

Details

Module: Purchasing

Key Columns

PO_LINE_ID, FROM_CHANGE_ORDER_SEQUENCE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PO_LINE_ID NUMBER 38 0 True Document line 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
TRANSACTION_UOM_CODE VARCHAR2 16 Transaction unit of measure DW_UNIT_OF_MEASURE_D_TL UOM_CODE
PURCHASE_ORDER_LINE_NUMBER NUMBER Purchase Order Line Number
PREVIOUS_PURCHASE_ORDER_LINE_NUMBER NUMBER Purchase Order Line Number of previous version
PURCHASE_ORDER_LINE_NUMBER_CHANGED_FLAG VARCHAR2 16 Set to Y if Purchase Order Line Number changed from previous version
LINE_DESCRIPTION VARCHAR2 256 Line Item description
PREVIOUS_LINE_DESCRIPTION VARCHAR2 256 Line Item description of previous version
LINE_DESCRIPTION_CHANGED_FLAG VARCHAR2 16 Set to Y if Line Item description changed from previous version
SUPPLIER_ITEM VARCHAR2 512 Supplier product number
PREVIOUS_SUPPLIER_ITEM VARCHAR2 512 Supplier product number of previous version
SUPPLIER_ITEM_CHANGED_FLAG VARCHAR2 16 Set to Y if Supplier product number changed from previous version
QUANTITY NUMBER Quantity ordered on the line
PREVIOUS_QUANTITY NUMBER Quantity ordered on the line of previous version
QUANTITY_CHANGED_FLAG VARCHAR2 16 Set to Y if Quantity ordered on the line changed from previous version
UNIT_PRICE NUMBER Unit price for the line
PREVIOUS_UNIT_PRICE NUMBER Unit price for the line of previous version
UNIT_PRICE_CHANGED_FLAG VARCHAR2 16 Set to Y if Unit price for the line 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
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.