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.
- 3D Printing Job Manager
- Data model
The tables behind 3D Printing Job Manager
3D Printing Job Manager ships with 17 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
- 17
- Features
- 7, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Customer orders
Parties distinguishes Customer and Supplier records. Orders links Customer to Parties; order lines links each Order and Item with Quantity and unit price.
Production planning
Work orders links Product, Order and Resource, optionally order line, and stores planned quantity, planned start, planned end and release requested. Resources holds capacity minutes per day and availability Status.
Print builds
Print builds links Printer and Material, optionally work order, and retains model file, layer height MM, estimated hours and Status.
Materials
Inventory balances records quantity on hand and reserved quantity by Item, Location and lot number. Material issues links work order and Item with lot number, Quantity, Status and stock applied.
Production evidence
Production logs links work order and Operator, with started at, ended at, good units and scrap units. People links shop personnel to Users.
Finishing and quality
Post process steps links Build and assigned to with step type, completed at and Result. Batches links work order with lot number, produced at, expiry date and Disposition.
Supplier purchasing
Purchase orders links Supplier to Parties. Purchase lines links purchase order and Item with ordered quantity, received quantity and unit cost.
Supporting records
Users holds platform-user information and access labels. Exchange rates contains read-only effective currency rates; use Currency, effective from and Rate when examining those records.
Every table, by feature
- Customer orders5
- Production planning5
- Print builds5
- Materials5
- Production evidence4
- Finishing and quality6
- Supplier purchasing6
- Shared and settings1
- Parties
Customers and suppliers for the print shop
- Orders
Customer orders for printed parts
Linked to Parties - Order lines
Line items on a customer order
Linked to Orders, Items - Items
Materials, components and finished goods
- Work orders
Released production work for an order
Linked to Items, Orders, Resources, Order lines
- Work orders
Released production work for an order
Linked to Items, Orders, Resources, Order lines - Orders
Customer orders for printed parts
Linked to Parties - Order lines
Line items on a customer order
Linked to Orders, Items - Items
Materials, components and finished goods
- Resources
Printers and production resources
- Print builds
Print jobs on a printer with material and layer settings
Linked to Resources, Items, Work orders - Resources
Printers and production resources
- Items
Materials, components and finished goods
- Work orders
Released production work for an order
Linked to Items, Orders, Resources, Order lines - Post process steps
Support removal, washing, curing and sanding steps
Linked to Print builds, People
- Items
Materials, components and finished goods
- Inventory balances
On-hand and reserved quantities by item, location and lot
Linked to Items - Material issues
Material postings against a work order
Linked to Work orders, Items - Work orders
Released production work for an order
Linked to Items, Orders, Resources, Order lines - Print builds
Print jobs on a printer with material and layer settings
Linked to Resources, Items, Work orders
- Production logs
Operator production intervals with good and scrap units
Linked to Work orders, People - People
Shop personnel linked to platform users
Linked to Users - Users
Users
Linked to Users - Work orders
Released production work for an order
Linked to Items, Orders, Resources, Order lines
- Post process steps
Support removal, washing, curing and sanding steps
Linked to Print builds, People - Print builds
Print jobs on a printer with material and layer settings
Linked to Resources, Items, Work orders - People
Shop personnel linked to platform users
Linked to Users - Production logs
Operator production intervals with good and scrap units
Linked to Work orders, People - Work orders
Released production work for an order
Linked to Items, Orders, Resources, Order lines - Batches
Produced lots and their disposition
Linked to Work orders
- Purchase orders
Supplier purchase orders
Linked to Parties - Purchase lines
Line items on a purchase order
Linked to Purchase orders, Items - Parties
Customers and suppliers for the print shop
- Items
Materials, components and finished goods
- Inventory balances
On-hand and reserved quantities by item, location and lot
Linked to Items - Material issues
Material postings against a work order
Linked to Work orders, Items
Keys and references
Preserve source record identities during migration. Resolve reference links by record identity rather than matching display names. Most operational records expose Id; exchange rates exposes ID. Users includes a required User reference, and People.User connects a shop person to that user record.
Material posting matches Item and lot number. Inventory balances also carry Location, so settle the location-selection rule before importing ambiguous item-and-lot combinations. Post process steps.assigned to and production logs.Operator refer to People; personal views need the People.User mapping to resolve the current user.
Production logs and Batches join through work order. Post process steps joins directly to Build. Review output quantities by work order and finishing results by Build; for a pilot that compares individual print attempts, use a separate work order for each attempt and link its build and lot to that job.
Migration order
- Access and personnel. Establish Users, resolve User references and link People.User.
- Trading and production setup. Import Parties, Items and Resources; agree units and resource availability.
- Demand and purchasing. Import Orders and purchase orders before their order lines and purchase lines.
- Opening material. Reconcile inventory balances by Item, Location and lot number.
- Planned production. Import work orders with valid Product, Order, Resource and optional order line links.
- Operational evidence. Import print builds before post process steps; link material issues, production logs and Batches to their work orders. Reconcile historical posting states before enabling live actions.
Set up 3D Printing Job Manager your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.