| Name | Description | Type | Additional information |
|---|---|---|---|
| ID |
The unique id of a service |
unsigned integer |
None. |
| UserID |
The user id who owns the service |
unsigned integer |
None. |
| SageReference |
Billing information |
integer |
None. |
| Created |
When the service was created |
date |
None. |
| DriverName | string |
None. |
|
| ContractEndDate |
The contact end date |
date |
None. |
| ContractStartDate |
The contact start date |
date |
None. |
| RenewalDue |
Date when the renewal is due |
date |
None. |
| RenewalCost |
The renewal cost |
decimal number |
None. |
| MonthlyContract |
If the service is a monthly contact |
boolean |
None. |
| DeviceID |
The id of the device attached to a service |
unsigned integer |
None. |
| Device |
The device information attached to the service |
Device |
None. |
| VehReg |
The registration of the service |
string |
None. |
| VehIcon1 |
The icon of the service displayed on the websites |
string |
None. |
| VehIcon2 |
The second icon of the service displayed on the websites |
string |
None. |
| V5Icon | string |
None. |
|
| Vin | string |
None. |
|
| StatusUpdateDate | date |
None. |
|
| Status | integer |
None. |
|
| V5IconColor | string |
None. |
|
| VehBody |
The vehicle body |
string |
None. |
| VehChasis |
The vehicle chassis |
string |
None. |
| VehYear |
The year the vehicle was made |
string |
None. |
| VehSeats |
The amount of seats in the vehicle |
integer |
None. |
| VehAveMpg |
The vehicle MPG |
decimal number |
None. |
| VehCostPerMile |
The vehicle cost per mile |
decimal number |
None. |
| VehCuttingWidth |
Cutting width if applicable |
decimal number |
None. |
| RoutingPermission |
If the service is allowed access to routing |
boolean |
None. |
| FriendlyName | string |
None. |
|
| VehOtherReg | string |
None. |
|
| SocialDriverService |
If the service is for social driver |
boolean |
None. |
| VehWeekdayAuthStart |
Authorised times for a service |
string |
None. |
| VehWeekdayAuthEnd |
Authorised times for a service |
string |
None. |
| VehWeekendAuthStart |
Authorised times for a service |
string |
None. |
| VehWeekendAuthEnd |
Authorised times for a service |
string |
None. |
| VehSundayAuthStart |
Authorised times for a service |
string |
None. |
| VehSundayAuthEnd |
Authorised times for a service |
string |
None. |
| LatestTelemetry |
The latest telemetry for the service |
Standard |
None. |
| SysRenewalPeriodMonths |
The renewal period |
integer |
None. |
| Sys_account_number |
The account number |
string |
None. |
| Sys_min_number_renewals |
Billing information |
integer |
None. |
| Log |
A log of actions performed on the service |
string |
None. |
| Activation_Inverted |
If the action status is inverted |
boolean |
None. |
| DocumentReference |
Any documents referenced by the service |
string |
None. |
| DocumentReferenceExpiryDate |
The expiry date of the documents referenced by the service |
date |
None. |
| Configuration |
Suretrack alert configuration |
SuretrackAlertConfiguration |
None. |
| MaxVoltage |
The maximum voltage possible on this service |
decimal number |
None. |
| MinVoltage |
The minimum voltage possible on this service |
decimal number |
None. |
| ECode |
Ecode of the service |
string |
None. |
| CommCode |
Comm Code of the service |
string |
None. |
| Description |
Description of the service |
string |
None. |
| LowCategory |
The low category of the service |
string |
None. |
| MidCategory |
The mid category of the service |
string |
None. |
| HighCategory |
The high category of the service |
string |
None. |
| ContractCode |
The contract code of the service |
string |
None. |
| EstimatedHireEndDate |
The estimated hire end date |
date |
None. |
| ActualHireEndDate |
The actual hire end date |
date |
None. |
| LolerCertificateName |
Certificate file name |
string |
None. |
| LolerCertificateS3Key |
Certificate S3 key |
string |
None. |
| TRCertificateName |
Certificate file name |
string |
None. |
| TRCertificateS3Key |
Certificate S3 key |
string |
None. |
| CompanyName |
Company name |
string |
None. |
| Active |
If the service is active |
boolean |
None. |
| ExternalContactNumber |
field for 3rd parties to store data for a service (e.g. Radius) |
string |
None. |
| ExternalCustomerName | string |
None. |
|
| VehNotes | string |
None. |
|
| ServiceType |
The type of the service |
ServiceType |
None. |
| DecelerationThreshold |
The deceleration threshold for this vehicle used during scoring |
integer |
None. |
| AccelerationThreshold |
The acceleration threshold for this vehicle used during scoring |
integer |
None. |
| Region |
The region where the service will be used |
string |
None. |
| DefaultJourneyType |
The default journey type of the service |
DefaultJourneyType |
None. |
| Sop | integer |
None. |
|
| BillingStartDate | date |
None. |
|
| BillingEndDate | date |
None. |
|
| SageSupplierReference | string |
None. |
|
| CommisionRate | decimal number |
None. |
|
| SalesPersonReference | integer |
None. |
|
| ImportedSysUserId | unsigned integer |
None. |
|
| SysRateId | integer |
None. |
|
| SysTariffId | integer |
None. |
|
| InstallDate | date |
None. |
|
| BilledCountryCode | string |
None. |
|
| InstallerReference | integer |
None. |
|
| SysStandingRateId | integer |
None. |
|
| LastFeeAmount | decimal number |
None. |
|
| FeeLastCalculatedDate | date |
None. |
|
| UrbanMPG | decimal number |
None. |
|
| ExtraUrbanMPG | decimal number |
None. |
|
| CombinedMPG | decimal number |
None. |
|
| UsDot | string |
None. |
|
| NoSpaceReg | string |
None. |
|
| AdminLog | string |
None. |