The Essential Guide to Report Categories: RESERVATIONS

These fields capture the full lifecycle and usage metrics of the reservation.

Data Field	Purpose
Reservation Id	Unique identifier for the trip/booking.
Reservation Type / Status	Defines the nature (e.g., Rental, Test Drive) and the current state (e.g., Active, Completed, Cancelled).
Reserved Time Start/End	The booked or scheduled time window.
Used Time Start/End	The actual time the asset was picked up and dropped off.
Reservation End/Start Time Delta	Calculated difference between reserved time and actual used time (key for efficiency).
Reservation Distance Used	Total distance traveled during the reservation.
Reservation Odometer Start/End	The mileage recorded at the beginning and end of the trip.
Fuel Level Start/End, Charge Level Start/End	Metrics tracking fuel/battery status for maintenance and billing accuracy.
Reservation Vehicle Id / Vin, User Id, Invoice Id	Linking IDs to associated records.
Reservation Offline Reason	Explanation if the vehicle was taken offline (e.g., maintenance, accident).

These groups categorize the asset and its organizational context for fleet management analysis.

Category	Key Fields	Purpose
Vehicle	id, Vin, Name, License Plate, Status	Core identification and current operational status of the specific vehicle.
Vehicle Type	Year, Make, Model, Trim, Powertrain, Asset Class, Category	Details for analyzing performance and popularity by vehicle class (e.g., "Sedan" vs. "Truck").
Vehicle Group (Service Group)	id, Name, Time zone, Drive Access	Organizational groupings for logistical and management purposes.
Fleet	Fleet Id, Name, Label	Defines which organizational fleet the vehicle belongs to.
Location	Id, Address, City, Name, State, Country	Defines the geographical location of the reservation pick-up or drop-off.
Organization	Organization Name	The name of the entity managing the asset.

These categories link the trip to the responsible party and the billing record.

Category	Key Fields	Purpose
User	ID, Email, First/Last Name, License State, Address City	Contact and demographic information for the individual who made the reservation.
Invoice	Id, Sub total, Tax, Due/Processed Time	Core financial data linking the reservation to its billable amount.
Invoice	Paid credit/Card, Cost Fees, Disputed, Past Due	Itemized payment status and costs associated with billing.

These metrics measure how efficiently and frequently the assets are being used.

Aggregate Metric	Calculation / Significance
Reservation Count	Total number of reservations completed or initiated.
Reservation Count Drill	A second count, often used to drill down into a subset (e.g., canceled vs. completed).
Reservation Hour Duration	The sum of total usage time across all reservations ($\sum (\text{Used Time End} - \text{Used Time Start})$).
Reservation Used Distance Sum / Avg	Total distance driven and the average distance per trip (key for maintenance scheduling).

These sums, drawn from the associated invoices, are essential for financial reporting.

Aggregate Metric	Significance
Invoice Paid Sum / Pre Auth sum	Total revenue successfully collected and funds currently reserved.
Invoice Unpaid sum / Past due Sum	Key metrics for Accounts Receivable (A/R) management and debt tracking.
Invoice Cost fees Sum / Disputed Sum	Total processing fees incurred and the total value of chargebacks/disputes.
Invoice Net Total Sum	The total revenue amount after discounts and taxes (key top-line metric).
Invoice Direct Costs / Margin	Total Margin, or profit, is calculated by taking the Invoice Sub Total Sum (the total value of goods/services sold) and subtracting your Direct Costs (what it cost you to provide them).