These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- Material Requirement Planning
- Data model and import order
The tables behind Material Requirement Planning
Material Requirement Planning ships with 19 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 19
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Demand and pegging
Orders, order lines, demand pegging, Items and Parties connect customer requirements to dated component needs.
Inventory availability
Inventory balances holds item, location, lot, on-hand and reserved quantities. Material issues retains separate production issue evidence.
MRP runs and exceptions
MRP runs links Planner to People; MRP exceptions links Run and Item. Demand pegging links demand line and Component.
Supply suggestions
Planning suggestions holds item, make or buy choice, quantity and dates. Reconcile the relevant item/date population with the actual purchase or work order.
Purchasing
Purchase orders links Supplier to Parties; purchase lines links purchase order and Item with ordered and received quantities.
Production execution
Work orders links Product, Order, Resource and released by. Batches, material issues and production logs refer to the work order; production logs also links Operator to People.
Supporting identity and rates
Users and People retain the user mapping. Exchange rates holds read-only effective rates by currency and date.
Every table, by feature
- Demand and pegging5
- Inventory availability4
- MRP runs and exceptions5
- Supply suggestions5
- Purchasing5
- Production execution6
- Shared and settings2
- Orders
Orders records for Material Requirement Planning.
Linked to Parties - Order lines
Order Lines records for Material Requirement Planning.
Linked to Orders, Items - Demand pegging
Demand Pegging records for Material Requirement Planning.
Linked to Order lines, Items - Items
Items records for Material Requirement Planning.
- Parties
Parties records for Material Requirement Planning.
- Inventory balances
Inventory Balances records for Material Requirement Planning.
Linked to Items - Items
Items records for Material Requirement Planning.
- Material issues
Material Issues records for Material Requirement Planning.
Linked to Work orders, Items - MRP exceptions
MRP Exceptions records for Material Requirement Planning.
Linked to MRP runs, Items
- MRP runs
MRP Runs records for Material Requirement Planning.
Linked to People - MRP exceptions
MRP Exceptions records for Material Requirement Planning.
Linked to MRP runs, Items - People
People records for Material Requirement Planning.
Linked to Users - Planning suggestions
Planning Suggestions records for Material Requirement Planning.
Linked to Items - Demand pegging
Demand Pegging records for Material Requirement Planning.
Linked to Order lines, Items
- Planning suggestions
Planning Suggestions records for Material Requirement Planning.
Linked to Items - Items
Items records for Material Requirement Planning.
- Purchase orders
Purchase Orders records for Material Requirement Planning.
Linked to Parties - Purchase lines
Purchase Lines records for Material Requirement Planning.
Linked to Purchase orders, Items - Work orders
Work Orders records for Material Requirement Planning.
Linked to Items, Orders, Resources, People
- Purchase orders
Purchase Orders records for Material Requirement Planning.
Linked to Parties - Purchase lines
Purchase Lines records for Material Requirement Planning.
Linked to Purchase orders, Items - Parties
Parties records for Material Requirement Planning.
- Items
Items records for Material Requirement Planning.
- Planning suggestions
Planning Suggestions records for Material Requirement Planning.
Linked to Items
- Work orders
Work Orders records for Material Requirement Planning.
Linked to Items, Orders, Resources, People - Resources
Resources records for Material Requirement Planning.
- Material issues
Material Issues records for Material Requirement Planning.
Linked to Work orders, Items - Production logs
Production Logs records for Material Requirement Planning.
Linked to Work orders, People - Batches
Batches records for Material Requirement Planning.
Linked to Work orders - People
People records for Material Requirement Planning.
Linked to Users
Keys and references
Use stable source identities to resolve references and preserve the exact field names. Most records use Id; exchange rates uses ID, while Users has a User self-reference. Load user identities before resolving that self-reference and People.User. A personal planning view must resolve the linked person through its User mapping.
Use the text in demand pegging.supply reference to locate and check the actual purchase or work order. Reconcile source quantity units with Items.Unit before comparing them. Work orders.release operation key and release input hash retain release identity evidence. Preserve their original values when reviewing released work rather than manufacturing new release evidence during import.
Migration order
- Establish Users identities, then resolve Users.User and People.User in a second pass where needed.
- Load Items, Parties and Resources with agreed units and source identities; agree the read-only exchange rates source separately.
- Load Orders and order lines, then purchase orders and purchase lines with reconciled open quantities.
- Load work orders after their product, customer order, resource and person references can resolve. Load linked material issues, production logs and Batches with their actual states.
- Reconcile inventory balances with the stock owner. Load MRP runs, MRP exceptions and demand pegging in dependency order and review existing planning suggestions before enabling another run.
- Verify references, quantities, identity access and guarded release behavior before accepting the first operating cycle. Do not start historical workflows merely to import prior state.
Set up Material Requirement Planning your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.