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.
- Yard Management System
- Data model and import order
The tables behind Yard Management System
Yard Management 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
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Gate and parking
Yard visits links through Parent to Loads and through Organization to Organizations. Trailer, arrived at, waiting minutes and parking slot describe the physical visit.
Dock review
Yard visits retains Status and Revision. Review decisions carries Reviewer, Decision, Rationale and source revision, with Parent pointing to Loads.
Load planning
Loads owns Carrier, dock door, seal number and promised delivery at. Load stops links through Load and retains Sequence, window start, window end and proof reference.
Driver and vehicle readiness
Load assignments connects Loads, Drivers and Vehicles over starts at and ends at. Vehicle defects links to Vehicles and records Severity, repair evidence and released at.
Stock handoff
Stock requests connects to stock items and transport partners. Stock reservations connects requests to stock lots; stock movements retains Parent, signed quantity and any Reverses reference. Handling units retains item, location and custody.
Operations evidence
Operation receipts links to a stock requests source record and an optional Loads Parent. Record attachments connects to a load and source request, with uploaded by pointing to team members.
Operating setup
Organizations, Users and team members establish identity context. Transport partners serves location references as well as the load's counterparty. Allocation policies retains organization allocation rules.
Every table, by feature
- Gate and parking4
- Dock review5
- Load planning6
- Driver and vehicle readiness5
- Stock handoff8
- Operations evidence7
- Shared and settings1
- Yard visits
Yard visit records supporting trailer-to-dock assignment, gate timestamps and dock reservation control.
Linked to Loads, Organizations - Loads
Inbound and outbound loads with carrier, dock door and seal.
Linked to Organizations, Team members, Transport partners - Transport partners
Warehouses, bins, yards and cold rooms where stock is held.
Linked to Organizations - Organizations
Operating organizations that own warehouses, stock and team members.
- Yard visits
Yard visit records supporting trailer-to-dock assignment, gate timestamps and dock reservation control.
Linked to Loads, Organizations - Loads
Inbound and outbound loads with carrier, dock door and seal.
Linked to Organizations, Team members, Transport partners - Review decisions
Approved, rejected, returned or escalated decisions on source records.
Linked to Organizations, Team members, Stock requests, Loads - Operation receipts
Recorded, verified, failed or corrected operation evidence.
Linked to Organizations, Team members, Stock requests, Loads - Record attachments
Documents and links attached to operational records.
Linked to Stock requests, Organizations, Loads, Team members
- Loads
Inbound and outbound loads with carrier, dock door and seal.
Linked to Organizations, Team members, Transport partners - Load stops
Sequenced stops and dock appointments for a load.
Linked to Loads, Transport partners - Transport partners
Warehouses, bins, yards and cold rooms where stock is held.
Linked to Organizations - Record attachments
Documents and links attached to operational records.
Linked to Stock requests, Organizations, Loads, Team members - Organizations
Operating organizations that own warehouses, stock and team members.
- Team members
Warehouse staff and reviewers linked to an organization and platform user.
Linked to Organizations, Users
- Load assignments
Driver and vehicle commitments for a load over a non-overlapping interval.
Linked to Loads, Drivers, Vehicles - Drivers
Driver eligibility records used when planning and dispatching loads.
- Vehicles
Vehicle and equipment readiness records used for load assignment.
- Vehicle defects
Reported vehicle defects and their repair evidence before release.
Linked to Vehicles - Loads
Inbound and outbound loads with carrier, dock door and seal.
Linked to Organizations, Team members, Transport partners
- Stock requests
Requests to receive, move, reserve or issue stock.
Linked to Organizations, Team members, Transport partners, Stock items - Stock reservations
Held, released or consumed reservations against eligible stock lots.
Linked to Stock lots, Stock requests - Stock lots
Lot or serial level inventory held at a storage location.
Linked to Stock items, Transport partners - Stock items
Stock keeping units with base unit, tracking mode and reorder settings.
- Stock movements
Posted signed-quantity movements that change on-hand inventory.
Linked to Organizations, Team members, Transport partners, Stock items - Handling units
Pallets, totes and license-plate handling units with custody.
Linked to Transport partners, Stock items - Allocation policies
Channel allocation rules with priority and safety stock.
Linked to Organizations - Transport partners
Warehouses, bins, yards and cold rooms where stock is held.
Linked to Organizations
- Operation receipts
Recorded, verified, failed or corrected operation evidence.
Linked to Organizations, Team members, Stock requests, Loads - Review decisions
Approved, rejected, returned or escalated decisions on source records.
Linked to Organizations, Team members, Stock requests, Loads - Record attachments
Documents and links attached to operational records.
Linked to Stock requests, Organizations, Loads, Team members - Stock requests
Requests to receive, move, reserve or issue stock.
Linked to Organizations, Team members, Transport partners, Stock items - Stock movements
Posted signed-quantity movements that change on-hand inventory.
Linked to Organizations, Team members, Transport partners, Stock items - Loads
Inbound and outbound loads with carrier, dock door and seal.
Linked to Organizations, Team members, Transport partners - Yard visits
Yard visit records supporting trailer-to-dock assignment, gate timestamps and dock reservation control.
Linked to Loads, Organizations
Keys and references
Import stable identifiers and resolve references before loading child records. Preserve the load number independently of the trailer text. A visit’s Parent identifies its load; it is not a direct reference from review decisions to a particular visit. Agree how the decision’s source revision and operation context identify the reviewed visit during setup.
Stock movements.Parent identifies the request being reconciled. Stock reservations.stock lot identifies the committed lot. Retain required stock-request references when importing receipts, attachments and decisions, even when those records also reference a load. Use the exact source relationships rather than matching changing display names.
Migration order
- Load Organizations and Users, then team members with resolved user references.
- Load transport partners, stock items, Drivers, Vehicles and allocation policies; resolve organization references.
- Load stock lots and stock requests, then Loads with their owner and partner references.
- Load load stops, load assignments, vehicle defects and yard visits against the existing load and resource identities.
- Load stock reservations, handling units and stock movements, resolving reversal references in dependency order.
- Load review decisions, operation receipts and record attachments with their required request and load references; reconcile open work before release.
Set up Yard Management System your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.