> ## Documentation Index
> Fetch the complete documentation index at: https://docs.alvys.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Loads Report and Trips Report: column and Key Metric reference

> Every column and Key Metric in the Loads Report and Trips Report: what it shows, how Alvys calculates it, the permission it needs, and how often the data refreshes.

This page lists every column and Key Metric in **Loads Report** and **Trips Report**, with the same definition you see in the app. Use it to check what a number means, how Alvys calculates it, and why a column or metric is missing.

## How current is the data?

Loads Report and Trips Report read the Alvys reporting warehouse, not the live app database. This makes reports faster, also when you report over a large date range.

The reports refresh about every 30 minutes, so a change can take up to about an hour to show. If you change a load or trip after the last refresh, the report shows the old values until the next refresh. The **Legacy Report** reads live data.

The **Data as of** time in the report toolbar shows the date and time of the last update.

If the **Data as of** time is more than an hour old, contact Alvys Support.

> [!TIP]
>
> For live, minute-by-minute work, use the **Loads** page or [Dispatch Planner](https://docs.alvys.com/en/help/loads-trips/dispatch-planner.md). Use Loads Report and Trips Report for analysis and end-of-day work.

## Why can't I see a column or a Key Metric?

Some columns need a permission. If you do not have it, the column is not in the **Columns** panel, and a Key Metric that uses the column does not show. The **Permission** column in the tables below names the permission. When it lists two, either one is enough.

* Users with the Admin, Biller, Office Admin or Partner Admin role see every column.
* The **Key Metrics** section needs the **View Summary Financial Report** permission or one of the roles above.
* A column marked **Billing only** needs the **Billing** permission (or one of the roles above). Other permissions do not unlock it.
* An Admin can change permissions in **Settings → Organization → Users**.

Your company's custom reference fields also appear as columns, in their own group at the end of the **Columns** panel. They are not listed here because they are different for each company.

## How is gross margin calculated?

Gross Margin is customer revenue minus total carrier cost. It is blank on cancelled loads.

* **Customer revenue** is the customer linehaul, plus the fuel surcharge when it is turned on, plus all customer accessorials on the load.
* **Total carrier cost** is the cost of each trip on the load, added together. A cancelled trip costs 0.
  * Brokered trip: the carrier rate plus all carrier accessorials, including carrier payment fees such as QuickPay. The carrier rate is the overridden carrier rate when one was entered, otherwise the trip value. Advances are not counted again, because an advance is part of the carrier rate paid early.
  * Own-fleet trip: the pay for Driver 1, Driver 2 and the owner-operator on the trip.
* **Not in the cost:** fuel-card charges, toll charges, and the fee your factoring company charges you (the **Factoring Fee** column).

**Known limitation:** own-fleet cost counts only the driver and owner-operator pay that is tied to a trip. Pay by day, per diem, minimum-pay top-ups and bonuses on the driver statement are not included, so the gross margin on those trips reads higher than it is.

Margin % is gross margin divided by customer revenue. It is blank when revenue is 0. Gross Margin and Margin % are only in **Loads Report**.

The definition in the **Gross Margin** column of **Loads Report** says the same in short form.

## Loads Report: Key Metrics

The Key Metrics cards add up the rows that match your current filters. Hover the info icon on a card to see the same definition in the app.

| Key Metric | What it shows | Calculation | Permission |
| - | - | - | - |
| Total Miles | Loaded miles (0 on Cancelled and TONU trips) plus empty miles (0 on Cancelled trips). | sum of (Loaded Miles + Empty Miles). Breakdown: Loaded Miles and Empty Miles with their share. | None |
| Customer Revenue | Customer revenue over the loads in this report. | sum of Customer Revenue | View Customer Rate or Billing |
| Carrier Rate | Carrier rate over the brokered trips in this report, without accessorials. Own-fleet trips have no carrier rate and add nothing; Total Carrier Cost covers them with driver pay. | sum of Carrier Rate | View Carrier Rate or Billing |
| Total Carrier Cost | Brokered trips: carrier rate plus carrier accessorials. Own-fleet trips: driver and owner-operator pay, without fuel or tolls. Cancelled trips count as 0. | sum of Total Carrier Cost | View Carrier Rate or Billing |
| Gross Margin | Customer revenue minus total carrier cost. | sum of Gross Margin. Second line: sum of Gross Margin ÷ sum of Customer Revenue, shown as a percentage. | **Billing only** |

## Loads Report: columns

**Loads Report** has one row per load. Columns marked **Default** are in the report's standard layout. Add the others from the **Columns** panel.

### Core Identifiers & Status

| Column | Definition | Permission |
| - | - | - |
| Load # (Default) | The company-facing load number. | None |
| Load Status (Default) | Current status of the load (Open, Covered, Dispatched, In Transit, Delivered, Completed, Invoiced, Financed, Cancelled, TONU...). | None |
| Load Type (Default) | Revenue or Non-Revenue. | None |
| Order # (Default) | Customer order number entered on the load. | None |
| PO # (Default) | Customer purchase-order number. | None |
| Equipment (Default) | Equipment type recorded on the load. | None |
| Commodity | Commodity description on the load. | None |
| Commodity Type | Commodity category, assigned from the commodity description using a fixed list (e.g. 'Food/Beverage (refrigerated)', 'Building Materials', 'Other/Unknown'). | None |
| Load Weight | Weight entered on the load, converted to pounds. Blank when no weight, a negative weight or an unknown unit is entered. | None |
| Load Lane | Route of the load as City, ST pairs joined by arrows. | None |
| Contract Lane Type | Priority of the lane contract applied to the load: Primary or Secondary. | None |
| Contract Name | Name of the lane-rate contract applied to the load. | View Customer Rate |
| Reason Not Complete | Reason Not Completed value selected on the load; blank when none is set. | None |
| Appointments Verified | 'Verified' when every appointment stop on the load's trips is confirmed, 'Unverified' when one is not; blank when the load has no appointment stop. | None |
| Notes | Text of the most recent note on the load, by note time. | None |
| Brokerage Status | Visibility-tracking (brokerage) status of the load's trip; blank when tracking was never started. 'Multiple Trips' when the load has 2 or more trips (cancelled trips don't count while a live one exists) and any of them is tracked. | None |
| Location | Address of the latest tracked position of the load's trip. 'Multiple Trips' when the load has two or more trips. | None |

