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.
- Manufacturing TMS
- Data model and import order
The tables behind Manufacturing TMS
Manufacturing TMS ships with 21 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
- 21
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Load planning
Loads link to Organizations, team members through Owner, and transport partners through Counterparty. Load stops.Parent identifies the load; Routes retain standard lane reference information.
Plant dock appointments
Plant appointments.Parent points to Loads and Organization points to Organizations. Review decisions retain source table, source record and source revision for the decision being recorded.
Dispatch and tracking
Load assignments connect Load, Driver and Vehicle. Tracking events.Load identifies the journey whose milestone is being reported.
Delivery evidence
Proof of delivery has both Load and Stop references. Record attachments.Parent is text and needs an agreed record-reference convention.
Fleet readiness
Drivers and Vehicles belong to Organizations. Inspections, vehicle defects, maintenance plans and fuel transactions reference Vehicles.
Freight and reconciliation
Freight charges.Load identifies the charged movement. Operation receipts retain Action, external reference, Owner and result state; review decisions.Reviewer points to team members.
Every table, by feature
- Load planning7
- Plant dock appointments5
- Dispatch and tracking7
- Delivery evidence6
- Fleet readiness7
- Freight and reconciliation7
- Shared and settings1
- Loads
Planned and executed transport loads
Linked to Organizations, Team members, Transport partners - Load stops
Pickup, delivery and service stops on a load
Linked to Loads - Routes
Standard lanes between an origin and destination
Linked to Organizations - Transport partners
Carriers, brokers, 3PLs and shippers linked to transport work
Linked to Organizations - Organizations
Carrier, broker, shipper and operating companies using the platform
- Team members
Dispatch, planning, safety and maintenance staff
Linked to Users, Organizations - Review decisions
Approval, rejection and escalation decisions on records
Linked to Organizations, Team members
- Plant appointments
Manufacturing plant dock appointments: inbound and outbound dock reservations tied to a load, confirmed through independent review before the dock slot is executed.
Linked to Loads, Organizations - Loads
Planned and executed transport loads
Linked to Organizations, Team members, Transport partners - Organizations
Carrier, broker, shipper and operating companies using the platform
- Review decisions
Approval, rejection and escalation decisions on records
Linked to Organizations, Team members - Operation receipts
Recorded operational outcomes awaiting verification
Linked to Organizations, Team members
- Load assignments
Driver and vehicle assignment for a load
Linked to Loads, Drivers, Vehicles - Loads
Planned and executed transport loads
Linked to Organizations, Team members, Transport partners - Drivers
Licensed drivers available for load assignment
Linked to Organizations - Vehicles
Powered units and trailing equipment in the fleet
Linked to Organizations - Load stops
Pickup, delivery and service stops on a load
Linked to Loads - Tracking events
Position and milestone events reported against a load
Linked to Loads - Plant appointments
Manufacturing plant dock appointments: inbound and outbound dock reservations tied to a load, confirmed through independent review before the dock slot is executed.
Linked to Loads, Organizations
- Proof of delivery
Delivery confirmation captured at the stop
Linked to Loads, Load stops - Loads
Planned and executed transport loads
Linked to Organizations, Team members, Transport partners - Load stops
Pickup, delivery and service stops on a load
Linked to Loads - Record attachments
Documents, photos and signature evidence attached to records
Linked to Organizations - Tracking events
Position and milestone events reported against a load
Linked to Loads - Plant appointments
Manufacturing plant dock appointments: inbound and outbound dock reservations tied to a load, confirmed through independent review before the dock slot is executed.
Linked to Loads, Organizations
- Drivers
Licensed drivers available for load assignment
Linked to Organizations - Vehicles
Powered units and trailing equipment in the fleet
Linked to Organizations - Inspections
Pre-trip, post-trip and periodic inspection results
Linked to Vehicles - Vehicle defects
Defects reported against a fleet asset
Linked to Team members, Vehicles - Maintenance plans
Preventive maintenance and service schedules
Linked to Vehicles - Fuel transactions
Fuel and energy purchases recorded per asset
Linked to Vehicles - Load assignments
Driver and vehicle assignment for a load
Linked to Loads, Drivers, Vehicles
- Freight charges
Freight, accessorial and service charges billed against a load
Linked to Loads - Operation receipts
Recorded operational outcomes awaiting verification
Linked to Organizations, Team members - Review decisions
Approval, rejection and escalation decisions on records
Linked to Organizations, Team members - Loads
Planned and executed transport loads
Linked to Organizations, Team members, Transport partners - Proof of delivery
Delivery confirmation captured at the stop
Linked to Loads, Load stops - Record attachments
Documents, photos and signature evidence attached to records
Linked to Organizations - Fuel transactions
Fuel and energy purchases recorded per asset
Linked to Vehicles
Keys and references
Use stable source-to-record mappings during import. Human numbers identify the operational documents, while actual references connect their records. Confirm that proof of delivery.Stop belongs to proof of delivery.Load. Resolve team members.User before using Loads.Owner for personal work queues.
Keep plant appointments.Revision with each reviewed request and review decisions.source revision with its decision. Decision at and decided at record different locations in the decision evidence and should reconcile for the same outcome. Do not infer a relational link from free text without an agreed mapping. Routes have no direct reference from Loads; Lane uses your agreed naming convention.
Migration order
- Import Organizations and Users, then team members and transport partners with resolved organization references.
- Import Drivers, Vehicles and Routes, confirming active states and the operating time convention.
- Import Loads and their load stops, then load assignments and plant appointments with valid parent records.
- Import tracking events, proof of delivery and record attachments using verified load, stop and parent mappings.
- Import Inspections, vehicle defects, maintenance plans and fuel transactions against their vehicles, then freight charges against their loads.
- Reconcile review decisions and operation receipts with their source record, revision and external-reference conventions before the operating owners accept the import.
Set up Manufacturing TMS your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.