This table provides information about picking, packing and shipping for sales orders and transfer orders.
Module: Inventory Management
SHIPMENT_LINE_ID
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 |
#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