# DW_PURCHASE_ORDER_CHANGE_LINE_LOCATIONS_CF

Contains details for Purchase Order Schedules 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 Schedules 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_SCHEDULE_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
PO_SCHEDULE_ID | NUMBER | 38 | 0 | True | Document shipment schedule 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 |  |
TRANSACTION_UOM_CODE | VARCHAR2 | 16 |  |  | Transaction unit of measure | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
PURCHASE_ORDER_SCHEDULE_NUMBER | NUMBER |  |  |  | Purchase Order Schedule Number |  |
PREVIOUS_PURCHASE_ORDER_SCHEDULE_NUMBER | NUMBER |  |  |  | Purchase Order Schedule Number of previous version |  |
PURCHASE_ORDER_SCHEDULE_NUMBER_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Purchase Order Schedule Number changed from previous version |  |
QUANTITY | NUMBER |  |  |  | Quantity |  |
PREVIOUS_QUANTITY | NUMBER |  |  |  | Quantity of previous version |  |
QUANTITY_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Quantity changed from previous version |  |
LOCATION_ID | NUMBER | 38 | 0 |  | Location Identifier | DW_WORKER_LOCATION_D | LOCATION_ID
PREVIOUS_LOCATION_ID | NUMBER | 38 | 0 |  | Location Identifier of previous version | DW_WORKER_LOCATION_D | LOCATION_ID
LOCATION_ID_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Location Identifier changed from previous version |  |
DESTINATION_TYPE_CODE | VARCHAR2 | 32 |  |  | Destination Type Code | DW_POR_DESTINATION_TYPE_D_TL | CODE
PREVIOUS_DESTINATION_TYPE_CODE | VARCHAR2 | 32 |  |  | Destination Type Code of previous version | DW_POR_DESTINATION_TYPE_D_TL | CODE
DESTINATION_TYPE_CODE_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Destination Type Code changed from previous version |  |
REQUESTED_DELIVERY_DATE | DATE |  |  |  | Requested Delivery Date |  |
PREVIOUS_REQUESTED_DELIVERY_DATE | DATE |  |  |  | Requested Delivery Date of previous version |  |
REQUESTED_DELIVERY_DATE_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Requested Delivery Date changed from previous version |  |
PROMISED_DELIVERY_DATE | DATE |  |  |  | Promised Delivery Date |  |
PREVIOUS_PROMISED_DELIVERY_DATE | DATE |  |  |  | Promised Delivery Date of previous version |  |
PROMISED_DELIVERY_DATE_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Promised Delivery Date changed from previous version |  |
REQUESTED_SHIP_DATE | DATE |  |  |  | Requested Ship Date |  |
PREVIOUS_REQUESTED_SHIP_DATE | DATE |  |  |  | Requested Ship Date of previous version |  |
REQUESTED_SHIP_DATE_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Requested Ship Date changed from previous version |  |
PROMISED_SHIP_DATE | DATE |  |  |  | Promised Ship Date |  |
PREVIOUS_PROMISED_SHIP_DATE | DATE |  |  |  | Promised Ship Date of previous version |  |
PROMISED_SHIP_DATE_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Promised Ship Date changed from previous version |  |
CARRIER_ID | NUMBER | 38 | 0 |  | Carrier Identifier | DW_PARTY_D | PARTY_ID
PREVIOUS_CARRIER_ID | NUMBER | 38 | 0 |  | Carrier Identifier of previous version | DW_PARTY_D | PARTY_ID
CARRIER_ID_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Carrier Identifier changed from previous version |  |
MODE_OF_TRANSPORT | VARCHAR2 | 32 |  |  | Mode of Transport |  |
PREVIOUS_MODE_OF_TRANSPORT | VARCHAR2 | 32 |  |  | Mode of Transport of previous version |  |
MODE_OF_TRANSPORT_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Mode of Transport changed from previous version |  |
SERVICE_LEVEL | VARCHAR2 | 32 |  |  | Service Level |  |
PREVIOUS_SERVICE_LEVEL | VARCHAR2 | 32 |  |  | Service Level of previous version |  |
SERVICE_LEVEL_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Service Level changed from previous version |  |
RECEIVING_ROUTING_ID | NUMBER | 38 | 0 |  | Receiving Routing Identifier | DW_RCV_ROUTING_HEADERS_D_TL | CODE
PREVIOUS_RECEIVING_ROUTING_ID | NUMBER | 38 | 0 |  | Receiving Routing Identifier of previous version | DW_RCV_ROUTING_HEADERS_D_TL | CODE
RECEIVING_ROUTING_ID_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Receiving Routing Identifier changed from previous version |  |
MATCH_APPROVAL_LEVEL | VARCHAR2 | 16 |  |  | Match Approval Level |  |
PREVIOUS_MATCH_APPROVAL_LEVEL | VARCHAR2 | 16 |  |  | Match Approval Level of previous version |  |
MATCH_APPROVAL_LEVEL_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Match Approval Level changed from previous version |  |
INVOICE_MATCH_OPTION_CODE | VARCHAR2 | 32 |  |  | Invoice Match Option Code | DW_PO_MATCH_OPTION_D_TL | CODE
PREVIOUS_INVOICE_MATCH_OPTION_CODE | VARCHAR2 | 32 |  |  | Invoice Match Option Code of previous version | DW_PO_MATCH_OPTION_D_TL | CODE
INVOICE_MATCH_OPTION_CODE_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Invoice Match Option Code changed from previous version |  |
NOTE_TO_RECEIVER | VARCHAR2 | 999 |  |  | Note to Receiver |  |
PREVIOUS_NOTE_TO_RECEIVER | VARCHAR2 | 999 |  |  | Note to Receiver of previous version |  |
NOTE_TO_RECEIVER_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Note to Receiver changed from previous version |  |
COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 16 |  |  | Country of Origin Code | DW_INSERT_COUNTRY_LKP_TL | INSERT_COUNTRY_LKP_CODE
PREVIOUS_COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 16 |  |  | Country of Origin Code of previous version | DW_INSERT_COUNTRY_LKP_TL | INSERT_COUNTRY_LKP_CODE
COUNTRY_OF_ORIGIN_CODE_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Country of Origin Code changed from previous version |  |
PO_SCHEDULE_PRICE | NUMBER |  |  |  | PO Schedule level price |  |
PREVIOUS_PO_SCHEDULE_PRICE | NUMBER |  |  |  | PO Schedule level price of previous version |  |
PO_SCHEDULE_PRICE_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if PO Schedule level price 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.