Winter '25 Data Dictionary S through Z

Destination Country

Picklist

The destination ISO country code. Values include: “CA,” “MX,” and “US.” No default value.

Destination State/Province

Picklist

The destination ISO state/province code. This field is dependent on the Destination Country field. No default value.

Jurisdiction

Picklist

The taxing jurisdiction – Canada or Mexico. Values include: “Canada” and “Mexico.” No default value.

Origin Country

Picklist

The origin ISO Country code. Values include: “CA,” “MX,” and “US.” No default value.

Origin State/Province

Picklist

The origin ISO state/province code. This field is dependent on the Origin Country field. No default value.

Tax Id Number

Text(50)

The Tax ID that corresponds to this Sales Tax record. 

Tax Name

Text(80)

The unique record identifier.

Tax Rate

Percent(3,3)

The tax rate as a percentage of the total transportation charges.

Tax Type

Picklist

The type of sales tax applied. Values include: “GST,” “HST,” “QST,” “VAT,” or “RET.” This field is dependent on the Jurisdiction field. No default value.

Account

Master-Detail(Account)

The Master-Detail relationship to the parent Account record the Sales Tax Exclusion belongs to.

Name

Auto Number

The unique record identifier. Example: Exclusion-{0}.

Sales Tax

Master-Detail(Sales Tax)

The Master-Detail relationship to the parent Sales Tax record the Sales Tax Exclusion belongs to.

Tax Treatment

Picklist

The selected action to perform for tax. Values include: “Do Not Calculate or Display” and “Display as Zero Amount.” No default value.

Labor Cost

Formula (Currency)

The monetary labor cost for the service item.

Labor Hours

Number(4, 2)

The number of labor hours required for the service item.

Labor Rate per Hour

Currency(16, 2)

The monetary rate for labor for the service item.

Parts Cost

Currency(16, 2)

The monetary cost for parts for the service item.

Service Item Name

Text(80)

The unique record identifier.

Total Cost

Formula (Currency)

The total monetary cost of parts and labor for the service item.

Name

Text(80)

The unique record identifier.

Category

Picklist

The type of service order. Values include: “Repair” and “Maintenance.” No default value.

Completion Date

Date

The completion date of the service order.

Description

Text Area(255)

Description of the service order.

Fleet Asset

Master-Detail(Fleet Asset)

The Master-Detail relationship to the parent Fleet Asset record the Service Order belongs to.

Incident

Lookup(Incident)

A lookup to the Incident record associated with the Service Order.

Inspection Report

Lookup(Inspection Report)

A lookup to the Inspection Report record associated with this Service Order.

Items Completed

Roll-Up Summary (COUNT Service Order Item)

A rollup count of the number of service order items completed.

Items On Hold

Roll-Up Summary (COUNT Service Order Item)

A rollup count of the number of service order items on hold.

Items Pending

Roll-Up Summary (COUNT Service Order Item)

A rollup count of the number of service order items pending.

Items Started

Roll-Up Summary (COUNT Service Order Item)

A rollup count of the number of service order items started.

Service Location

Lookup(Account)

A lookup to the Account record associated with the location of servicing.

Service Manager

Lookup(User)

A lookup to the User record associated that belongs to the service manager.

Service Order Items  

Roll-Up Summary (COUNT Service Order Item)

A rollup count of the total number of service order items.

Service Order Number

Auto Number

The unique record identifier. Example: Service Order-{0}.

Service Order Status  

Picklist

The current state of the service order. Values include: “Pending,” “Started,” and “Completed.” “Pending” is the default value.

Service Order Template

Lookup(Service Order Template)

A lookup to the Service Order Template record associated with creating the service order.

Start Date

Date

The service order start date.

Total Cost

Roll-Up Summary (SUM Service Order Item)

A rollup of the total service order costs.

Total Labor Cost

Roll-Up Summary (SUM Service Order Item)

A rollup of the total service order labor costs.

Total Labor Hours

Roll-Up Summary (SUM Service Order Item)

A rollup of the total service order labor hours.

Total Parts Cost 

Roll-Up Summary (SUM Service Order Item)

A rollup of the total service order parts costs.

Comments

Text Area(255)

Comments for the service order item.

Completion Date

Date

The completion date for the service order item.

Labor Cost

Formula (Currency)

The monetary labor cost for the service order item.

Labor Hours

Number(4, 2)

The number of labor hours for the service order item.

Labor Rate per Hour

Currency(16, 2)

The monetary rate for labor for the service order item.

Order

Number(4, 0)

The position number in the list of service order items under the parent record.

Parts Cost

Currency(16, 2)

The monetary parts cost for the service order item.

Service Item Master               

Lookup(Service Item Master)

A lookup to the Service Item Master record the service order item was cloned from.

Service Order

Master-Detail(Service Order)

The Master-Detail relationship to the parent Service Order record the Service Order Item belongs to.

Service Order Item

Text(80)

The unique record identifier.

Service Technician

Lookup(User)

A lookup to the User record associated with the service technician.

Start Date

Date

The service order item start date.

Status

Picklist

The current state of the service order item. Values include: “Pending,” “On Hold,” “Started,” and “Completed.” “Pending” is the default value.

Total Cost

Formula (Currency)

The total monetary cost of labor and parts for the service order item.

Category

Picklist

The type of service order template. Values include: “Repair” and “Maintenance.” No default value.

Description

Text Area(255)

Description of the service order template.

Template Name

Text(80)

The unique record identifier.

Order

Number(4, 0)

The position of the service item in the parent service order template list of children.

Service Item Master

Master-Detail(Service Item Master)

The Master-Detail relationship to the parent Service Item Master record the Service Order Template Item belongs to and was cloned from.

Service Order Template

Master-Detail(Service Order Template)

The Master-Detail relationship to the parent Service Order Template record the Service Order Template Item belongs to.

Template Item ID

Auto Number

The unique record identifier. Example: Template Item-{0}.

Carrier Service

Master-Detail(Carrier Service)

The Master-Detail relationship to the parent Carrier Service record the Service Route belongs to.

Name

Text(80)

The unique record identifier.

Address

Formula (Text)

The complete address of the stop (concatenation formula field).

Appointment Required

Checkbox

If, “Checked” the Carrier must make an appointment at this stop location.

Appointment Time

Text(11)

The Carrier’s appointment time for the pickup/drop-off at this stop. Validation Rule: Field must be 24-hour time (HH:MM) or time period (HH:MM-HH:MM).

Arrival Date

Date

The date the Carrier arrives at the stop.

Arrival Status

Formula (Text)

Calculated based on the Arrival Date and the Expected Date and returns, “Early,” “On Time,” or “Late.”

Arrival Time

Text(5)

The 24-hour time the Carrier arrives at the stop. Validation Rule: Field must be 24-hour time (HH:MM).

Carrier ETA Date

Date

The Carrier-predicted arrival date at the stop.

Carrier ETA Time

Text(5)

The Carrier-predicted 24-hour arrival time at the stop. Validation Rule: Field must be 24-hour time (HH:MM).

Carrier Status

Picklist

High-level description of conditions at the stop. Values include: “No Issues,” “Delayed by Weather,” “Delayed by Traffic,” “Delayed by Equipment Breakdown,” “Checked In,” “Loading,” “Unloading,” “In Detention,” “Loaded Clean,” “Loaded with Issues,” “Unloaded Clean,” “Unloaded with Issues,” and “Other (see comments).” No default value.

Carrier Status as of

Date/Time

The date and time the Carrier provided a status update.

Carrier Status Comments

Text(255)

Carrier status comments regarding issues at the stop.

Carrier Status Reason

Picklist

EDI 214 status reason codes. Note: Do NOT change this list of reasons as they are based on the EDI 214 specification.

City

Text(40)

The stop city (if no Location populated).

City Index

Text(100) (External ID)

The indexed City-State Lane for the LaneIQ LWC.

Country

Picklist

The stop country code (if no Location populated).

Country Index

Text(40) (External ID)

The indexed Country Lane for the LaneIQ LWC.

Cumulative Miles

Number(10, 3)

The distance in miles to arrive at this stop via the route.

Departure Date

Date

The date the Carrier departs the stop.

Departure Time

Text(5)

The 24-hour time the Carrier departs the stop. Validation Rule: Field must be 24-hour time (HH:MM).

EDI Provider

Formula (Text)

Name of the integration providing the stop information. “Kleinschmidt” or “Cleo” are the two possible values.

Expected Date

Date

The date the Carrier is expected to arrive at the stop.

Expected Day

Formula (Text)

The Expected Date day of the week name.

Geolocation

Geolocation

The latitude and longitude coordinates for a stop. Typically these stops are not associated with an account.

Instructions

Long Text Area(2000)

Free-form Carrier instructions.

Is Dropoff

Checkbox

If “Checked,” this is a stop where a load is unloaded.

Is Geolocation

Checkbox

If “Checked,” the latitude and longitude stop location information is provided.

Is Pickup

Checkbox

If “Checked,” this is a stop that a load is loaded.

Kilometers Away

Number(10, 3)

The current distance between the driver’s location and the stop location in kilometers.

Last Route Update

Date/Time

A value that is set whenever the location or date/time of a stop appointment changes.

Load

Master-Detail(Load)

The Master-Detail relationship to the parent Load record the Stop belongs to.

