M3 Reference
Inventory & Warehouse
Supply chainWarehouse and location balances, lot records, stock transactions, and the warehouse master
6 tables1 programs
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