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.
- Trailer Tracking System
- Data model and import order
The tables behind Trailer Tracking System
Trailer Tracking System 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
- 7, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Trailer assets and partners
Vehicles identifies equipment through unit number, asset type and Organization. Transport partners supplies the load counterparty; Drivers and Routes support planning.
Yard visits and detention
Trailer visits links trailer asset to Vehicles and Load to Loads. Yard, trailer location and the arrival/departure fields describe the stay. Grace minutes and detention minutes retain the duration context.
Load planning and dispatch
Loads links Organization, Owner and Counterparty. Load assignments connects a Load with a Driver and Vehicle; load stops holds its sequenced operating stops.
Stops and tracking
Load stops retains window start, window end and actual times. Tracking events records event type, occurred at, Source and location against the Load.
Delivery evidence
Proof of delivery references Load and Stop. Operation receipts, record attachments and review decisions retain source references and outcomes.
Fleet upkeep
Inspections, vehicle defects, maintenance plans and fuel transactions reference Vehicles. Defect Owner references team members.
Freight charges and review
Freight charges references Loads and retains charge type, Amount, Currency and Status. Review decisions identifies source table, source record and Revision.
Every table, by feature
- Trailer assets and partners5
- Yard visits and detention6
- Load planning and dispatch8
- Stops and tracking4
- Delivery evidence6
- Fleet upkeep7
- Freight charges and review7
- Shared and settings1
- Vehicles
Powered units and trailing equipment in the fleet
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
- Drivers
Licensed drivers available for load assignment
Linked to Organizations - Routes
Standard lanes between an origin and destination
Linked to Organizations
- Trailer visits
Trailer site visits linked to registered trailer assets and loads, capturing yard and trailer location, arrival and departure timestamps, grace periods, detention, and closure evidence.
Linked to Loads, Organizations, Vehicles - Vehicles
Powered units and trailing equipment in the fleet
Linked to Organizations - Loads
Planned and executed transport loads
Linked to Organizations, Team members, Transport partners - 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 - Record attachments
Documents, photos and signature evidence attached to records
Linked to Organizations
- 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 - Load assignments
Driver and vehicle assignment for a load
Linked to Loads, Drivers, Vehicles - Drivers
Licensed drivers available for load assignment
Linked to Organizations - Vehicles
Powered units and trailing equipment in the fleet
Linked to Organizations - 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 - Team members
Dispatch, planning, safety and maintenance staff
Linked to Users, 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 - Loads
Planned and executed transport loads
Linked to Organizations, Team members, Transport partners - Routes
Standard lanes between an origin and destination
Linked to 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 - 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 - Record attachments
Documents, photos and signature evidence attached to records
Linked to Organizations
- Vehicles
Powered units and trailing equipment in the fleet
Linked to Organizations - Drivers
Licensed drivers available for load assignment
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 - Team members
Dispatch, planning, safety and maintenance staff
Linked to Users, Organizations
- Freight charges
Freight, accessorial and service charges billed against a load
Linked to Loads - Loads
Planned and executed transport loads
Linked to Organizations, Team members, Transport partners - Trailer visits
Trailer site visits linked to registered trailer assets and loads, capturing yard and trailer location, arrival and departure timestamps, grace periods, detention, and closure evidence.
Linked to Loads, Organizations, Vehicles - 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 - 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
Keys and references
Match trailer visits.trailer asset to the intended Vehicles record and keep the load’s Organization consistent with the operating case. Load assignments.Vehicle selects the truck; trailer visits.trailer asset identifies the trailer. Proof of delivery.Stop must belong to proof of delivery.Load and be the completed Delivery stop used for verification.
Owner on Loads, vehicle defects and operation receipts references team members. Team members.User references Users; configure that identity mapping before using current-user views. Source record, related record and signature reference are text references, so agree and validate their identifier format during migration. They do not provide a foreign-key relationship by themselves.
Create each trailer visits record with actual arrival timestamp and departure timestamp values, grace minutes and Revision. Preserve explicit UTC offsets on both timestamps. Configure and test the closure action to calculate detention minutes from these instants and grace minutes; do not import a manual replacement for its calculation. Preserve Loads.Revision and trailer visits.Revision with their respective decisions. For charge reviews, retain charge number, Amount and Currency in review decisions.Rationale and identify any supporting load revision explicitly.
Migration order
- Establish Organizations and Users, then link team members to their identities and organizations.
- Load Vehicles, Drivers, transport partners and Routes with stable source mappings.
- Import Loads with their organization, owner and counterparty; reconcile required promised delivery and freight amount values.
- Link load stops and load assignments, preserving stop line numbers and revisions. Reconcile active resource commitments before dispatch.
- Load trailer visits and tracking events, then connect proof of delivery to the correct load and stop.
- Add inspection, defect, maintenance and fuel history, then reconcile freight charges, record attachments, review decisions and operation receipts against their source references.
Set up Trailer Tracking System your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.