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.
- SCM with Route Optimization
- Data model
The tables behind SCM with Route Optimization
SCM with Route Optimization ships with 14 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
- 14
- Features
- 6
- Change it
- Add fields and tables in Proto
How the model is organised
Load planning:
Loads belongs to Organizations, team members and transport partners; load stops carries the ordered plan.
Route decisions:
Route proposals belongs to a load and organization; review decisions captures the reviewer and source revision.
Dispatch:
Load assignments joins a load, driver and vehicle over a dated interval; vehicle defects records repair context.
Evidence:
Operation receipts and record attachments belong to a load and preserve action outcomes and supporting files.
Access:
Team members links people to Organizations and Users.
Every table, by feature
- Load planning6
- Route proposals5
- Assignments and fleet6
- Stop execution4
- Review and evidence6
- Organization and access8
- Loads
Freight loads planned, dispatched and delivered by the organization.
Linked to Organizations, Team members, Transport partners - Load stops
Ordered stops with time windows and actual arrival evidence for each load.
Linked to Loads - Route proposals
Route proposals submitted for independent review before dispatch.
Linked to Loads, Organizations - Load assignments
Driver and vehicle intervals held for a load.
Linked to Loads, Drivers, Vehicles - Transport partners
Carriers and transport partners eligible for load assignment.
Linked to Organizations - Team members
Staff and their role scope inside an organization.
Linked to Organizations, Users
- Route proposals
Route proposals submitted for independent review before dispatch.
Linked to Loads, Organizations - Loads
Freight loads planned, dispatched and delivered by the organization.
Linked to Organizations, Team members, Transport partners - Load stops
Ordered stops with time windows and actual arrival evidence for each load.
Linked to Loads - Review decisions
Independent review decisions recorded against a load revision.
Linked to Loads, Team members - Operation receipts
Durable receipts for every guarded operation attempt.
Linked to Loads
- Load assignments
Driver and vehicle intervals held for a load.
Linked to Loads, Drivers, Vehicles - Drivers
Drivers with eligibility evidence for assignment.
- Vehicles
Fleet vehicles with capacity and readiness state.
- Vehicle defects
Reported vehicle defects and repair release evidence.
Linked to Vehicles - Loads
Freight loads planned, dispatched and delivered by the organization.
Linked to Organizations, Team members, Transport partners - Route proposals
Route proposals submitted for independent review before dispatch.
Linked to Loads, Organizations
- Load stops
Ordered stops with time windows and actual arrival evidence for each load.
Linked to Loads - Loads
Freight loads planned, dispatched and delivered by the organization.
Linked to Organizations, Team members, Transport partners - Record attachments
Evidence files attached to a load.
Linked to Loads, Team members - Route proposals
Route proposals submitted for independent review before dispatch.
Linked to Loads, Organizations
- Review decisions
Independent review decisions recorded against a load revision.
Linked to Loads, Team members - Operation receipts
Durable receipts for every guarded operation attempt.
Linked to Loads - Record attachments
Evidence files attached to a load.
Linked to Loads, Team members - Route proposals
Route proposals submitted for independent review before dispatch.
Linked to Loads, Organizations - Loads
Freight loads planned, dispatched and delivered by the organization.
Linked to Organizations, Team members, Transport partners - Team members
Staff and their role scope inside an organization.
Linked to Organizations, Users
- Organizations
Freight organizations operating in this workspace.
- Team members
Staff and their role scope inside an organization.
Linked to Organizations, Users - Users
Users
Linked to Users - Transport partners
Carriers and transport partners eligible for load assignment.
Linked to Organizations - Drivers
Drivers with eligibility evidence for assignment.
- Vehicles
Fleet vehicles with capacity and readiness state.
- Loads
Freight loads planned, dispatched and delivered by the organization.
Linked to Organizations, Team members, Transport partners - Route proposals
Route proposals submitted for independent review before dispatch.
Linked to Loads, Organizations
Keys and references
Use the load’s record number for the human handoff and its reference links for related records. A proposal’s parent points to the load; its revision identifies the candidate under review. Assignment references point to the selected driver and vehicle. Review decisions and operation receipts also point to the load, so the team can inspect the full trail from a single movement.
Migration order
- Set up Organizations and Users, then team members with their organization and user links.
- Add transport partners, Drivers and Vehicles; record vehicle defects where relevant.
- Create Loads with owner, counterparty and promised delivery time.
- Add load stops and route proposals for planned work.
- Bring in load assignments, review decisions, record attachments and operation receipts with their parent references.
Set up SCM with Route Optimization your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.