### People & Organization

| Column | Definition | Permission |
| - | - | - |
| Customer (Default) | Customer (bill-to) name. | None |
| Customer Sales Agent | Sales agent on the load; when none is set, the user who created the load. | None |
| Account Manager | Account manager assigned to the load. | None |
| Sales Manager | Sales manager assigned to the load. | None |
| Customer Service Rep | Customer service representative assigned to the load. | None |
| Load Planner | Load planner assigned to the load. | None |
| Created By | User who created the load. | None |
| Carrier | Carrier assigned to the load's trip. 'Multiple Trips' when the load has 2 or more trips (cancelled trips don't count while a live one exists). | None |
| Driver 1 | First driver on the load's trip. 'Multiple Trips' when the load has 2 or more trips (cancelled trips don't count while a live one exists). | None |
| Driver 2 | Second (team) driver on the load's trip. 'Multiple Trips' when the load has 2 or more trips (cancelled trips don't count while a live one exists). | None |
| Owner Operator | Owner-operator on the load's trip. 'Multiple Trips' when the load has 2 or more trips (cancelled trips don't count while a live one exists). | None |
| Dispatcher | Dispatcher responsible for the load's trips (the user a trip was dispatched on behalf of); when none is set, the user who dispatched it. 'Multiple Dispatchers' when the trips have different dispatchers; blank when none is set or that user has been deleted. | None |
| Carrier External Compliance Status | External compliance certification status of the carrier on the load's trip. 'Multiple Trips' when the load has 2 or more trips (cancelled trips don't count while a live one exists). | None |
| Carrier Sales Agent | Sales agent on the carrier of the load's trip; when the trip has none, the sales agent on the carrier profile. 'Multiple Carrier Sales Agents' when the load has 2 or more trips (cancelled trips don't count while a live one exists). | None |

### Assets & Fleets

| Column | Definition | Permission |
| - | - | - |
| Office (Default) | Office the load belongs to. | None |
| Invoice As | Subsidiary the load is invoiced as. | None |
| Load Fleet | Fleet assigned to the load. | None |
| Truck | Truck number on the load's trip. 'Multiple Trips' when the load has 2 or more trips (cancelled trips don't count while a live one exists). | None |
| Trailer | Trailer number on the load's trip. 'Multiple Trips' when the load has 2 or more trips (cancelled trips don't count while a live one exists). | None |
| Driver 1 Fleet | Fleet of the first driver on the load's trip. 'Multiple Trips' when the load has 2 or more trips (cancelled trips don't count while a live one exists). | None |
| Driver 2 Fleet | Fleet of the second driver on the load's trip. 'Multiple Trips' when the load has 2 or more trips (cancelled trips don't count while a live one exists). | None |
| Truck Fleet | Fleet of the truck on the load's trip. 'Multiple Trips' when the load has 2 or more trips (cancelled trips don't count while a live one exists). | None |
| Trailer Fleet | Fleet of the trailer on the load's trip. 'Multiple Trips' when the load has 2 or more trips (cancelled trips don't count while a live one exists). | None |
| Tender As | Subsidiary the load's trip is tendered as. 'Multiple Trips' when the load has 2 or more trips (cancelled trips don't count while a live one exists). | None |

### Dates & Times

