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.
- Transport Management
- Data model and import order
The tables behind Transport Management
Transport Management ships with 57 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
- 57
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Shipment planning:
Shipments2, shipment items2, shipment legs2, Stops2, Loads2 and load shipments2 retain cargo, legs, stop order and load membership.
Rates and carrier agreements:
Carriers2, carrier contacts2, carrier services2, Lanes2, rate contracts2, rate matrix2, Accessorials2, accessorial rates2 and renewal reminders retain the commercial and renewal context.
Carrier tendering:
Tendering2 and EDI messages2 connect each shipment offer to its carrier response and local exchange records.
Tracking and exceptions:
Tracking providers2, tracking events2, Exceptions2 and Detentions2 retain provider configuration, movement history, operational issues and waiting-time proof.
Proof of delivery:
Proof of delivery2 connects recipient and document evidence to Shipments2. Hazmat shipments2 retains hazardous-freight details for the shipping review.
Freight audit and disputes:
Freight invoices2, freight invoice lines2, freight audit results2 and Disputes2 trace billed amounts to the expected charge and carrier follow-up. Users2 holds user metadata.
Every table, by feature
- Shipment planning7
- Rates and carrier agreements9
- Carrier tendering4
- Tracking and exceptions6
- Proof of delivery4
- Freight audit and disputes10
- Shared and settings4
- Shipments 2
Shipment header and lifecycle from Planned through Delivered.
Linked to Carriers 2, Carrier services 2, Rate contracts 2 - Shipment items 2
The packed contents of the shipment - what is on the BOL.
Linked to Shipments 2 - Shipment legs 2
One leg per mode change or carrier handoff within a shipment.
Linked to Shipments 2, Carriers 2 - Stops 2
Stop point on a leg's route - pickup, cross-dock, final delivery.
Linked to Shipment legs 2 - Loads 2
Consolidated load combining multiple shipments into one carrier movement.
Linked to Carriers 2 - Load shipments 2
Shipment to Load join with allocated cost share.
Linked to Loads 2, Shipments 2 - Hazmat shipments 2
Flagged hazardous shipments tracked for DOT 49 CFR compliance.
Linked to Shipments 2
- Carriers 2
Carrier master - Parcel, LTL, FTL, Intermodal, Air and Ocean carriers.
- Carrier contacts 2
Operational, sales and accounting contacts at each carrier.
Linked to Carriers 2 - Carrier services 2
Service levels offered by each carrier, driving rate-shop service-match filtering.
Linked to Carriers 2 - Lanes 2
Origin to destination pairs at zip-prefix granularity.
- Rate contracts 2
Negotiated rate contract per carrier per lane, term-bounded.
Linked to Carriers 2, Lanes 2, Carrier services 2 - Rate matrix 2
Per-weight-band, per-NMFC-class, per-zone rate grid cell.
Linked to Rate contracts 2 - Accessorials 2
Catalog of accessorial charges.
- Accessorial rates 2
Per-contract accessorial rate ceiling.
Linked to Rate contracts 2, Accessorials 2 - Renewal reminders
Rate contracts expiring within 30 days, written daily by 'Lane Rate Renewal Reminder'. Set Status to Renewed or Dropped once handled.
Linked to Rate contracts 2, Carriers 2
- Shipments 2
Shipment header and lifecycle from Planned through Delivered.
Linked to Carriers 2, Carrier services 2, Rate contracts 2 - Tendering 2
Tender record per carrier per shipment. Multi-round tendering keeps a row per attempt.
Linked to Shipments 2, Carriers 2, EDI messages 2 - EDI messages 2
Append-only log of EDI traffic - 204, 990, 214 and 210.
Linked to Carriers 2, Shipments 2, Tendering 2, Freight invoices 2 - Carriers 2
Carrier master - Parcel, LTL, FTL, Intermodal, Air and Ocean carriers.
- Shipments 2
Shipment header and lifecycle from Planned through Delivered.
Linked to Carriers 2, Carrier services 2, Rate contracts 2 - Tracking events 2
Append-only log of tracking events from any source.
Linked to Shipments 2, Tracking providers 2 - Tracking providers 2
Registered tracking-visibility integrations.
- Exceptions 2
Shipment exceptions - anything off the happy path, routed by severity.
Linked to Shipments 2 - Detentions 2
Detention and demurrage tracking against contract free time.
Linked to Shipments 2, Stops 2 - Stops 2
Stop point on a leg's route - pickup, cross-dock, final delivery.
Linked to Shipment legs 2
- Proof of delivery 2
POD record per delivered shipment with signature and photo capture.
Linked to Shipments 2 - Shipments 2
Shipment header and lifecycle from Planned through Delivered.
Linked to Carriers 2, Carrier services 2, Rate contracts 2 - Tracking events 2
Append-only log of tracking events from any source.
Linked to Shipments 2, Tracking providers 2 - Exceptions 2
Shipment exceptions - anything off the happy path, routed by severity.
Linked to Shipments 2
- Freight invoices 2
Carrier freight invoice from EDI 210 inbound or manual entry.
Linked to Carriers 2 - Freight invoice lines 2
Per-shipment, per-charge breakdown of the carrier invoice. The audit grain.
Linked to Freight invoices 2, Shipments 2, Accessorials 2 - Freight audit results 2
Per freight invoice line audit verdict.
Linked to Freight invoice lines 2, Shipments 2 - Disputes 2
Disputed freight invoice lines - formal escalation with the carrier.
Linked to Freight invoice lines 2, Carriers 2 - Shipments 2
Shipment header and lifecycle from Planned through Delivered.
Linked to Carriers 2, Carrier services 2, Rate contracts 2 - Rate contracts 2
Negotiated rate contract per carrier per lane, term-bounded.
Linked to Carriers 2, Lanes 2, Carrier services 2 - Rate matrix 2
Per-weight-band, per-NMFC-class, per-zone rate grid cell.
Linked to Rate contracts 2 - Accessorial rates 2
Per-contract accessorial rate ceiling.
Linked to Rate contracts 2, Accessorials 2 - Accessorials 2
Catalog of accessorial charges.
- Detentions 2
Detention and demurrage tracking against contract free time.
Linked to Shipments 2, Stops 2
Keys and references
Keep Shipment and Shipment2, and Status and Status2, distinct when assigning import sources. Match the actual field identity to the rate, tender and tracking action that uses it. Reconcile references with the original business record before starting a new operating cycle.
Retain the actual Id, Id2 or ID identity fields from each table and use stable source identifiers in the import mapping. Shipment number, contract number and invoice number explain business documents; do not assume their uniqueness is enforced by the platform. Tendering2 links outbound and inbound EDI messages2, and disputes link the specific freight invoice line rather than only the invoice header.
Retain the responsible-person values in assigned to, filed by, reviewed by and approved by with the event they describe. Review the numeric representation of variance amount, variance percent and shipment weight lb before aggregation. Keep the exact Currency and Currency2 choices associated with their imported amounts.
Migration order
- Reconcile Users2 and the configured access accounts without inferring permissions from a Role select value.
- Load Carriers2, carrier contacts2, carrier services2, Lanes2, Accessorials2 and tracking providers2 with stable reference mappings.
- Load rate contracts2, then rate matrix2 and accessorial rates2. Confirm terms, bands, currency and workflow field identity.
- Load Shipments2, shipment items2, shipment legs2 and Stops2, then Loads2 and load shipments2 and the applicable hazmat shipments2.
- Load linked tender, tracking, exception, detention and proof history with EDI messages2 references resolved deliberately; avoid replaying historical delivery events as new workflow triggers.
- Load freight invoices2 and freight invoice lines2 before audit results and disputes. Reconcile renewal reminders against actual contract terms and agree the reminder schedule and notification connection during setup.
- Rehearse live triggers with a controlled new shipment and invoice, comparing resulting records with the original source evidence before broad imports.
Set up Transport Management your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.