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.
- Assembly Line Tracking
- Data model
The tables behind Assembly Line Tracking
Assembly Line Tracking 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
Production planning
Orders reference Parties as Customer, and order lines join Orders to Items. Work orders reference Product, Order and Resource, with planned quantity, dates and status.
Station routing
Station routes join a Product in Items to a Station in Resources and carry Sequence and target takt seconds.
Station passes
Station passes reference Resources through Station and carry unit serial, entered at, exited at and Disposition.
Material control
Material issues reference work orders and Items. Inventory balances reference Items and identify Location and lot number. Purchase orders reference supplier Parties, while purchase lines reference purchase orders and Items.
Production reporting
Production logs reference work orders and People. People reference Users, connecting operator identity to the user account.
Quality release
Batches reference work orders and record lot number, produced at, expiry date and Disposition. Accepted release connects the operating decision to finished inventory.
Every table, by feature
- Production planning6
- Station routing3
- Station passes2
- Material control7
- Production reporting5
- Quality release6
- Work orders
Released production work for a product on a resource.
Linked to Items, Orders, Resources - Orders
Customer orders for finished goods.
Linked to Parties - Order lines
Line items on a customer order.
Linked to Orders, Items - Items
Materials, components and finished goods.
- Parties
Customers and suppliers.
- Resources
Assembly stations and work centers.
- Station routes
Product routing through stations with sequence and target takt.
Linked to Items, Resources - Items
Materials, components and finished goods.
- Resources
Assembly stations and work centers.
- Station passes
Unit serial movement through a station with disposition.
Linked to Resources - Resources
Assembly stations and work centers.
- Material issues
Material postings that decrement 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
Released production work for a product on a resource.
Linked to Items, Orders, Resources - Purchase orders
Supplier purchase orders for materials.
Linked to Parties - Purchase lines
Line items on a purchase order.
Linked to Purchase orders, Items - Parties
Customers and suppliers.
- Production logs
Operator production intervals with good and scrap units.
Linked to Work orders, People - People
Operators, planners and reviewers who act on production work.
Linked to Users - Users
Users
Linked to Users - Work orders
Released production work for a product on a resource.
Linked to Items, Orders, Resources - Batches
Produced lot identities and their disposition.
Linked to Work orders
- Batches
Produced lot identities and their disposition.
Linked to Work orders - Production logs
Operator production intervals with good and scrap units.
Linked to Work orders, People - Work orders
Released production work for a product on a resource.
Linked to Items, Orders, Resources - Inventory balances
On-hand and reserved quantity by item, location and lot.
Linked to Items - Items
Materials, components and finished goods.
- Station passes
Unit serial movement through a station with disposition.
Linked to Resources
Keys and references
Preserve the existing record identities during migration. Use item code and lot number consistently when reconciling physical stock, and keep unit serial stable for station capture. Resources supply the shared station identity used by routes, passes and work orders.
Station passes link to Station, while production logs link to work order and Operator. Keep those reference paths distinct in reports and integrations. Configure any additional cross-record matching explicitly. Map People.User before enabling My Production Intervals so the current account resolves to the intended operator.
Migration order
- Establish Users and People with verified user links.
- Load Parties, Items and Resources, checking stable business identifiers.
- Load Orders with order lines and purchase orders with purchase lines.
- Prepare station routes and reconcile inventory balances by item, lot and location.
- Load work orders with valid product, order and resource references.
- Reconcile material issues and production logs before using migrated Batches or station passes in operating reviews.
Set up Assembly Line Tracking your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.