# DW_WSH_PICK_AND_SHIP_CF

This table provides information about picking, packing and shipping for sales orders, transfer orders and work 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 |  |  | This column is for Oracle Internal use only. 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
WORK_ORDER_NUMBER | VARCHAR2 | 128 |  |  | For Outside Processing - The representation of the Work Order for which the shipment was created. |  |
WORK_ORDER_OPERATION_SEQ_NUMBER | NUMBER |  |  |  | For Outside Processing - The sequence number of the Work Order Operation for the Work Order for which the shipment was created. |  |
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
SHIPMENT_LINE_INVENTORY_ORG_PROFIT_CENTER_BU_ID | NUMBER | 38 | 0 |  | Profit Center Business Unit Id of the Inventory Organization. | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_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_PARENT_LPN_ID | NUMBER | 38 | 0 |  | Parent Packing Unit ID for the shipment line. |  |
SHIPMENT_LINE_PARENT_PACKING_UNIT | VARCHAR2 | 32 |  |  | Parent Packing Unit name for 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_NAME | VARCHAR2 | 32 |  |  | This is the name 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_CARRIER_PARTY_ID | NUMBER | 38 | 0 |  | This is the party identifier of the carrier on shipment level, that is tagged to the shipping method | DW_PARTY_D | PARTY_ID
SHIPMENT_MODE_OF_TRANSPORT_CODE | VARCHAR2 | 32 |  |  | Mode of transport for the shipping method for shipment. | DW_WSH_MODE_OF_TRANSPORT_LKP_TL | WSH_MODE_OF_TRANSPORT_CODE
SHIPMENT_SERVICE_LEVEL_CODE | VARCHAR2 | 32 |  |  | Service level for the shipping method at shipment level.. | DW_WSH_SERVICE_LEVELS_LKP_TL | WSH_SERVICE_LEVELS_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

Copyright © 2019, 2025, Oracle and/or its affiliates.