| 1 |
stock |
String |
Stock number defined by dealer (can be same as the VIN) |
| 2 |
title |
String |
Title of the vehicle (New, Used, Certified Pre-Owned, Other)* |
| 3 |
vin |
String(17) |
Vehicle Identification Number (17 characters) |
| 4 |
year |
Integer(4) |
Year the vehicle was manufactured (for example: 1984) |
| 5 |
make |
String |
Manufacturer of the vehicle |
| 6 |
model |
String |
Model of vehicle |
| 7 |
trim |
String |
Specific trim of the model |
| 8 |
free_text |
String |
Text added by the dealer to show specific details |
| 9 |
type |
String |
Type of vehicle (AGRICULTURAL EQUIPMENT, AIRCRAFT, ATVs, BOAT, CARS & TRUCKS & VANS, COMMERCIAL TRUCKS & TRAILERS &BUSES, CONSTRUCTION EQUIPMENT, DISMANTLED MACHINE, GO KARTS & SCOOTERS, MILITARY VEHICLES, MOTORCYCLE, OTHER, PWC/ATV, RVs & CAMPERS, SAVING PLANS (CARS), SNOWMOBILES, TRAILERS) |
| 10 |
body |
String |
Body style of vehicle (Convertible, Coupe, Hatchback, Limousine, Minivan, Other, Pickup, Sedan, Sport Utility, Suv, Truck, Van, Wagon) |
| 11 |
mileage |
Integer |
mileage Integer Odometer value |
| 12 |
price_current |
Integer |
Current price of car |
| 13 |
price_wholesale |
Integer |
Price charged to wholesalers who buy large quantities for resale |
| 14 |
price_cost |
Integer |
The price a dealer paid for the vehicle |
| 15 |
InternetPrice |
Integer |
Internet price of the vehicle |
| 16 |
MSRP |
Integer |
Manufacturer Suggested Retail Price |
| 17 |
BookValue |
Integer |
The value is based on the original cost of the vehicle without depreciation, amortization or impairment costs made against the vehicle |
| 18 |
exterior/td>
| String |
Exterior color of vehicle |
| 19 |
interior |
String |
Interior color of vehicle |
| 20 |
doors |
String |
Number of doors |
| 21 |
engine |
String |
Type of engine |
| 22 |
transmission |
String |
Type of transmission |
| 23 |
drive_type |
String |
Driving wheels of the vehicle |
| 24 |
fuel_type |
String |
Fuel Type (Gasoline, Diesel, Hybrid, etc.) |
| 25 |
warranty |
Integer |
Vehicle warranty, 1 - if warranty exists, 0 – if none |
| 26 |
warranty_description |
String |
Warranty Text |
| 27 |
description |
String |
Description of the vehicle |
| 28 |
pics |
String |
URL of the photos for the vehicle |
| 29 |
condition |
String |
Condition of vehicle (Excellent, Good, Average, Poor, Undefined) |
| 30 |
options |
String |
Vehicle options, separated by a comma |
| 31 |
URL_YouTube |
String |
You Tube video URL |
| 32 |
URL_MAS |
String |
Make-a-Show video URL (export only) |
| 33 |
date_in_stock |
String |
The date on which the vehicle was uploaded into the inventory |
| 34 |
DealerName |
String |
Dealer's name |
| 35 |
DealerContactPerson |
String |
Dealer's contact person |
| 36 |
DealerPhone |
String |
Dealer's contact phone number |
| 37 |
DealerEmail |
String |
Dealer's e-mail |
| 38 |
DealerAddress |
Integer |
Dealer's address |
| 39 |
DealerCity |
String |
Dealer's address (City) |
| 40 |
DealerState |
String |
Dealer's address (State) |
| 41 |
DealerZIP |
Integer |
Dealer's address (ZIP code) |
| 42 |
DealerCountry |
String |
Dealer's address (Country) |
| 43 |
DealerID |
String |
The ID of the dealer |
| 44 |
DealerLOT |
String |
Dealer's LOT |
| 45 |
DealerGroup |
String |
Dealer's Group |
| 46 |
Certified |
Integer |
Whether the vehicle is certified or not (1 / 0) |
| 47 |
CategorizedOptions |
String |
Vehicle options with categories; a category is separated from an option by @ and options separated by a comma (Exterior@Black,Interior@Leather) |
| 48 |
MarketClass |
String |
e.g. 2WD Small Pickup Trucks / 4wd Sport Utility Vehicle |
| 49 |
User_price1 |
Integer |
User's (Special) Price of the vehicle |
| 50 |
User_price2 |
Integer |
User's (Special) Price of the vehicle |
| 51 |
User_price3 |
Integer |
User's (Special) Price of the vehicle |
| 52 |
Comment1 |
String |
A comment regarding the vehicle |
| 53 |
Comment2 |
String |
A comment regarding the vehicle |
| 54 |
Comment3 |
String |
A comment regarding the vehicle |
| 55 |
VIDEO_URL_1 |
String |
URL of a custom movie |
| 56 |
VIDEO_URL_2 |
String |
URL of a custom movie |
| 57 |
VIDEO_URL_3 |
String |
URL of a custom movie |
| 58 |
VehicleID |
String |
The ID of the vehicle |
| 59 |
DetailURL |
String |
The URL of the details page of the vehicle
|