M3 Reference
Items & Product Data
Supply chainThe item master and the product data every balance, order, and movement points back to
4 tables2 programs
Tables
Master · 4
- MITAUNAlternate units of measure — one row per item, unit type, and alternate unit, carrying the conversion factor between the alternate unit and the item's basic unit; the table that answers 'how many eaches in a case'Prefix: MUmaster
- MITFACThe item/facility record — one row per item and facility, where costing lives; the approved cost the facility values the item at sits here, between the company-wide item master and the warehouse-level balancesPrefix: M9master
- MITMASThe item master — one row per item per company, carrying the item's identity, status, grouping codes, basic unit of measure, and physical attributes; every balance, order line, and stock movement joins back to it on ITNOPrefix: MMmaster
- MITPOPItem aliases — one row per alias type, qualifier, and alias number, mapping external identities (customer or supplier item numbers, barcodes) to the internal ITNO; the lookup behind alias-based item searchPrefix: MPmaster