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.