Loading/Unloading Complete Date

Date

The date when the loading/unloading is completed at the stop. Usually occurs after the arrival and before the departure.

Loading/Unloading Complete Time

Text(5)

The time when the loading/unloading is completed at the stop. Usually occurs after the arrival and before the departure. Validation Rule: Field must be 24-hour time (HH:MM).

Location

Lookup(Account)

A lookup to the Account record associated with the stop’s location.

Location Name

Formula (Text)

The account name of the location.

Miles Away

Number(10, 3)

The current distance between the driver’s location and the stop location in miles.

Number

Number(3, 0)

The number of the stop in the route.

OTD Counter

Formula (Number)

Counter to track the arrival times at stops. “1” if the Carrier is early or on time. “0” otherwise.

P/D

Formula (Text)

Formula field indicating whether a stop is for a “Pickup” or “Delivery.”

P/D Status

Text(255)

This field stores the result of the Pickup/Delivery Status calculation using the Grace fields on the Location TP. This field is used by the Arrival Status field.

P/DAS

Formula (Text)

Internal formula field supporting on time calculations.

Pickup/Delivery Number

Text(200)

The customer pickup/delivery number.

Pickup/Delivery Status

Text Area(255)

The Carrier status summary information for a stop.

Postal Code

Text(20)

The stop postal code (if no Location populated).

Postal Code Index

Text(60) (External ID)

The indexed Postal Code Lane for the LaneIQ LWC.

References

Text(255)

Stop-level reference numbers and IDs.

Shipping/Receiving Contact

Lookup(Contact)

A lookup to the Contact record associated with the shipping/receiving contact for the stop location.

Shipping/Receiving Hours

Text(11)

The stop location hours of operation. Validation Rule: Field must be 24-hour time (HH:MM) or time period (HH:MM-HH:MM).

State Index

Text(40) (External ID)

The indexed State Lane for the LaneIQ LWC.

State/Province

Picklist

The stop state/province (if no Location populated).

Stop

Text(80)

The auto-generated stop name for a load.

Stop Status

Picklist

The status of a load in relation to a stop. Values include: “En Route,” “Arrived,” and “Departed.” This field is dependent on the Carrier Status field. No default value.

Terminal Email

Email

Returned by SMC3 for Carrier Quotes and set here on assignment.

Terminal Location

Text Area(255)

Returned by SMC3 for Carrier Quotes and set here on assignment.

Terminal Phone

Phone

Returned by SMC3 for Carrier Quotes and set here on assignment.

Timezone

Picklist

The time zone for a stop when the Location is null. No default value.

Tracking Provider (Customer)

Formula (Text)

The provider currently tracking the load for a customer.

Name

Text(80)

The unique record identifier.

Document Options

Master-Detail(Document Options)

The Master-Detail relationship to the parent Document Options record the TMS Document Field belongs to.

Field Name

Text(50)

The API field name to add to the document.

Name

Auto Number

The unique record identifier. Example: Field-{0}.

Order

Number(4, 0)

The order of the added field on the document.

Table

Text(50)

The API object name the field comes from. The current choices are “Load,” “Stop,” and “Line Item.”

TMS Document

Master-Detail(TMS Document)

The Master-Detail relationship to the parent TMS Document record the TMS Document Field belongs to.

Custom Header Page Name

Text(50)

The API Name of the Visualforce page that overrides the current document header page. Currently only used for CustomerInvoiceBatch.

Custom Page Name

Text(50)

The API Name of the Visualforce page that overrides the current default document.

Document Options

Master-Detail(Document Options)

The Master-Detail relationship to the parent Document Options record the TMS Document Options belongs to.

Logo Id

Text(18)

The document-specific ID for a logo override file attachment.

Name

Auto Number

The unique record identifier. Example: Option-{0}.

Suppress Expected Delivery Date

Checkbox

For LTL loads, if “Checked,” the expected delivery date from the (.pdf) document will be suppressed as well as the delivery receiving hours.

Suppress Logo

Checkbox

If Checked, the logo from the (.PDF) document will be suppressed.

TMS Document

Master-Detail(TMS Document)

The Master-Detail relationship to the parent TMS Document record the TMS Document Options belongs to.

Name

Text(80)

The unique record identifier. Example: Override-{0}.

Override Text

Long Text Area(1000)

Text replacement in the document.

Parent Id

Text(18) (External ID)

The parent record (often a load) that this document refers to.

Target Field

Text(50)

The field name that is replaced in the document.

TMS Document

Master-Detail(TMS Document)

The Master-Detail relationship to the parent TMS Document record the TMS Document Override belongs to.

Carrier (Air)

Carrier (Ocean)

Shipper/Consignee

Carrier (Ground)

Carrier (Rail)

Broker/3PL

A/R Current

Currency(16, 2)

The monetary amount of the current accounts receivable balance.

A/R Past Due

Currency(16, 2)

The monetary amount of the past due accounts receivable balance.

A/R Unbilled

Currency(16, 2)

The monetary amount of any pending customer invoices and accepted customer quotes without corresponding invoices.

Agreement Date

Date

The date when the Carrier agreed to the terms and conditions and signed the agreement.

Agreement Signed By

Lookup(Contact)

A lookup to the Contact record that signed the agreement.

Agreement Status

Picklist

The current state of the agreement with a Carrier. Values include: “Pending,” “Requested,” “Received,” and “Verified.” No default value.

AI Generated Customer Quote Status

Picklist

The status of a customer quote created from the OpenAI integration. Values include: “Quoted” and “Accepted.” No default value.

Allow Booking from Load Postings

Picklist (Multi-Select)

This field is used to add a Carrier to a load board via the selected API. Values include: “Truckstop 2” and “Trucker Tools Load Board.” No default value.

Appointment Lead Time (Days)

Number(2, 0)

The number of days prior to the appointment date.

Appointment Method

Picklist

The method for scheduling an appointment. Values include: “Phone,” “Email,” and “Website.” No default value.

Appointment Time Grace Period (After)

Number(3, 0)

The number of minutes a Carrier can arrive after an appointment time and still be considered On Time.

Appointment Time Grace Period (Before)

Number(3, 0)

The number of minutes a Carrier can arrive before an appointment time and still be considered On Time.

Appointment Website

URL(255)

The website URL for scheduling Fleet appointments.

Authority Granted Date

Date

The date the Carrier authority was granted.

Authority Risk

Picklist

The SaferWatch/MyCarrierPackets authority risk measure. Values include: “Pending,” “Acceptable,” “Moderate,” “Unacceptable,” “Unacceptable Review,” and “Unacceptable Fail.” “Pending” is the default value.

Authority Risk Points

Number(6, 0)

The MyCarrierPackets authority risk score point number.

Auto-Apply Accessorial Rating Source

Picklist

Selection of quotes to apply the accessorial. Values include: "Customer Rates Only," and "Customer + Global Rates." No default value.

Auto-Send Invoices

Checkbox

If “Checked,” approved customer invoices are automatically sent by the CustomerInvoiceGenerationJob batch job on the Invoice date.

Barcode Height

Number(7, 3)

The height of the barcode measured in pixels to the left of the decimal and thousands of an inch to the right of the decimal.

Barcode Type

Picklist

The barcode type selection. Values include: “Code 39” and “Code 128.” No default value.

Barcode Units

Picklist

The unit type selection for barcodes. Values include: “Inches” and “Pixels.” No default value.

Barcode Width

Number(7, 3)

The width of the barcode measured in pixels to the left of the decimal and thousands of an inch to the right of the decimal.

Batch Invoicing Email Process

Picklist

This field determines how invoices are batched and sent via email. Values include: “One Email, Combined Invoice Attachment,” “One Email, Individual Invoice Attachments,” and “Multiple Emails, Individual Invoice Attachments.” This field is dependent on the Batch Invoicing POD Treatment field. “One Email, Combined Invoice Attachment” is the default value.

Batch Invoicing POD Treatment

Picklist

How to handle POD attachments to a load when individually and batch-generating customer invoices. Values include: “Include as Attachment” and “Include in Invoice Attachment.” No default value.

Billing Email Attachment Format

Picklist

The field for selecting the attachment file type for customer billing via email. Values include: “PDF” and “PDF with .csv.” “PDF” is the default value. Validation Rule: This field requires a Customer Invoice Export File to use.

Billing Method

Picklist

The field for selecting a billing method for a customer. Values include: “Email,” “EDI,” and “Print.” “Email” is the default value.

Blue Yonder ID

Text(255)

The ID number for Blue Yonder customers, shippers, and consignees.

Bonded Carrier IRS Number

Text(50)

The IRS number assigned to a Bonded Carrier.

Breakthrough Fuel Shipper Id

Text(50)

The Breakthrough Fuel customer identifier field.

Broker Authority Pending

Picklist

Selection for whether a broker authority is pending. Values include: “Yes” or “No.” No default value.

Broker Authority Revocation

Picklist

Selection if a broker authority has been revoked. Values include: “Yes” or “No.” No default value.

Broker Authority Status

Picklist

The state of the broker authority. Values include: “Active,” “Inactive,” and “None.” No default value.

CA Port Code

Text(4)

The port code assigned to a Canadian Customs location.

CA Port Sublocation Code

Text(4)

The port code assigned to the sublocation of a Canadian Customs location.

CAAT

Text(40)

