![TAI_LOGO_CMYK Option 1.2-03.jpg]](https://learn.tai-software.com/hs-fs/hubfs/TAI_LOGO_CMYK%20Option%201.2-03.jpg?height=40&name=TAI_LOGO_CMYK%20Option%201.2-03.jpg){kind=logo}
Custom Reports: Carrier Report
The Carrier report type pulls data from your carrier profiles. Use it to audit carrier information, review audit scores, analyze shipping activity, and export contact details.
For instructions on creating a report, configuring columns, filters, and delivery schedules, see Custom Reports: Overview & Setup.
General Information
| Column | Description |
|---|---|
| LSP Carrier ID | Your internal LSP carrier identifier |
| Carrier Master ID | System-wide carrier master ID |
| Status | Carrier status (Active, Inactive, etc.) |
| Has Factoring Company | Whether the carrier uses a factoring company |
| Tax Id | Carrier tax identification number |
| 1099 Required | Whether a 1099 is required |
| Intrastate | Whether the carrier operates intrastate only |
| Carrier Rep | Assigned carrier rep |
| Supported Shipment Types | Shipment types the carrier can handle |
| Trailer Types List | List of trailer types the carrier operates |
| Payment Terms | Carrier payment terms |
| Created Date | Date the carrier was added |
| Modified Date | Date the carrier record was last updated |
Master Carrier Information
| Column | Description |
|---|---|
| Name | Carrier company name |
| DOT Number | Department of Transportation number |
| Motor Carrier Number | MC number |
| SCAC | Standard carrier alpha code |
| Airline Code | Airline code (air freight carriers) |
| Phone | Main phone number |
| Fax | Fax number |
| Web URL | Carrier website |
| Tracking URL | Carrier tracking page URL |
| TSA Compliance | TSA compliance status |
| Common Authority | Common carrier authority |
| Contract Authority | Contract carrier authority |
| # of Drivers | Number of drivers on record |
| # of Power Units | Number of power units on record |
Physical Address
| Column | Description |
|---|---|
| Street Address | Physical street address |
| Street Address Two | Suite, unit, etc. |
| City | City |
| State | State |
| ZIP Code | ZIP code |
| Country | Country |
Remit Payment Address
| Column | Description |
|---|---|
| Remit Name | Name on the remit address |
| Remit Street Address | Remit street address |
| Remit City | City |
| Remit State | State |
| Remit ZIP Code | ZIP code |
| Remit Country | Country |
| Remit Email | Remit email address |
| Factoring Company ID | ID of factoring company (if applicable) |
Carrier Contact
| Column | Description |
|---|---|
| Contact Name | Contact's full name |
| Contact Email | Contact email address |
| Contact Phone | Contact phone number |
| Contact Type | Type of contact (Dispatch, Billing, etc.) |
Carrier Scorecard
| Column | Description |
|---|---|
| Audit Total Score | Overall audit score across all shipments |
| Audit Pickup Score | Average pickup performance score |
| Audit Delivery Score | Average delivery performance score |
| Total Audit Count | Total number of audits completed |
| Pickup Audit Count | Number of pickup audits |
| Delivery Audit Count | Number of delivery audits |
Shipping Data
Shipping Data columns reflect activity over a configurable date range. A Date Range for Shipping Data filter is required when any Shipping Data column is included — the system adds it automatically.
| Column | Description |
|---|---|
| Has Shipments | Whether the carrier has any shipments in the period |
| Number of Shipments | Total shipments in the date range |
| Number of Quotes | Total quotes in the date range |
| Total Buy | Total buy amount in the date range |
| Total Weight | Total weight shipped |
| Total Miles | Total miles across all shipments |
| Total Margin | Total margin in the date range |
| Last Quote Date | Date of the most recent quote |
| Last Shipment Date | Date of the most recent shipment |
Reference Numbers
| Column | Description |
|---|---|
| Reference Type | Broker carrier parameter |
| Reference Number | The value from the broker carrier parameter |
Detail Data
| Column | Description |
|---|---|
| Shipment Type | Shipment type for the carrier detail record |
| Question Category | Category of the audit question |
| Question Type | Type of question |
| Question | Audit question text |
| Answer | Answer given |
| Answer Score | Numeric score for the answer |
| Answer Date | Date the answer was submitted |
Custom Column
The Custom Column option adds a static-value column to your report, displaying the same fixed text on every row of the export. It does not pull data from the shipment record.
When to use it
Mainly for downstream processing: if you're exporting a report that gets imported into another system (like Excel, a TMS, or a BI tool) and that system needs a constant-identifier column, such as a batch label, region code, status tag, or source marker.
It doesn't filter or change any data; it just stamps every row with the same value you configured.
Example: If you set the fixed value to "Q2 2025", every row in the exported file will have "Q2 2025" in that column, regardless of the shipment.