AVV Vehicles Inventory Data Feed
Format: Comma Delimited With Double Quote Text Qualifier
Schema:
| Field Title | Data Type | Field Width |
|---|
| Vendor_ID |
varchar |
50 |
| Status |
char |
1 |
| New_Used |
char |
1 |
| StockNo |
varchar |
50 |
| VIN |
varchar |
17 |
| Tag_Number |
varchar |
30 |
| Tag_State |
varchar |
2 |
| Make |
varchar |
50 |
| Model |
varchar |
100 |
| Series |
varchar |
100 |
| Model_Number |
varchar |
50 |
| Year |
int |
|
| List_Price |
int |
|
| Internet_Price |
int |
|
| MSRP |
int |
|
| Invoice_Price |
int |
|
| Mileage |
int |
|
| Exterior_Color |
varchar |
100 |
| Interior_Color |
varchar |
100 |
| Style |
varchar |
50 |
| Body_Style |
varchar |
50 |
| Doors |
int |
|
| Engine_Size_L |
decimal 3 |
|
| Cylinders |
varchar |
10 |
| Restraint |
varchar |
300 |
| Image_File_Name |
varchar |
50 |
| Date_In_Stock |
datetime |
|
| Additional_Text |
varchar |
1000 |
| Options_Text |
varchar |
4000 |
| 12PS |
bit |
|
| 15PS |
bit |
|
| 5PS |
bit |
|
| 6PS |
bit |
|
| 7PS |
bit |
|
| 8PS |
bit |
|
| 9PS |
bit |
|
| AC |
bit |
|
| AFS |
bit |
|
| AL |
bit |
|
| AM |
bit |
|
| AS |
bit |
|
| AW |
bit |
|
| ABS |
bit |
|
| AT |
bit |
|
| BIS |
bit |
|
| BL |
bit |
|
| BNH |
bit |
|
| BS |
bit |
|
| BSM |
bit |
|
| CAR |
bit |
|
| CBG |
bit |
|
| CDC |
bit |
|
| CLK |
bit |
|
| CON |
bit |
|
| CP |
bit |
|
| CPT |
bit |
|
| CSL |
bit |
|
| CTH |
bit |
|
| CUC |
bit |
|
| CA |
bit |
|
| CD |
bit |
|
| CC |
bit |
|
| DB |
bit |
|
| DCC |
bit |
|
| DD |
bit |
|
| DRW |
bit |
|
| DSD |
bit |
|
| DVD |
bit |
|
| FL |
bit |
|
| FLM |
bit |
|
| FT |
bit |
|
| 4SP |
bit |
|
| 4WD |
bit |
|
| 5SP |
bit |
|
| FWD |
bit |
|
| GG |
bit |
|
| GP |
bit |
|
| GPS |
bit |
|
| HS |
bit |
|
| KE |
bit |
|
| LEA |
bit |
|
| LR |
bit |
|
| M |
bit |
|
| NVS |
bit |
|
| ORT |
bit |
|
| OSS |
bit |
|
| PA |
bit |
|
| PB |
bit |
|
| PDS |
bit |
|
| PL |
bit |
|
| PM |
bit |
|
| PMR |
bit |
|
| PPS |
bit |
|
| PRW |
bit |
|
| PS |
bit |
|
| PW |
bit |
|
| QCC |
bit |
|
| QS |
bit |
|
| RAC |
bit |
|
| RAL |
bit |
|
| RAR |
bit |
|
| RB |
bit |
|
| RD |
bit |
|
| RF |
bit |
|
| RLR |
bit |
|
| RR |
bit |
|
| RS |
bit |
|
| RSH |
bit |
|
| RT |
bit |
|
| RTM |
bit |
|
| RW |
bit |
|
| SB |
bit |
|
| SBL |
bit |
|
| SDR |
bit |
|
| SP |
bit |
|
| SPR |
bit |
|
| SRD |
bit |
|
| SSD |
bit |
|
| SS |
bit |
|
| SR |
bit |
|
| SRL |
bit |
|
| SRW |
bit |
|
| TG |
bit |
|
| TT |
bit |
|
| TP |
bit |
|
| TO |
bit |
|
| TB |
bit |
|
| TC |
bit |
|
| TCR |
bit |
|
| TR |
bit |
|
| TS |
bit |
|
| TV |
bit |
|
| UB |
bit |
|
| VCP |
bit |
|
| VR |
bit |
|
| VS |
bit |
|
| WA |
bit |
|
| WB |
bit |
|
| WC |
bit |
|
| WD |
bit |
|
| ACC |
bit |
|
| ALD |
bit |
|
| APO |
bit |
|
| BKH |
bit |
|
| CPS |
bit |
|
| CSC |
bit |
|
| DAB |
bit |
|
| DCL |
bit |
|
| DMS |
bit |
|
| DRL |
bit |
|
| FDB |
bit |
|
| HAB |
bit |
|
| HFS |
bit |
|
| HRS |
bit |
|
| HSM |
bit |
|
| INW |
bit |
|
| LGB |
bit |
|
| LMS |
bit |
|
| OFP |
bit |
|
| PAB |
bit |
|
| PMS |
bit |
|
| PSR |
bit |
|
| RDB |
bit |
|
| RED |
bit |
|
| RFD |
bit |
|
| RTR |
bit |
|
| SAB |
bit |
|
| SPC |
bit |
|
| SSC |
bit |
|
| STB |
bit |
|
| STP |
bit |
|
| TEL |
bit |
|
| TPC |
bit |
|
| TOH |
bit |
|
| TTP |
bit |
|
| TUR |
bit |
|
| XHL |
bit |
|
| ZCC |
bit |
|
Options Table:
The table has descriptions for option columns for the AVV Datafeed.
| OptionsColumnName |
Description |
| 12PS |
12 Passenger Seating |
| 15PS |
15 Passenger Seating |
| 5PS |
5 Passenger Seating |
| 6PS |
6 Passenger Seating |
| 7PS |
7 Passenger Seating |
| 8PS |
8 Passenger Seating |
| 9PS |
9 Passenger Seating |
| AC |
Air Conditioning |
| ACC |
Auto Climate Control |
| AFS |
AM/FM Stereo |
| AL |
Security System |
| ALD |
All Wheel Drive |
| AM |
AM Stereo |
| APO |
Adiditional Power Outlet(s) |
| AS |
Accent Stripes |
| AW |
Alloy Wheels |
| ABS |
Anti-Lock Brakes |
| AT |
Automatic Transmission |
| BIS |
Built in Sink |
| BKH |
Block Heater |
| BL |
Bed Liner |
| BNH |
Bench Seat |
| BS |
Bucket Seats |
| BSM |
Body Side Molding |
| CAR |
Center Arm Rest |
| CBG |
Complete Body Glass |
| CDC |
Compact Disk Changer |
| CLK |
Clock |
| CON |
Conversion Package |
| CP |
Integrated Cell Phone |
| CPS |
Compass |
| CPT |
Custom Paint |
| CSC |
Captain's Chairs |
| CSL |
Console |
| CTH |
Cloth Seats |
| CUC |
Certified Used Car |
| CA |
Cassette |
| CD |
Compact Disk Player |
| CC |
Cruise Control |
| DAB |
Driver Air Bag |
| DB |
Dump Box |
| DCC |
Dual Captains Chairs |
| DCL |
Dual Climate Control |
| DD |
Digital Dash |
| DMS |
Driver Memory Seat |
| DRL |
Daytime Running Lights |
| DRW |
Dual Rear Wheels |
| DSD |
Dual Sliding Doors |
| DVD |
DVD Player |
| FDB |
Front Disc Brakes |
| FL |
Fog/Driving Lamps |
| FLM |
Floor Mats |
| FT |
FiberGlass Topper |
| 4SP |
4 Speed Manual Transmission |
| 4WD |
4 Wheel Drive |
| 5SP |
5 Speed Manual Transmission |
| FWD |
Front Wheel Drive |
| GG |
Grill Guard |
| GP |
Graphics Package |
| GPS |
GPS Navigation System |
| HAB |
Head Air Bags |
| HFS |
Heated Front Seats |
| HRS |
Heated Rear Seats |
| HS |
Heated Seats |
| HSM |
Heated Side Mirrors |
| INW |
Intermittent Wipers |
| KE |
Keyless Entry |
| LEA |
Leather Seats |
| LGB |
Long Bed |
| LMS |
Lumbar Support |
| LR |
Luggage Rack |
| M |
Manual Transmission |
| NVS |
Night Vision System |
| OFP |
Off Road Package |
| ORT |
On/Off Road Tires |
| OSS |
OnStar System |
| PA |
Power Antenna |
| PAB |
Passenger Air Bag |
| PB |
Power Brakes |
| PDS |
Power Drivers Seat |
| PL |
Power Locks |
| PM |
Power Mirrors |
| PMR |
Power Moon Roof |
| PMS |
Passenger Memory Seat |
| PPS |
Power Passenger Seat |
| PRW |
Premium Wheels |
| PS |
Power Steering |
| PSR |
Power Sunroof |
| PW |
Power Windows |
| QCC |
Quad Captains Chairs |
| QS |
Quad Seating |
| RAC |
Rear Air Conditioning |
| RAL |
Roof Access Ladder |
| RAR |
Rear Arm Rest |
| RB |
Running Boards |
| RD |
Rear Defrost |
| RDB |
Rear Disc Brakes |
| RED |
Remote Entry (door panel) |
| RF |
Refrigerator |
| RFD |
Remote Fuel Door |
| RLR |
Roof Luggage Rack |
| RR |
Raised Roof |
| RS |
Rear Stereo |
| RSH |
Rear Shoulder Harness |
| RT |
Removeable Top |
| RTM |
Rear Tire Mount |
| RTR |
Remote Trunk Release |
| RW |
Rear Wiper |
| SAB |
Side Air Bags |
| SB |
Split Bench Seat |
| SBL |
Sofa/Bed Lounge |
| SDR |
Sliding Side Door |
| SP |
Snow Plow |
| SPC |
SuperCharged |
| SPR |
Spoiler |
| SRD |
Swing-Out Rear Doors |
| SSC |
Steering Wheel Stereo Controls |
| SSD |
Swing-Out Side Doors |
| SS |
Sports Suspension |
| SR |
Sunroof |
| SRL |
Side Rails |
| SRW |
Sliding Rear Window |
| STB |
Short Bed |
| STP |
Step Side |
| TEL |
Telescopic Wheel |
| TG |
Tinted Glass |
| TT |
T-Top |
| TP |
Towing Package |
| TPC |
Trip Computer |
| TO |
Trip Odometer |
| TOH |
Tow Hitch |
| TB |
Tool Box |
| TC |
Traction Control |
| TCR |
Tonneau Cover |
| TR |
Trunk Rack |
| TS |
Tilt Steering |
| TTP |
Two Tone Paint |
| TUR |
Turbo |
| TV |
Television |
| UB |
Utility Box |
| VCP |
Video Cassette Player |
| VR |
Vinyl Roof |
| VS |
Vinyl Seats |
| WA |
Warranty |
| WB |
Window Blinds |
| WC |
Window Curtains |
| WD |
Wind Deflector |
| XHL |
Xenon Headlights |
| ZCC |
Zone Climate Control |
© Copyright 2008 Dominion Enterprises