WMS Order Line

WM_InOutBoundLine

Overview

Table NameWM_InOutBoundLine
Access LevelClient Only
Entity TypeMM06
Is DocumentNo
Is ViewNo
Has UUIDYes
Parent TableM_InOutLine
WikiView on iDempiere Wiki

Columns (37)

Column Type Required Default Description
InternalNote Text(2000) No - -
M_InOutLine_ID Search(22) No - Line on Shipment or Receipt document
PendingQty Number(14) No 0 -
PickingNote Text(2000) No - -
ShippingNote Text(2000) No - -
WMSNote Text(2000) No - -
WM_InOutBound_ID Table Direct(10) Yes - -
Line Integer(22) Yes @SQL=SELECT NVL(MAX(Line),0)+10 AS DefaultValue FROM WM_InOutBoundLine WHERE WM_InOutBound_ID=@ WM_InOutBound_ID@ Unique line for this document
AD_Client_ID Table Direct(22) Yes @#AD_Client_ID@ Tenant for this installation.
AD_Org_ID Table Direct(10) Yes @#AD_Org_ID@ Organizational entity within tenant
AD_OrgTrx_ID Table(10) No - Performing or initiating organization
C_Activity_ID Table Direct(10) No - Business Activity
C_Campaign_ID Table Direct(10) No - Marketing Campaign
C_Charge_ID Table Direct(10) No - Additional document charges
C_OrderLine_ID Search(22) No - Sales Order Line
C_Project_ID Table Direct(10) No - Financial Project
C_ProjectPhase_ID Table Direct(10) No - Phase of a Project
C_ProjectTask_ID Table Direct(10) No - Actual Project Task in a Phase
Created Date+Time(29) Yes SYSDATE Date this record was created
CreatedBy Search(10) Yes - User who created this records
C_UOM_ID Table Direct(22) Yes @#C_UOM_ID@ Unit of Measure
Description String(255) No - Optional short description of the record
IsActive Yes-No(1) Yes - The record is active in the system
IsDescription Yes-No(1) Yes - if true, the line is just description and no transaction
M_AttributeSetInstance_ID Product Attribute(22) No - Product Attribute Set Instance
MovementQty Quantity(131089) Yes 1 Quantity of a product moved.
M_Product_ID Search(10) No - Product, Service, Item
PickDate Date+Time(7) No - Date/Time when picked for Shipment
PickedQty Quantity(22) No - -
Processed Yes-No(1) Yes - The document has been processed
ShipDate Date+Time(7) No - Shipment Date/Time
Updated Date+Time(29) Yes SYSDATE Date this record was updated
UpdatedBy Search(10) Yes - User who updated this records
User1_ID Table(10) No - User defined element #1
User2_ID Table(10) No - User defined element #2
WM_InOutBoundLine_ID ID(22) Yes - -
WM_InOutBoundLine_UU String(36) No - -

Foreign Keys

Column References Description
M_InOutLine_ID M_InOutLine.M_InOutLine_ID Line on Shipment or Receipt document
WM_InOutBound_ID WM_InOutBound.WM_InOutBound_ID -
AD_Client_ID AD_Client.AD_Client_ID Tenant for this installation.
AD_Org_ID AD_Org.AD_Org_ID Organizational entity within tenant
AD_OrgTrx_ID AD_OrgTrx.AD_OrgTrx_ID Performing or initiating organization
C_Activity_ID C_Activity.C_Activity_ID Business Activity
C_Campaign_ID C_Campaign.C_Campaign_ID Marketing Campaign
C_Charge_ID C_Charge.C_Charge_ID Additional document charges
C_OrderLine_ID C_OrderLine.C_OrderLine_ID Sales Order Line
C_Project_ID C_Project.C_Project_ID Financial Project
C_ProjectPhase_ID C_ProjectPhase.C_ProjectPhase_ID Phase of a Project
C_ProjectTask_ID C_ProjectTask.C_ProjectTask_ID Actual Project Task in a Phase
C_UOM_ID C_UOM.C_UOM_ID Unit of Measure
M_AttributeSetInstance_ID M_AttributeSetInstance.M_AttributeSetInstance_ID Product Attribute Set Instance
M_Product_ID M_Product.M_Product_ID Product, Service, Item
User1_ID User1.User1_ID User defined element #1
User2_ID User2.User2_ID User defined element #2

Generated on 2026-05-03T17:55:42.135549074Z