LoadOps Data Dictionary - Loads/Trips
Data Summary and Location for Loads/Trips
Module: Loads
Page: Load List
Section (Header) |
Description |
Data Type |
Locations |
Load Id |
This field appears in the Load List page of the Loads module and represents internal load id, as seen in values such as LD5556, LD5510, LD5524. Prefix for the loads and sequence number can be set in the Preferences module. |
Text |
Grid/Panel |
Reference # |
This field appears in the Load List page of the Loads module and represents external reference #, as seen in values such as 55348 or AB49856. |
Text |
Grid/Panel |
Load Status |
This field appears in the Load List page of the Loads module and represents load status, as seen in values such as Planned, Available, Assigned, Complete, etc. |
Text |
Grid/Panel |
Tags |
This field appears in the Load List page of the Loads module. Tags are completely customizable and used for custom data filtering. |
Enum LIst |
Grid/Panel |
Settlement Status |
This field appears in the Load List page of the Loads module. This status relates to the status of the settlement items such as Driver, Dispatcher, Tractor on the Trips related to the load. |
Text |
Grid/Panel |
Revenue |
This field appears in the Load List page of the Loads module and represents load revenue, which displays as $ values in the UI but exports as numeric values only. |
Numeric |
Grid/Panel |
Trip |
This field appears in the Load List page of the Loads module and represents associated trips to the Load, as seen in values such as LD5556, LD5510-1, LD5510-2. |
Text |
Grid/Panel |
Brokered |
This field appears in the Load List page of the Loads module and represents brokered Trips associated to the Load, as seen in values such as LD5510, LD5543-1. |
Text |
Grid/Panel |
Load Type |
This field appears in the Load List page of the Loads module and represents whether the load is a FTL (full truckload) or Partial (partial truckload) so that it can be consolidated into a manifest. |
Text |
Grid/Panel |
Driver |
This field appears in the Load List page of the Loads module and represents driver(s) assigned to the associated Trips. |
Text |
Grid/Panel |
Dispatcher |
This field appears in the Load List page of the Loads module and represents dispatcher(s) assigned to the associated Trips. |
Text |
Grid/Panel |
Invoicing Terminal |
This field appears in the Load List page of the Loads module and represents invoicing terminal of the load (this represents the Pay To field on of the invoice. |
Text |
Grid/Panel |
Dispatch Terminal |
This field appears in the Load List page of the Loads module and represents dispatch terminal of the load, which will be the terminal from which the drivers and assets are assigned. |
Text |
Grid/Panel |
Customer |
This field appears in the Load List page of the Loads module and represents associated company that will be billed for the load, as seen in values such as Allen Lund Company, Amazon, FedEx. |
Text |
Grid/Panel |
Tractor # |
This field appears in the Load List page of the Loads module and represents tractor(s) that are assigned to the trip(s). |
Text |
Grid/Panel |
Trailer # |
This field appears in the Load List page of the Loads module and represents trailer(s) that are assigned to the trip(s). |
Text |
Grid/Panel |
Required Equipment Type |
This field appears in the Load List page of the Loads module and represents required equipment type, as seen in values such as Flatbed, Reefer, Van. |
Text |
Grid/Panel |
Seal # |
This field appears in the Load List page of the Loads module. This represents the seal number of a shipment but can also be used generically as another reference number. |
Text |
Grid/Panel |
Chassis # |
This field appears in the Load List page of the Loads module. This represents the Chassis number of a Load which can be redundant with Trailer Number in some cases but is tied directly to the Chassis and Container equipment type. |
Text |
Grid/Panel |
Container # |
This field appears in the Load List page of the Loads module. This represents the Container number of a Load which can be redundant with Trailer Number in some cases but is tied directly to the Chassis and Container equipment type. |
Text |
Grid/Panel |
Import/Export |
This field appears in the Load List page of the Loads module. This field is an enum related to Drayage mode Loads as to whether the load is an import or export denoting whether it should be loaded are empty when coming from or returning to the port. |
Text Enum |
Grid/Panel |
Booking # |
This field appears in the Load List page of the Loads module. This represents the booking number of a shipment but can also be used generically as another reference number and is related to Drayage Mode Loads. |
Text |
Grid/Panel |
Appointment # |
This field appears in the Load List page of the Loads module. This represents the appointment number of a shipment but can also be used generically as another reference number and is related to Drayage Mode Loads. |
Text |
Grid/Panel |
Commodity Type |
This field appears in the Load List page of the Loads module and represents commodity type(s), as seen in values such as General Freight or custom commodity types. |
Text |
Grid/Panel |
Weight |
This field appears in the Load List page of the Loads module and represents the Total weight of the Load in pounds from the aggregated commidites or entered weight value from load details. |
Numeric |
Grid/Panel |
Last Free Day |
This field appears in the Load List page of the Loads module. This field is specific to Drayage operations for the Last Free Day out of the port for a container. |
Date |
Grid/Panel |
Origin Location Name |
This field appears in the Load List page of the Loads module and represents origin location name (or first pickup location), which will populate for any Business Name stored on a location. |
Text |
Grid/Panel |
Destination Location Name |
This field appears in the Load List page of the Loads module and represents destination location name (or last dropoff location), which will populate for any Business Name stored on a location. |
Text |
Grid/Panel |
Origin |
This field appears in the Load List page of the Loads module and represents first pickup city and state, as seen in values such as Dallas, TX, Chicago, IL, New York City, NY. |
Text |
Grid/Panel |
Destination |
This field appears in the Load List page of the Loads module and represents last drop off city and state, as seen in values such as Dallas, TX, Chicago, IL, New York City, NY. |
Text |
Grid/Panel |
Pickup |
This field appears in the Load List page of the Loads module and represents Appointment pickup time, as seen in values such as Mar 11, 2025 00:00 CDT, Feb 18, 2025 00:00 CST, Feb 26, 2025 00:00 CST. |
Date |
Grid/Panel |
Drop Off |
This field appears in the Load List page of the Loads module and represents Appointment drop off time, as seen in values such as Mar 12, 2025 00:00 CDT, Feb 19, 2025 00:00 PST, Feb 27, 2025 00:00 CST. |
Date |
Grid/Panel |
Actual Pickup |
This field appears in the Load List page of the Loads module and represents Actual pickup time, as seen in values such as Mar 11, 2025 00:00 CDT, Feb 18, 2025 00:00 CST, Feb 26, 2025 00:00 CST. |
Date |
Grid/Panel |
Actual Drop Off |
This field appears in the Load List page of the Loads module and represents Actual drop off time, as seen in values such as Mar 12, 2025 00:00 CDT, Feb 19, 2025 00:00 PST, Feb 27, 2025 00:00 CST. |
Date |
Grid/Panel |
Stops |
This field appears in the Load List page of the Loads module and represents the number of load stops in the associated trips. |
Numeric |
Grid/Panel |
Missing Documents |
This field appears in the Load List page of the Loads module and represents missing required documents, as seen in values such as RC, POD, BOL. |
Enum Text |
Grid/Panel |
Dispatch Notes |
This field appears in the Load List page of the Loads module. This field represents the open text notes field related to dispatch instructions for the Load. |
Text |
Grid/Panel |
Created Date-Time |
This field appears in the Load List page of the Loads module and represents the Loads date and time of creation. Samples values such as Mar 10, 2025 10:59 GMT, Feb 17, 2025 19:38 GMT, Feb 25, 2025 08:56 GMT on export but in local time in the UI. |
Date |
Grid/Panel |
Hold |
This field appears in the Load List page of the Loads module. It only contains a value of Hold if the status of the Load is currently in a Hold status. |
Text |
Grid/Panel |
Load Detail Panels
Section (Header) |
Description |
Data Type |
Locations |
Load ID | Unique identifier of the load. | text | Overview |
Loaded Miles | Total loaded miles for the load. | number | Overview |
Empty Miles | Total empty (deadhead) miles. | number | Overview |
Revenue | Gross revenue for the load. | currency | Overview |
Revenue Per Mile | Revenue earned per mile driven. | currency | Overview |
Customer | Customer associated with the load. | text | Overview |
Tracking Link | URL for real-time load tracking. | link | Overview |
Delay Warning | Flag warning of potential delay by stop. | text | Overview |
Priority | Urgency or handling level assigned to the load. | enum | Overview |
Is Brokered | Indicates whether the load is brokered. | boolean | Overview |
Required Equipment | Equipment type needed for this load. | enum | Overview |
Weight | Weight of the load in pounds. | number | Overview |
Load Type | Load classification such as FTL or Partial. | enum | Overview |
Mode | Transportation mode (e.g., TL, Drayage) [Drayage mode opens additional fields for input] | enum | Overview |
Quantity | Number of units or packages for the commodity. | number | Overview > Commodity |
Package Type | Packaging type (e.g., Pallets, Boxes). | text | Overview > Commodity |
Stackable | Whether the freight is stackable. | boolean | Overview > Commodity |
Floor Load | Indicates whether freight is floor-loaded. | boolean | Overview > Commodity |
Volume | Total volume in cubic feet. | number | Overview > Commodity |
Length | Length of the commodity in feet. | number | Overview > Commodity |
Width | Width of the commodity in feet. | number | Overview > Commodity |
Height | Height of the commodity in feet. | number | Overview > Commodity |
Description | Additional description of the commodity. | text | Overview > Commodity |
Ref # | Reference number for the load. | text | Overview |
PO # | Purchase Order number associated with the load. | text | Overview |
BOL # | Bill of Lading number associated with the load. | text | Overview |
Seal # | Seal number used for load security. | text | Overview |
Notes for Dispatching | Instructions or notes for dispatchers. | text | Overview |
Service Type | Type of drayage service required. | enum | Overview > Drayage |
Steamship Line | Name of the shipping line moving the container. | text | Overview > Drayage |
Terminal Info | Details about the port or terminal. | text | Overview > Drayage |
Holds Category | Category of any customs or port holds. | text | Overview > Drayage |
Holds Type | Specific type of hold applied to the shipment. | text | Overview > Drayage |
Yard Location | Name or address of the yard where the container is stored. | text | Overview > Drayage |
Container Size | Size of the container (e.g., 20', 40'). | text | Overview > Drayage |
Chassis Provider | Entity providing the chassis for the container. | text | Overview > Drayage |
Earliest Return Date | First date the container can be returned without penalty. | date | Overview > Drayage |
Last Free Day | Last day before demurrage or per diem charges apply. | date | Overview > Drayage |
Perdiem Start Date | Date when per diem charges begin. | date | Overview > Drayage |
Full Outgate Date | Timestamp when container exited the port or yard. | date | Overview > Drayage |
In Pin | Security pin used for container entry. | text | Overview > Drayage |
Out Pin | Security pin used for container release. | text | Overview > Drayage |
Number of Stops | Total number of planned loads stops. | number | Routes |
Dispatch Sheet | Link or download of dispatch instructions. | file/link | Routes |
Pickup & Dropoff Appointments | Scheduled dates and times per stop. | datetime | Routes |
Stop Locations | Names and addresses of all stop locations. | text | Routes |
Assigned Terminal | Operational Dispatching terminal assigned to the load. | enum text | Routes |
Assigned Dispatcher | User managing dispatch responsibilities. | user | Routes |
Assigned Driver | Driver assigned to the load. | driver | Routes |
Assigned Tractor | Tractor unit assigned to haul the load. | tractor id | Routes |
Assigned Trailer | Trailer unit assigned to haul the load. | trailer id | Routes |
Driver Pay | Total amount owed to the driver for this trip. | currency | Finance |
Dispatcher Pay | Compensation to the dispatcher for this load. | currency | Finance |
Tractor Pay | Payment allocated to the tractor owner or unit. | currency | Finance |
Total Money In | Sum of incoming payments or expected revenue. | currency | Finance |
Total Money Out | Sum of payouts (e.g., driver, dispatcher, equipment). | currency | Finance |
Invoice ID | Unique identifier for this invoice. | text | Invoice |
Customer Name | Name of the billed customer. | text | Invoice |
Contact Info | Contact assigned to this invoice. | text | Invoice |
Invoice Terminal | Terminal managing the invoice. | text | Invoice |
Net Term | Days allowed for payment after invoice issue. | number | Invoice |
Invoice Reference Number | Optional external reference. | text | Invoice |
Invoice Notes | Internal notes for invoicing team. | text | Invoice |
Invoice Message | Message that appears on the invoice sent to the customer. | text | Invoice |
Invoice Total | Sum of all invoice line items. | currency | Invoice |
Factoring Charges | Amount subtracted due to factoring agreements. | currency | Invoice |
Amount Due | Net amount due after deductions. | currency | Invoice |
Factoring Status | Status of factoring payment (e.g., Requested, Funded). | enum | Invoice |
Factoring Company | Company handling factoring process. | text | Invoice |
Factoring Charges (%) | Percentage deducted as factoring fee. | percent | Invoice |
Alert Contact | Contact person for load-related alerts. | text | Alerts |
Alert Email | Email of the alert recipient. | text | Alerts |
Alert Phone | Phone number of the alert recipient. | text | Alerts |
Notification Triggers | List of alert trigger events (e.g., En route, Arrived, Completed). | list | Alerts |
Notes | Chronological log of internal load-related notes. | text list | Notes |
Note Category | Context or purpose of the note (e.g., Dispatch, Hold, Invoice). | enum | Notes |
Note Author | User who submitted the note. | text | Notes |
Note Timestamp | Date and time when note was created. | datetime | Notes |