DW_WSH_PICK_AND_SHIP_CF

This table provides information about picking, packing and shipping for sales orders and transfer orders.

Details

Module: Inventory Management

Key Columns

SHIPMENT_LINE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SHIPMENT_LINE_ID NUMBER 38 0 True Unique Identifier for a shipment line    
SOURCE_RECORD_ID VARCHAR2 128     System Identifier    
SALES_ORDER_HEADER_ID NUMBER 38 0   Unique identifier of the orchestration order    
SALES_ORDER_LINE_ID NUMBER 38 0   Unique identifier of the sales order line    
FULFILL_LINE_ID NUMBER 38 0   Unique Identifier for a fulfillment line    
SHIPMENT_LINE_ASSIGNMENT_ID NUMBER 38 0   Primary Key for assignment of a shipment line to a shipment.    
INV_MTL_TRANSACTION_ID NUMBER 38 0   Primary key of the inventory transaction.    
MOVEMENT_REQUEST_HEADER_ID NUMBER 38 0   This is the primary key of the movement request.    
MOVEMENT_REQUEST_LINE_ID NUMBER 38 0   Primary key of the movement request line.    
PICK_WAVE_ID NUMBER 38 0   Primary key of the pick wave batch.    
FULFILL_LINE_NUMBER NUMBER 38 0   Numerical value associated to fulfillment line. It is defaulted to 1 and increments in integers as fulfillment lines split    
FULFILL_DISPLAY_LINE_NUMBER VARCHAR2 256     Fulfill Line number for display purposes. Corresponds to the Fulfill line number on UI    
FULFILL_LINE_PROFIT_CENTER_BUSINESS_UNIT_ID NUMBER 38 0   Reference to Unique Identifier of Profit Center Business Unit DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
FULFILL_LINE_INVENTORY_ORG_ID NUMBER 38 0   Indicates the identifier of the inventory organization DW_INTERNAL_ORG_D ORGANIZATION_ID
FULFILL_LINE_BILL_TO_CUSTOMER_ACCOUNT_ID NUMBER 38 0   Reference to the unique identifier for the bill-to customer DW_CUSTOMER_ACCOUNT_D CUSTOMER_ACCOUNT_ID
FULFILL_LINE_BILL_TO_PARTY_ID NUMBER 38 0   Reference to the unique identifier for bill-to Party DW_PARTY_D PARTY_ID
FULFILL_LINE_SHIP_TO_PARTY_ID NUMBER 38 0   Reference to the unique identifier for ship-to Party DW_PARTY_D PARTY_ID
FULFILL_LINE_CUSTOMER_PO_NUMBER VARCHAR2 64     A commercial document that is used to request that a seller to supply a product or service in return for payment.    
FULFILL_LINE_CUSTOMER_PO_LINE_NUMBER VARCHAR2 64     An identifier of the line record on a transaction. The purchase order line describes an item or service, with a price and quantity ordered    
FULFILL_LINE_CUSTOMER_PO_SCHEDULE_NUMBER VARCHAR2 64     Contains Customers Purchase Order Shipment Schedule number , if specified while submitting an order.    
FULFILL_LINE_REQUEST_ARRIVAL_TIMESTAMP TIMESTAMP       The original date the customer requested the item arrive on.    
FULFILL_LINE_REQUEST_ARRIVAL_DATE DATE       The original date the customer requested the item arrive on. DW_DAY_D CALENDAR_DATE
FULFILL_LINE_REQUEST_SHIP_TIMESTAMP TIMESTAMP       The original date the customer requested the item ship on.    
FULFILL_LINE_REQUEST_SHIP_DATE DATE       The original date the customer requested the item ship on. DW_DAY_D CALENDAR_DATE
SALES_ORDER_NUMBER VARCHAR2 64     Representation of a sales order used in communication with fulfillment systems    
SALES_ORDER_STATUS_CODE VARCHAR2 32     Status of the order. DW_OM_STATUS_D STATUS_CODE
SALES_ORDER_TYPE_CODE VARCHAR2 32     Name of the type of order that was placed. Stores codes for values of order types. DW_ORDER_TYPE_LKP_TL ORDER_TYPE_CODE
SALES_ORDER_BUSINESS_UNIT_ID NUMBER 38 0   Sales order Business Unit Identifier DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
SALES_ORDER_SOLD_TO_PARTY_ID NUMBER 38 0   Reference to the unique identifier for the sold-to Party. DW_PARTY_D PARTY_ID
SALES_ORDER_LINE_DISPLAY_LINE_NUMBER VARCHAR2 128     Line number for display purposes. Corresponds to the line number on UI    
MATERIAL_TXN_PICK_SLIP_NUMBER NUMBER 38 0   Pick Slip number for the transaction line    
MATERIAL_TXN_PICK_SLIP_LINE_NUMBER NUMBER       Pick slip line number for this transaction.    
MATERIAL_TXN_PICKED_TIMESTAMP TIMESTAMP       This is the date(Timestamp format) when the transaction was processed.    
MATERIAL_TXN_PICKED_DATE DATE       This is the date when the transaction was processed. DW_DAY_D CALENDAR_DATE
MOVEMENT_REQUEST_NUMBER VARCHAR2 32     Request number of the move order    
MOVEMENT_REQUEST_CREATION_TIMESTAMP TIMESTAMP       Creation date(Timestamp format) of the move order    
MOVEMENT_REQUEST_CREATION_DATE DATE       Creation date of the move order DW_DAY_D CALENDAR_DATE
MOVEMENT_REQUEST_LAST_UPDATE_TIMESTAMP TIMESTAMP       Last update date(timestamp format) of the move order    
MOVEMENT_REQUEST_LAST_UPDATE_DATE DATE       Last update date of the move order DW_DAY_D CALENDAR_DATE
MOVEMENT_REQUEST_LINE_NUMBER NUMBER 38 0   This is the movement request line number.    
MOVEMENT_REQUEST_LINE_CREATION_TIMESTAMP TIMESTAMP       Creation date(Timestamp format) of the move order line    
MOVEMENT_REQUEST_LINE_CREATION_DATE DATE       Creation date of the move order line DW_DAY_D CALENDAR_DATE
MOVEMENT_REQUEST_LINE_LAST_UPDATE_TIMESTAMP TIMESTAMP       Last update date(timestamp format) of the move order line    
MOVEMENT_REQUEST_LINE_LAST_UPDATE_DATE DATE       Last update date of the move order DW_DAY_D CALENDAR_DATE
TRANSFER_ORDER_NUMBER VARCHAR2 256     This is the transfer order number    
TRANSFER_ORDER_LINE_NUMBER VARCHAR2 256     This is the transfer order line number    
SHIPMENT_LINE_SCHEDULED_SHIP_TIMESTAMP TIMESTAMP       This is the scheduled ship date(Timestamp format) for the shipment line    
SHIPMENT_LINE_SCHEDULED_SHIP_DATE DATE       This is the scheduled ship date for the shipment line DW_DAY_D CALENDAR_DATE
SHIPMENT_LINES_INV_ORG_BUSINESS_UNIT_ID NUMBER 38 0   This is the Business unit assigned to the inventory org on shipment lines DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
SHIPMENT_LINES_INV_ORG_LEDGER_ID NUMBER 38 0   This is the Ledger for the business unit assigned to the inventory org on shipment lines DW_LEDGER_D LEDGER_ID
FISCAL_PERIOD_SET_NAME VARCHAR2 16     Period Set Name.Derived from the ledger associated with the Business Unit. #2 DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE VARCHAR2 16     Period type. Derived from the ledger associated with the Business Unit. #2 DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
SHIPMENT_LINE_ORGANIZATION_ID NUMBER 38 0   This is the inventory org on shipment lines DW_INTERNAL_ORG_D ORGANIZATION_ID
LEGAL_ENTITY_ID NUMBER 38 0   This is the legal entity identifier for the inventory org DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
SHIPMENT_LINE_INVENTORY_ITEM_ID NUMBER 38 0   This is the inventory Item identifier on shipment line #1 DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID
SHIPMENT_LINE_LOT_NUMBER VARCHAR2 128     Lot number of item in the shipment line.    
SHIPMENT_LINE_REQUESTED_DATE_TYPE_CODE VARCHAR2 32     Code that determines the type of date requested, Like Deliver/Ship DW_ORA_WSH_REQ_DATE_TYPE_LKP_TL ORA_WSH_REQ_DATE_TYPE_CODE
SHIPMENT_LINE_ORDER_TYPE_CODE VARCHAR2 32     Identifies the type of source line. DW_ORA_WSH_ORDER_LINE_TYPE_LKP_TL ORA_WSH_ORDER_LINE_TYPE_CODE
SHIPMENT_LINE_STATUS_CODE VARCHAR2 16     Status that determines where the shipment line is in its lifecycle (ready to release, released, staged, shipped, or backordered). DW_WSH_PICK_STATUS_LKP_TL WSH_PICK_STATUS_CODE
SHIPMENT_LINE_CREATION_TIMESTAMP TIMESTAMP       This is the creation date(Timestamp format) for the shipment line    
SHIPMENT_LINE_CREATION_DATE DATE       This is the creation date for the shipment line DW_DAY_D CALENDAR_DATE
SHIPMENT_LINE_LAST_UPDATE_TIMESTAMP TIMESTAMP       Last update date for the shipment line(Timestamp format)    
SHIPMENT_LINE_LAST_UPDATE_DATE DATE       Last update date for the shipment line DW_DAY_D CALENDAR_DATE
SHIPMENT_LINE_WEIGHT_UOM_CODE VARCHAR2 16     Unit of measure code for weight DW_UNIT_OF_MEASURE_D_TL UOM_CODE
SHIPMENT_LINE_GROSS_WEIGHT NUMBER       Gross weight of the shipment line    
SHIPMENT_LINE_NET_WEIGHT NUMBER       Container Net and Loose Item weight    
SHIPMENT_LINE_VOLUME_UOM_CODE VARCHAR2 16     Unit of measure code for volume DW_UNIT_OF_MEASURE_D_TL UOM_CODE
SHIPMENT_LINE_VOLUME NUMBER       Volume of the item in this shipment line    
SHIPMENT_LINE_SHIPMENT_PRIORITY_CODE VARCHAR2 32     Shipment priority for the shipment line. DW_WSH_SHIPPING_PRIORITY_LKP_TL WSH_SHIPPING_PRIORITY_CODE
SHIPMENT_LINE_TRACKING_NUMBER VARCHAR2 32     Tracking number of the shipment line.    
SHIPMENT_LINE_LOADING_SEQUENCE NUMBER       Sequence number for loading the shipment line.    
SHIPMENT_LINE_FOB_CODE VARCHAR2 32     Code that determines freight on board. DW_FOB_LKP_TL FOB_CODE
SHIPMENT_LINE_FREIGHT_TERMS_CODE VARCHAR2 32     Code that determines the freight terms. DW_WSH_FREIGHT_CHARGE_TERMS_LKP_TL WSH_FREIGHT_CHARGE_TERMS_CODE
SHIPMENT_LINE_CARRIER_PARTY_ID NUMBER 38 0   This is the party identifier of the carrier, that is tagged to the shipping method DW_PARTY_D PARTY_ID
SHIPMENT_LINE_MODE_OF_TRANSPORT_CODE VARCHAR2 32     Mode of transport for the shipping method. DW_WSH_MODE_OF_TRANSPORT_LKP_TL WSH_MODE_OF_TRANSPORT_CODE
SHIPMENT_LINE_SERVICE_LEVEL_CODE VARCHAR2 32     Service level for the shipping method. DW_WSH_SERVICE_LEVELS_LKP_TL WSH_SERVICE_LEVELS_CODE
SHIPMENT_LINE_SHIP_SET_NAME VARCHAR2 256     Ship Set Name to which the Order Line belongs to    
SHIPMENT_LINE_TRANSACTION_UOM_CODE VARCHAR2 16     Unit of measure for requested quantity for the shipment line DW_UNIT_OF_MEASURE_D_TL UOM_CODE
SHIPMENT_LINE_REQUESTED_QUANTITY NUMBER       Requested shipping quantity for customer.    
SHIPMENT_LINE_STAGED_QUANTITY NUMBER       Quantity that is picked for the shipment line and staged for shipping    
SHIPMENT_LINE_SHIPPED_QUANTITY NUMBER       Shipped quantity in requested quantity unit of measure    
SHIPMENT_LINE_CANCELLED_QUANTITY NUMBER       Quantity that was canceled by the source system.    
SHIPMENT_LINE_SECONDARY_UOM_CODE VARCHAR2 16     Secondary ordered quantity unit of measure for the shipment line. DW_UNIT_OF_MEASURE_D_TL UOM_CODE
SHIPMNT_LINE_SECONDARY_REQUESTED_QUANTITY NUMBER       Requested shipping secondary quantity for customer.    
SHIPMENT_LINE_SECONDARY_STAGED_QUANTITY NUMBER       Quantity that is picked for the shipment line and staged for shipping in secondary unit of measure    
SHIPMENT_LINE_SECONDARY_SHIPPED_QUANTITY NUMBER       Shipped quantity in secondary unit of measure    
SHIPMENT_LINE_SECONDARY_CANCELLED_QUANTITY NUMBER       Quantity that was canceled by the source system in secondary unit of measure    
SHIPMENT_LINE_PUOM_CODE VARCHAR2 16     Primary Unit of measure of the Item used for the transaction DW_UNIT_OF_MEASURE_D_TL UOM_CODE
SHIPMENT_LINE_PUOM_CONVERSION_FACTOR NUMBER       Primary Unit conversion factor    
SHIPMENT_LINE_PUOM_REQUESTED_QUANTITY NUMBER       Requested quantity in Primary Unit of measure    
SHIPMENT_LINE_PUOM_STAGED_QUANTITY NUMBER       Staged quantity in Primary Unit of measure    
SHIPMENT_LINE_PUOM_SHIPPED_QUANTITY NUMBER       Shipped quantity in Primary Unit of measure    
SHIPMENT_LINE_PUOM_CANCELLED_QUANTITY NUMBER       Cancelled quantity in Primary Unit of measure    
SHIPMENT_LINE_REQUESTED_TIMESTAMP TIMESTAMP       Date on which line is requested(Timestamp format)    
SHIPMENT_LINE_REQUESTED_DATE DATE       Date on which line is requested DW_DAY_D CALENDAR_DATE
SHIPMENT_NUMBER NUMBER 38 0   This is the delivery identifier of the shipment    
SHIPMENT_STATUS_CODE VARCHAR2 16     Delivery shipping status ,e.g., OP for Open delivery DW_WSH_DELIVERY_STATUS_LKP_TL WSH_DELIVERY_STATUS_CODE
SHIPMENT_INITIAL_SHIP_TIMESTAMP TIMESTAMP       Date on which the delivery is first picked up(Timestamp format)    
SHIPMENT_INITIAL_SHIP_DATE DATE       Date on which the delivery is first picked up DW_DAY_D CALENDAR_DATE
SHIPMENT_PLANNED_DELIVERY_TIMESTAMP TIMESTAMP       Date on which the delivery is finally dropped off(Timestamp format)    
SHIPMENT_PLANNED_DELIVERY_DATE DATE       Date on which the delivery is finally dropped off DW_DAY_D CALENDAR_DATE
SHIPMENT_ACTUAL_SHIP_TIMESTAMP TIMESTAMP       This date is when the shipment was actually shipped(Timestamp format).    
SHIPMENT_ACTUAL_SHIP_DATE DATE       This date is when the shipment was actually shipped DW_DAY_D CALENDAR_DATE
SHIPMENT_BILL_OF_LADING_NUMBER VARCHAR2 64     This is the bill of lading number.    
SHIPMENT_WAYBILL VARCHAR2 32     This may be the tracking number.    
SHIPMENT_PACKING_SLIP_NUMBER VARCHAR2 64     This is the packing slip number.    
SHIPMENT_PACKING_SLIP_STATUS_CODE VARCHAR2 16     Defines Packing Slip Status (F = Final, D = Draft, C = Canceled) DW_ORA_WSH_PACK_STATUS_LKP_TL ORA_WSH_PACK_STATUS_CODE
SHIPMENT_CREATION_TIMESTAMP TIMESTAMP       Date on which shipment is created(Timestamp format)    
SHIPMENT_CREATION_DATE DATE       Date on which shipment is created DW_DAY_D CALENDAR_DATE
SHIPMENT_LAST_UPDATE_TIMESTAMP TIMESTAMP       Last update date of the shipment(Timestamp format)    
SHIPMENT_LAST_UPDATE_DATE DATE       Last update date of the shipment DW_DAY_D CALENDAR_DATE
PICK_WAVE_NUMBER VARCHAR2 32     Unique name of this pick wave batch.    
MATERIAL_TXN_PICK_FROM_SUBINVENTORY VARCHAR2 16     Subinventory to pick release from. #3 DW_INV_SUBINVENTORY_D SECONDARY_INVENTORY_NAME
MATERIAL_TXN_PICK_FROM_SUBINVENTORY_LOCATION_ID NUMBER 38 0   This identifies the location of the subinventory the shipment is picked from DW_WORKER_LOCATION_D LOCATION_ID
MATERIAL_TXN_PICK_FROM_LOCATOR_ID NUMBER 38 0   This identifies the locator to pick release from. DW_INV_LOCATOR_D INVENTORY_LOCATION_ID
MATERIAL_TXN_STAGING_SUBINVENTORY VARCHAR2 16     This identifies the location of the staging subinventory DW_INV_SUBINVENTORY_D SECONDARY_INVENTORY_NAME
MATERIAL_TXN_STAGING_SUBINVENTORY_LOCATION_ID NUMBER 38 0   This identifies the location of the staging subinventory the shipment is picked from DW_WORKER_LOCATION_D LOCATION_ID
MATERIAL_TXN_STAGING_LOCATOR_ID NUMBER 38 0   This identifies the default locator to stage to DW_INV_LOCATOR_D INVENTORY_LOCATION_ID
PICK_WAVE_CREATION_TIMESTAMP TIMESTAMP       This is the creation date(Timestamp format) for the pick wave    
PICK_WAVE_CREATION_DATE DATE       This is the creation date for the pick wave DW_DAY_D CALENDAR_DATE
PICK_WAVE_LAST_UPDATE_TIMESTAMP TIMESTAMP       Last update date for the pick wave batch(Timestamp format)    
PICK_WAVE_LAST_UPDATE_DATE DATE       Last update date for the pick wave batch(Timestamp format) DW_DAY_D CALENDAR_DATE
PICK_WAVE_CREATED_BY VARCHAR2 64     Indciates the user who created the pick wave DW_USER_D USERNAME
PJC_PROJECT_ID NUMBER 38 0   Identifier of the project used to build the transaction descriptive flexfield for project-related transaction distributions. DW_PROJECT_D PROJECT_ID
PJC_TASK_ID NUMBER 38 0   Identifier of the task used to build the transaction descriptive flexfield for project-related transaction distributions. DW_PROJECT_ELEMENT_D PROJ_ELEMENT_ID

Notes

#1 In these cases in addition to the item columns SHIPMENT_LINE_ORGANIZATION_ID column should also be used for join with DW_INVENTORY_ITEM_D

#2 In these cases to join with DW_FISCAL_DAY_D apart from FISCAL_PERIOD_TYPE and FISCAL_PERIOD_SET_NAME the relationship should be based on SHIPMENT_LINE_SCHEDULED_SHIP_DATE column

#3 In these cases in addition to the subinventory columns SHIPMENT_LINE_ORGANIZATION_ID column should also be used for join with DW_INV_SUBINVENTORY_D