From | Dispatch Id | Trip No | To | Price | E-Stat | Set Delta | Reversal | Total Amount |
---|---|---|---|---|---|---|---|---|
|
%
|
1 |
Source | Rating | Comments | Pick up/ Drop off | Vehicle | Driver Behavior | The Route | Updated By | Date/ Time |
---|---|---|---|---|---|---|---|---|
Fleet | Amount | Trip No | Created (UTC0) | Updated (UTC0) | Cancel | |
---|---|---|---|---|---|---|
|
Time | Status | Latitude | Longitude |
---|---|---|---|
field | value | Time |
---|---|---|
Id | Status | Partner | Subpartner | Reference | VIP | Meet & Greet | Date/Time (local) | Return Date/Time | From | To | Service Area | Fleet | Vehicle Class | Cellphone | Passenger Name | Trip Count | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Id | Status | Partner | Subpartner | Reference | VIP | Meet & Greet | Date/Time (local) | Return Date/Time | From | To | Service Area | Fleet | Vehicle Class | Cellphone | Passenger Name | Trip Count | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ID | Partner ID | Vehicle Class | Local Time | Hour From Now | Time left to dispatch | Service Area | VIP | Distance | Airport Code | Country Code | Assigned Employee | Added to Auction |
---|---|---|---|---|---|---|---|---|---|---|---|---|
|
ID | Partner ID | Vehicle Class | Local Time | Hour From Now | Time left to dispatch | Service Area | VIP | Airport Code | Country Code | Assigned Employee |
---|---|---|---|---|---|---|---|---|---|---|
Id | Vehicle Class | Local Time | Hour From Now | Service Area | VIP | Airport Code | Country Code | Assigned Employee | Added to Auction |
---|---|---|---|---|---|---|---|---|---|
Id | Vehicle Class | Local Time | Hour From Now | Service Area | VIP | Airport Code | Country Code |
---|---|---|---|---|---|---|---|
Id | Vehicle Class | Local Time | Hour From Now | Service Area | VIP | Airport Code | Country Code | Dispatch Status | Time in Dispatch | Auction Price | Price Version | Time In Auction | Assigned Employee |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Id | Local Time | Service Area | Hours From Now | Stat | Fleet | Name | Cell Number |
---|---|---|---|---|---|---|---|
Ride Id | Dispatch Stat | GPS counts | Last Known Location (lat,lng) | HH:MM | Service Area | Fleet Name | Fleet Emp | Fleet Driver | Vehicle Class | Local Pickup Time | Meeting Point | Flight Arrival | Latest flight track time | Flight tracking URL |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Ride Id | Service Area | Pickup Location | Pickup Time (UTC0) | Airport Code | Country Code | Missing data | Passenger |
---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
Id | From Inaccuracy (meters) | To Inaccuracy (meters) |
---|---|---|
Ride Id | Partner | Reference | Local Time | Fleet | Fleet Emp | Dispatch Driver | Service Area | Zoho Ref |
---|---|---|---|---|---|---|---|---|
Ride Id | Partner | Reference | Local Time | Fleet | Fleet Emp | Dispatch Driver | Service Area | Delta value | Reversal % | E stat | Last note |
---|---|---|---|---|---|---|---|---|---|---|---|
Id | Vehicle Class | Local Time | Service Area | VIP | Airport Code | Country Code | Assigned Employee | |
---|---|---|---|---|---|---|---|---|
Id | Local Time | Service Area | Stat | Fleet | Name | Cell Number |
---|---|---|---|---|---|---|
Ride Id | Details | Updated At | Changes | Local Time | Service Area | To Fleet | Fleet Emp |
---|---|---|---|---|---|---|---|
Ride Id | Stat | Pickup Location | Dropoff Location | Local Time | Service Area |
---|---|---|---|---|---|
Employee ID | First Name | Last Name | Cellphone | Airport | |
---|---|---|---|---|---|
Employee ID | First Name | Last Name | Cellphone | Country | |
---|---|---|---|---|---|
Employee ID | First Name | Last Name | Cellphone | Granted Access | |
---|---|---|---|---|---|
Id | Partner | Reference | Vehicle class | Pickup date | Return date | From | To | Notes | VIP | Meet & greet | From flight | To flight |
---|---|---|---|---|---|---|---|---|---|---|---|---|
Ride ID | Pickup time (Local Time) | Pickup Location | Drop Off Location | Service Area | Partner Amount |
---|---|---|---|---|---|
Ride ID | Partner ID | Insights | Potential matches | Inserted at |
---|---|---|---|---|
Id | File Name | Ride Reference | Status | Response | Ride Data | Zoho ref |
---|---|---|---|---|---|---|
Ride ID | Paid Time | AC Created Time | Trip ID | Country Code | Service Area | Local Time | Hour From Now | Fleet | Cause of AC |
---|---|---|---|---|---|---|---|---|---|
Ride Id | Completed time | Trip ID | Country Code | Service Area | Local Time | Hours From Now | Fleet | Cause of charge | Latest changes |
---|---|---|---|---|---|---|---|---|---|
ID | Partner Reference ID | Vehicle Class | Local Pickup Time | Modification Date Time (UTC) | Hour From Now | Time Left To Accept | Distance | Service Area | VIP | Airport Code | Country Code | Assigned Employee | Added to Auction |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Ride ID | Partner ID | Insert date | Ride Date | Reference | Reason for Zoho | Zoho Reference |
---|---|---|---|---|---|---|
Id | Name | Cell Number | Status | Last Updated At (UTC) | |
---|---|---|---|---|---|
Ride ID
|
Partner ID
|
Subpartner ID
|
Reference | Service Level | Local Pickup Time |
Hour to Pickup
|
Service Area | Fleet Name | Driver | Vehicle Class | Vehicle License Plate | SMS Sent Status | SMS Action |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Id | Note | Changed By | Date/Time (Local) |
---|---|---|---|
ID | Partner | Can see | Can edit | Actions |
---|---|---|---|---|
|
|
ID | Agency | Can see | Can edit | Actions |
---|---|---|---|---|
|
|
ID | Affiliate | Can see | Can edit | Actions |
---|---|---|---|---|
|
|
Airport | Check |
---|---|
Country | Check |
---|---|
Id | File Name | Num Of Records | Num Status Success | Num New Rides (succ,fail,other) | Num Canceled Rides (succ,fail,other) | Num Sync Rides (succ,fail,other) | Num Status Warning/Errors | Inserted Date | Partner | Job Status | Process File |
---|---|---|---|---|---|---|---|---|---|---|---|
( , , ) |
( , , ) |
( , , ) |
Id | File Name | Ride ID | Ride Reference | Status | Ride Data | Response | Ride Action | Inserted Date | Zoho ref |
---|---|---|---|---|---|---|---|---|---|
Id | File Name | Ride Reference | Status | Response | Ride Data | Zoho ref |
---|---|---|---|---|---|---|