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