Data columns for different report types
When creating a report, you first choose the report type, and then add the data columns.
The available data depends on the selected report type:
1. You choose a report type
2. The system automatically loads the available data categories and fields
3. In the Columns section, you add the required data
4. When the report is generated, only the selected columns are displayed
Example: report type RFID tags
If you select the RFID tags report type, RFID-related data becomes available.
This report helps you analyze:
-
which RFID tags were detected
-
when the event happened
-
where it happened
-
and which object or device the record belongs to
When creating a report, you specify the main settings:
-
Name — report name
-
Sorting — the field used to sort the data
-
Desc — descending sort order
-
Columns — the data to display
-
Configuration — additional parameters and filters
After that, you can start adding columns:
1. Click the Add button in the Columns section 
2. In the Data field, select the required parameter from the list
The available fields depend on the selected report type.
Example of available RFID data
In addition to common data such as vehicle, device, ID, group, and so on, specialized fields will also be available:
-
RFID Time — time when the tag was read
-
RFID Name — tag name, for example an employee name or an object name
-
RFID Location — reading location
-
RFID UID — unique tag ID
-
RFID Group — tag group
Add the required columns to build the report structure.
List of available columns
Below is a structured list of all fields that can be selected in the Data field when creating a column.
Main parameters
|
Column name
|
Description
|
|
Object ID
|
Unique object identifier
|
|
Last speed
|
Last recorded speed of the object
|
|
Group
|
Object group
|
|
Company name
|
Name of the company that owns the object
|
|
Make
|
Vehicle make
|
|
Model
|
Vehicle model
|
|
Period duration
|
Length of the selected report period
|
|
Time zone
|
Object time zone
|
|
Created at
|
Object creation time in the system
|
|
Driver’s license expiry date
|
License expiration date
|
|
Max speed
|
Maximum allowed speed of the object
|
|
Engine number
|
Vehicle engine number
|
|
VIN
|
Vehicle identification number
|
|
Fuel type
|
Fuel type used by the object
|
|
Year of manufacture
|
Vehicle production year
|
|
Vehicle type
|
Type of vehicle
|
|
Device ID
|
Monitoring device identifier
|
|
Trailer
|
Trailer information, if connected
|
|
Mileage cost
|
Cost per kilometer
|
|
Empty row
|
Blank row for report formatting
|
|
Last event
|
Last event recorded for the object
|
|
Object tags
|
Tags assigned to the object
|
|
Connection lost
|
Information about connection loss for the object
|
|
Connection loss duration
|
Total duration of connection loss during the selected period
|
|
Formula
|
Formula used to calculate object data
|
|
Geofence
|
Geofence where the object is located
|
|
Last movement time
|
Time of the object’s last movement
|
|
Speed control
|
Speed control settings for the object
|
|
Current value
|
Current value of the parameter
|
|
Last location
|
Last known location of the object
|
|
Last update time
|
Time when the object data was last updated in the system
|
|
Start date
|
Report period start date
|
|
End date
|
Report period end date
|
Trips
|
Column name
|
Description
|
|
Location of first trip start
|
Location where the object’s first trip in the selected report period started
|
|
Total duration of overtime trips
|
Total duration of all overtime trips during the period
|
|
Number of overtime trips
|
Total number of overtime trips during the period
|
|
Total idle events
|
Number of idle periods recorded during the period
|
|
Parking time during trips
|
Total time spent parked during trips
|
|
Trip count
|
Total number of trips during the period
|
|
Parking count
|
Number of parking events during the period
|
|
Maximum parking duration
|
Duration of the longest parking event during the period
|
|
Location of maximum parking
|
Location where the longest parking event was recorded
|
|
First trip start time
|
Start time of the first trip in the selected period
|
|
First trip end time
|
End time of the first trip in the selected period
|
|
First trip duration
|
Duration of the first trip
|
|
First trip mileage
|
Distance covered in the first trip
|
|
First trip end location
|
Location where the first trip ended
|
|
Last trip start time
|
Start time of the last trip in the selected period
|
|
Last trip end time
|
End time of the last trip in the selected period
|
|
Last trip duration
|
Duration of the last trip
|
|
Last trip mileage
|
Distance covered in the last trip
|
|
Last trip start location
|
Location where the last trip started
|
|
Active days
|
Number of days when the object moved
|
|
Time from start to end of all trips
|
Interval from the start of the first trip to the end of the last trip in the selected period
|
|
Trips with tags count
|
Number of trips with tags assigned
|
|
CAN mileage at start
|
Odometer/mileage value from CAN at the beginning of the period
|
|
CAN mileage at end
|
Odometer/mileage value from CAN at the end of the period
|
|
CAN mileage
|
Mileage for the period calculated from CAN data
|
|
GPS mileage at start
|
GPS mileage at the beginning of the period
|
|
GPS mileage at end
|
ЗGPS mileage at the end of the period
|
|
Mileage GPS
|
Mileage for the period calculated from GPS data
|
|
Mileage
|
Total mileage for the period
|
|
Engine hours
|
Number of engine hours for the period
|
|
Odometer at start
|
Odometer value at the start of the period
|
|
Odometer at end
|
Odometer value at the end of the period
|
|
Duration
|
Total trip duration for the period
|
|
Driving time during trips
|
Total time the object was moving during trips
|
|
Idle time
|
Total idle time for the period
|
Fuel
|
Column name
|
Description
|
|
Idle fuel consumption
|
Amount of fuel consumed while the engine was running and the object was not moving
|
|
Fuel consumption by CAN
|
Fuel consumption calculated from the vehicle CAN bus data
|
|
Fuel price
|
Fuel price used to calculate consumption or refueling cost
|
|
Fuel consumption by norm
|
Fuel consumption calculated using the configured norm
|
|
Fuel consumption on norm CAN
|
Normative fuel consumption calculated using CAN data
|
|
Fuel at start
|
Amount of fuel at the beginning of the selected period
|
|
Fuel at end
|
Amount of fuel at the end of the selected period
|
|
Refuel volume
|
Total volume of all refuelings during the period
|
|
Refuel count
|
Number of refueling events during the period
|
|
Drain volume
|
Total amount of fuel drained during the period
|
|
Drain count
|
Number of fuel drain events during the period
|
|
Fuel consumption by sensor
|
Fuel consumption calculated from the fuel level sensor
|
|
Fuel cards
|
Fuel card data
|
Filling and draining events
|
Column name
|
Description
|
|
Filling type
|
Type of refueling
|
|
Filling liters
|
Amount of fuel added in one refueling event
|
|
Filling location
|
Address where refueling occurred
|
|
Filling start fuel level
|
Amount of fuel in the tank at the start of refueling
|
|
Filling start time
|
Date and time when the refueling event started
|
|
Filling end time
|
Date and time when the refueling event ended
|
|
Fuel price
|
Cost of fuel per unit
|
|
Fuel at start
|
Fuel amount at the beginning of the selected report period
|
|
Fuel at end
|
Fuel amount at the end of the selected report period
|
|
Sensor
|
Fuel sensor
|
|
Start location
|
Location where the fuel event started
|
Equipment
|
Column name
|
Description
|
|
Engine hours at start
|
Engine hours at the beginning of the selected period
|
|
Engine hours at end
|
Engine hours at the end of the selected period
|
|
Equipment operation time
|
Total equipment operating time for the period
|
|
Number of equipment sensor actions
|
How many times the equipment sensor triggered or switched during the period
|
|
Engine hours
|
Total engine hours for the period
|
|
Equipment sensor last switch-off time
|
Date and time when the equipment sensor was last switched off
|
|
Number of event sensor actions
|
Number of event sensor triggers during the period
|
|
Ignition on time
|
Total time the ignition was on during the selected period
|
|
Equipment sensor first activation time
|
Date and time when the equipment sensor was first activated in the period
|
Sensors
|
Column name
|
Description
|
|
Sensor name
|
Display name of the sensor in the system
|
|
Sensor description
|
Sensor description from the sensor settings
|
|
Installed sensors
|
List of sensors installed on the object
|
|
Start
|
Start time of the sensor-related interval
|
|
End
|
End time of the sensor-related interval
|
|
Initial sensor value
|
First recorded sensor value for the selected period
|
|
Final sensor value
|
Last recorded sensor value for the selected period
|
|
Sensor value difference
|
Difference between the final and initial values for the period
|
|
Minimum sensor value
|
Minimum sensor value for the selected period
|
|
Maximum sensor value
|
Maximum sensor value for the selected period
|
|
Average sensor value
|
Average sensor value for the selected period
|
|
Total sensor value — total sensor value for the period
|
Total sensor value for the period
|
|
Number of sensor issues
|
Number of errors, failures, or invalid sensor readings recorded during the period
|
Temperature
|
Column name
|
Description
|
|
Temperature sensor name
|
Name of the temperature sensor
|
|
Temperature sensor description
|
Description of the sensor from its settings
|
|
Initial temperature sensor value
|
Temperature at the beginning of the selected period
|
|
Final temperature sensor value
|
Temperature at the end of the selected period
|
|
Minimum temperature sensor value
|
Lowest temperature during the period
|
|
Maximum temperature sensor value
|
Highest temperature during the period
|
|
Average temperature sensor value
|
Average temperature for the selected period
|
|
Temperature sensor value difference
|
Difference between temperature values during the period, usually between the initial and final values
|
Places
|
Column name
|
Description
|
|
Start location
|
Location where the vehicle was at the beginning of the period
|
|
Stop location
|
Location where the object was stopped
|
Speed
|
Column name
|
Description
|
|
Max Speeding Time
|
Duration of the longest speeding event during the period
|
|
Speeding over 30
|
Speeding by more than 30
|
|
Speeding 21–30
|
Speeding by 21–30
|
|
Speeding 11–20
|
Speeding by 11–20
|
|
Speeding 1–10
|
Speeding by 1–10
|
|
Speeding based on object settings
|
Speeding events calculated according to the speed limit set in the object settings
|
|
Speeding time
|
Total time the object was moving while speeding
|
|
Max speed
|
Maximum speed
|
|
Average speed
|
Average speed
|
|
Total speeding
|
Summary metric for all speeding events during the period
|
|
Mileage
|
mileage
|
|
Location
|
Location where the speeding event was recorded
|
Violation monitoring
|
Column name
|
Description
|
|
Max Speeding Time
|
Duration of the longest speeding event during the period
|
|
Over Speed Count 1-10
|
Number of speeding events by 1–10
|
|
Over Speed Count 11-20
|
Number of speeding events by 11–20
|
|
Over Speed Count 21-30
|
Number of speeding events by 21–30
|
|
Over Speed Count > 30
|
Number of speeding events over 30
|
|
Total speeding count
|
Total number of speeding events
|
Geofences
|
Column name
|
Description
|
|
First entry time to base
|
Time of the first entry into the geofence
|
|
Last entry time to base
|
Time of the last entry into the geofence
|
|
First exit time from base
|
Time of the first exit from the geofence
|
|
Last exit time from base
|
Time of the last exit from the geofence
|
|
Number of exits from base
|
Number of exits from the geofence
|
|
Parking time at base
|
Parking time inside the geofence
|
|
Total parking time
|
Total parking time
|
|
Uniq Geofences Count
|
Number of different geofences visited during the period, excluding repeat visits to the same geofence
|
|
Geofences History
|
Timeline of geofence visits with entry and exit times
|
|
Geofences List
|
List of geofences visited
|
Notifications
|
Column name
|
Description
|
|
Notifications Count
|
Number of notifications during the selected period
|
Eco driving
|
Column name
|
Description
|
|
Maximum speeding value
|
Maximum speeding value
|
|
Speeding count
|
Number of speeding events
|
|
Speeding value
|
Speeding value
|
|
Speeding fine
|
Penalty for speeding
|
|
Acceleration Count
|
Number of harsh accelerations
|
|
Acceleration Value
|
Value of the harsh acceleration event
|
|
Acceleration Fine
|
Penalty for harsh acceleration
|
|
Braking Count
|
Number of harsh braking events
|
|
Braking Value
|
Value of the harsh braking event
|
|
Braking Fine
|
Penalty for harsh braking
|
|
Turn Count
|
Number of harsh turns
|
|
Turn Value
|
Value of the harsh turn event
|
|
Turn Fine
|
Penalty for harsh turns
|
|
Forward collision Count
|
Number of forward collision warnings
|
|
Forward collision Value
|
Value of the forward collision event
|
|
Forward collision Fine
|
Penalty for forward collision warnings
|
|
Lane deviation Count
|
Number of lane departure events
|
|
Lane deviation Value
|
Value of the lane departure event
|
|
Lane deviation Fine
|
Penalty for lane departure
|
|
Car distance near Value
|
Value of the event when the distance to the vehicle ahead was too small
|
|
Car distance near Fine
|
Penalty for unsafe following distance
|
|
Pedestrian collision Count
|
Number of risky pedestrian-related events
|
|
Pedestrian collision Value
|
Value of the pedestrian-related event
|
|
Pedestrian collision Fine
|
Penalty for pedestrian-related events
|
|
Frequent lane change
|
Violation related to frequent lane changes
|
|
Seat Belt Count
|
Number of seat belt violations
|
|
Seat Belt Value
|
Value of the seat belt violation
|
|
Seat Belt Fine
|
Penalty for seat belt violations
|
|
Fatigue driving Count
|
Number of fatigue or drowsiness events
|
|
Fatigue driving Value
|
Value of the fatigue driving event
|
|
Fatigue driving Fine
|
Penalty for fatigue driving
|
|
Phone call Count
|
Number of phone call events while driving
|
|
Phone call Value
|
Value of the phone call event
|
|
Phone call Fine
|
Penalty for using a phone while driving
|
|
Smoking Count
|
Number of smoking events while driving
|
|
Smoking Value
|
Value of the smoking event
|
|
Smoking Fine
|
Penalty for smoking while driving
|
|
Eco Event Speed
|
Vehicle speed at the time of the eco event
|
|
Eco Event Avg Speed
|
Average speed during the eco event
|
|
Eco Event Max Speed
|
Maximum speed recorded during the eco event
|
|
Eco Event Location
|
Location where the eco event occurred
|
|
Eco Event Fine
|
Penalty for the eco event
|
|
Eco Event Value
|
Value of the eco event
|
|
Eco Event Count
|
Number of eco events recorded during the period
|
|
Eco Event Type
|
Category of the eco event
|
Services
|
Column name
|
Description
|
|
Service works price
|
Total cost of the performed work
|
|
Service date
|
Service date
|
|
Service name
|
Name of the service performed
|
|
Service supplier
|
Company or contractor that provided the service
|
|
Service type
|
Service category
|
|
Service status
|
Service status: completed, scheduled, canceled
|
|
Service amount
|
Total service amount
|
|
Service invoice number
|
Invoice or document number related to the service
|
|
Service comment
|
Additional comment about the service
|
|
Service due mileage
|
Mileage at which the next service is due
|
|
Service due motohours
|
Engine hours at which the next service is due
|
|
Service due dates
|
Planned date of the next service
|
|
Service works & parts list
|
List of completed work and used parts
|
|
Service works list
|
List of completed work
|
|
Service parts list
|
List of used parts
|
|
Service parts price
|
Cost of parts
|
|
Service downtime
|
How long the object was unavailable due to service
|
|
Last TO motohours
|
Engine hours at the last completed maintenance
|
|
Next TO motohours
|
Planned engine hours for the next maintenance
|
|
Mh until next TO
|
Engine hours remaining until the next maintenance
|
|
Last TO date
|
Date of the last maintenance
|
|
Last TO number
|
Number or sequence number of the last maintenance record
|
|
Next TO date
|
Planned date of the next maintenance
|
|
Last TO mileage
|
Mileage at the last maintenance
|
Working hours
|
Column name
|
Description
|
|
Shift start
|
Time when the work shift starts according to the schedule
|
|
Shift end
|
Time when the work shift ends
|
|
Night drive time
|
Total trip time during the night interval
|
|
Night drive start
|
Time when the first night trip started
|
|
Night drive end
|
Time when the last night trip ended
|
|
Night drive address
|
Location where the night trip was recorded
|
|
Exceeding time
|
Total time the object worked or moved outside the scheduled working hours
|
|
Exceeding drive time
|
Part of the exceeding time that happened during trips
|
|
Exceeding movement time
|
Part of the exceeding time when the object was moving
|
|
Exceeding parking time
|
Part of the exceeding time spent parked
|
|
Exceeding idling time
|
Part of the exceeding time when the engine was running but the object was not moving
|
|
Exceeding address
|
Location where the working-hours violation was recorded
|
|
Workday start
|
Start time of the working day in the schedule
|
|
Workday end
|
End time of the working day in the schedule
|
|
Break time, sec.
|
Break duration in seconds, which is excluded or counted separately
|
|
Saturday start
|
Schedule start time for Saturday
|
|
Saturday end
|
Schedule end time for Saturday
|
|
Sunday start
|
Schedule start time for Sunday
|
|
Sunday end
|
Schedule end time for Sunday
|
Driver fields
|
Column name
|
Description
|
|
Driver name
|
Driver’s full name or name as stored in the system
|
|
Driver group
|
Group the driver belongs to
|
|
Driver’s license
|
Driver’s license number
|
|
Driver’s license expiry date
|
Date when the driver’s license expires
|
|
Driver email
|
Driver’s email address
|
|
Driver phone
|
Driver’s phone number
|
|
Driver description
|
Additional text description or note about the driver
|
|
Driver iButton
|
iButton/key identifier linked to the driver
|
|
Driver tags
|
Tags assigned to the driver for grouping
|
PTM
|
Column name
|
Description
|
|
PTM fields
|
Group of fields related to PTM tasks
|
|
PTM tasks count
|
Total number of PTM tasks for the selected period
|
|
PTM tasks completed count
|
Number of completed PTM tasks during the period
|
|
PTM tasks unplanned stop duration
|
Total duration of unplanned stops related to PTM tasks
|
|
PTM tasks idle duration
|
Total idle time related to PTM tasks
|
RFID tags
|
Column name
|
Description
|
|
RFID Location
|
Location where the RFID event was recorded
|
|
RFID Time
|
Date and time when the RFID tag was read
|
|
RFID Name
|
Name or description of the RFID tag
|
|
RFID UID
|
Unique RFID tag identifier
|
|
RFID Group
|
Group the RFID tag belongs to
|
Fuel card transactions
|
Column name
|
Description
|
|
Transaction Gas
|
Name of the fuel station or service point
|
|
Transaction Type
|
Type of transaction
|
|
Transaction Location
|
Address where the transaction was performed
|
|
Transaction Time
|
Date and time of the card transaction
|
|
Номер карты
|
Fuel card number
|
|
Distance Previous-Current
|
Distance between two consecutive operations
|
|
Current
|
Current reading at the time of the transaction
|
|
Transaction Amount
|
Monetary amount of the transaction
|
|
Transaction Price
|
Fuel price per unit in the transaction
|
|
Transaction Fuel
|
Fuel amount specified in the transaction
|
|
Transaction Volume
|
Fuel volume for the transaction
|
|
Transaction Odo
|
Odometer reading at the time of the transaction
|
|
Transaction Gas Type
|
Fuel type: diesel, petrol, gas
|
|
Pump Amount
|
Amount charged at the pump
|
|
Pump Volume
|
Amount of fuel dispensed by the pump
|
|
Nozzle Number
|
Number of the fuel nozzle
|
|
Pump Number
|
Number of the fuel pump
|
|
Machine Hours
|
Engine hours at the time of the transaction
|
|
Previous-Current
|
Change between the previous and current value
|
Connection loss
|
Column name
|
Description
|
|
Total Disconnection Duration
|
Total time without connection
|
|
Disconnection Start Date & Time
|
Moment when the connection to the device was lost
|
|
Disconnection End Date & Time
|
Moment when the connection was restored
|
|
Ignition Status at Disconnection
|
Whether ignition was on at the moment of disconnection
|
|
Disconnection Address
|
Address of the last known point before connection loss
|
|
Last Known Latitude & Longitude
|
Coordinates of the last known point before connection loss
|
|
Reconnection Address
|
Address where the connection was restored
|
|
Reconnection Latitude & Longitude
|
Coordinates where the connection was restored
|
|
Reconnection Speed (km/h)
|
Object speed at the time of reconnection
|
|
Offline Reason Code
|
Technical code indicating the reason for the connection loss
|