| Column | Definition | Permission |
| - | - | - |
| Created | When the load was created (UTC). | None |
| Scheduled Pickup Start (Default) | Start of the scheduled window of the load's first customer pickup stop, in that stop's local time. For an appointment, start and end are the same. Also known as Ship Date. | None |
| Scheduled Pickup End | End of the scheduled window of the load's first customer pickup stop, in that stop's local time. For an appointment, start and end are the same. | None |
| Scheduled Delivery Start (Default) | Start of the scheduled window of the load's last customer delivery stop, in that stop's local time. For an appointment, start and end are the same. Also known as Delivery Date. | None |
| Scheduled Delivery End | End of the scheduled window of the load's last customer delivery stop, in that stop's local time. For an appointment, start and end are the same. | None |
| Pickup Schedule Type | Schedule type of the load's first customer pickup stop, the stop Scheduled Pickup Start reads: FCFS (a window) or APPT (an appointment). | None |
| Delivery Schedule Type | Schedule type of the load's last customer delivery stop, the stop Scheduled Delivery Start reads: FCFS (a window) or APPT (an appointment). | None |
| Date Dispatched | When the carrier was assigned to the trip. | None |
| Release Date | When the trip was released. | None |
| First Pick Arrived | Actual arrival at the first pickup (local time). | None |
| First Pick Departed | Actual departure from the first pickup (local time). | None |
| Last Drop Arrived | Actual arrival at the last delivery (local time). | None |
| Last Drop Departed | Actual departure from the last delivery (local time). | None |
| Last Check Call | Most recent driver check call on any trip of the load. | None |
| Invoiced Date | When the customer invoice was generated. | None |
| Invoice Age (Default) | Days since the invoiced date, counted in UTC days. | **Billing only** |
| Date Imported | Creation date for loads that came in through bulk import; empty otherwise. | None |
| Location Update | When the load's latest tracked position was recorded (UTC). Empty when the load has two or more trips. | None |
| Time Left | Minutes until the next stop of the load's first trip that is not yet arrived, picked up, emptied or spotted, for loads not yet delivered. Negative when late. | None |

### Geography

| Column | Definition | Permission |
| - | - | - |
| Pick City (Default) | City of the first pickup. | None |
| Pick State (Default) | State of the first pickup. | None |
| Drop City (Default) | City of the last delivery. | None |
| Drop State (Default) | State of the last delivery. | None |
| First Stop (Default) | Company (shipper) at the first pickup. | None |
| Last Stop (Default) | Company (receiver) at the last delivery. | None |
| First Pick Status | Status of the first pickup stop (Open, Covered, Arrived, Picked Up, Departed, Empty). | None |
| Last Drop Status | Status of the last delivery stop. | None |
| Pickup Region | DAT region of the pickup location. | None |
| Pickup Market | DAT market of the pickup location. | None |
| Dropoff Region | DAT region of the dropoff location. | None |
| Dropoff Market | DAT market of the dropoff location. | None |

### Financial - Customer Side

| Column | Definition | Permission |
| - | - | - |
| Customer Revenue (Default) | Customer linehaul plus fuel surcharge plus all customer accessorials on the load. Blank for cancelled loads. | View Customer Rate or Billing |
| Customer Freight Charge (Default) | Customer linehaul plus customer fuel surcharge, before accessorials (a missing part counts as 0). Blank for cancelled loads. | View Customer Rate or Billing |
| Customer Linehaul | Base linehaul amount of the customer rate, without fuel surcharge or accessorials. Blank for cancelled loads. | **Billing only** |
| Customer Fuel Surcharge | Fuel surcharge on the customer rate: the load's fuel surcharge amount when it is turned on; 0 when it is off or none. Blank for cancelled loads. | **Billing only** |
| Customer Accessorials | Sum of all customer accessorial charges on the load (rate times quantity). Blank for cancelled loads. | View Customer Rate or Billing |
| Customer Detention | Customer detention on the load: accessorials named detention, waiting time, dwell or standby. Trailer detention counts as Other. Lines are grouped by accessorial type name, including misspellings and Spanish terms; a name that fits two categories counts once, in the first of payment fees, detention, layover, lumper, late fees, fuel surcharge. The seven categories add up to Customer Accessorials. Blank for cancelled loads. | **Billing only** |
| Customer Layover | Customer layover on the load: accessorials named layover, hold over or stay over. Lines are grouped by accessorial type name, including misspellings and Spanish terms; a name that fits two categories counts once, in the first of payment fees, detention, layover, lumper, late fees, fuel surcharge. The seven categories add up to Customer Accessorials. Blank for cancelled loads. | **Billing only** |
| Customer Lumpers | Customer lumpers on the load: accessorials named lumper, unloading or offload. Driver assist, extra labor and restack count as Other. Lines are grouped by accessorial type name, including misspellings and Spanish terms; a name that fits two categories counts once, in the first of payment fees, detention, layover, lumper, late fees, fuel surcharge. The seven categories add up to Customer Accessorials. Blank for cancelled loads. | **Billing only** |
| Customer Late Fees | Customer late fees on the load: accessorials named late (late fee, late delivery) or missed appointment; credits make the sum negative. Lines are grouped by accessorial type name, including misspellings and Spanish terms; a name that fits two categories counts once, in the first of payment fees, detention, layover, lumper, late fees, fuel surcharge. The seven categories add up to Customer Accessorials. Blank for cancelled loads. | **Billing only** |
| Customer Payment Fees | Customer payment fees on the load: QuickPay, Standard Fee, factoring, fast pay and early pay, and fees for Comcheck, EFS, ACH, wire, transfer or advance payments. Lines are grouped by accessorial type name, including misspellings and Spanish terms; a name that fits two categories counts once, in the first of payment fees, detention, layover, lumper, late fees, fuel surcharge. The seven categories add up to Customer Accessorials. Blank for cancelled loads. | **Billing only** |
| Customer Fuel Surcharge Accessorials | Customer fuel surcharge accessorials on the load: accessorial lines named fuel surcharge, FSC, fuel charge or fuel adjustment. Fuel advances count as Other. Not the fuel surcharge on the load's rate (Customer Fuel Surcharge). Lines are grouped by accessorial type name, including misspellings and Spanish terms; a name that fits two categories counts once, in the first of payment fees, detention, layover, lumper, late fees, fuel surcharge. The seven categories add up to Customer Accessorials. Blank for cancelled loads. | **Billing only** |
| Customer Other Accessorials | Other customer accessorials on the load: every accessorial in none of the other six categories, such as tolls, extra stops, TONU, trailer detention and driver assist. Lines are grouped by accessorial type name, including misspellings and Spanish terms; a name that fits two categories counts once, in the first of payment fees, detention, layover, lumper, late fees, fuel surcharge. The seven categories add up to Customer Accessorials. Blank for cancelled loads. | **Billing only** |
| Customer Miles | Customer (billing) mileage entered on the load, with kilometres converted to miles. Blank when no mileage or an unknown unit is set. | None |
| Customer Payments | Total of all payments recorded from the customer on the load, every payment type included. Blank for cancelled loads. | **Billing only** |
| Customer Payment Date | Date of the most recent customer payment, any payment type. | **Billing only** |
| Customer Due Date | Due date of the customer invoice. | **Billing only** |
| Invoicing Method | Invoicing methods configured for the load (Email, Factoring Company, EDI...). | None |
| Customer Rate per Mile | Customer revenue divided by customer miles (kilometres converted to miles). Blank when the load has no customer miles or is cancelled. | View Customer Rate or Billing |
| Commissionable Amount | Carrier rate of the load plus carrier Detention and Layover accessorials on trips that are not cancelled. Used as the sales-commission basis. | View Customer Rate or Billing |