Mexico Carrier identifier.

Canada Province Coverage

Picklist (Multi-Select)

Canadian provinces served by the Carrier. No default value.

CARB-TRU Certificate Expiration Date

Date

The date when the CARB-TRU Certification expires. Field received from RMIS.

CARB-TRU Compliance Type

Text(100)

The specific CARB-TRU Compliance Type and is received from RMIS.

CARB-TRU Compliant Vehicles Reported

Number(7, 0)

The number of CARB-TRU Compliant Vehicles and is received from RMIS.

CARB-TRU Non-Compliant Reason

Long Text Area(8000)

The description field of the CARB-TRU Non-Compliant Reason received from RMIS.

Cargo Carried

Picklist (Multi-Select)

The cargo type carried by the Carrier. No default value.

Cargo Insurance Option   

Picklist

Selection field for cargo insurance. Values include: “Hide,” “Opt In,” and “Opt Out.” No default value.

Carrier API Login Group

Text(40)

The Login Group Key for customer-specific Carrier pricing via Banyan or Project44.

Carrier Comments

Text Area(255)

Information received from the Carrier from their application. This information includes comments on their FMCSA data.

Carrier Engagement Automation

Picklist (Multi-Select)

Functions that can automatically occur for the Carrier. Values include: “Auto-Tender” and “Auto-Post.” No default value.

Carrier Markup Group

Lookup(Carrier Markup Group)

The set of Carrier Markup records to use for this customer.

Carrier Operation

Picklist (Multi-Select)

The type of Carrier operations. Values include: “Interstate,” “Intrastate,” “Intrastate HazMat,” and “None.” No default value.

Carrier Pay To Name

Text(255)

The name of the Factor Company in RMIS.

Carrier Payment Terms

Lookup(Payment Terms)

A lookup to the Payment Terms record associated with the Carrier.

Carrier Remit To

Lookup(Account)

A lookup to the Account record associated with remitting to the Carrier itself or to a Factor Company.

Carrier Remit To Admin Job Id

Text(18)

This internal field is an ID of the batch job updating the Carrier Remit To field.

Carrier Remit To As Of

Date/Time

The date and time when the Carrier Remit To changed.

Carrier Review Comments

Long Text Area(2000)

Analyst comments regarding the Carrier during the review process.

CBSA Carrier Code

Text(4)

The Canadian Border Customs code to identify Carriers.

Carrier Review Status

Picklist

The current state of a Carrier regarding carrying loads. Values include: “Incomplete Application,” “Pending,” “Approved,” “Rejected,” and “Updated (FMCSA).” “Incomplete Application” is the default value.

Commodity Catalogue

Lookup(Commodity Catalogue)

A lookup to the Commodity Catalogue record for line-item entry.

Common Authority Pending

Picklist

The field indicates whether a common authority is pending. Values include: “Yes” and “No.” No default value.

Common Authority Revocation

Picklist

The field indicates whether a common authority has been revoked. Values include: “Yes” and “No.” No default value.

Common Authority Status

Picklist

The field indicates the state of the common authority. Values include: “Active,” “Inactive,” and “None.” No default value.

Company Logo

Rich Text Area(31000)

The company logo used in the CustomerShipmentTracking LWC.

Company Risk

Picklist

The state of the overall company credit risk. Values include: “Pending,” “Acceptable,” “Moderate,” and “Unacceptable.” “Pending” is the default value.

Company Type

Picklist

The company legal organization type. Values include: “Corporation,” “C Corporation,” “S Corporation,” “Limited Liability Company,” “Partnership,” “Individual/Sole Proprietor/Single-Member LLC,” and “Other.” No default value.

Connection Status

Picklist

The current status of the Carrier as determined in the Highway integration. Values include: “Verified,” “Pending,” and “Requested.” No default value.

Consolidated Invoicing

Checkbox

If “Checked,” the Master Invoice Number is displayed on invoice documents.

Contract Authority Pending

Picklist

The field indicates whether a contract authority is pending. Values include: “Yes” and “No.” No default value.

Contract Authority Revocation

Picklist

The field indicates whether a contract authority has been revoked. Values include: “Yes” and “No.” No default value.

Contract Authority Status

Picklist

The field indicates the state of the contract authority. Values include: “Active,” “Inactive,” and “None.” No default value.

Credit Limit

Lookup(Credit Limit)

A lookup to the Credit Limit record associated with the shared credit limit record.

Credit Limit Amount

Currency(16, 2)

The maximum monetary amount of credit extended to this customer.

Credit Limit Available

Formula (Currency)

The calculated monetary amount of remaining credit by taking: [Credit Limit + Unapplied Cash/Credit Memos]

- [the three A/R balances].

Credit Limit Calculation Error

Text(255)

An automatically populated error message, should one occur, when the AR Calculation is performed.

Credit Limit Utilized

Formula (Percent)

The percent of the credit limit that is used.

Credit Rating

Picklist

The credit score for the account(s) related to this record. Values include: “A,” “B,” “C,” and “F.” No default value.

Credit Review Comments

Text Area(255)

Comments related to the credit review.

Credit Review Date

Date

The date of the credit review.

Credit Review Status

Picklist

The state of the credit review of a customer. Values include: “Pending,” “Approved,” “Credit Hold,” and “Denied.” “Pending” is the default value.

CSA Business Number

Text(15)

The identifier number issued by the Canada Revenue Agency to the importer of a CSA shipment.

Customer Invoice Day

Picklist

Values include: “--None--,” “Monday,” “Tuesday,” “Wednesday,” “Thursday,” “Friday,” “Saturday,” and “Sunday.”  TMS Accounting only. When the field is blank, invoices are sent daily. No default value.

Customer Invoice Export File

Lookup(File Export Definition)

A lookup to the File Export Definition .csv) record associated with the customer.  TMS Accounting only. Validation Rule: The “Customer Invoice Export File” is required with the “Billing Email Attachment Format” is “PDF with .csv.”

D&B DUNS Number

Text(9)

The D&B DUNS Number business identifier received from MyCarrierPackets.

Default Customer Bill To

Lookup(Account)

A lookup to the Account record associated with the default customer bill to account.

Default Delivery Instructions

Long Text Area(2000)

The default delivery instructions for load stops whose location (account record) refers to this transportation profile record.

Default Delivery Range

Number(4, 0)

The distance a Carrier will travel to deliver a load.

Default Pickup Instructions

Long Text Area(2000)

The default pickup instructions for load stops whose location (account record) refers to this transportation profile record.

Default Pickup Range

Number(4, 0)

The distance a Carrier will travel to pick up a load.

Delivery Appointment Required

Checkbox

If “Checked,” a load stop whose location (account record) refers to this transportation profile record requires an appointment for delivery.

Distance Units

Picklist

Units of distance for pickup and delivery ranges for Truck Postings. Values include: “Miles” and “Kilometers.”  “Miles” is the default value. 

DOT State Authority

Picklist

The state authority for the DOT Number.  No default value.

Driver Info Available

Checkbox

“Checked” indicates that a driver can communicate the status of a load.

Drop and Hook Duration (Minutes)

Number(4, 0)

The amount of time in minutes to drop and hook a Fleet Load.

Drop Duration (Minutes)

Number(4, 0)

The amount of time in minutes to drop a Fleet Load.

EPayment Authorized

Picklist

This field enables/disables the ability to issue EPayments. Values include: “Comdata Comchek” and “EFS Money Code.” No default value.

Exclude Carrier Pricing

Checkbox

“Checked” will exclude Carrier Quote totals from the Sales History and RateIQ tool results.

Federal Tax Id

Text (Encrypted)(11)

The Federal Tax ID or SSN.

Fleet Size

Number(18, 0)

The size of the fleet available to handle loads.

FMCSA Insurance Cancellation Date

Date

The FMCSA Insurance Cancellation date retrieved from SaferWatch.

FMCSA Insurance Cancellation Type

Text(20)

The FMCSA Insurance Cancellation insurance type retrieved from SaferWatch. 

Highway ID

Text(40) (External ID)

The identifier for a Carrier used by the Highway integration.

Hook Duration (Minutes)

Number(4, 0)

The amount of time in minutes to hook a Fleet Load.

Image Resolution

Number(4, 0)

The DPI of the image. 

Insurance Risk

Picklist

The SaferWatch/MyCarrierPackets insurance risk measure. Values include: “Pending,” “Acceptable,” “Moderate,” “Unacceptable,” “Unacceptable Review,” and “Unacceptable Fail.” “Pending” is the default value.

Insurance Risk Points

Number(6, 0)

The MyCarrierPackets insurance risk score point number.

Internal Cargo Insurance Mode

Multi-Select Picklist

The Mode type selection(s) for cargo insurance automation. Values include, "Truckload," "LTL," "Intermodal," etc. Default value is null.

Internal Cargo Insurance Option

Picklist

Automation selection for cargo insurance. Values include: "Opt In" and "Opt Out." Default value is null.

Internal Notes

Long Text Area(2000)

Notes available for internal viewing only about the account/location.

Invoice Terms

Number(4, 0)

The number of days between the Customer Invoice Date and the Customer Invoice Due Date.

Is Drop Location

Checkbox

When “Checked,” the location is a Fleet Asset equipment drop.

Language

Picklist

