Bike Sales

Field mapping for the Custom Dealer System report

Field OrderField NameDescriptionExampleRequired?
1
FinalizeDateDate the bike deal was finalized2/14/2018YES
2FinalizeInvoiceNumberInvoice number of the finalized bike deal5855834YES
3WorksheetNumberBike deal worksheet number4005521YES
4SetupFeeSetup fees included in the bike deal0YES
5TradeAllowanceAmount given for a trade-in6374.90YES
6NewUsedIs the bike being purchased New or Used?UsedYES
7MakeMake of the bike being purchasedHarley-DavidsonYES
8BikeYearYear of the bike being purchased2017YES
9BikeModelModel of the bike being purchasedFXDLS
YES
10BikeClassClass of the bike being purchasedMYES
11VINVIN of the bike being purchased1HD1GS812HC300754
YES
12BikeColorColor of the bike being purchasedBlackYES
13OdometerOdometer reading of the bike being purchased7506YES
14BasePriceBase Price of the bike being purchased20,499YES
15CostDealer cost of the bike being purchased18,999YES
16PartsInstalledPrice of any parts included in the bike deal294.50YES
17PartsInstalledCostCost of parts included in the bike deal120YES
18PartsNonInstalledPrice of any parts included in the bike deal but NOT installed.699.95YES
19PartsNonTaxablePrice of parts included in the bike deal that are not taxable.0YES
20PartsNonTaxableCostCost of parts included in the deal that are not taxable0YES
21LaborInstalledTaxablePrice of labor for parts included in the bike deal that were installed.120YES
22LaborInstalledTaxableCostCost of labor for parts included in the bike deal that were installed.0YES
23LaborInstalledNonTaxablePrice of labor for parts included in the bike deal that were installed but NOT taxable.
0YES
24LaborInstalledTotalTotal of Taxable and non-taxable labor120YES
25LaborNonInstalledTotalPrice of labor for parts included in the bike deal that were not installed0YES
26ExtrasPrice of any extras that were included in the bike deal0YES
27CustomerSalesPersonNameName of the salesperson who sold the bikeAaron SmithYES
28CustomerFISalesPersonNameName of the F&I person on this bike dealTaylor JohnsonYES
29CustomerFirstNameCustomer's First NameDougYES
30CustomerLastNameCustomer's Last NamePedersenYES
31CustsomerAddress1Customer's Street Address1220 Lombardi Ave
YES
32CustomerAddress2Add-ons to customer's address: Apt #, Suite #, Unit #, etc.Suite 103NO
33CustomerCityCustomer's CityGreen BayYES
34CustomerStateCustomer's StateWIYES
35CustomerZipCustomer's ZIP Code54304YES
36CustomerHomePhoneCustomer's Home Phone920-555-5812YES
37CustomerMobilePhoneCustomer's Mobile Phone920-555-1212NO
38CustomerWorkPhoneCustomer's Work Phone920-569-7500
NO
39CustomerEmailCustomer's Email Addressgreenbayrules12@gmail.comNO
40CustomerBeeperPhoneThis is the field that the customer's rewards number will be entered into your DMS system.GB1212YES
41CustomerIDCustomer ID number from your DMS system.554292YES