### Financial - Carrier/Driver Side

| Column | Definition | Permission |
| - | - | - |
| Carrier Rate (Default) | Carrier rate summed over the load's brokered trips that have a carrier: the overridden carrier rate, otherwise the trip value. Cancelled trips count as 0. Excludes accessorials. Blank when the load has no brokered trip, as on own-fleet loads; for those use Driver Rate. | View Carrier Rate or Billing |
| Carrier All-in Rate | Carrier rate plus carrier accessorials minus e-checks issued, summed over brokered trips. 0 for loads moved only by your own fleet; blank for cancelled loads. | View Carrier Rate |
| Carrier Advances | Sum of e-checks of type Advance or Fuel Advance issued on the load's brokered trips. Cancelled trips and cancelled e-checks count as 0. | **Billing only** |
| Carrier Detention | Carrier detention summed over the load's trips that are not cancelled: accessorials named detention, waiting time, dwell or standby. Trailer detention counts as Other. Lines are grouped by accessorial type name, including misspellings and Spanish terms; a name that fits two categories counts once, in the first of payment fees, detention, layover, lumper, late fees, fuel surcharge. The seven categories add up to all carrier accessorials on those trips. | **Billing only** |
| Carrier Layover | Carrier layover summed over the load's trips that are not cancelled: accessorials named layover, hold over or stay over. Lines are grouped by accessorial type name, including misspellings and Spanish terms; a name that fits two categories counts once, in the first of payment fees, detention, layover, lumper, late fees, fuel surcharge. The seven categories add up to all carrier accessorials on those trips. | **Billing only** |
| Carrier Lumper | Carrier lumper summed over the load's trips that are not cancelled: accessorials named lumper, unloading or offload. Driver assist, extra labor and restack count as Other. Lines are grouped by accessorial type name, including misspellings and Spanish terms; a name that fits two categories counts once, in the first of payment fees, detention, layover, lumper, late fees, fuel surcharge. The seven categories add up to all carrier accessorials on those trips. | **Billing only** |
| Carrier Late Fee Reimbursement | Carrier late fee reimbursement summed over the load's trips that are not cancelled: accessorials named late (late fee, late delivery) or missed appointment; credits make the sum negative. Lines are grouped by accessorial type name, including misspellings and Spanish terms; a name that fits two categories counts once, in the first of payment fees, detention, layover, lumper, late fees, fuel surcharge. The seven categories add up to all carrier accessorials on those trips. | **Billing only** |
| Carrier Payment Fees | Carrier payment fees summed over the load's trips that are not cancelled: QuickPay, Standard Fee, factoring, fast pay and early pay, and fees for Comcheck, EFS, ACH, wire, transfer or advance payments. Often negative, when the fee is taken out of the carrier's pay. Lines are grouped by accessorial type name, including misspellings and Spanish terms; a name that fits two categories counts once, in the first of payment fees, detention, layover, lumper, late fees, fuel surcharge. The seven categories add up to all carrier accessorials on those trips. | **Billing only** |
| Carrier Fuel Surcharge Accessorials | Carrier fuel surcharge accessorials summed over the load's trips that are not cancelled: accessorial lines named fuel surcharge, FSC, fuel charge or fuel adjustment. Fuel advances count as Other. Lines are grouped by accessorial type name, including misspellings and Spanish terms; a name that fits two categories counts once, in the first of payment fees, detention, layover, lumper, late fees, fuel surcharge. The seven categories add up to all carrier accessorials on those trips. | **Billing only** |
| Carrier Other Accessorials | Other carrier accessorials summed over the load's trips that are not cancelled: every accessorial in none of the other six categories, such as tolls, extra stops, TONU, trailer detention and driver assist, plus advances and fuel advances. Lines are grouped by accessorial type name, including misspellings and Spanish terms; a name that fits two categories counts once, in the first of payment fees, detention, layover, lumper, late fees, fuel surcharge. The seven categories add up to all carrier accessorials on those trips. | **Billing only** |
| Carrier Factoring Company | Factoring company of the carrier on the load's trip. 'Multiple Trips' when the load has 2 or more trips (cancelled trips don't count while a live one exists). | None |
| Carrier Invoice Number | Carrier's invoice number for the load's trip; blank when the trip is not brokered. 'Multiple Trips' when the load has 2 or more trips (cancelled trips don't count while a live one exists). | None |
| Carrier Invoice Due Date | Due date of the carrier's invoice for the load's trip. 'Multiple Trips' when the load has 2 or more trips (cancelled trips don't count while a live one exists); those rows sort last and match only the blank filter. | **Billing only** |
| Driver Rate | Total driver pay on the load's trip: driver 1 + driver 2 + owner-operator payable amounts; 0 on a cancelled trip. 'Multiple Trips' when the load has 2 or more trips (cancelled trips don't count while a live one exists); those rows sort last and match only the blank filter. | View Driver Rates |
| Driver Accessorials | Total driver accessorials on the load's trip: driver 1 + driver 2 + owner-operator accessorials; 0 on a cancelled trip. 'Multiple Trips' when the load has 2 or more trips (cancelled trips don't count while a live one exists); those rows sort last and match only the blank filter. | View Trip Value or Billing |

