AVV

ADS - Overview

• Home
• About ADS
• Products
• Contact
• AVV Homepage

Extraction Information

• Export Examples
  • Inventory
    • Details
  • Sales
  • Maintenance History
• DMS Fields
• Spelling Lists
• More Information
• Downloads

Sales Schema One

Title: Sales Schema One

Format: Comma Delimited

Basic Information: This comma delimited quote qualified file is exported to your ftp site from our database every weekday. It contains your dealerships' sales data with a header row to allow you to examine the data easier. Dealerships can get their data to AVV in many different ways; AVV can dial into their DMS systems (if it meets our criteria), the dealer can e-mail us their data, or they can send the data to us via FTP. All of these methods are processed on a basis determined in your contract.

Example:

"UniqueID","ContactFirstName","ContactLastName","Address","City","StateOrProvince","PostalCode","HomePhone","WorkPhone","Email","SaleDate","Veh_Stock_Number","VIN","Veh_Make","Model_Identification","Series_Identification","Veh_Year","Veh_Price","Type","PurchaseType","PurchaseTerm"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/7/2000","23123","1G3WH52H7YF175678","Oldsmobile","Intrigue","GX","2000","23070","N","P","48"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/11/2000","23464B","1G3HY54C8JW419922","Oldsmobile","Delta 88","Royale Brghm","1988","4000","U","P","0"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/6/2000","23451","1G3WS52HXYF349325","Oldsmobile","Intrigue","GL","2000","26235","N","P","0"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/7/2000","23429","1G3NL12E1YC428147","Oldsmobile","Alero","GL","2000","20910","N","P","0"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/7/2000","23398","1G3WH52H7YF317866","Oldsmobile","Intrigue","GX","2000","23255","N","P","36
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/14/2000","200163","JF1SF63581H733472","Subaru","Forester","L","2001","22170","N","P",""
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/11/2000","23558","1G3NF52E61C104308","Oldsmobile","Alero","GLS","2001","23615","N","P","0"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/11/2000","23535A","1G6KD54Y6VU257256","Cadillac","DeVille","","1997","19587","U","P","0"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/11/2000","23562","1G3GS64C414131829","Oldsmobile","Aurora","4","2001","38054","N","P","36"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/12/2000","23466","1G3WS52H4YF309144","Oldsmobile","Intrigue","GL","2000","26735","N","P","60"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/12/2000","2030","4S3BD6759W7201798","Subaru","Legacy","","1998","20481","U","P","0"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/12/2000","2064","1FAFP53U2XG239526","Ford","Taurus","","1999","16258","U","P","0"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/12/2000","2062","1FALP66L1TK121194","Ford","Contour","","1996","12073","U","P","0"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/11/2000","200141B","WBADK8307H9710913","BMW","528","E","1987","4000","U","P","0"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/11/2000","23123A","1FAPP6249PH111239","Ford","Thunderbird","LX","1993","7524","U","P","0"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/8/2000","23435A","1ZVLT20A9R5147231","Ford","Probe","SE","1994","6420","U","P","0"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/12/2000","2117","1G3HN52K0T4833505","Oldsmobile","88","LS","1996","0","U","P","0"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/12/2000","200182","4S3BH686417617925","Subaru","Legacy","Outback LTD","2001","27590","N","P","60"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/13/2000","8454A","1J4FJ58SXML548998","Jeep","Cherokee","Laredo","1991","5920","U","P","0"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/13/2000","23162","1G3NL52E9YC353625","Oldsmobile","Alero","GL","2000","20475","D","P","0"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/13/2000","10479","JS2GB41S9Y5182303","Suzuki","Esteem","","2000","15545","N","P","0"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/14/2000","2076","1FMEU18W8VLB92648","Ford","Expedition","","1997","24290","U","P","60"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/13/2000","8491","JF1GF4858YH810189","Subaru","IMPREZA OUTBACK SPT 4WD  ","","2000","20752","N","P","60"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/13/2000","200123","JF1GC67501H500176","Subaru","Impreza","RS","2001","21895","N","P","48"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/14/2000","23577","1G3NL52E01C119685","Oldsmobile","Alero","GL","2001","21210","N","P","60"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/14/2000","23161","1G3WS52H7YF201052","Oldsmobile","Intrigue","GL","2000","26545","N","P","0"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/13/2000","23535B","1P4GH4433RX380664","Plymouth","Grand Voyager","SE","1994","4000","U","P","0"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/13/2000","23466A","1G2NE14N5NC234468","Pontiac","Grand AM","SE","1992","4000","U","P","0"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/14/2000","200174","JF1SF65581H736594","Subaru","Forester","S","2001","25003","N","P",""
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/6/2000","300003","2S3TA52C7Y6102351","Suzuki","Vitara","JLX","2000","18445","N","P","48"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/8/2000","2097","1G2NW12M1WC704603","Pontiac","Grand AM","GT","1998","15955","U","P","0"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/9/2000","23464A","1G2JB12T5V7540250","Pontiac","Sunfire","SE","1997","9216","U","P","60"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/9/2000","23218","1G3WH52H1YF203457","Oldsmobile","Intrigue","GX","2000","23645","D","P","60"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/9/2000","200025A","1FAFP68G9WK285231","Ford","Contour","SVT","1998","16986","U","P","0"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/9/2000","200141A","4S3BD6753W7203353","Subaru","Legacy","","1998","18021","U","P","60"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/14/2000","","1FMZU73E2YZB38394","Ford","Expedition","","1997","0","U","",""
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/14/2000","5518","1FTNW21FX1EA05035","Ford","F250","Super Duty","2001","0","N","P","60"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/14/2000","1265","1FTYR14VXYPA11305","Ford","Ranger","Super","2000","40700","U","L","48"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/14/2000","5503","1FAFP58S1YG286815","Ford","Taurus","SE","2000","0","N","P","60"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/11/2000","M0713","JH4DB7653YS003710","Acura","Integra","LS","2000","21380","N","L","0"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/11/2000","M1092","JH4KA9658YC014640","Acura","RL","3.5","2000","0","N","P","0"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/11/2000","36145A","4S2CK58E8V4343891","Isuzu","Rodeo","S","1997","0","U","P","60"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/13/2000","36187","JACDJ58X3Y7J17960","Isuzu","Trooper","","2000","29470","N","P","60"
"139","Doe","John","123 NoWhere ln","MONTGOMERY","IL","60538","630-859-0376","630-111-2222","","9/11/2000","166320A","4S2CK58E7V4351464","Isuzu","Rodeo","S","1997","0","U","P","60"

Sales Schema 1 | Sales Schema 2