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.
- Batch Manufacturing
- Data model and import order
The tables behind Batch Manufacturing
Batch Manufacturing 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
- 6
- Change it
- Add fields and tables in Proto
How the model is organised
Work orders and resources
Work orders references Product in Items, Order in Orders and Resource in Resources. Planned quantity, planned start and planned end define the plan; Resources records capacity minutes per day and Status.
Materials and lot inventory
Material issues references work order and Item and records lot number, Quantity, issued at and Status. Inventory balances keeps Item, Location, lot number, quantity on hand and reserved quantity.
Production logs
Production logs links work order and Operator in People, retaining started at, ended at, good units and scrap units. People.User links the operator identity to Users.
Batch inputs
Batch inputs references Batch in Batches and Material in Items. Source lot, issued quantity and Unit describe the attributed material.
Batch outputs and quality
Batches references work order and keeps lot number, produced at, expiry date and Disposition. Batch outputs references Batch and output item in Items, with good quantity, rework quantity, scrap quantity and Unit.
Orders and purchasing
Orders.Customer and purchase orders.Supplier reference Parties. Order lines links Order and Item; purchase lines links purchase order and Item and retains ordered quantity, received quantity and unit cost.
Every table, by feature
- Work orders and resources5
- Materials and lot inventory5
- Production logs6
- Batch inputs5
- Batch outputs and quality7
- Orders and purchasing8
- Work orders
Production work orders
Linked to Items, Orders, Resources - Resources
Production resources and capacity
- Orders
Customer orders
Linked to Parties - Order lines
Order line items
Linked to Orders, Items - Items
Materials, components and finished goods
- Material issues
Material issue postings to work orders
Linked to Work orders, Items - Inventory balances
Item inventory balances by location and lot
Linked to Items - Items
Materials, components and finished goods
- Work orders
Production work orders
Linked to Items, Orders, Resources - Batch inputs
Materials issued into a batch
Linked to Batches, Items
- Production logs
Production interval logs with good and scrap units
Linked to Work orders, People - Work orders
Production work orders
Linked to Items, Orders, Resources - People
People records for Batch Manufacturing
Linked to Users - Users
Users
Linked to Users - Material issues
Material issue postings to work orders
Linked to Work orders, Items - Inventory balances
Item inventory balances by location and lot
Linked to Items
- Batch inputs
Materials issued into a batch
Linked to Batches, Items - Batches
Production batches and disposition
Linked to Work orders - Items
Materials, components and finished goods
- Work orders
Production work orders
Linked to Items, Orders, Resources - Material issues
Material issue postings to work orders
Linked to Work orders, Items
- Batch outputs
Batch output quantities including rework and scrap
Linked to Batches, Items - Batches
Production batches and disposition
Linked to Work orders - Batch inputs
Materials issued into a batch
Linked to Batches, Items - Work orders
Production work orders
Linked to Items, Orders, Resources - Production logs
Production interval logs with good and scrap units
Linked to Work orders, People - Inventory balances
Item inventory balances by location and lot
Linked to Items - Items
Materials, components and finished goods
- Orders
Customer orders
Linked to Parties - Order lines
Order line items
Linked to Orders, Items - Purchase orders
Supplier purchase orders
Linked to Parties - Purchase lines
Purchase order line items
Linked to Purchase orders, Items - Parties
Customers and suppliers
- Items
Materials, components and finished goods
- Work orders
Production work orders
Linked to Items, Orders, Resources - Inventory balances
Item inventory balances by location and lot
Linked to Items
Keys and references
Use stable record identities when resolving references. A lot label is text on the inventory, issue and batch records; batch inputs.source lot is also text. Review those labels explicitly during import. A matching label alone does not create a database reference or establish a physical connection.
Map production logs.Operator to People and People.User to Users. Resolve the signed-in user’s People identity before applying My Production Logs. Do not compare names or assume the Users.Role select replaces the operating permission policy.
Keep Items.Unit and the entered batch units consistent. Separate locations when importing inventory balances, even where Item and lot number match. Preserve the existing Users identity and self-reference behavior when loading People rather than manufacturing new sign-in accounts from display names.
Migration order
- Establish Users identities, then People.User mappings, Items, Parties and Resources.
- Load customer Orders and their order lines, followed by purchase orders and purchase lines using resolved party and item references.
- Reconcile inventory balances by Item, Location and lot number before enabling material issues posting.
- Load work orders with valid Product, Order and Resource references. Preserve their actual lifecycle state.
- Load Batches against work orders, then batch inputs, batch outputs, material issues and production logs with their original context. Treat historical imports as data loading; agree explicitly whether any posting action should execute.
- Compare quantities and dispositions with the source, test the role mapping and rehearse a new production cycle before cutover.
Set up Batch Manufacturing your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.