### Financial - Margin & Mileage

| Column | Definition | Permission |
| - | - | - |
| Gross Margin (Default) | Customer revenue minus total carrier cost. Brokered trips cost carrier pay plus carrier accessorials, without advance lines; own-fleet trips cost driver and owner-operator pay, without fuel-card or toll charges. Cancelled trips cost 0; blank for cancelled loads. | **Billing only** |
| Loaded Miles (Default) | Routed loaded miles summed over the load's trips, excluding cancelled and TONU trips. | None |
| Empty Miles | Estimated empty (deadhead) miles summed over the load's trips, excluding cancelled trips. | None |
| Loaded Dispatch Mileage | Paid loaded miles summed over the load's trips; uses routed miles when paid miles are 0 or not set. TONU trips count as 0 and cancelled trips are excluded. | None |
| Empty Dispatch Mileage | Paid empty miles summed over the load's trips; uses estimated empty miles when paid empty miles are 0 or not set. Cancelled trips are excluded. | None |
| Total Dispatch Mileage | Loaded dispatch mileage plus empty dispatch mileage. | None |
| Factoring Payments | Total amount funded by the factoring company across the load's factoring purchase transactions. Kept on cancelled loads, since the money was already paid. | **Billing only** |
| Factoring Fee | Total fee charged by the factoring company across the load's factoring purchase transactions. Kept on cancelled loads. | **Billing only** |
| Factoring Escrow | Total reserve (escrow) held back by the factoring company across the load's factoring purchase transactions. Kept on cancelled loads. | **Billing only** |
| Margin % (Default) | Gross margin divided by customer revenue. Blank when revenue is 0 or the load is cancelled. | **Billing only** |

## Trips Report: Key Metrics

The Key Metrics cards add up the rows that match your current filters. Hover the info icon on a card to see the same definition in the app.

| Key Metric | What it shows | Calculation | Permission |
| - | - | - | - |
| Total Miles | Loaded miles (0 on Cancelled and TONU trips) plus empty miles (0 on Cancelled trips). | sum of Total Miles. Breakdown: Loaded Miles and Empty Miles with their share. | None |
| Total Trips | Trips that are not Cancelled or TONU. | count of trips whose Trip Status is not Cancelled or TONU | None |
| Deadhead % | Empty miles as a share of total miles. Empty miles still count on TONU trips. | sum of Empty Miles ÷ sum of Total Miles | None |
| Total Carrier Cost | Brokered trips: carrier rate plus carrier accessorials. Own-fleet trips: driver and owner-operator pay, without fuel or tolls. Cancelled trips count as 0. | sum of Total Carrier Cost | View Carrier Rate or Billing |
| Carrier Cost per Mile | Total carrier cost divided by total miles. A TONU trip adds its cost but no miles. | sum of Total Carrier Cost ÷ sum of Total Miles | View Carrier Rate or Billing |

