LoadOps Data Dictionary - Loads/Trips

Section (Header)

Description

Data Type

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 Prefences module.

Text

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

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

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

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

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

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

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

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

Driver

This field appears in the Load List page of the Loads module and represents driver(s) assigned to the associated Trips.

Text

Dispatcher

This field appears in the Load List page of the Loads module and represents dispatcher(s) assigned to the associated Trips.

Text

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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