D365 Reference
Inventory
Supply chainOn-hand balances, the inventory transaction ledger, dimension records, and warehouse/location master data
11 tables3 entities
Tables
Main · 2
- InventItemPriceItem price records — activated cost, purchase, and sales prices per item, costing version, and dimension; the source for standard-cost analysis
- WMSLocationWarehouse location (bin) master — one row per storage location within a warehouse, with its aisle/rack/level coordinates, zone, profile, and capacity limitsmain
Group · 3
- InventDimThe inventory dimension hub — one row per unique combination of site, warehouse, location, batch, and serial that every stock quantity hangs off by InventDimIdgroup
- InventLocationWarehouse master — one row per warehouse (inventory location) with its site and typegroup
- InventSiteSite master — one row per operational site, the top of the inventory dimension hierarchy that warehouses roll up togroup
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
- InventOperationalSiteEntityOperational sites — the site master export, one record per site with its time zone, default status, and primary address flattened into columns
- InventWarehouseEntityWarehouses — the warehouse master export, one record per warehouse with its site, type, and warehouse-management settings
- InventWarehouseOnHandV2EntityInventory on-hand by warehouse — aggregated on-hand, reserved, available, and on-order quantities per item variant, site, and warehouse