MTL_ONHAND_QUANTITIES_DETAIL
Current on-hand quantity for an item by subinventory/locator.
Key Columns
Common Joins
MTL_SECONDARY_INVENTORIESvia SUBINVENTORY_CODE + ORGANIZATION_IDThe subinventory (warehouse storage area, e.g. Stores, Staging, Damaged) this on-hand quantity sits in.
MTL_ITEM_LOCATIONSvia LOCATOR_IDThe specific locator (row/rack/bin) within the subinventory this quantity is placed at, if the subinventory tracks locators.
Used In
Related
Item and on-hand data model
EGP_SYSTEM_ITEMS_B is the item master (per item per org). MTL_ONHAND_QUANTITIES_DETAIL is the current snapshot of quantity by subinventory; MTL_MATERIAL_TRANSACTIONS is the full historical log of everything that moved that quantity.
Warehouse structure: subinventories and locators
A warehouse's physical structure in Fusion Inventory is two levels: subinventories (MTL_SECONDARY_INVENTORIES) are named storage areas within an organization — Stores, Staging, Damaged — and, where locator control is enabled, each subinventory is further divided into locators (MTL_ITEM_LOCATIONS) representing a specific row/rack/bin. On-hand quantity (MTL_ONHAND_QUANTITIES_DETAIL) is tracked at whichever granularity is enabled — subinventory alone, or subinventory plus locator.