Maintenance Data Set for Car Rental Company

Maintenance records for a car rental company. The column details are provided as below:

CARID: Unique ID for each of the cars in the fleet

Brand: Brand of the car

Model : Model of the car 

SubModel : Submodel for the brand and model of the car

Segment: there are segments for the cars ( for further information please refer to wikipedia : https://en.wikipedia.org/wiki/Car_classification ) 

Year : Model year of the car

Fuel Type: Fuel consumption Type ( like Diesel, Petrol, Hybrid or Electric)

Gear : Gear type of the car

Milage: is the of the call of the maintenance (expected milage for the maintenance), the actual milage might be different than the scheduled one, this column indicates the scheduled milage for maintenance.

MaintenanceMile : is the actual mile during the call 

CallID: a unique id for each maintenance call. 

StockID: ID of the parts or services provided during the call

Quantity: Quantity of the parts or duration of service or amount of items used during the maintenance

UnitPrice : unit price for the parts, services or consumption

SubTotal : Line bases subtotal for the invoice (the actual total value in US Dollars for the quantity and the unit price : unitprice x quantity)

Discount: Line based discount for the stockid, quantity and unitprice

Tax : Legal taxes in USD

GrandTotal : invoice based total amount (total amount of each lines in the same invoice)

InvoiceDate : Data of invoice in Year - Month - Day Hour - Minute - Seconds , you can skip the hour, minute and seconds 

VendorID: Unique ID of each vendor providing the maintenance service

CityID: Location of the maintenance

MaintenanceType : It can be a regular maintenance ( 0) , request based maintenance (1) or unknown (2)