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.
- Logistics Tracking System
- Data model
The tables behind Logistics Tracking System
Logistics Tracking System 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, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Organization and people
Organizations own team members and transport partners; team members link to Users.
Movement
Loads hold the overall promise, owner, partner, status and actual delivery; load stops hold ordered visits and proof references.
Capacity
Load assignments connect a load interval with Drivers and Vehicles; vehicle defects explain release and readiness evidence.
Events and controls
Carrier milestones, review decisions, record attachments and operation receipts reference their parent Loads.
Every table, by feature
- Loads and dispatch7
- Stops and delivery5
- Assignments and fleet5
- Carrier milestones6
- Review and evidence6
- Operations overview7
- Shared and settings1
- Loads
Freight loads tracked from draft through delivery
Linked to Organizations, Team members, Transport partners - Load stops
Ordered stops belonging to a load
Linked to Loads - Load assignments
Driver and vehicle commitments to a load interval
Linked to Loads, Drivers, Vehicles - Transport partners
Carriers and transport partners eligible for loads
Linked to Organizations - Team members
Membership records linking a platform user to an organization role
Linked to Organizations, Users - Review decisions
Independent review decisions recorded against a load revision
Linked to Loads, Team members - Operation receipts
Idempotent receipts for executed and reconciled operations
Linked to Loads
- Load stops
Ordered stops belonging to a load
Linked to Loads - Loads
Freight loads tracked from draft through delivery
Linked to Organizations, Team members, Transport partners - Record attachments
Evidence files attached to a load
Linked to Loads, Team members - Review decisions
Independent review decisions recorded against a load revision
Linked to Loads, Team members - Transport partners
Carriers and transport partners eligible for loads
Linked to Organizations
- Load assignments
Driver and vehicle commitments to a load interval
Linked to Loads, Drivers, Vehicles - Loads
Freight loads tracked from draft through delivery
Linked to Organizations, Team members, Transport partners - Drivers
Eligible drivers and their authority records
- Vehicles
Fleet vehicles with equipment class, capacity and readiness
- Vehicle defects
Reported vehicle defects and release evidence
Linked to Vehicles
- Carrier milestones
Carrier-reported milestone events submitted for review and acceptance
Linked to Loads, Organizations - Loads
Freight loads tracked from draft through delivery
Linked to Organizations, Team members, Transport partners - Organizations
Operating organizations for logistics tracking
- Operation receipts
Idempotent receipts for executed and reconciled operations
Linked to Loads - Transport partners
Carriers and transport partners eligible for loads
Linked to Organizations - Record attachments
Evidence files attached to a load
Linked to Loads, Team members
- Review decisions
Independent review decisions recorded against a load revision
Linked to Loads, Team members - Record attachments
Evidence files attached to a load
Linked to Loads, Team members - Operation receipts
Idempotent receipts for executed and reconciled operations
Linked to Loads - Loads
Freight loads tracked from draft through delivery
Linked to Organizations, Team members, Transport partners - Load stops
Ordered stops belonging to a load
Linked to Loads - Team members
Membership records linking a platform user to an organization role
Linked to Organizations, Users
- Loads
Freight loads tracked from draft through delivery
Linked to Organizations, Team members, Transport partners - Load stops
Ordered stops belonging to a load
Linked to Loads - Carrier milestones
Carrier-reported milestone events submitted for review and acceptance
Linked to Loads, Organizations - Operation receipts
Idempotent receipts for executed and reconciled operations
Linked to Loads - Review decisions
Independent review decisions recorded against a load revision
Linked to Loads, Team members - Transport partners
Carriers and transport partners eligible for loads
Linked to Organizations - Load assignments
Driver and vehicle commitments to a load interval
Linked to Loads, Drivers, Vehicles
Keys and references
The load’s record number identifies the operating move, while its Id carries relationships. A load stop’s Parent points to that load; its sequence and revision explain route order. A load assignment links Load, Driver and Vehicle for a specific interval. Carrier milestones keep a provider event identifier beside the linked Parent and Organization. Review decisions retain source revision, Reviewer and Decision. Operation receipts keep operation key, expected revision and effect references for reconciliation.
Migration order
- Bring in Organizations and Users, then team members with valid organization membership.
- Bring in transport partners, Drivers, Vehicles and any vehicle defects used for readiness review.
- Bring in Loads with owners, organizations, partners and original promised delivery times.
- Bring in ordered load stops and load assignments linked to the correct loads.
- Bring in carrier milestones, record attachments, review decisions and operation receipts with their original event, decision and revision context.
Set up Logistics Tracking System your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.