Orders report guide
Liza
Last Update a year ago
Order ID
Unique identification number of the order generated by the system.Date and time of order creation. At this very moment, the order is submitted to the system and dispatched between drivers.
Author ID
Unique identification number of the person/facility used to create an order. It can be the id of a:
a) Customer;
b) Operator;
c) Web App;
d) 1-click Taxi Button;
Order source
A facility used for order creation. It can be:
a) Operator App;
b)Web App (orders created with a One-click taxi button have operator app order source)
Bundle
Bundle identifier is the namespace of the app used to create an order. It can be:
a) ios.passenger.yourbundle;
b) android.passenger.yourbundle;
c) web.dispatcher;
d) api.dispatch.v1.2664e0df-93f5-4b41-83cf-01dd381c11e0 (One-click taxi button);
e) web.passenger.yourbundle (web app)
Requested vehicle type
Service the client booked. Remember that customer always pays for the service ordered, not the one he/she finally received.
Requested pickup
Time and date when the customer wants to receive a service. It can be ASAP or pre-booking. In pre-booking case, a date and time of the order are provided.
Origin type
A way the author of the order chose the pick-up location. It can be:
a) PointOnMap (location is set by the pin on the map);
b) AddressPoint (order author inserted address);
c) Location (location of the client provided by the GPS automatically).
Origin location
GPS coordinates of the pick-up location.
Origin address
Address of the pick-up location.
Destination type
This column notifies if the author of the booking provided a drop-off location. The cell can have two values:
a) AddressPoint (author made a booking with a drop-off point);
b) blank (author made booking without drop-off location).
Destination location
GPS coordinates of the drop-off location provided.
Destination address
Address of the drop-off location provided.
Dropoff type
A way the author of the order chose the drop-off location. It can be:
a) PointOnMap (location is set by the pin on the map);
b) AddressPoint (order author inserted address);
c) Location (location of the client provided by the GPS automatically).
Dropoff location
GPS coordinates of the point where the order finishes.
Dropoff address
Address of the location where the order finishes.
Dropoffs count
The number of stops the author chose when creating the order. “1” means that the customer was taken from the pick-up to the drop-off directly.
Order notes
A note the client or operator left to the driver while creating the order.
Passengers number
Number of seats that should be available in the cab for this order. Operators only can insert this information.
Client documents
The list of additional documents added to the customer’s profile.
Note! Temporarily unavailable.
Driver payment documents
The list of additional documents added to the driver’s profile.
Note! Temporarily unavailable.
Passenger id
Unique identification number of the client who asks for a service.
Passenger name
Name of the client who orders the service.
Passenger email
Email of the client who orders the service.
Passenger phone
Phone number of the client who orders the service.
Passenger operator ID
Unique identification number of the operator who creates the order. In case the operator has not been an author of the order, the cell remains blank.
Passenger operator name
Name of the operator who creates the order. In case the operator has not been an author of the order, the cell remains blank.
Passenger operator email
Email of the operator who creates the order. In case the operator has not been an author of the order, the cell remains blank.
Driver operator ID
Unique identification number of the operator who assigns the order. In case the operator has not participated in assigning the order the cell remains blank.
Driver operator name
Name of the operator who assigns the order. In case the operator has not participated in assigning the order the cell remains blank.
Driver operator email
Email of the operator who assigns the order. In case the operator has not participated in assigning the order the cell remains blank.
Driver id
Unique identification number of the driver who accepts the order. In case the order is cancelled before being accepted by any driver or no driver takes the ride, the cell remains blank.
Driver custom key
A unique identification the company management sets for the driver. In case the order is cancelled before being accepted by any driver or no driver takes the ride, the cell remains blank.
Driver name
In case the order is cancelled before being accepted by any driver or no driver takes the ride, the cell remains blank.
Driver email
In case the order is cancelled before being accepted by any driver or no driver takes the ride, the cell remains blank.
Driver phone
In case the order is cancelled before being accepted by any driver or no driver takes the ride, the cell remains blank.
Vehicle type
Main channel of the driver. It can be different from the F column (Requested vehicle type) if allowed in the service settings.
Vehicle plate number
In case the order is cancelled before being accepted by any driver or no driver takes the ride, the cell remains blank.
Vehicle board number
In case the order is cancelled before being accepted by any driver or no driver takes the ride, the cell remains blank.
Estimation time
Estimated time of the driver's arrival at the client. The system calculates this value and shows it to the driver before he accepts the trip. After the driver takes the job, the estimated time of arrival will be shown to the customer. This indicator decides on customer or driver cancellation fee application.
Estimation distance
Estimated distance from the driver's location to the client. This value is calculated by the system and shown to the driver before he accepts the trip.
Driver rate plan
The name of the plan the driver was subscribed to at the moment of order processing. Driver plan name will not be shown if the order was processed before this column was released.
Offer#
The number of times the system makes an offer to the drivers. This is a number of so-called green cards.
Reject#
The number of drivers who rejected the offer. Rejected offer does not imply a driver cancellation fee.
Total bid#
Number of times drivers and operators bid for the orderDriver bid#Number of times drivers bid for the order.
Dispatcher bid#
Number of times operators assigned orders to themselves.
Order status
The final status of the order or simply what happens with the order. It can be:
a) CancelledDecidedNotToGo (client manually cancels the order except for no taxi cases);
b) CancelledByDriver;
c) CancelledByDispatcher;
d) CANCELLED_SEARCH_EXCEEDED (assigned to all unaccepted orders: for instant customer app/web app orders - within 3 minutes upon creation, for instant operator app orders - within 30 minutes upon creation, for pre-orders - if no driver accepted it up to the pick-up time);
e) CANCELLED_EXPIRED - when the systems automatically cancel pre-booking if it hasn't been started by the driver
f) STARTED (driver accepted the order);
g) ARRIVED (driver swiped arrived);
h) TRANSFERRING (customer is in the cab and order is in the process);
i) REVIEW_SUMMARY (cab arrived and the driver has to confirm the total amount to pay (or report no funds case or wrong total case);
j) FinishedPaid;
k) FinishedUnpaid.
UnpaidReason
This cell gives more details about FinishedUnpaid (column AO) orders. The driver chooses a reason at the end of the ride. It can be:
a) WrongPrice;
b) NoFundsCancellation reason
There are reasons that forced customers to cancel the order.
They are:
1) FARE_IS_TOO_HIGH;
2) DRIVER_IS_TOO_FAR_AWAY;
3) VEHICLE_DOESNT_FIT_CLASS;
4) JUST_TYING_THE_APP;
5) CHANGED_MY_MIND;
6) CUSTOM_REASON
Cancellation comment
Customer note made after order cancellation with custom reason.
Trip distance
Length of the trip made. This value is essential for the calculation of the order total for regular rates if the calculation is auto.
Trip time
Duration of the trip made. This value is essential for the calculation of the order total for regular and hourly rates if the calculation is auto.
Intermediate driver IDs
ID of the driver who accepted the order initially, but cancelled it with "Reject service" reason before arrival.
Passenger cancellation fee
The amount taken from the customer for cancelling (if configured in the company panel)
Driver cancellation fee
The amount taken from the driver for cancelling (if configured in the company panel).
Trip cost
Cost of the trip in the currency of My hub. It is based on the major parameters for a rate cost calculation. Trip cost does not include extra costs which the driver can add at the end of the ride.
Extra cost
Extra fee the driver adds to the trip cost at the end of the ride.
Total cost
A sum of the trip cost (column AS) and extra cost (column AT). This is the final price charged from the client at the end of the ride.
Coupon and Tips are not available at Onde.Light.
Tax
Additional fee added on top of the trip cost
Transaction fee
Additional fee taken for credit card transactions.
Final cost
Cost of the trip with coupon discount and additional fees.
Unpaid cost
The non-covered part of the trip cost if any.
Rounding correction
The rounding value that applied if rounding rule is set.
Payment method
It can be: a) Cash; b) Terminal; c) CreditCard/Payment card
Payment errors
Information about the reason for the unsuccessful credit card payment
Rating by driver
Here you have information about the driver rating his ride.
Rating by passenger
Here you have information about your driver ratings.
Started at
For asap orders, it is the exact time when the driver accepts the order. For pre-orders, it is the exact time when the driver swipes to start the order.
Started location
GPS coordinates of the location where the driver accepts the trip.
Arrived at
The exact time when the driver presses "arrived" to the pick-up location.
Arrived location
GPS coordinates of the location where the driver presses "arrived" at the pick-up location.
Loaded at
The exact time when the driver presses "start a ride" to the drop-off location.
Loaded location
GPS coordinates of the location where the driver presses "start a ride" to the drop off point.
Finished at
The exact time when the driver presses "Finish" at the drop location.
Finished location
GPS coordinates of the location where the driver presses "Finish" at the drop-off point.
Closed at
The time when the order was finalised by the driver.
Closed location
GPS coordinates of the location where the order was closed at.
Service space
It can be: a) PRODUCTION; b) DEMO
Active
Shows TRUE if the order was ongoing at the time the report was generated.
Linked order
In case the order is a back-to-back one, column “Linked order” contains the ID of the order the driver was on when this back-to-back order was offered. If the order is a regular instant one or a pre-order the cell in “Linked order” column is empty.