This export shows all available fields for rentals
|
Column |
Description |
Additional information |
|---|---|---|
|
id |
|
|
|
state |
State of the rental |
RESERVATION ACTIVE EXPIRED ENDED CANCELLED ENDED_NO_MOVEMENT |
|
user_id |
|
|
|
vehicle_id |
|
|
|
start_branch_id |
|
|
|
end_branch_id |
|
|
|
type |
|
PERSONAL or BUSINESS |
|
group_id |
If type = BUSINESS, there will be a group_id |
|
|
start_time |
|
UTC |
|
end_time |
|
UTC |
|
trip_duration |
|
In seconds |
|
time_reservation |
|
In seconds |
|
time_driving |
|
In seconds |
|
time_parking |
|
In seconds |
|
start_lat |
|
|
|
start_lng |
|
|
|
end_lat |
|
|
|
end_lng |
|
|
|
start_address |
|
|
|
end_address |
|
|
|
start_odometer |
|
In kilometers |
|
end_odometer |
|
In kilometers |
|
trip_distance |
|
In kilometers |
|
cost_reservation_gross |
|
With VAT |
|
cost_reservation_net |
|
|
|
cost_driving_gross |
|
With VAT |
|
cost_driving_net |
|
|
|
cost_parking_gross |
|
With VAT |
|
cost_parking_net |
|
|
|
cost_non_rebatable_gross |
Amount of the cost of the rental that cannot be rebated by a voucher |
With VAT |
|
cost_non_rebatable_net |
|
|
|
cost_gross |
The total cost of the rental |
With VAT |
|
cost_net |
|
|
|
rebate_gross |
Amount of the rental covered by the vouchers |
With VAT |
|
rebate_net |
|
|
|
price_gross |
Amount of the rental that is not covered by the vouchers |
With VAT |
|
price_net |
|
|
|
rating_score |
|
|
|
rating_description |
|
|