The language used on generated document. Values include: “English,” “French,” “German,” “Italian,” and “Spanish.” “English” is the default selection.

Last Carrier Review Date

Date/Time

The most recent date and time that a Carrier’s Review Status was checked. Set every time the SaferWatch/RMIS data is pulled and updated on the TP via the batch process or manually by the user.

Last Carrier Review Status

Text(40)

This Read-Only field displays the most recent Carrier Review Status.

Live Load Duration (Minutes)

Number(4, 0)

The amount of time in minutes a Fleet Load is live.

Location Hours Grace Period (After)

Number(3, 0)

The number of hours a Carrier can arrive after the shipping/receiving hours and still be considered On Time.  Note: if an appointment time is scheduled, the Appointment Time Grace Period (After) field is used to calculate On Time.

Location Hours Grace Period (Before)

Number(3, 0)

The number of hours a Carrier can arrive before the shipping/receiving hours and still be considered On Time.  Note: if an appointment time is scheduled, the Appointment Time Grace Period (Before) field is used to calculate On Time.

Location Update Send Frequency

Picklist

How often an EDI 214 X6 location updates to the customer. Values include: “15 minutes,” “30 minutes,” “1 hour,” “2 hours,” “4 hours,” “12 hours,” and “24 hours.” No default value.

LTL Quote Refresh

Number(18, 0)

The Number of minutes before LTL quotes expire in the Customer Portal.

Manually Regenerate Barcode

Checkbox

If “Checked,” barcodes must be manually regenerated for the Carrier.

Mask Load Board Booking Requests

Checkbox                    

If “Checked,” the stop location names are hidden on the load boards (Truckstop only). 

MC/MX/FF Number

Text(20)

The Carrier identifier.

Mexico State Authority

Picklist

The Mexican state authority for the Carrier.

Mexico State Coverage

Picklist (Multi-Select)

The Mexican states served by the Carrier.

Mexico Tax ID

Text (Encrypted)(20)

Mexican federal tax Id.

Mileage API

Picklist

Selection for where to obtain routing data. Values include: “PC Miler” and “Rand McNally.” No default value.

Mileage API Routing

Picklist

Selection for the type of route. Values include: “Practical” and “Shortest.” No default value.

Mileage API Version

Picklist

Customer-specific version of the API mileage data to use. This field is dependent on the Mileage API field.

Monitor Carrier

Checkbox

If “Checked,” the Carrier is monitored daily for changes in FMCSA data via SaferWatch.

Name

Text(80)

The unique record identifier and is usually identical to the associated account record name.

NSC Number

Text(40) (External ID)

The Canadian National Safety Code number.

NSC Safety Certificate Date

Date

The effective date of a Canadian NSC safety certification.

Number of Drivers 

Number(18, 0)

The number of drivers available to handle loads.

Operation Risk

Picklist

The SaferWatch/MyCarrierPackets operation risk measure. Values include: “Pending,” “Acceptable,” “Moderate,” “Unacceptable,” “Unacceptable Review,” and “Unacceptable Fail.” “Pending” is the default value.

Operation Risk Points

Number(6, 0)

The MyCarrierPackets operation risk score point number.

Other Carrier Capabilities

Picklist (Multi-Select)

Capabilities of the Carrier such as, “Bonded (US),” “CARB-TRU Compliant (California),” “C-TPAT Certified (US),” “HazMat Certified (US),” and “TSA Certification.” No default value.

Out of Service

Picklist

Selection for whether a Carrier is in service. Values include: “Yes” and “No.” No default value.

Out of Service Date

Date

The date the Carrier was designated as out of service.

Overall Risk

Picklist

The SaferWatch/MyCarrierPackets overall risk measure. Values include: “Pending,” “Acceptable,” “Moderate,” “Unacceptable,” “Unacceptable Review,” and “Unacceptable Fail.” “Pending” is the default value.

Overall Risk Points

Number(6, 0)

The MyCarrierPackets overall risk score point number.

Payment Processor

Picklist

The settlement choice for processing payments. Values include: “Accounting” and “TriumphPay.” “Accounting” is the default value.

Payment Terms

Picklist

The default payment terms for a customer. Values include: “Prepaid,” “Collect,” and “Third Party.” No default value.

Pickup Appointment Required

Checkbox

“Checked” is the default value for load stops whose location (account record) refers to this transportation profile record.

POD Required

Checkbox

If “Checked,” the POD is required to invoice this customer.

Portal Quote Direct/Interline Filter

Picklist (Multi-Select)

Quotes shown to customers in the Portal are filtered based on the routing of the quote.

Portal Quote HU Count Threshold

Number(18, 0)

The HU count threshold for loads created in the customer Portal.

Portal Quote Weight Threshold

Number(18, 0)

The weight threshold for loads created in the customer Portal.

Provincial Authority

Picklist

The Canadian province that authorized the Carrier. No default value.

Provincial Permit Number

Text(40) (External ID)

The Canadian provincial permit number.

Rating Source

Picklist

When auto-creating Quotes and rating choose from the following sources. Values include: “Customer Rates Only” or “Customer + Global Rates.” No default value.

Rebate Program

Lookup(Rebate Program)

A lookup to the Rebate Program record associated with generating rebates on the customer’s load.

Receiving Hours

Text(11)

The default value for load stops whose location (account record) refers to this transportation profile record. Validation Rule: Field must be 24-hour time (HH:MM) or time period (HH:MM-HH:MM).

Remit To Option

Picklist

Selection to choose between remitting payment of an invoice to the Carrier or to a Factoring company. Values include: “Direct” and “Factor.” No default value.

Remove Special Characters

Checkbox

If “Checked,” remove special characters from the PRO # in the barcode.

Reseller Markup Group

Lookup(Carrier Markup Group)

A lookup to the Carrier Markup Group record associated with determining the reseller markup on the portal.

RMIS Carrier Payment Option

Text(255)

If collected in the RMIS onboarding process, the payment terms selected by the Carrier will appear here (informational only).

RMIS Certified

Picklist

The RMIS certification status of a Carrier. Values Include: “Yes” and “No.” No default value.

RMIS ID

Text(40) (External ID)

The RMIS unique Carrier identifier.

RMIS Non-Certified Reason

Text Area(255)

A description of why the Carrier failed the RMIS certification rules.

Safety Rating

Picklist

The FMCSA safety rating. Values include: “Not Rated,” “Satisfactory,” “Unsatisfactory,” and “Conditional.” No default value.

Safety Rating Date

Date

The date of the FMCSA safety rating.

Safety Risk

Picklist

The SaferWatch/MyCarrierPackets safety risk measure. Values include: “Pending,” “Acceptable,” “Moderate,” “Unacceptable,” “Unacceptable Review,” and “Unacceptable Fail.” “Pending” is the default value.

Safety Risk Points

Number(6, 0)

The MyCarrierPackets safety risk score.

SCAC

Text(4)

The Standard Carrier Alpha Code Identifier.

Shipping Hours

Text(11)

The default value for load stops whose location (account record) refers to this transportation profile record. Validation Rule: Field must be 24-hour time (HH:MM) or time period (HH:MM-HH:MM).

Show Text

Checkbox

If “Checked,” the barcode will show the readable PRO #.

State DOT Number

Text(20)

The state Department of Transportation number.

Tax Exempt

Checkbox

If “Checked,” sales taxes should NOT be calculated for this customer.

Temporary Approval Expiration

Date

Compliance rules that auto-reject the Carrier will not execute until this date.

Tender Documents

Picklist (Multi-Select)

Documents emailed to the Carrier during load tendering. Values include: “Bill of Lading” and “Carrier Rate and Load Confirmation.” No default value.

Text Align

Picklist

The alignment for the text associated with the barcode. Values include: “Left,” “Center,” and “Right.” No default value.

Text Color

Text(6)

The color as represented in RBG Hex code for the text associated with the bar code.

Text Distance

Number(7, 3)

The space between the barcode and the associated text based on the Barcode Units unit of measure. Left of the decimal is measured in pixels and numbers to the right of the decimal are thousandths of an inch.

Text Font

Text(40)

The font for the text associated with the bar code.

Text Position

Picklist

The position of text associated with the bar code. Values include: “Top” and “Bottom.” No default value.

Time Until Auto Unpost

Number(2, 0)

The number of hours until a Posted Load is auto-unposted.

Total Power Units

Number(18, 0)

Data provided by the FMCSA for the number of total power units.

Total US Vehicle Inspections

Number(18, 0)

Data provided by the FMCSA for the number of vehicle inspections.

Tracking Customer Id

Text(20)

MacroPoint customer number for shared load status tracking with that customer.

Tracking Notes

Text Area(255)

Notes sent when tracking a load.

Tracking Provider

Picklist

The default tracking provider in the Load Tracking Admin modal. Values include: "FourKites," "MacroPoint," "Project44," “SMC3 EVA,” and "Trucker Tools."

Tracking Update Email List

Text Area(255)

Comma separated list of email addresses to receive tracking notifications. MacroPoint only.

Unapplied Cash/Credit Memos

Currency(16, 2)

Field that contains any cash or credit memo balances for customer not yet allocated to an invoice.

Upload Complete

Picklist (Multi-Select)

The list of load boards the Carrier has been added to via API. Values include: “Truckstop 2” and “Trucker Tools Load Board.” No default value.

US DOT Number

Text(10)

