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.
- Production Dashboard
- Data model and import order
The tables behind Production Dashboard
Production Dashboard ships with 16 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
- 16
- Features
- 7
- Change it
- Add fields and tables in Proto
How the model is organised
Target planning
Production targets, Resources and Items define the product, resource, target date, good-unit target and planned minutes.
Shift performance
Shift actuals points to production targets through Target and retains shift code, good units, scrap units, run minutes and recorded at.
Work order control
Work orders links Product, Order and Resource; Orders, order lines and Parties provide the approved demand context.
Resources and scheduling
Resources carries availability and daily capacity; work orders supplies planned start and planned end for release checks.
Materials and inventory
Material issues and inventory balances connect quantities with Items and lot context. Purchase orders and purchase lines provide supplier-order context through Parties.
Production evidence
Production logs links work order and Operator. People.User links the operator identity to Users for guarded actor resolution.
Batch quality
Batches links work order and lot disposition. The release action checks completed interval evidence and the required finished-goods balance.
Every table, by feature
- Target planning5
- Shift performance5
- Work order control7
- Resources and scheduling4
- Materials and inventory8
- Production evidence6
- Batch quality6
- Production targets
Planned good units and minutes per resource, product and date.
Linked to Resources, Items - Resources
Production work centers and machines.
- Items
Materials, components and finished goods.
- People
Production staff and their linked platform user accounts.
Linked to Users - Shift actuals
Shift-level actual output recorded against a production target.
Linked to Production targets
- Shift actuals
Shift-level actual output recorded against a production target.
Linked to Production targets - Production targets
Planned good units and minutes per resource, product and date.
Linked to Resources, Items - Resources
Production work centers and machines.
- Items
Materials, components and finished goods.
- Production logs
Operator production intervals with good and scrap units.
Linked to Work orders, People
- Work orders
Production work orders released to the shop floor.
Linked to Items, Orders, Resources - Orders
Customer sales orders.
Linked to Parties - Order lines
Line items on customer orders.
Linked to Orders, Items - Parties
Customers and suppliers.
- Items
Materials, components and finished goods.
- Resources
Production work centers and machines.
- People
Production staff and their linked platform user accounts.
Linked to Users
- Resources
Production work centers and machines.
- Work orders
Production work orders released to the shop floor.
Linked to Items, Orders, Resources - Production targets
Planned good units and minutes per resource, product and date.
Linked to Resources, Items - Items
Materials, components and finished goods.
- Material issues
Material issued to work orders, decrementing inventory.
Linked to Work orders, Items - Inventory balances
On-hand and reserved quantity by item, location and lot.
Linked to Items - Items
Materials, components and finished goods.
- Work orders
Production work orders released to the shop floor.
Linked to Items, Orders, Resources - Purchase orders
Supplier purchase orders.
Linked to Parties - Purchase lines
Line items on purchase orders.
Linked to Purchase orders, Items - Parties
Customers and suppliers.
- People
Production staff and their linked platform user accounts.
Linked to Users
- Production logs
Operator production intervals with good and scrap units.
Linked to Work orders, People - Work orders
Production work orders released to the shop floor.
Linked to Items, Orders, Resources - People
Production staff and their linked platform user accounts.
Linked to Users - Users
Users
Linked to Users - Batches
Produced lots and their quality disposition.
Linked to Work orders - Shift actuals
Shift-level actual output recorded against a production target.
Linked to Production targets
- Batches
Produced lots and their quality disposition.
Linked to Work orders - Work orders
Production work orders released to the shop floor.
Linked to Items, Orders, Resources - Production logs
Operator production intervals with good and scrap units.
Linked to Work orders, People - Inventory balances
On-hand and reserved quantity by item, location and lot.
Linked to Items - Items
Materials, components and finished goods.
- People
Production staff and their linked platform user accounts.
Linked to Users
Keys and references
The model contains 16 tables. Preserve Id where supplied and resolve references by stable record identity rather than Name. Users uses User as its required self-reference. Import Users and resolve self-references in a controlled pass, then connect People.User to the authenticated platform identity.
Shift actuals.Target points to production targets. Review targets and work orders through their shared resource and product context. Agree how the material posting action resolves the exact inventory balances record, including its Location and lot number, before live withdrawal.
Target and shift capture preserve attributed successor evidence on correction. Keep the saved evidence and verify effective-record selection before aggregating corrected targets or actuals. Rehearse the selection with the operating team so the earlier submission remains available for explanation.
Migration order
- Prepare Users identities and controlled self-references, then People and its User mapping.
- Load Parties, Items and Resources with their stable identifiers, units and reviewed availability.
- Load Orders and order lines, then purchase orders and purchase lines as demand and supply context.
- Reconcile inventory balances by Item, Location and lot number; load work orders with resolved Product, Order and Resource references.
- Load production targets before shift actuals and preserve the exact Target references and correction evidence.
- Migrate historical material issues, production logs and Batches only with their original evidence and resolved references. Do not replay live posting actions merely to copy history.
- Reconcile opening quantities and current comparisons, test actor resolution and rehearse guarded failures before admitting live work.
Set up Production Dashboard your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.