Maintenance Data Set for Car Rental Company

<p>Maintenance records for a car rental company. The column details are provided as below:</p> <ul> <li><strong>CARID: </strong>Unique ID for each of the cars in the fleet</li> <li><strong>Brand:</strong> Brand of the car</li> <li><strong>Model :</strong> Model of the car&nbsp;</li> <li><strong>SubModel :</strong> Submodel for the brand and model of the car</li> <li><strong>Segment:</strong> there are segments for the cars ( for further information please refer to wikipedia :&nbsp;https://en.wikipedia.org/wiki/Car_classification )&nbsp;</li> <li><strong>Year :</strong> Model year of the car</li> <li><strong>Fuel Type: </strong>Fuel consumption Type ( like Diesel, Petrol, Hybrid or Electric)</li> <li><strong>Gear : </strong>Gear type of the car</li> <li><strong>Milage:</strong> 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.</li> <li><strong>MaintenanceMile :</strong> is the actual mile during the call&nbsp;</li> <li>CallID: a unique id for each maintenance call.&nbsp;</li> <li>StockID: ID of the parts or services provided during the call</li> <li>Quantity: Quantity of the parts or duration of service or amount of items used during the maintenance</li> <li>UnitPrice : unit price for the parts, services or consumption</li> <li>SubTotal : Line bases subtotal for the invoice (the actual total value in US Dollars for the quantity and the unit price : unitprice x quantity)</li> <li>Discount: Line based discount for the stockid, quantity and unitprice</li> <li>Tax : Legal taxes in USD</li> <li>GrandTotal : invoice based total amount (total amount of each lines in the same invoice)</li> <li>InvoiceDate : Data of invoice in Year - Month - Day Hour - Minute - Seconds , you can skip the hour, minute and seconds&nbsp;</li> <li>VendorID: Unique ID of each vendor providing the maintenance service</li> <li>CityID: Location of the maintenance</li> <li>MaintenanceType : It can be a regular maintenance ( 0) , request based maintenance (1) or unknown (2)&nbsp;</li> </ul> <p>&nbsp;</p>