## Trips Report: columns

**Trips Report** has one row per trip. Columns marked **Default** are in the report's standard layout. Add the others from the **Columns** panel.

### Core Identifiers & Status

| Column | Definition | Permission |
| - | - | - |
| Trip # (Default) | The company-facing trip number. | None |
| Load # (Default) | Company-facing number of the load the trip belongs to. | None |
| Trip Status (Default) | Current status of the trip. | None |
| Load Status (Default) | Current status of the load the trip belongs to. | None |
| Equipment (Default) | Equipment type and length of the trip, e.g. 'Reefer - 53'. | None |
| Equipment Class | Equipment class of the trip (Van, Reefer, Flatbed, Specialized, Other); comma-separated when the equipment type belongs to more than one. | None |
| Brokerage Status (Default) | Visibility-tracking (brokerage) status of the trip; blank when tracking was never started. | None |
| Order # (Default) | Order number of the load the trip belongs to. | None |
| Notes | Text of the most recent note on the load the trip belongs to, by note time. | None |
| Appointments Verified | 'Verified' when every appointment stop on the trip has a confirmed appointment, 'Unverified' when at least one has not; blank when the trip has no appointment stops. | None |
| Completed Stops | Completed customer stops out of total customer stops, shown as 'completed / total'. | None |
| Weight | Sum of commodity weights on the trip's pickup stops, in pounds (kilograms converted). Blank when the pickup stops list no commodities; 0 when commodities have no weight. | None |
| SMS | Chat icon that opens the SMS conversation with the trip's first driver; shown when your company has a Twilio integration. | None |

### People & Organization

| Column | Definition | Permission |
| - | - | - |
| Carrier (Default) | Carrier assigned to the trip. | None |
| Driver 1 (Default) | First driver on the trip. | None |
| Driver 2 | Second (team) driver on the trip. | None |
| Owner Operator | Owner-operator on the trip. | None |
| Dispatcher (Default) | Dispatcher responsible for the trip (the user it was dispatched on behalf of); when none is set, the user who dispatched it. Blank when neither is set or that user has been deleted. | None |
| Carrier External Compliance Status | External compliance certification status of the trip's carrier. | None |
| Carrier Sales Agent | Sales agent on the trip's carrier; when the trip has none, the sales agent on the carrier profile. | None |
| Customer (Default) | Customer (bill-to) of the load the trip belongs to. | None |
| Created By | User who created the load the trip belongs to. | None |
| Customer Sales Agent | Sales agent on the load the trip belongs to; when none is set, the user who created the load. | None |
| Account Manager | Account manager assigned to the load the trip belongs to. | None |
| Sales Manager | Sales manager assigned to the load the trip belongs to. | None |
| Customer Service Rep | Customer service representative assigned to the load the trip belongs to. | None |
| Load Planner | Load planner assigned to the load the trip belongs to. | None |

### Assets & Fleets

| Column | Definition | Permission |
| - | - | - |
| Truck (Default) | Truck number on the trip. | None |
| Trailer (Default) | Trailer number on the trip. | None |
| Fleet | Fleet of the load the trip belongs to. | None |
| Driver 1 Fleet | Fleet of the first driver. | None |
| Driver 2 Fleet | Fleet of the second driver. | None |
| Truck Fleet | Fleet of the truck. | None |
| Trailer Fleet | Fleet of the trailer on the trip. | None |
| Tender As (Default) | Subsidiary the trip is tendered as. | None |
| Tender As Type | Type of the tender-as subsidiary: 'Brokerage' or 'Carrier' (asset). Decides which cost columns apply. | None |
| Invoice As | Subsidiary the load the trip belongs to is invoiced as. | None |
| Office (Default) | Office of the trip, taken from its load. | None |

### Dates & Times

| Column | Definition | Permission |
| - | - | - |
| Created | When the trip was created (UTC). | None |
| Age | Whole days since the load the trip belongs to was created, counted from when the report was read. | None |
| Scheduled Pickup Start (Default) | Start of the scheduled window of the trip's first customer pickup stop, in that stop's local time. For an appointment, start and end are the same. Also known as Ship Date. | None |
| Scheduled Pickup End | End of the scheduled window of the trip's first customer pickup stop, in that stop's local time. For an appointment, start and end are the same. | None |
| Scheduled Delivery Start (Default) | Start of the scheduled window of the trip's last customer delivery stop, in that stop's local time. For an appointment, start and end are the same. Also known as Delivery Date. | None |
| Scheduled Delivery End | End of the scheduled window of the trip's last customer delivery stop, in that stop's local time. For an appointment, start and end are the same. | None |
| Pickup Schedule Type | Schedule type of the trip's first customer pickup stop, the stop Scheduled Pickup Start reads: FCFS (a window) or APPT (an appointment). | None |
| Delivery Schedule Type | Schedule type of the trip's last customer delivery stop, the stop Scheduled Delivery Start reads: FCFS (a window) or APPT (an appointment). | None |
| Dispatched Date | When the carrier was assigned to the trip. | None |
| Release Date | When the trip was released. | None |
| Last Check Call | Time of the last check call on the trip. | None |
| Date Imported | Creation date of the load when it came in through bulk import; blank otherwise. | None |
| Invoiced Date | When the customer invoice of the load the trip belongs to was generated. | None |
| Dwell Hours | Hours between arrival and departure at each completed pickup and delivery stop, added up for the trip. Blank when no completed stop has both an arrival and a departure time. | None |
| ETA | Estimated driving time from the trip's latest tracked position to its next stop, allowing for the driver's remaining hours of service. It is the estimate made when that position arrived and does not count down. Empty when the trip is not active or has no estimate. | None |
| Next Appointment | Date and appointment time of the Next Stop as the legacy board shows them: 'MM/DD/YYYY @ HH:MM', or the date alone. | None |

