D365 Reference
Inventory
Supply chainOn-hand balances, the inventory transaction ledger, dimension records, and warehouse/location master data
11 tables3 entities
Verified September 2026
In the business-problem map Inventory & Working Capital
Tables
Main · 2
- InventDimThe inventory dimension hub — one row per unique combination of site, warehouse, location, batch, and serial that every stock quantity hangs off by InventDimIdmain
- WMSLocationWarehouse location (bin) master — one row per storage location within a warehouse, with its aisle/rack/level coordinates, zone, profile, and capacity limitsmain
Group · 2
Worksheet Header · 2
- InventBatchBatch master — one row per item and batch number, carrying expiry and manufacturing dates plus vendor batch details; the record behind the inventBatchId dimensionworksheet header
- InventJournalTableInventory journal header — one row per movement, adjustment, transfer, BOM, or counting journal, with its type, posting status, and line countworksheet header
Transaction · 3
- InventSumAggregated on-hand quantities by item and inventory dimension — physical, available, and posted balancestransaction
- InventTransThe inventory transaction ledger — every physical and financial stock movement, with issue/receipt status, quantities, dates, and links back to its source documenttransaction
- InventTransOriginThe origin record every inventory transaction points to — resolves an InventTrans row back to the sales line, purchase line, or journal that created ittransaction
Data Entities
- InventOperationalSiteEntity — Operational sites — the site master export, one record per site with its time zone, default status, and primary address flattened into columns
- InventWarehouseEntity — Warehouses — the warehouse master export, one record per warehouse with its site, type, and warehouse-management settings
- InventWarehouseOnHandV2Entity — Inventory on-hand by warehouse — aggregated on-hand, reserved, available, and on-order quantities per item variant, site, and warehouse