MGCLatticeInventOnHandEntity
The MGCLatticeInventOnHandEntity exposes inventory on-hand quantities from InventSum joined to inventory dimensions (InventDim), filtered to open (non-closed) rows. Read-only and performance-optimized with an explicit minimal field projection for high-volume snapshot feeds.
- Public collection name:
LatticeInventoryOnHands
- Primary key:
ItemNumber, InventoryDimensionId
Fields
| Name | Type | Mandatory | Description |
|---|
ItemNumber | ItemId | No | |
InventoryDimensionId | InventDimId | No | |
PhysicalInventoryQuantity | InventQtyPhysicalOnhand | No | |
PhysicalReservedQuantity | InventQtyReservPhysical | No | |
PickedQuantity | InventQtyPicked | No | |
ReceivedQuantity | InventQtyReceived | No | |
DeductedQuantity | InventQtyDeducted | No | |
OnOrderQuantity | InventQtyOnOrder | No | |
OrderedQuantity | InventQtyOrdered | No | |
InventorySiteId | InventSiteId | No | |
InventoryWarehouseId | InventLocationId | No | |
WarehouseLocationId | WMSLocationId | No | |
InventoryBatchId | InventBatchId | No | |
InventoryStatusId | WHSInventStatusId | No | |
LicensePlateId | WHSLicensePlateId | No | |
Mappings
| Entity field | Data source | Field |
|---|
ItemNumber | InventSum | ItemId |
InventoryDimensionId | InventSum | InventDimId |
PhysicalInventoryQuantity | InventSum | PhysicalInvent |
PhysicalReservedQuantity | InventSum | ReservPhysical |
PickedQuantity | InventSum | Picked |
ReceivedQuantity | InventSum | Received |
DeductedQuantity | InventSum | Deducted |
OnOrderQuantity | InventSum | OnOrder |
OrderedQuantity | InventSum | Ordered |
InventorySiteId | InventDim | InventSiteId |
InventoryWarehouseId | InventDim | InventLocationId |
WarehouseLocationId | InventDim | wMSLocationId |
InventoryBatchId | InventDim | InventBatchId |
InventoryStatusId | InventDim | InventStatusId |
LicensePlateId | InventDim | LicensePlateId |