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