The US DOT number of the Carrier.

US Port Code

Text(4)

The port code assigned to a US Customs location.

US State Coverage

Picklist (Multi-Select)

The US states served by the Carrier.

Vendor Invoice Processor

Picklist

Selection for which service processes Vendor Invoices. “HubTran” can be selected, or none.

W9 Address

Text Area(255)

Street address returned by RMIS or MCP on the W9 form.

W9 City

Text(40)

City returned by RMIS on the W9 form.

W9 Postal Code

Text(20)

Postal Code returned by RMIS on the W9 form.

W9 State

Picklist

State returned by RMIS on the W9 form. No default value.

W9 Validated

Checkbox

If “Checked,” RMIS has validated the W9 information.

Watchdog Reports

Picklist

SaferWatch-provided Carrier field. Values include: “Yes” and “No.” No default value.

Weight Units

Picklist

Weight units of the Portal Quote Weight Threshold field. Values include: “lbs” and “kg.” No default value.

White Space Border

Text(20)

The white space surrounding the bar code.

Accessorial

Master-Detail(Accessorial)

References the generic accessorial record.

Charge

Currency(16, 2)

The negotiated charge for this accessorial.

Charge Type

Picklist

Type of charge, such as Fixed Cost or Per Mile.

Name

Text(80)

Accessorial name/description.

Stop

Picklist

The stop number to apply a stop charge to.

Stop Count Threshold

Picklist

The number of load stops that triggers application of stop charges.

Transportation Profile

Master-Detail(Transportation Profile)

The parent transportation profile (and accounts).

Contact

Master-Detail(Contact)

The Master-Detail relationship to the parent Contact record the Travel Credential belongs to.

Country

Picklist

The issuing country of the Travel Credential. Values include: “US,” “CA,” and “MX.” “US” is the default value.

Document Number

Text(100)

The ID number of the travel document.

Expiration Date

Date

The date the travel credential expires.

State/Province

Picklist

The state or province issuing the Travel Credential. Many options available. No default value.

Travel Credential Name

Auto Number

The name of the Travel Credential. Example: TC-{0}

Type

Picklist

The type of credential. Many options available. No default value.

Action Taken

Long Text Area(2000)

The action taken to address the Trip Event.

Addressed By

Lookup(User)

The lookup to the user that addressed the Trip Event.

Addressed Datetime

Date/Time

The date and time the Trip Event was addressed.

Event Datetime

Date/Time

The date and time of the Trip Event.

Event Detail

Long Text Area(2000)

The details of the Trip Event.

Event Type

Picklist

The type of Trip Event. Values include: “Approaching,” “Arrival,” “Departure,” “Breakdown,” ETA Alert,” and more. No default value.

Is Addressed

Formula (Checkbox)

An indicator to note if a Trip Event was addressed.

Is Alert

Checkbox

An indicator to note if a Trip Event is an alert.

Name

Auto Number

The name of the Trip Event. Example: Trip Event-{0}.

Trip Plan

Master-Detail(Trip Plan)

The Master-Detail relationship to the parent Trip Plan record the Trip Event belongs to.

Trip Plan Leg

Lookup(Trip Plan Leg)

A lookup to the Trip Plan Leg record associated with the Trip Event.

Trip Plan Segment

Lookup(Trip Plan Segment)

A lookup to the Trip Plan Segment record associated with the Trip Event.

Billable Distance (Kilometers)

Roll-Up Summary (SUM Trip Plan Segment)

The Trip Plan billable distance in kilometers.

Billable Distance (Miles)

Roll-Up Summary (SUM Trip Plan Segment)

The Trip Plan billable distance in miles.

Description

Text Area(255)

A description of the Trip Plan.

Distance (Kilometers)

Roll-Up Summary (SUM Trip Plan Segment)

The Trip Plan distance in kilometers.

Distance (Miles)

Roll-Up Summary (SUM Trip Plan Segment)

The Trip Plan distance in miles.

End Date/Time

Roll-Up Summary (MAX Trip Plan Segment)

The end date and time of the Trip Plan.

Is Template

Checkbox

Indicates if the Trip Plan is part of a template.

Loaded Distance (Kilometers)

Roll-Up Summary (SUM Trip Plan Segment)

The Trip Plan loaded distance in kilometers.

Loaded Distance (Miles)

Roll-Up Summary (SUM Trip Plan Segment)

The Trip Plan loaded distance in miles.

Name

Auto Number

The name of the Trip Plan. Example: Trip Plan-{0}.

Payable Distance (Kilometers)

Roll-Up Summary (SUM Trip Plan Segment)

The Trip Plan payable distance in kilometers.

Payable Distance (Miles)

Roll-Up Summary (SUM Trip Plan Segment)

The Trip Plan payable distance in miles.

Start Date/Time

Roll-Up Summary (MIN Trip Plan Segment)

The start date and time of the Trip Plan.

Status

Picklist

The current status of the Trip Plan. Values include: “Pending,” “Load Changed,” “Configured,” “Dispatched,” “Pending Final,” “Completed,” and ”Cancelled.” “Pending” is the default value.

Type

Picklist

The type of Trip Plan. Values include: “Single Load,” “Multiple Load,” and “Asset Move.” No default value.

Unloaded Distance (Kilometers)

Formula (Number)

The Trip PLan unloaded distance in kilometers.

Unloaded Distance (Miles)

Formula (Number)

The Trip Plan unloaded distance in miles.

Driver Confirmation URL

URL(255)

The website URL for confirming Trip Plan Drivers.

Driver Hashcode

Text(50) (External ID)

The Trip Plan Driver hashcode.

Name

Auto Number

The name of the Trip Plan Driver. Example: Trip Plan Driver-{0}.

Number

Number(2, 0)

The Trip Plan Driver number.

Seat on Start

Checkbox

A temporary driver assignment for the Trip Plan Driver.

Segment Hashcode

Text(50) (External ID)

The Trip Plan Segment hashcode.

Trip Plan Segment

Master-Detail(Trip Plan Segment)

The Master-Detail relationship to the parent Trip Plan Segment record the Trip Plan Driver belongs to.

Appointment Change Count

Number(3, 0)

The number of times a Fleet Appointment has changed.

Appointment Confirmed By

Lookup(User)

A lookup to the user record the Trip Plan Leg appointment was confirmed by.

Appointment Date

Date

The appointment date for the Trip Plan Leg.

Appointment End Time

Time

The appointment end time for the Trip Plan Leg.

Appointment Requested By

Lookup(User)

A lookup to the user record the Trip Plan Leg appointment was requested by.

Appointment Start Time

Time

The appointment start time for the Trip Plan Leg.

Appointment Status

Picklist

The appointment status in the Trip Plan Leg. Values include: “Unmade,” “Requested,” "and “Confirmed.” “Unmade” is the default value.

Arrival Date

Date

The arrival date of the Trip Plan Leg.

Arrival Date/Time

Date/Time

The arrival date and time of the Trip Plan Leg.

Arrival Time

Time

The time of a Trip Plan Leg arrival.

Billable

Checkbox

An indicator of whether a Trip Plan Leg is billable.

Departure Date

Date

The departure date of the Trip Plan Leg.

Departure Date/Time

Date/Time

The departure date and time of the Trip Plan Leg.

Departure Time

Time

The departure time of the Trip Plan Leg.

Distance (Kilometers)

Number(16, 2)

The Trip Plan Leg distance in kilometers.

Distance (Miles)

Number(16, 2)

The Trip Plan Leg distance in miles.

Due Out Date

Date

The date a Trip Plan Leg is scheduled due out.

Due Out Date/Time

Date/Time

The date and time a Trip Plan Leg is scheduled due out.

Due Out Time

Time

The time a Trip Plan Leg is scheduled due out.

End City

Text(40)

The destination city of the Trip Plan Leg.

End Country

Picklist

The destination country of the Trip Plan Leg.

End Date/Time

Date/Time

The end date and time of the Trip Plan Leg.

End Dock

Lookup(Dock)

A lookup to the Dock record associated with the destination dock for the Trip Plan Leg.

End ELD Id

Text(40) (External ID)

The destination ELD ID for the Trip Plan Leg.

End Geolocation

Geolocation

The destination geolocation for the Trip Plan Leg.

End Location

Lookup(Account)

A lookup to the Account record associated with the destination location for the Trip Plan Leg.

End Location Summary

Formula (Text)

The description of the destination of the Trip Plan Leg.

End Postal Code

Text(20)

The destination Postal Code of the Trip Plan Leg.

End State/Province

Picklist

The destination State/Province of the Trip Plan Leg. Controlled by the End Country field.

End Stop

Lookup(Stop)

A lookup to the Stop record associated with the destination of the Trip Plan Leg.

End Street Address

Text(100)

The destination street address of the Trip Plan Leg.

End Timezone

Picklist

The destination time zone of the Trip Plan Leg. No default value.

End Type

Picklist

The destination type of the Trip Plan Leg. Values include: “Load Stop,” “Distribution Center,” “Terminal,” “Location,” “Border Crossing,” “Waypoint Location,” “Waypoint Address,” and “Address.” No default value.

Leg Name

Text(80)

The name of the Trip Plan Leg.

Leg Number

Number(3, 0)

The number of the Trip Plan Leg.

Leg Summary

Formula (Text)

A summary of the Trip Plan Leg.

