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