### Geography

| Column | Definition | Permission |
| - | - | - |
| Last Drop Status | Status of the trip's last delivery stop. | None |
| Pick City (Default) | City of the trip's first pickup. | None |
| Pick State (Default) | State of the trip's first pickup. | None |
| Pickup Market | DAT market of the trip's first pickup. | None |
| Pickup Region | DAT region of the trip's first pickup. | None |
| Drop City (Default) | City of the trip's last delivery. | None |
| Drop State (Default) | State of the trip's last delivery. | None |
| Dropoff Market | DAT market of the trip's last delivery. | None |
| Dropoff Region | DAT region of the trip's last delivery. | None |
| First Stop (Default) | Company name at the trip's first pickup stop. | None |
| Last Stop (Default) | Company name at the trip's last delivery stop. | None |
| Trip Lane | Origin to destination of the trip, as 'City, ST → City, ST'. | None |
| Next Stop | Address of the trip's next pickup or delivery stop: the first one not yet reached (Open or Covered), otherwise the last one. Uses the stop company's current address. | None |

### Financial - Customer Side

| Column | Definition | Permission |
| - | - | - |
| Invoicing Method | Invoicing methods configured for the load the trip belongs to (Email, Factoring Company, EDI...). | None |
| Estimated Trip Revenue | The trip's share of the load's total revenue (customer linehaul, fuel surcharge and accessorials), split across the load's trips by loaded miles, then total miles, then evenly. 0 on cancelled trips; blank when the load is cancelled or its revenue is out of range. | View Customer Rate or Billing |

### Financial - Carrier/Driver Side