Loaded

Checkbox

Indicates if the Trip Plan Leg is loaded.

Payable

Checkbox

Indicates if the Trip Plan Leg is payable.

Start City

Text(40)

The origin city of the Trip Plan Leg.

Start Country

Picklist

The origin state of the Trip Plan Leg.

Start Date/Time

Date/Time

The starting date and time of the Trip Plan Leg.

Start Dock

Lookup(Dock)

A lookup to the Dock record associated with the origin dock of the Trip Plan Leg.

Start ELD Id

Text(40) (External ID)

The origin ELD ID of the Trip Plan Leg.

Start Geolocation

Geolocation

The origin geolocation of the Trip Plan Leg.

Start Location

Lookup(Account)

A lookup to the Account record associated with the origin location of the Trip Plan Leg.

Start Location Summary

Formula (Text)

A summary of the origin location of the Trip Plan Leg.

Start Postal Code

Text(20)

The origin postal code of the Trip Plan Leg.

Start State/Province

Picklist

The origin state/province of the Trip Plan Leg. Controlled by the Start Country field.

Start Stop

Lookup(Stop)

A lookup to the Stop record associated with the origin stop of the Trip Plan Leg.

Start Street Address

Text(100)

The origin street address of the Trip Plan Leg.

Start Timezone

Picklist

The origin time zone of the Trip Plan Leg. No default value.

Start Type

Picklist

The origin location type. Values include: “Load Stop,” “Distribution Center,” “Terminal,” “Location,” “Border Crossing,” “Waypoint Location,” “Waypoint Address,” "and “Address.” No default value.

Status

Picklist

The current status of the origin Trip Plan Leg. Values include: “Pending,” “Configured,” “Dispatched,” and “Completed.” “Pending” is the default value.

Trip Plan Segment

Master-Detail(Trip Plan Segment)

The Master-Detail relationship to the parent Trip Plan Segment record the Trip Plan Leg belongs to.

Accessorial

Master-Detail(Accessorial)

The Master-Detail relationship to the parent Accessorial record the Trip Plan Leg Accessorial belongs to.

Comment

Text(255)

Additional notes for a Trip Plan Leg Accessorial.

Name

Text(80)

The name of the Trip Plan Leg Accessorial record.

Payable

Checkbox

If “Checked,” the Trip Plan Leg Accessorial is eligible for driver pay.

Quantity

Number(16, 2)

The count of Trip Plan Leg Accessorial records.

Total

Formula (Currency)

The calculated total to be paid from the Trip Plan Leg Accessorial.

Trip Plan Leg

Master-Detail(Trip Plan Leg)

The Master-Detail relationship to the parent Trip Plan Leg record the Trip Plan Leg Accessorial belongs to.

Unit

Picklist

The unit value of the accessorial to calculate. Many values available. No default value.

Unit Price

Currency(16, 2)

The price per unit for the Trip Plan Leg Accessorial.

Action

Picklist

The action for the Trip Plan Leg Asset. Values include: “Dropoff,” “Hooked,” and “Pickup.” No default value.

Cargo Status

Picklist

The status of the cargo asset. Values include: “Empty,” “Loaded,” “Live Load,” and “Live Unload.” No default value. This field is dependent on the Action field.

Fleet Asset

Lookup(Fleet Asset)

A lookup to the Fleet Asset record the Trip Plan Leg Asset is associated with.

Name

Auto Number

The name of the Trip Plan Leg Asset. Example: Asset-{0}.

Seal Number

Text(15)

The unique identifier for the Fleet Asset on a Trip Plan Leg.

Train Sequence

Number(2, 0)

The sequence of Fleet Assets.

Trip Plan Leg

Master-Detail(Trip Plan Leg)

The Master-Detail relationship to the parent Trip Plan Leg record the Trip Plan Leg Asset belongs to.

Type

Formula (Text)

The type of Trip Plan Leg Asset.

API Trip Id

Text(40) (External ID)

The API Trip ID for the Trip Plan Segment sent to Samsara.

Billable Distance (Kilometers)

Roll-Up Summary (SUM Trip Plan Leg)

The Trip Plan Segment billable distance in kilometers.

Billable Distance (Miles)

Roll-Up Summary (SUM Trip Plan Leg)

The Trip Plan Segment billable distance in miles.

Dispatch Date/Time

Date/Time

The date and time the Trip Plan Segment was dispatched.

Distance (Kilometers)

Roll-Up Summary (SUM Trip Plan Leg)

The Trip Plan Segment distance in kilometers.

Distance (Miles)

Roll-Up Summary (SUM Trip Plan Leg)

The Trip Plan Segment distance in miles.

Driver Confirmation Accepted Date/Time

Date/Time

The date and time the driver confirmed acceptance of the Trip Plan Segment.

Driver Confirmation Declined Date/Time

Date/Time

The date and time the driver declined the Trip Plan Segment.

Driver Confirmation Requested Date/Time

Date/Time

The date and time the driver was requested for the Trip Plan Segment.

Driver Confirmation Status

Picklist

The status of the driver confirmation. Values include: “Pending,” “Requested,” “Accepted,” and “Declined.” “Pending” is the default value.

ELD Trip Id

Text(40) (External ID)

The ELD Trip ID of the Trip Plan Segment sent to Samsara.

End Date/Time

Roll-Up Summary (MAX Trip Plan Leg)

The end date and time of the Trip Plan segment.

First Leg Number

Roll-Up Summary (MIN Trip Plan Leg)

Supports advanced filtering on the Fleet Management Console.

Last Leg Number

Roll-Up Summary (MAX Trip Plan Leg)

Supports advanced filtering on the Fleet Management Console.

Load

Lookup(Load)

A lookup to the Load record the Trip Plan Segment is associated with.

Loaded Distance (Kilometers)

Roll-Up Summary (SUM Trip Plan Leg)

The loaded distance of the Trip Plan Segment in kilometers.

Loaded Distance (Miles)

Roll-Up Summary (SUM Trip Plan Leg)

The loaded distance of the Trip Plan Segment in miles.

Name

Text(80)

The name of the Trip Plan Segment.

Payable Distance (Kilometers)

Roll-Up Summary (SUM Trip Plan Leg)

The payable distance of the Trip Plan Segment in kilometers.

Payable Distance (Miles)

Roll-Up Summary (SUM Trip Plan Leg)

The payable distance of the Trip Plan Segment in miles.

Power Unit

Lookup(Fleet Asset)

A lookup to the Fleet Asset record associated with the Trip Plan Segment.

Segment Number

Number(3, 0)

The segment number of the Trip Plan Segment.

Start Date/Time

Roll-Up Summary (MIN Trip Plan Leg)

The starting date and time of the Trip Plan Segment.

Status

Picklist

The current status of the Trip Plan Segment. Values include: “Pending,” “Configured,” “Dispatched,” “Pending Final,” and “Completed.” The default value is “Pending.”

Trip Plan

Master-Detail(Trip Plan)

The Master-Detail relationship to the parent Trip Plan record the Trip Plan Segment belongs to.

Undispatch Date/Time

Date/Time

The date and time a Trip Plan Segment was undispatched.

Unloaded Distance (Kilometers)

Formula (Number)

The Trip Plan Segment unloaded distance in kilometers.

Unloaded Distance (Miles)

Formula (Number)

The Trip Plan Segment unloaded distance in miles.

Age (Hours)

Formula (Number)

The elapsed time of the Posting in hours.

Age (Minutes)

Formula (Number)

The elapsed time of the Posting in minutes.

AI Confidence Score

Number(3, 2)

The confidence score returned from the OpenAI integration.

AI Generated

Checkbox

If “Checked,” the Truck Posting record was generated via the OpenAI integration.

Carrier Country

Picklist

The country a Carrier is located in. Values include: “US,” “CA,” and “MX.” “US” is the default value.

Carrier Name

Text(60)

The name of the Carrier that operates the truck.

Carrier Service

Lookup(Carrier Service)

A lookup to the Carrier Service record associated with the truck posting.

Carrier State

Picklist

The state a Carrier is located in. Many values are available. No default value. This field is dependent on the Carrier Country field.

Comments

Text Area(255)

Comments related to the posting from the Carrier.

Contact Email

Email

The email address of the Carrier contact.

Contact Extension

Text(10)

The phone extension of the Carrier contact.

Contact Name

Text(40)

The name of the Carrier contact.

Contact Phone

Phone

The phone number of the Carrier contact.

Date Available

Date

The date a truck is available.

Date Entered

Date/Time

The date and time a posting was entered.

Day Available

Picklist

The day of the week a truck is available for repeating postings. Values include: “Sunday,” “Monday,” “Tuesday,” “Wednesday,” “Thursday,” “Friday,” and “Saturday.” No default value.

Delivery Range (Miles)

Number(10, 0)

The distance from the delivery location that a Carrier is looking for loads.

Desired Rate per Mile

Currency(6, 2)

The minimum rate the Carrier is looking for.

Destination

Formula (Text)

The city/state/country of a truck destination.

Destination City

Text(40)

The truck destination city.

Destination Country

Picklist

The truck destination country. Values include: “US,” “CA,” and “MX.” “US” is the default value.

Destination Geolocation

Geolocation

The truck destination latitude and longitude.

Destination State

Picklist

