ADS - Overview

Home
About ADS
Products
Contact
AVV Homepage

Extraction Information

Export Examples
DMS Fields
Spelling Lists
More Information
Downloads

DMS Fields


This page contains data about the specific fields we pull from your DMS. Click below to jump directly where you would like, or scroll through the screen to browse all the options.





ADP Inventory

ADP Field Description
   
STOCK-NO. Vehicle Stock Number
SERIAL Vehicle VIN Number (17 digits)
YR Vehicle Year
MAKE Vehicle Make
MODEL Vehicle Model
MODEL-NO. Vehicle Model Number (Code)
COLOR Vehicle Exterior Color
INT-COLOR Vehicle Interior Color
FIELD26 or MILEAGE Vehicle Mileage
RETAIL or LIST Vehicle List Price
BALANCE or COST Vehicle Invoice Price
TRANS Transmission Type (A or M)
OPTIONS Vehicle Option Codes
STOCK-TYPE Vehicle Type (N or U)
Return To Top






















ADP Sales

ADP Field Description
   
BUYER-NAME Customer Full Name
BUYER-NUMBER Customer Number
E-MAIL ADDRESS 1 Customer Email Address
BUYER-BIRTH-DATE Customer Date of Birth
STREET Customer Address
CITY Customer City
ST Customer State
ZIP Customer Zip Code
PHONE Customer Home (evening) Phone Number
BUS.-PHONE Customer Work (day) Phone Number
SOLD Date of Sale
MAKE Vehicle Make
MODEL Vehicle Model
YEAR Vehicle Year
NEW/USED Vehicle Stock Type (N or U)
VEHICLE-STOCK-NO Vehicle Stock Number
SERIAL-NO Vehicle VIN Number (17 digits)
VEHICLE - PRICE1 Sale Price of Vehicle
VEHICLE - PRICE2 Invoice Price of Vehicle
TOTAL COMM/DEALER Total Gross Profit From Sale
FRNT END GRS Front End Gross Profit From Sale
BACK END GRS Back End Gross Profit From Sale
DLR FINANCE RESERVE Dealer Finance Reserve From Sale
M.B.I./DEALER COMM. Service Contract Reserve From Sale
CR-LIFE COMM/DEALER    Credit&Life Reserve From Sale
A&H INS/DEALER COMM Accident&Health Reserve From Sale
TERM Term of Sale
DEAL TYPE Type of Sale (L or P)
SALESMAN Full name of salesman
SALESPERSON NO. 1 Salesman Number
DEAL-NO DMS Reference Number of Sale
STATUS Status of Deal
Return To Top






















Reynolds & Reynolds Inventory

Reynolds Field Description
   
STOCK NO Vehicle Stock Number
SERIAL# Vehicle VIN Number (17 digits)
YEAR Vehicle Year
MAKE Vehicle Make
CARLINE Vehicle Model
MODEL Vehicle Model Number (Code)
EXT CLR CD or COLOR Vehicle Exterior Color
INT CLR CD Vehicle Interior Color
MILES Vehicle Mileage
LST PRICE Vehicle List Price
INVOICE$ Vehicle Invoice Price
LOCATION Vehicle Location
F-ACC Factory Accessory Codes (option codes)
Return To Top























Reynolds & Reynolds Sales

Reynolds Field Name Description
   
NAME Customer Full Name
FIRST NAME Customer First Name
CUST NO Customer Number
LAST NAME Customer Last Name
BYR ADDRESS Customer Address
BYR CITY Customer City
B ST Customer State
B ZIP Customer Zip Code
BYR HOME PHONE Customer Home (evening) Phone Number
BYR WORK PHONE Customer Work (day) Phone Number
DEAL DTE Date of Sale
MAKE Vehicle Make
CARLINE Vehicle Model
YEAR Vehicle Year
N/U/O Vehicle Stock Type (N or U)
STOCK NO Vehicle Stock Number
SERIAL# Vehicle VIN Number (17 digits)
PRICE Sale Price of Vehicle
COST OF VEH Invoice Price of Vehicle
GROS PFT Total Gross Profit From Sale
GROS PYBL Front End Gross Profit From Sale
TOT F&I RES Back End Gross Profit From Sale
FIN RES Dealer Finance Reserve From Sale
SVC CONT RES Service Contract Reserve From Sale
LIFE RESERVE Credit&Life Reserve From Sale
AH RESERVE Accident&Health Reserve From Sale
TERM Term of Sale
TY Type of Sale (L or P)
SLSM 1 NAME Full Name of Salesman
SLSM 1 NO. Salesman Number
DEAL # DMS Reference Number of Sale
STAT Status of Deal
Return To Top


© Copyright 2008 Dominion Enterprises