| Column | Definition | Permission |
| - | - | - |
| Carrier Factoring Company | Factoring company of the trip's carrier. | None |
| Carrier Invoice Due Date | Due date of the carrier's invoice for the trip. | **Billing only** |
| Carrier Rate (Default) | The carrier's rate on a brokered trip (Tender As Type 'Brokerage'): the overridden carrier rate when one was entered, otherwise the trip value. 0 on cancelled trips. Blank on own-fleet trips (Tender As Type 'Carrier') and when no carrier is assigned; for own-fleet trips use Trip Value or Driver Rate. | View Carrier Rate or Billing |
| Total Carrier Cost | Brokered trips: carrier rate plus carrier accessorials, without advance lines (an advance is part of the carrier rate paid early; advance fees stay in). Asset trips: driver 1, driver 2 and owner-operator pay; fuel-card and toll charges are not included. 0 on cancelled trips; blank when a brokered trip's carrier rate is out of range. | View Carrier Rate or Billing |
| Carrier Advances | Sum of Advance and Fuel Advance e-checks issued on the trip (voided e-checks excluded). Brokered trips only; 0 on asset and cancelled trips. | View Carrier Rate or Billing |
| Carrier Invoice Number | Carrier's invoice number for the trip; blank on trips that are not brokered. | None |
| Posted Rate | Mean rate the trip is currently posted at on external load boards, zero rates excluded; blank when it is not posted. Listed only for companies with an active load-board integration. | None |
| Carrier Detention | Carrier detention on the trip: accessorials named detention, waiting time, dwell or standby. Trailer detention counts as Other. Lines are grouped by accessorial type name, including misspellings and Spanish terms; a name that fits two categories counts once, in the first of payment fees, detention, layover, lumper, late fees, fuel surcharge. The seven categories add up to all carrier accessorials on the trip. 0 on cancelled trips; blank when the trip has no carrier accessorials. | **Billing only** |
| Carrier Layover | Carrier layover on the trip: accessorials named layover, hold over or stay over. Lines are grouped by accessorial type name, including misspellings and Spanish terms; a name that fits two categories counts once, in the first of payment fees, detention, layover, lumper, late fees, fuel surcharge. The seven categories add up to all carrier accessorials on the trip. 0 on cancelled trips; blank when the trip has no carrier accessorials. | **Billing only** |
| Carrier Lumper | Carrier lumper on the trip: accessorials named lumper, unloading or offload. Driver assist, extra labor and restack count as Other. Lines are grouped by accessorial type name, including misspellings and Spanish terms; a name that fits two categories counts once, in the first of payment fees, detention, layover, lumper, late fees, fuel surcharge. The seven categories add up to all carrier accessorials on the trip. 0 on cancelled trips; blank when the trip has no carrier accessorials. | **Billing only** |
| Carrier Late Fee Reimbursement | Carrier late fee reimbursement on the trip: accessorials named late (late fee, late delivery) or missed appointment; credits make the sum negative. Lines are grouped by accessorial type name, including misspellings and Spanish terms; a name that fits two categories counts once, in the first of payment fees, detention, layover, lumper, late fees, fuel surcharge. The seven categories add up to all carrier accessorials on the trip. 0 on cancelled trips; blank when the trip has no carrier accessorials. | **Billing only** |
| Carrier Payment Fees | Carrier payment fees on the trip: QuickPay, Standard Fee, factoring, fast pay and early pay, and fees for Comcheck, EFS, ACH, wire, transfer or advance payments. Often negative, when the fee is taken out of the carrier's pay. Lines are grouped by accessorial type name, including misspellings and Spanish terms; a name that fits two categories counts once, in the first of payment fees, detention, layover, lumper, late fees, fuel surcharge. The seven categories add up to all carrier accessorials on the trip. 0 on cancelled trips; blank when the trip has no carrier accessorials. | **Billing only** |
| Carrier Fuel Surcharge Accessorials | Carrier fuel surcharge accessorials on the trip: accessorial lines named fuel surcharge, FSC, fuel charge or fuel adjustment. Fuel advances count as Other. Lines are grouped by accessorial type name, including misspellings and Spanish terms; a name that fits two categories counts once, in the first of payment fees, detention, layover, lumper, late fees, fuel surcharge. The seven categories add up to all carrier accessorials on the trip. 0 on cancelled trips; blank when the trip has no carrier accessorials. | **Billing only** |
| Carrier Other Accessorials | Other carrier accessorials on the trip: every accessorial in none of the other six categories, such as tolls, extra stops, TONU, trailer detention and driver assist, plus advances and fuel advances. Lines are grouped by accessorial type name, including misspellings and Spanish terms; a name that fits two categories counts once, in the first of payment fees, detention, layover, lumper, late fees, fuel surcharge. The seven categories add up to all carrier accessorials on the trip. 0 on cancelled trips; blank when the trip has no carrier accessorials. | **Billing only** |
| Driver Rate | Total driver pay on the trip: driver 1 + driver 2 + owner-operator payable amounts. 0 on cancelled trips. | View Driver Rates |
| Driver 1 Payable Amount | Pay owed to the first driver for this trip, calculated from their pay rates on the trip. 0 on cancelled trips. | View Driver Rates |
| Driver 2 Payable Amount | Pay owed to the second (team) driver for this trip, calculated from their pay rates on the trip. 0 on cancelled trips. | View Driver Rates |
| Owner Operator Payable Amount | Pay owed to the owner-operator for this trip, calculated from their pay rates on the trip. 0 on cancelled trips. | View Driver Rates |
| Driver Accessorials | Total driver accessorials on the trip: driver 1 + driver 2 + owner-operator accessorials. 0 on cancelled trips. | View Trip Value or Billing |
| Driver 1 Accessorials | Sum of driver accessorials assigned to the first driver on the trip. 0 on cancelled trips. | View Trip Value or Billing |
| Driver 2 Accessorials | Sum of driver accessorials assigned to the second driver on the trip. 0 on cancelled trips. | View Trip Value or Billing |
| Owner Operator Accessorials | Sum of driver accessorials assigned to the owner-operator on the trip. 0 on cancelled trips. | View Trip Value or Billing |
| Trip Value (Default) | The trip's share of the load rate as the app stores it (load rate × trip miles ÷ load miles). 0 on cancelled trips; blank when the stored amount is out of range. | View Trip Value or Billing |

### Financial - Margin & Mileage

| Column | Definition | Permission |
| - | - | - |
| Loaded Miles (Default) | Calculated loaded miles for the trip's route. 0 on cancelled and TONU trips. | None |
| Empty Miles (Default) | Estimated empty (deadhead) miles for the trip. 0 on cancelled trips; still shown on TONU trips. | None |
| Total Miles (Default) | Loaded miles plus estimated empty miles for the trip. 0 on cancelled and TONU trips, so on a TONU trip it can be 0 while Empty Miles still shows a value. | None |
| Loaded Dispatch Mileage | Loaded miles used for dispatch pay: the dispatcher's paid loaded miles when entered, otherwise the calculated loaded miles. 0 on cancelled and TONU trips. | None |
| Empty Dispatch Mileage | Empty miles used for dispatch pay: the dispatcher's paid empty miles when entered, otherwise the estimated empty miles (0 if cancelled). A paid value is kept even on cancelled and TONU trips. | None |
| Total Dispatch Mileage | Loaded dispatch miles plus empty dispatch miles. On cancelled and TONU trips only a dispatcher-entered paid empty-miles value counts. | None |

## Related

* [Loads Report and Trips Report](https://docs.alvys.com/en/help/loads-trips/loads-and-trips-custom-reports.md)
* [Report Permissions](https://docs.alvys.com/en/help/administration/report-permissions.md)