The truck destination state. Many values present. No default value. This field is dependent on the Destination Country field.

DOT Number

Text(10)

The Carrier Department of Transportation Number

Equipment Description

Text(100)

A description of the truck equipment available.

Equipment Options

Text(200)

A description of the truck equipment options.

Equipment Type

Lookup(Equipment Type)

A lookup to the Equipment Type record associated with the Truck Posting.

Full/Partial

Picklist

Selection for either a “Full” and “Partial” load capability. “Full” is the default value.

Initial Quantity

Number(6, 0)

The initial quantity of trucks related to this posting.

MC Number

Text(20)

The Carrier MC Number.

Minimum Miles

Number(10, 0)

The minimum trip length the Carrier will accept.

Origin

Formula (Text)

The city/state/country of the truck origin.

Origin City

Text(40)

The origin city of a truck.

Origin Country

Picklist

The origin country of a truck. Values include: “US,” “CA,” and “MX.” “US” is the default value.

Origin Geolocation

Geolocation

The latitude and longitude of a truck origin.

Origin State

Picklist

The origin state of a truck. Many values present. This field is dependent on the Origin Country field. No default value.

Pickup Range (Miles)

Number(10, 0)

The distance from the pickup location the Carrier is looking for loads.

Posting

Auto Number

The unique record identifier. Example: P-{0}.

Quantity

Number(6, 0)

The current number of trucks related to this posting.

Source

Picklist

The source for a Truck Posting. Values include: “Internal,” “DAT,” “Truckstop,” “TransCore,” “Trucker Tools Load Board,” and “Artimus.” “Internal” Is the default value.

Transaction Id

Text(20) (External ID)

A “Session”-specific identifier for a batch of load board postings.

Duplicate Indicator

Text(255)

An updated XML payload was received for a specific invoice.

EDI Provider

Picklist

Name of the integration providing the EDI 210s. Values include: “Kleinschmidt,” “Cleo,” and “Custom EDI.”

Fingerprint

Text(200)

The stored image of an XML payload used to compare incoming transactions for duplicates.

Invoice Number

Text(200)

The transaction payload invoice number.

Load

Lookup(Load)

A lookup to the Load once a transaction is matched.

Payload

Long Text Area(130000)

The transaction payload stored as a string.

Status

Picklist

The status of a transaction. Values include: “Pending,” “Awaiting Reconciliation,” and “Invoice Created.” “Pending” is the default value.

Transaction

Auto Number

The unique record identifier. Example: Transaction-{0}.

Type

Picklist

The transaction type. Values include: “EDI 210 Invoice.”

Vendor

Lookup(Account)

A lookup to the Vendor Account for the transaction.

Customer Portal Quote Visibility

Picklist

Determines which Carrier quotes are visible to the user on the customer portal Quote Wizard. Values include: “Lowest Quote Only,” “Fastest Transit Only,” “All Quotes - Sort by Fastest Transit,” and “All Quotes - Sort by Lowest Cost.” No default value.

Customer Portal Tender Options

Picklist

Determines which Carrier quotes a user can select on the customer portal Quote Wizard. Values include: “Any Quote,” “Any Quote with Reason,” and “Lowest Quote Only.” No default value.

Display Optional Features

Checkbox

If “Checked,” the user is able to view all object fields on each lightning record page layout.

Fleet Permissions

Picklist (Multi-Select)

The Fleet Permissions enabled for a user. Values include: “Fleet Management - Read Only,” “Fleet Management - Read/Write,” “Trip Planning - Read Only,” “Trip Planning - Read/Write,” “Appointment Scheduling - Read Only,” “Appointment Scheduling - Read/Write,” “Equipment Management - Read Only,” and “Equipment Management - Read/Write.” No default value.

Load Locking Administrator

Checkbox

If “Checked,” the user is a load locking administrator.

Load Locking Max Count

Number(3, 0)

The number of load locks that a user can hold simultaneously.

MCP Intellivite Link

URL(255)

A personal URL at MyCarrierPackets to onboard Carriers.

Rerate/Rebill Permissions

Picklist (Multi-Select)

Enables a user to interact with the rerate/rebill buttons on the Customer Quote Builder. Values include: “Rerate,” “Update Invoice,” and “Lock.” No default value.

Review Before Tender    

Checkbox

If “Checked,” a Customer Portals user’s loads require internal review. Portal users see “Submit,” button instead of “Tender.”

Selection Reason Required Modes

Picklist

Modes when selected require a Carrier Quote selection reason for all non-lowest cost quotes. Values include: “Truckload,” “LTL,” “Intermodal,” “Drayage,” “Ocean FCL,” “Ocean LCL,” “Air Freight,” “Flatbed,” “Bulk,” and “Parcel.” No default value.

Show Itemized Charges In Portal

Checkbox

If “Checked,” the Customer Portal user sees itemized quotes.

Comments

Text Area(255)

Comments regarding the vehicle involved.

Fleet Asset

Lookup(Fleet Asset)

A lookup to the Fleet Asset record associated with this Vehicle Involved.

Incident

Master-Detail(Incident)

The Master-Detail relationship to the parent Incident record the Vehicle Involved belongs to.

Vehicle Involved ID

Auto Number

The unique record identifier. Example: Vehicle Involved-{0}.

Accessorial Charges

Currency(16, 2)

The monetary Total Accessorial Charges for this Vendor Invoice.

Accounting Processed Date

Date/Time

The date and time the invoice was processed; for example, when it was exported to QuickBooks.

Accounting Status

Picklist

Flag for the Pub/Sub Accounting integration. Values include: "Ready for Accounting," "Sent to Accounting," "Publish Error."

Adjustments

Currency(16, 2)

The additional monetary charges for a re-weigh, re-classification, etc.

Balance Due

Formula (Currency)

The monetary result of the Carrier Total field minus the Paid Amount field and the Payment Discount field.

Carrier

Formula (Text)

The name of the Carrier covering the load. This field is Read-Only.

Carrier Quote

Lookup(Carrier Quote)

A lookup to the Carrier Quote record associated with this auto-generated Vendor Invoice.

Carrier Service ID

Formula (Text)

The ID of the Carrier Service record covering the load.

Comments

Text Area(255)

Comments usually provided by the carrier regarding the Vendor Invoice.

Destination City

Text(40)

The destination stop city for the load invoiced.

Destination Country

Picklist

The destination stop country for the load invoiced. The Destination State field is dependent on this field. "US" is the default value.

Destination Name

Text(80)

The destination stop name for the load invoiced.

Destination Postal Code

Text(20)

The destination stop postal code for the load invoiced.

Destination State

Picklist

The destination stop state for the load invoiced. This field is dependent upon the Destination Country field selection. No default value.

Destination Street

Text Area(255)

The destination stop street for the load invoiced.

Discount

Currency(16, 2)

The monetary difference between the Freight Charges and Net Freight Charges fields, if provided, representing the customer’s discount.

EPayment

Lookup(EPayment)

A lookup to the EPayment record that generated the Vendor Invoice.

Freight Charges

Currency(16, 2)

The gross monetary Freight Charges rate, before any customer discount.

Freight Surcharge

Currency(16, 2)

The total freight charges captured from the Carrier quote.

Fuel Surcharge

Currency(16, 2)

The monetary Fuel Surcharge line-item for this Vendor Invoice.

Invoice Date

Date

The date the Invoice was generated by the Carrier or the User.

Invoice Due Date

Date

The date the payment for a Vendor Invoice is due.

Invoice Number

Text(80)

The Invoice Number for a load (as possibly provided by Carrier).

Invoice Status

Picklist

The current state of the Vendor Invoice. Values include: “Pending,” “Audit Hold,” “Approved,” “Paid,” and “Short Paid.” “Pending” is the default value.

Invoice Total

Formula (Currency)

The total monetary Vendor Invoice amount.  This field is calculated by Adding the Net Freight Charges plus the Fuel Surcharge plus the Accessorial Charges plus the Adjustments fields. Note that the API name of this field is “CarrierTotal__c.”

Load

Master-Detail(Load)

The Master-Detail relationship to the parent Load record the Vendor Invoice belongs to.

Master Invoice Number

Text(50) (External ID)

When a set of Invoices are collected into a single email or printed as one PDF document, all contained Vendor Invoices will have the same Master Invoice Number.

Net Freight Charges

Formula (Currency)

The monetary charges calculated by taking the Freight Surcharge amount field and subtracting the Discount field amount.

Order Number

Formula (Text)

The customer Order Number of the related load.

Origin City

Text(40)

The origin stop city for the load invoiced.

Origin Country

Picklist

The origin stop country for the load invoiced. The Origin State field is dependent on this field. "US" is the default value. 

Origin Name

Text(80)

The origin stop name for the load invoiced.

Origin Postal Code

Text(20)

The origin postal code country for the load invoiced.

Origin State

Picklist

The origin stop state for the load invoiced. This field is dependent upon the Origin Country field selection. No default value. 

Origin Street

Text Area(255)

The origin stop street for the load invoiced.

Paid Amount

Currency(16, 2)

The total monetary amount paid to date toward this Vendor Invoice.

Payee Reference

Text(100)

This is typically the Carrier’s Invoice Number, if available.

Payment Discount

Currency(16, 2)

Any monetary discount that can be applied to this Vendor Invoice, such as advance payment.

Payment Discount Taken

