organization_idstring required
integration_connection_idstring required
Integration connection UUID
external_reference_idstring required
External reference ID (e.g., L302537)
tms_display_reference_idstring nullable
Human-facing reference supplied by the TMS (e.g., Turvo customId)
display_reference_idstring nullable
Connection-preferred display identifier, falling back to external_reference_id
tms_statusstring nullable
Raw status from TMS system (e.g., 'Dispatched', 'At Shipper')
mentium_statusstring required
Mentium mapped status (PLANNED, ACTIVE, COVERED, IN_TRANSIT, DELIVERED, COMPLETED, TERMINATED, ARCHIVED, TEMP)
equipment_typestring nullable
Equipment type (e.g., REEFER, VAN, DRY INTERMODAL TEST)
descriptionstring nullable
mode_typestring nullable
Mode type (e.g., Brokerage, Asset)
transport_modestring nullable
service_typestring nullable
pallet_countinteger nullable
weight_uomstring nullable
Weight unit of measure (lbs, kg)
billable_weightnumber nullable
billable_weight_uomstring nullable
declared_valuenumber nullable
ltl_reference_numberstring nullable
carrier_pro_numberstring nullable
beginning_buy_ratenumber nullable
Initial target offer to carriers
max_buy_ratenumber nullable
Maximum negotiation ceiling
buy_rates_set_atstring date-time nullable
When the buy rates were last set, by either an operator or the TMS
buy_rates_set_by_user_idstring nullable
Mentium user who set the buy rates; null means the TMS set them
priority_levelstring nullable
over_short_or_damagedboolean
carrier_milesnumber nullable
customer_milesnumber nullable
total_distancenumber nullable
empty_distancenumber nullable
trailer_lengthstring nullable
equipment_codestring nullable
chassis_numstring nullable
tractor_numstring nullable
trailer_numberstring nullable
seal_numberstring nullable
driver_namestring nullable
driver_phonestring nullable
first_pickup_stop_target_arrival_earliest_atstring date-time nullable
Canonical pickup window start (first PICKUP stop's target_arrival_earliest_at)
first_pickup_stop_target_arrival_latest_atstring date-time nullable
Canonical pickup window end (exclusive; first PICKUP stop's target_arrival_latest_at)
last_delivery_stop_target_arrival_earliest_atstring date-time nullable
Canonical delivery window start (last DELIVERY stop's target_arrival_earliest_at)
last_delivery_stop_target_arrival_latest_atstring date-time nullable
Canonical delivery window end (exclusive; last DELIVERY stop's target_arrival_latest_at)
elapsed_timeinteger nullable
transit_timeinteger nullable
created_datestring date-time nullable
activity_datestring date-time nullable
rate_sourcestring nullable
Rate source (SpotQuote, Contract, Manual)
load_sourcestring nullable
Load source (Lmws, Manual)
tracking_link_urlstring nullable
integration_statusstring nullable
Integration status (Sent, New, Pending)
assigned_tostring nullable
offer_statusesCarrierOfferStatus[]
Distinct carrier offer statuses for the load
late_tracking_statusstring nullable
Late-load tracking status when the load has an active late episode (LATE)
analytics_error_categorystring nullable
Category of the analytics error (INTERNAL_ERROR, EXTERNAL_DATA_VALIDATION, SKIPPED)
analytics_error_descriptionstring nullable
Description of the analytics error
batch_analyticsboolean
True if analytics processing is pending
lane_historical_load_countinteger nullable
All-time analyzed load count on this load's lane. None when no analytics history exists.
lane_historical_marginnumber nullable
All-time total margin (customer − carrier) on this load's lane. Drives the lane P/L tag (>0 profit, <0 loss, 0 break-even).
customer_historical_load_countinteger nullable
All-time analyzed load count for this load's customer. None when no analytics history exists.
customer_historical_marginnumber nullable
All-time total margin (customer − carrier) for this load's customer. Drives the customer P/L tag (>0 profit, <0 loss, 0 break-even).
archived_atstring date-time nullable
When the load was auto-archived
archive_reasonstring nullable
Human-readable reason the load was archived
external_linkstring nullable
External TMS link to view load
sales_rep_display_namestring nullable
Sales rep display name (from TMS user info or mapping)
sales_rep_mentium_user_idstring nullable
Mentium user ID when sales rep is mapped to a workspace user
assigned_dispatcher_rep_display_namestring nullable
Assigned dispatcher rep display name (from TMS user info or mapping)
assigned_dispatcher_rep_mentium_user_idstring nullable
Mentium user ID when assigned dispatcher rep is mapped to a workspace user
actual_dispatcher_display_namestring nullable
Actual dispatcher display name (from TMS user info or mapping)
actual_dispatcher_mentium_user_idstring nullable
Mentium user ID when actual dispatcher is mapped to a workspace user
created_atstring date-time required
updated_atstring date-time required