M3 Reference
Inventory & Warehouse
Supply chainWarehouse and location balances, lot records, stock transactions, and the warehouse master
6 tables5 programs
Verified September 2026
In the business-problem map Inventory & Working Capital
Tables
Master · 2
- MILOMAThe lot master — one row per item and lot (batch) number, carrying the lot's identity and life-cycle dates; location balances and allocations reference it by BANOPrefix: LMmaster
- MITWHLThe warehouse master — one row per warehouse with its name, facility, and warehouse type; the WHLO every balance and movement carries resolves herePrefix: MWmaster
Balance · 2
- MITBALThe item/warehouse record — one row per item and warehouse, pairing planning policy (safety stock, reorder point, lead time, main supplier) with the warehouse-level on-hand and allocated balancesPrefix: MBbalance
- MITLOCThe location-level balance — one row per item, warehouse, location, lot, and receipt, holding the physical on-hand at the finest grain M3 tracks stock; warehouse-level figures in MITBAL are the roll-up of these rowsPrefix: MLbalance
Transaction · 2
- MITALOAllocations — one row per item, location, and lot allocated to a specific order line, connecting demand (the order reference) to the exact stock that will fill it; the bridge between order lines and MITLOC balancesPrefix: MQtransaction
- MITTRAThe stock transaction ledger — one row per inventory movement (receipt, issue, transfer, adjustment) with its transaction type, quantity, date, and the order reference that caused itPrefix: MTtransaction
Programs
- MMS002 — Item/warehouse maintenance — connects items to warehouses and manages the MITBAL planning parametersInteractive
- MMS060 — Balance identity display — the inquiry over the MITLOC location-level balancesInteractive
- MMS850MI — Stock movement API — moves stock between locations programmatically, writing the MITLOC balances and their MITTRA transactionsAPI
- MWS068 — Balance identity toolbox — the working view over the MITLOC balance identities (item, location, lot, receipt)Interactive
- MWS070 — Stock transaction history — the display over the MITTRA ledger, where M3 stores every physical stock transactionInteractive