Currency(16, 2)

Any monetary discount applied to the Vendor Invoice, rolled up from the child payment records.

POD Received

Formula (Checkbox)

If “Checked,” the load-level field of the same name is true.

Remit To

Lookup(Account)

A lookup to the Account record associated with the name of the Carrier or Factoring Company.

Unmatched EDI Transaction

Text(30)

A reference to the Id of the Unmatched Transaction that created the invoice.

Vendor

Lookup(Account)

A lookup to the Account record associated with the Carrier or Vendor who is the payee for this Vendor Invoice.

Accessorial

Lookup(Accessorial)

A lookup to the Accessorial record associated with the Vendor Invoice Accessorial.

Carrier Accessorial

Lookup(Carrier Accessorial)

A lookup to the Carrier Accessorial record associated with the Vendor Invoice Accessorial.

Carrier Invoice

Master-Detail(Vendor Invoice)

The Master-Detail relationship to the parent Vendor Invoice record the Vendor Invoice Accessorial belongs to.

Charge

Currency(16, 2)

The monetary charge from the Carrier for this accessorial.

Code

Text(20)

The Carrier’s standard accessorial invoicing code.

Name

Text(80)

The Carrier-specific name/description of an accessorial.

Notes

Text(200)

Optional details related to the accessorial charge.

Quantity

Number(16, 2)

The number of Units for the accessorial.

Stop

Lookup(Stop)

A lookup to the Stop record associated with the Vendor Invoice Accessorial.

Unit

Picklist

Type of accessorial cost category. There are many options including, “Fixed Cost,” “Percent of Amount,” “Per Cubic Foot,” etc. No default value.

Unit Price

Number(16, 2)

The per-unit cost of the accessorial.

Adjustment Amount

Currency(16, 2)

The monetary amount of the Vendor Invoice Adjustment.

Category

Picklist

The type or category of Vendor Adjustment. Values include: “Re-Class,” “Re-Weight,” and “Other.” No default value.

Description

Text(80)

The description of the Vendor Invoice Adjustment.

Vendor Invoice

Master-Detail(Vendor Invoice)

The Master-Detail relationship to the parent Vendor Invoice record the Vendor Invoice Adjustment belongs to.

Freight Charge

Currency(16, 2)

The freight charge amount associated with this freight charge item.

Freight Charge Item Number

Auto Number

The unique record identifier. Example: Freight Charge Item-{0}. 

Item Description

Text(255)

The item description this freight charge item refers to.

NMFC Class (Rated As)

Picklist

The NMFC Class associated with this freight charge item. Many possible values with no default value.

Quantity

Number(16, 2)

The number of freight charge items.

Rate

Currency(10, 2)

The rate associated with this freight charge item.

Unit

Picklist

The unit of measure for this freight charge item. No default value.

Vendor Invoice

Master-Detail(Vendor Invoice)

The Master-Detail relationship to the parent Vendor Invoice record the Vendor Invoice Freight Charge Item belongs to.

Weight

Number(18, 0)

The weight of the the freight charge item.

Weight Units

Picklist

The unit of measure for the weight of the freight charge item. Values include "lbs" and "kg." No default value.

Accounting Processed Date

Date/Time

The date and time the payment was processed; for example, when it was exported to QuickBooks.

Check/Reference Number

Text(50) (External ID)

The check or transaction number of the Vendor Payment.

Comments

Text Area(255)

Any comments related to the Vendor Payment.

Description

Text(80)

The name/description of the Vendor Payment.

Discount

Currency(16, 2)

The monetary amount applied toward the total due amount.

EPayment

Lookup(EPayment)

A lookup to the EPayment record associated with and generated the Vendor Payment.

Load

Lookup(Load)

A lookup to the Load record associated with the Vendor Payment.

Payment Amount

Currency(16, 2)

The monetary amount of the payment toward the total due.

Payment Fee

Currency(16, 2)

Any payment fee assessed against the Carrier; for example, an early payment fee.

Payment Type

Picklist

The type of payment. Values include: “Company Check,” “Comdata Comchek,” “EFS MoneyCode,” “ACH,” “Wire,” and “Other.” No default value.

Processor Fee

Currency(16, 2)

Any fee assessed by the payment processor; for example, a Comchek processor fee.

Recipient

Lookup(Contact)

A lookup to the Contact record associated with receiving payment for the Vendor Invoice.

Status

Picklist

The current state of the Vendor Invoice payment. Values include: “Pending,” “Issued,” “Blocked,” “Cancelled,” and “Cashed.” “Pending” is the default value.

Transaction Id

Text(50)

The Comchek transaction identifier.

Vendor

Master-Detail(Account)

The Master-Detail relationship to the parent Account record the Vendor Payment belongs to. Note that the API name is “Carrier__c.”

Vendor Invoice

Lookup(Vendor Invoice)

A lookup to the Vendor Invoice record the Vendor Payment is applied to. Note that the API name is “CarrierInvoice__c.”

Category

Picklist

Violation category description. Values include: “Driver,” “Vehicle,” “Hazmat,” and “Other.” No default value.

City

Text(50)

The city where the Violation occurred.

Code

Text(80)

The Legal code related to the Violation.

Country

Picklist

The country where the Violation occurred. Values include: “US,” “CA,” and “MX.” “US” is the default value.

Description

Picklist

A description of the violation. There are many selections available including: “Speeding,” “Failing to use seat belt,” and “No ELD instruction sheet.” No default value.

Fine Amount  

Currency(16, 2)

The monetary amount of the violation fine.

Incident

Lookup(Incident)

A lookup to the Incident record associated with the Violation.

Inspection Report       

Lookup(Inspection Report)

A lookup to the Inspection Report record associated with the Violation.

Officer Agency   

Lookup(Account)

A lookup to the Account record associated with the Officer Agency.

Officer First Name               

Text(50)

The first name of the Officer involved with the Violation.

Officer ID

Text(50)

The ID or Badge Number of the Officer involved with the Violation.

Officer Last Name

Text(50)

The last name of the Officer involved with the Violation.

Other Description

Text Area(255)

Additional comments and details regarding the Violation.

Recipient

Lookup(Driver)

A lookup to the Driver record associated with the Violation.

State/Province   

Picklist

The State/Province where the violation occurred. States and Provinces from the US, Mexico, and Canada are available. This field is dependent upon the Country field selection. No default value.

Tractor/Truck     

Lookup(Fleet Asset)

A lookup to the Fleet Asset record associated with the Violation.

Trailer

Lookup(Fleet Asset)

A lookup to the Fleet Asset record associated with the Violation.

Type

Picklist

The authority type for the Violation. Values include: “Federal,” “State,” and “Local.” No default value.

Violation Date/Time  

Date/Time

The date and time of the violation.

Violation ID

Auto Number

The unique record identifier. Example: Violation-{0}.

Arrival Date

Date

The estimated or actual arrival date at the Port of Discharge.

Carrier Service

Master-Detail(Carrier Service)

The Master-Detail relationship to the parent Carrier Service record the Voyage belongs to.

Departure Date

Date

The estimated or actual departure date at the Port of Loading.

Destination Name

Text(100)

The destination city/state/country name.

Destination Type

Picklist

Description of the final stop for a load. Values include: “Port of Discharge” and “Place of Delivery.” “Port of Discharge” is the default value.

Destination UN Location Code

Text(6)

The UN Location code for the destination, such as “BEANR” for Antwerp.

Door to Door

Formula (Checkbox)

If “Checked,” the FCL load is door to door.

Door to Port

Formula (Checkbox)

If “Checked,” the FCL load is door to port.

Lloyds Code

Text(50)

The Lloyd’s code of a vessel.

Load

Lookup(Load)

A lookup to the load record associated with the ocean voyage.

Name

Auto Number

The unique record identifier. Example: Voyage-{0}.

Origin Name

Text(100)

The origin city/state/country name.

Origin Type

Picklist

A description of the acceptance of a load. Values include: “Port of Load” and “Place of Receipt.” “Port of Load” is the default value.

Origin UN Location Code

Text(6)

The UN Location code for the origin, such as “CAMTR” for Montreal.

Port to Door

Formula (Checkbox)

If “Checked,” the FCL load is port to door.

Port to Port

Formula (Checkbox)

If “Checked,” the FCL load is port to port.

Service Name

Text(100)

Service Name (such as Pacific Loop 1) for a vessel itinerary.

Transit Time (Days)

Number(3, 0)

The transit time for a voyage measured in days.

Vessel

Text(100)

The name of the vessel.

Voyage Number

Text(20)

The number identification for a voyage.

Category

Picklist (Multi-Select)

The type of zone. Values include: “Rate Entry” and/or “Fleet.” No default value.

Is Fleet Category

Formula (Checkbox)

Indicates a zone is a Fleet type.

Is Rate Entry Category

Formula (Checkbox)

Indicates a zone is a Rate Entry type.

Type

Picklist

A description for the type of zone for a collection of locations. Values include: “Country,” “State,” “City/State,” “Zip3,” “Zip5,” “Postal Code,” “Location,” and “Mixed.” No default value.

Zone Name

Text(80)

The name for a collection of locations. For example, “Western Region.”

Category

Picklist

A method to select zone entries. Values include: “Included” and “Excluded.” “Included” is the default value.

City

Text(40)

The city name for a zone entry.