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.
- Kitting & Assembly
- Data model
The tables behind Kitting & Assembly
Kitting & Assembly ships with 97 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
- 97
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Product and recipe
Stock items, BO ms, BOM lines, production routings and routing operations define the finished kit and its versioned inputs.
Demand and supply
Sales orders and sales order lines hold dealer demand; purchase orders, goods receipts and receipt acceptances establish component supply.
Warehouse
Inventory positions, stock layers, stock reservations and stock events track custody, value and claims.
Assembly
Kit builds, work order materials, work order operations, production entries, production completions and work order cost entries record the planned and actual build.
Handoff
Shipments, shipment lines, delivery routes, delivery attempts and delivery results connect finished stock to the dealer outcome.
Every table, by feature
- Kit definitions9
- Build planning9
- Component supply11
- Assembly execution6
- Completion and costing9
- Fulfillment12
- Shared and settings60
- Stock items
Trade goods and assembly outputs; master values do not rewrite transactions.
Linked to Units of measure, Master changes - BO ms
Effective distribution assembly/repacking recipes with explicit output basis.
Linked to Master changes, Organizations, Stock items - BOM lines
Component quantities per explicit output basis, preserving dimensions and allowed loss.
Linked to BO ms, Stock items - Production routings
Versioned assembly/repacking instructions, distinct from delivery routes.
Linked to Organizations, BO ms, Master changes - Routing operations
Ordered work instructions and declared labour/overhead bases.
Linked to Production routings - Product units
Versioned product-specific buy/sell packs and base conversions.
Linked to Stock items, Units of measure, Master changes - Units of measure
Dimension and precision for stock, purchase, sale and production quantities.
- Standard costs
Entity/product standard per base unit with immutable effective versions.
Linked to Organizations, Stock items, Master changes - Master changes
Protected master activation without direct Manage permission bypass.
Linked to Organizations, Users, Review decisions
- Kit builds
Released bounded assembly/kitting/repacking, without plant APS or payroll scope.
Linked to Sales order lines, Users, Organizations, Document revisions - Sales order lines
Bounded accepted quantity/value and retained original promise.
Linked to Sales orders, Quote lines, Product units, Storage locations - BO ms
Effective distribution assembly/repacking recipes with explicit output basis.
Linked to Master changes, Organizations, Stock items - Production routings
Versioned assembly/repacking instructions, distinct from delivery routes.
Linked to Organizations, BO ms, Master changes - Standard costs
Entity/product standard per base unit with immutable effective versions.
Linked to Organizations, Stock items, Master changes - Stock items
Trade goods and assembly outputs; master values do not rewrite transactions.
Linked to Units of measure, Master changes - Storage locations
Physical sites may host segregated entity-owned positions; legal owner stays on each position.
Linked to Users - Review decisions
Authoritative human decisions independent of document lifecycle.
Linked to Users, Authority delegations, Exchange rates, Organizations - Document revisions
Immutable typed document snapshots and source basis.
Linked to Organizations, Users
- Purchase orders
Immutable approved supplier commitments; cumulative amendments cannot bypass authority.
Linked to Organizations, Currencies, Exchange rates, Document revisions - Purchase order lines
Buy-unit quantities, frozen commercial costs and current accepted scope.
Linked to Purchase orders, Requisition lines, Product units, Tax codes - Goods receipts
Immutable actual arrivals and separately accepted quantities.
Linked to Organizations, Document revisions, Operation receipts, Purchase orders - Goods receipt lines
Receipt history does not change as accepted inventory moves or is consumed.
Linked to Goods receipts, Purchase order lines, Locations, Standard costs - Receipt acceptances
Independent bounded disposition tranches against one immutable actual arrival.
Linked to Organizations, Operation receipts, Goods receipt lines, Standard costs - Inventory positions
Current owned stock by complete identity and custody state; provenance is not a second balance.
Linked to Organizations, Stock items, Storage locations, Locations - Stock layers
Remaining quantity/carrying value with receipt/output/return lineage.
Linked to Organizations, Inventory positions, Stock items, Stock events - Stock reservations
Exclusive bounded demand claims through picking and owned transit.
Linked to Organizations, Operation receipts, Inventory positions, Stock layers - Work order materials
Frozen required input and actual traced issue/return scope.
Linked to Kit builds, BOM lines, Stock items, Stock reservations - Stock events
One immutable group of stock movements and the associated journal effect.
Linked to Journal entries, Stock events, Organizations, Operation receipts - Stock movements
Signed position/layer legs; transfers balance quantity and value by SKU.
Linked to Stock events, Inventory positions, Stock layers, Stock reservations
- Work order operations
Frozen instructions and assigned actual work.
Linked to Kit builds, Routing operations, Users - Routing operations
Ordered work instructions and declared labour/overhead bases.
Linked to Production routings - Production entries
Actual operation throughput, scrap and labour evidence; intermediate counts do not sum to output.
Linked to Organizations, Operation receipts, Work order operations, Users - Kit builds
Released bounded assembly/kitting/repacking, without plant APS or payroll scope.
Linked to Sales order lines, Users, Organizations, Document revisions - Work order materials
Frozen required input and actual traced issue/return scope.
Linked to Kit builds, BOM lines, Stock items, Stock reservations - Review decisions
Authoritative human decisions independent of document lifecycle.
Linked to Users, Authority delegations, Exchange rates, Organizations
- Production completions
Accepted terminal output and WIP cost allocation, once per actual completed scope.
Linked to Organizations, Operation receipts, Review decisions, Kit builds - Production entries
Actual operation throughput, scrap and labour evidence; intermediate counts do not sum to output.
Linked to Organizations, Operation receipts, Work order operations, Users - Work order cost entries
Immutable WIP debit/credit sources and bounded actual-cost allocation.
Linked to Organizations, Operation receipts, Kit builds, Work order materials - Kit builds
Released bounded assembly/kitting/repacking, without plant APS or payroll scope.
Linked to Sales order lines, Users, Organizations, Document revisions - Standard costs
Entity/product standard per base unit with immutable effective versions.
Linked to Organizations, Stock items, Master changes - Inventory positions
Current owned stock by complete identity and custody state; provenance is not a second balance.
Linked to Organizations, Stock items, Storage locations, Locations - Stock layers
Remaining quantity/carrying value with receipt/output/return lineage.
Linked to Organizations, Inventory positions, Stock items, Stock events - Stock events
One immutable group of stock movements and the associated journal effect.
Linked to Journal entries, Stock events, Organizations, Operation receipts - Review decisions
Authoritative human decisions independent of document lifecycle.
Linked to Users, Authority delegations, Exchange rates, Organizations
- Sales orders
Dealer-accepted scope plus mandatory independent commercial approval.
Linked to Exchange rates, Document revisions, Review decisions, Dealers - Sales order lines
Bounded accepted quantity/value and retained original promise.
Linked to Sales orders, Quote lines, Product units, Storage locations - Inventory positions
Current owned stock by complete identity and custody state; provenance is not a second balance.
Linked to Organizations, Stock items, Storage locations, Locations - Stock reservations
Exclusive bounded demand claims through picking and owned transit.
Linked to Organizations, Operation receipts, Inventory positions, Stock layers - Pick tasks
Actual picked quantities remain exclusively tied to the order and do not post COGS.
Linked to Organizations, Operation receipts, Sales order lines, Stock reservations - Shipments
Actual dispatch and title/delivery state separated for partial deliveries.
Linked to Organizations, Document revisions, Operation receipts, Sales orders - Shipment lines
Actual dispatch quantities and current title-transferred/delivered portions.
Linked to Shipments, Sales order lines, Stock reservations, Stock events - Delivery routes
Manual route/stop sequence and assigned execution; no optimization or live tracking.
Linked to Users, Organizations, Document revisions, Review decisions - Route stops
Explicit stable sequence and exact order/shipment ownership.
Linked to Delivery routes, Shipments, Route stops - Delivery attempts
Actual visit/handoff facts, separate from line outcomes and legal title.
Linked to Organizations, Operation receipts, Route stops, Users - Delivery results
Each attempt allocates line outcomes once; one visit may partially deliver many lines.
Linked to Delivery attempts, Shipment lines, Stock events, Return lines - Stock events
One immutable group of stock movements and the associated journal effect.
Linked to Journal entries, Stock events, Organizations, Operation receipts
Keys and references
A kit build points to its output product, bill, routing, standard cost and destination warehouse. Work order materials point to the bill lines and component stock items. Operations point to routing operations. Entries point to assigned operations, while completions point to the build and terminal entry. Stock events connect receipt, issue, output and dispatch changes to positions and layers. Shipment lines point back to order lines and stock reservations. Review decisions and document revisions preserve decision and snapshot context.
Migration order
- Create organizations, users, units, warehouses and stock items.
- Load effective bills, routings, standard costs and dealer or supplier masters.
- Load opening positions and layers with their stock identity and value evidence.
- Bring in open orders, receipts, reservations and released build scope with original references.
- Reconcile posted output, shipment and financial balances before operating the next cycle.
Set up Kitting & Assembly your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.