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.
- Warehouse-to-Truck Loading
- Data model
The tables behind Warehouse-to-Truck Loading
Warehouse-to-Truck Loading 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 carries record number, Organization, Owner and Counterparty; load stops records the planned and actual stop sequence. Routes describes standard lanes and transport partners holds the working parties.
Dock and seal review
Load checks links Parent to Loads and Organization to Organizations, with Dock, loaded at, loaded pallets, seal number, Revision and decision at.
Resource assignments
Load assignments connects Load, Driver and Vehicle and retains starts at, ends at, Revision and availability check.
Dispatch and delivery
Tracking events links movement observations to Loads. Proof of delivery references both Load and Stop, with the receiver, delivery date and signature reference.
Fleet readiness
Vehicles links to Inspections, defect register, maintenance plans and fuel transactions. Driver eligibility remains in Drivers.
Charges and reconciliation
Freight charges references Load. Review decisions, record attachments and operation receipts carry Parent references to Loads and retain decision, document or outcome context.
Every table, by feature
- Load planning6
- Dock and seal review4
- Resource assignments6
- Dispatch and delivery6
- Fleet readiness6
- Charges 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 - Transport partners
Carriers, brokers, 3PLs and shippers linked to transport work
Linked to Organizations - Routes
Standard lanes between an origin and destination
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
- Load checks
Dock and seal verification checks supporting release of a sealed truck load.
Linked to Loads, 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, Loads - Record attachments
Documents, photos and signature evidence attached to records
Linked to Organizations, Loads, 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 - Defect register
Defects reported against a fleet asset
Linked to Team members, Vehicles - Inspections
Pre-trip, post-trip and periodic inspection results
Linked to Vehicles
- Loads
Planned and executed transport loads
Linked to Organizations, Team members, Transport partners - Load assignments
Driver and vehicle assignment for a load
Linked to Loads, Drivers, Vehicles - 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 - 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, Loads, Team members
- Vehicles
Powered units and trailing equipment in the fleet
Linked to Organizations - Defect register
Defects reported against a fleet asset
Linked to Team members, Vehicles - Inspections
Pre-trip, post-trip and periodic inspection results
Linked to 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
- Operation receipts
Recorded operational outcomes awaiting verification
Linked to Organizations, Team members, Loads - Freight charges
Freight, accessorial and service charges billed against a load
Linked to Loads - Review decisions
Approval, rejection and escalation decisions on records
Linked to Organizations, Team members, Loads - Record attachments
Documents, photos and signature evidence attached to records
Linked to Organizations, Loads, Team members - 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
Keys and references
Use the human load number to locate work and the record reference to join it. Team members.User links operational staff to Users. Load ownership points to team members; user-specific queues need that identity mapping. Proof of delivery.Stop must correspond to a load stops record for the same Load when the team verifies evidence.
Review decisions.Revision identifies the reviewed version; operation receipts.expected revision identifies the version expected by an action. Operation key, external reference and effect references support outcome reconciliation. Agree their identity rules when connecting external systems. Never use a similar Subject as a substitute for the correct Parent reference.
Active Loads and Loads Awaiting Approval are list screens over Loads. Open Defects is a list screen over defect register. Their records retain the keys and references of their source tables.
Migration order
- Organization and identities. Prepare Organizations and Users, then team members with its user and organization references.
- Operating parties and resources. Load transport partners, Routes, Drivers and Vehicles; reconcile names and unit identities with the source records.
- Current load work. Import Loads, then load stops, load assignments and load checks with their parent and resource references intact.
- Movement and fleet evidence. Link tracking events, proof of delivery, Inspections, defect register, maintenance plans and fuel transactions to the right load, stop or vehicle.
- Review and financial context. Attach review decisions, operation receipts, record attachments and freight charges after validating the referenced load and organization.
Set up Warehouse-to-Truck Loading your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.