MGCLatticeWarehouseReservationEntity
The MGCLatticeWarehouseReservationEntity exposes aggregated warehouse inventory reservation quantities (physical/ordered available and reserved) by item and inventory dimension from the WHSInventReserve table. Read-only, single-root projection with an explicit minimal field set for high-volume snapshot feeds. Storage/product/tracking dimensions are represented by the InventDimId key rather than joining InventDim.
- Public collection name:
LatticeWarehouseReservations
- Primary key:
ItemNumber, InventoryDimensionId
Fields
| Name | Type | Mandatory | Description |
|---|
ItemNumber | ItemId | No | |
InventoryDimensionId | InventDimId | No | |
AvailablePhysicalQuantity | InventQtyAvailPhysical | No | |
AvailableOrderedQuantity | InventQtyAvailOrdered | No | |
ReservedPhysicalQuantity | InventQtyReservPhysical | No | |
ReservedOrderedQuantity | InventQtyReservOrdered | No | |
ReservationHierarchyLevel | WHSReservationHierarchyLevel | No | |
InventorySiteId | InventSiteId | No | |
InventoryWarehouseId | InventLocationId | No | |
Mappings
| Entity field | Data source | Field |
|---|
ItemNumber | WHSInventReserve | ItemId |
InventoryDimensionId | WHSInventReserve | InventDimId |
AvailablePhysicalQuantity | WHSInventReserve | AvailPhysical |
AvailableOrderedQuantity | WHSInventReserve | AvailOrdered |
ReservedPhysicalQuantity | WHSInventReserve | ReservPhysical |
ReservedOrderedQuantity | WHSInventReserve | ReservOrdered |
ReservationHierarchyLevel | WHSInventReserve | HierarchyLevel |
InventorySiteId | WHSInventReserve | InventSiteId |
InventoryWarehouseId | WHSInventReserve | InventLocationId |