This glossary defines the custom data fields available for your shift ticket exports and organizes them by the specific FleetWatcher page where the information is managed or populated. Use this guide to understand exactly what data each field captures, identify where to locate or edit those fields within the platform interface, and review any relevant visibility or configuration requirements.
(H) = Header Columns
(S) = Summary Columns
(D) = Detail Columns
(B) = Blank Columns
Add Edit Companies:
Broker # (H): An external ID or reference number assigned to a specific broker.
Broker Name (H): The company name of the subcontractor.
Add Edit Custom Equipment Type:
Night Pay Rate Per Ton (H): Tonnage pay rate applied specifically during night shifts.
Day Pay Rate Per Ton (H): Standard tonnage pay rate for day shifts.
Day Pay Rate Per Hour (H): Standard hourly pay rate for day shifts.
Day Bill Rate Per Ton (H): Standard tonnage billing rate for day shifts.
Day Pay Rate Per Load (H): Standard per-load pay rate for day shifts.
Day Bill Rate Per Load (H): Standard per-load billing rate for day shifts.
Day Bill Rate Per Hour (H): Standard hourly billing rate for day shifts.
Night Bill Rate Per Hour (H): Hourly billing rate for night shifts.
Night Bill Rate Per Load (H): Per-load billing rate for night shifts.
Night Bill Rate Per Ton (H): Tonnage billing rate for night shifts.
Night Pay Rate Per Hour (H): Hourly pay rate for night shifts.
Night Pay Rate Per Load (H): Per-load pay rate for night shifts.
Bill Rate Type (D): The unit used for billing (Hour, Ton, Load).
Pay Rate Type (D): The unit used for paying the driver (Hour, Ton, Load).
Rate Per Hour (D): The specific hourly rate applied to this row.
Rate Per Ton (D): The specific tonnage rate applied to this row.
TruckType/Axles (H): Configuration data pulled from the Fleet asset profile.
Pay Class (H): The labor category (e.g., Company Driver vs. Hired Hauler)
Alphanumeric code stored on the Custom Equipment Type that tells the accounting/ERP system which asset class to bill, and which is exported on VST shift ticket exports (CSV/PDF, summary and detail) when the “Pay Class” column is enabled.
Add Edit Drivers:
Driver Name (H): Name of the driver assigned to the shift in the mobile app.
Driver Phone (H): The phone number associated with the driver’s user profile.
Employee ID (D): The unique employee number from the driver’s user profile.
Add Edit Equipment:
Account Asset Name (H): The internal organizational name for the equipment.
Broker Truck (H): The ID or Number used by the subcontractor for their own equipment.
Truck (H): Maps to Equip Number on the report; the primary asset ID.
Add Edit Project
Job Number (D): The project cost code for this specific row.
Project Number
Job (D): The project name for this specific row; maps to Project on report.
Project Name
Job Number (H): The primary project code assigned to the shift.
This is the project number - Pulls directly from the "Add/Edit Projects" screen.
DOT Project Name (H): The DOT Project Name value entered on the project.
Pulls directly from the "DOT Project Name" field on the "Add/Edit Projects" screen.
Location Name (H): The location name associated with the project.
Pulls directly from the "Add/Edit Projects" screen.
Add Edit Shifts:
Shift (H): The shift category designation (Day vs. Night).
Shift Name (H): The custom name given to the shift (e.g., "Milling Crew A").
Material (D): The name of the product hauled (e.g., "12.5 Cw").
Manual Entry under Material.
Assign Trailers to Tractor:
Trailer(s) (H): Identification of specific trailers attached to the truck.
Displays the Trailer(s) assigned to a tractor. If a trailer is assigned, the "Truck" column will only show the Tractor's equipment number
Custom Equipment Types / Shift Level Override rates:
Total Billable Charge (H): Final dollar sum intended for customer billing.
Bill rate X tonnage/hours - These are the same calculation (Revenue = Bill Rate). "Billable Charge" was added to reduce confusion.
Total Revenue (H): Total billing value generated (often matches Total Charge).
Bill rate X tonnage/hours - These are the same calculation (Revenue = Bill Rate). "Billable Charge" was added to reduce confusion.
Driver App:
Driver Approval (H): Status indicator showing if the driver has signed off in the app.
Displays [Driver Name], [Status – Pending/Accepted/Rejected], and [Date-Time] of approval or rejection from the mobile app.
Edit Information:
UDF1 (H) – UDF16 (H): User Defined Fields. In your view, Create personalized UDF names in Edit Information.
Edit, Approve and Export page:
Approved By (H): The email address of the user who clicked "Approve" for this ticket.
Driver Start Time (H): The raw timestamp when the driver tapped "Start Shift" in the app.
Only visible if "Driver Time" is enabled in MMS control.
Driver Stop Time (H): The raw timestamp when the driver tapped "End Shift" in the app.
Only visible if "Driver Time" is enabled in MMS control.
Driver Total Hours (H): Sum of hours recorded by the driver's manual taps in the mobile app.
Only visible if "Driver Time" is enabled in MMS control.
Manual Ticket Number (H): A physical ticket number entered into the general Header section.
Ticket Export Key (H): Internal system marker tracking the export status of the record.
The VST Ticket Number, Daily Ticket Number, and Row Index get fed to a function that produces a unique number for the row.
Edit, Approve And Export page when editing a ticket:
Additional Time (H): Total hours added manually as "Extra Time" or "Travel Time."
Additional Time Job (H): The specific project assigned to manual "Additional Time" hours.
Additional Time Phase (H): The Phase/Cost Code assigned specifically to manual extra time.
Adjusted Start Time (H): The final shift start time after manager review/edits.
Adjusted Stop Time (H): The final shift end time after manager review/edits.
Additional Pay (H): Total sum of manual dollar "Additional Charges" added to the ticket.
Total Hours (H): Calculated shift duration: Adj Stop Time minus Adj Start Time.
Total Charge (H): Final total shift dollar value (Haul Charges + Additional Charges).
Driver Total Charge (H): Total pay calculated specifically for the driver/broker.
Drive time enabled MMS Controls
Date (H): The calendar date the shift occurred.
End Date (H): The date the shift concluded (different from Start Date for overnight work).
Start Date (H): The date the shift began.
Adjustment (D): The numerical amount of time manually added/removed from a specific row.
Adjustment Code (D): The label used to categorize a time edit (e.g., "Down Time").
Adjustment Comment (D): Text notes explaining the reason for a manual time adjustment.
Customer Name (D): Name of the customer assigned to a specific load.
Dest (D): Name of the destination geozone.
Dest Arrival (D): GPS timestamp when the truck entered the destination zone.
Dest Departure (D): GPS timestamp when the truck exited the destination zone.
Hours Driven per Phase (D): Aggregated hours calculated for a specific phase code on that line.
Subtotaled by Phase Code
Source (D): Name of the source geozone.
Source Arrival (D): GPS timestamp when the truck entered the source zone.
Source Departure (D): GPS timestamp when the truck exited the source zone.
Travel Time to Dest (D): Time duration between Source Departure and Destination Arrival.
Travel Time to Source (D): Time duration between previous Dest Departure and current Source Arrival.
Rate Per Load (D): The specific per-load dollar rate applied to this individual row.
Time in Source (D): Total "Wait Time" spent inside the source zone boundaries.
Time in Dest (D): Total "Wait Time" spent inside the destination zone boundaries.
Rate (D): The general rate value applied to this detail row.
Phase (D): The specific Phase/Cost Code selected for this individual load.
Cycle Time (D): The total haul duration from start to finish.
Adjusted Cycle Time (D): Cycle time recalculated after manager edits.
Row Charge (D): Calculated dollar value for that single row.
How much charge was allocated to that row
Charge (D): Total calculated dollar value for the specific line.
Sub Total Billable Charge (S): Sum of billable charges grouped by Job or Phase.
Sub Total Tons (S): Sum of tonnage grouped by Job or Phase.
Sub Total Time in Source (S): Sum of time spent in source zones for a specific group.
Sub Total Time in Dest (S): Sum of time spent in destination zones for a specific group.
Sub Total Charge (S): General sum of all charges for a specific group.
Sub Total Driver Charge (S): Sum of driver pay specifically for a group.
Sub Total Driver Hours (S): Sum of driver-recorded hours for a group.
Sub Total Truck Hours (S): Sum of equipment/truck hours for a group.
Implemented for a customer:
RecKey (H): Unique record key used for syncing with external databases.
The sequence number of the VST in the batch. First ticket = 1, 2nd ticket = 2, etc - Added for customer
Equipment Object (D): The technical database ID for the equipment used in that row.
Implemented for a customer. It is based on the Job Number. If it is between 7 & 8 characters, the value is 1440. If between 5 & 6 characters, it is 5512. Otherwise, empty string.
Compound Account Number - Type 1 (D): Un-definable. Used for specific ERP third-party integrations (e.g., Vista).
Rule based on Job Number and Phase Code. If Job Number is 7-8 characters, return "{Job Number}.1441.{Phase Code}". If Job Number is 5-6 characters, return "{Job Number}.5111.{Phase Code}"
Shift KPI:
Estimated Tons (H): The projected tonnage goal set during the Dispatch/Order phase.
Dispatch:
Scheduled Dispatch Time (H): The original time the driver was scheduled to start the shift.
From the Dispatch page. Arrival time of truck only applicable if using dispatch feature
Only for APEX DS Order Integrations:
Order ID (D): The ID number of the Dispatch/MMS Order.
Scale Ticket Integration:
Scale Asset Name (H): The name of the scale or plant facility where the truck was loaded.
Total Loads (H): The total count of haul cycles/rows on the ticket.
Total Tons (H): The sum of all tonnage recorded across every load row.
Free Form 1 (D): A customizable text field for individual load rows.
Plant ID (D): The technical database ID for the source facility.
Scale Ticket Date (D): The date printed on the physical plant/scale ticket.
Scale Ticket Number (D): The number from the scale software; mapped to Ticket Num on report.
Tons (D): The weight quantity for that specific load row.
Tons Hauled per Phase (D): Aggregated tonnage calculated for a specific phase code on that line.
Material ID (D): The internal system code for the product being hauled.
Sourced via Scale Ticket integration. Material ID is pulled from the scale ticket for the cycle.
Load End (D): The timestamp when the loading process was completed.
Load End is the timestamp of the next cycle's Load Time
Load Time (D): The timestamp when the loading process began.
Load Time is the timestamp on the scale ticket for a cycle.
Shift Notes from LCA Graph:
Notes (H): General text comments or shift notes.
Zone Analysis Rules:
Dest Event (D): Log of the trigger type (Geozone, Beacon, or Manual).
Source Event (D): Log of the trigger type for the source zone.
The system leaves this field empty by default:
Dest Description (D): Pulls text from the "Description" field in the destination zone settings.
Source Description (D): Pulls text from the "Description" field in the source zone settings.
N/A. Generates automatically:
Invoice Number (H): Unique ID assigned after a ticket is approved/finalized for billing.
Shift Ticket Number (H): The primary 10-digit system-generated ticket ID.
Row (D): The sequence number/index of the load on the ticket.
Details show the numbered rows.
Daily Ticket Number (H): Sequence number (1, 2, 3) for trucks running multiple tickets in one day.
Shift Ticket ID (H): Internal 10-digit database ID number.
N/A:
Customer ID (D): The technical database ID for the customer.
Blank Column (B): Inserts an empty column into the export to separate data or match an external file format.
