Parts Sales

Last Modified on 08/03/2018 12:08 pm CDT

Field mapping for the Custom Dealer System report

Field OrderField NameDescriptionExampleRequired?
1
InvoiceDateThe date the item was purchased.1/1/2018YES
2InvoiceNumberInvoiceNumber306504YES
3CustomerBeeperPhoneThis is the field in your DMS that the reward number gets entered into.
AA1234NO
4PartNumberPart Number of the item sold49002-98YES
5PartDescDetailed description of the item soldKit, Adjustable Highway PegYES
6QuantitySoldQuantity of this item sold to the customer on this invoice.1YES
7QuantityPickedUpQuantity of this item the customer picked up1YES
8CostDealership's cost for this item97.42YES
9TotalCostCost multiplied by quantity sold.97.42YES
10RetailPriceRetail price of the item sold149.95YES
11TotalRetailPriceRetail price multiplied by quantity sold149.95YES
12ActualPriceThe price the customer paid for the item including any discounts.125.00YES
13TotalActualPriceActualPrice multiplied by the quantity sold125.00YES
14SpecialOrderWas this a special order part? True/FalseFALSEYES
15CustomerFirstName
Customer's First NameJohnYES
16CustomerLastNameCustomer's Last NameSmithYES
17CustomerAddress1Customer's Street Address
30182 HERITAGE ST
YES
18CustomerAddress2Add-ons to customer's address: Apt #, Suite #, Unit #, etc.Apt 1125NO
19CustomerCityCustomer's CityTemeculaYES
20CustomerStateCustomer's StateCAYES
21CustomerZip
Customer's ZIP Code95134YES
22CustomerHomePhoneCustomer's Home Phone951-555-8873YES
23CustomerMobilePhoneCustomer's Mobile Phone951-555-8854NO
24CustomerWorkPhoneCustomer's Work Phone951-888-4512NO
25CustomerEmailCustomer's Email AddressJSmith25@gmail.comNO
26CashierNameName of the cashier who sold this itemSally SmithYES
27CustomerIDCustomer's ID number from your DMS.5618965YES
28CategoryCodeSale category codeHDPYES
About this Article
  • Created: 02/14/2018 1:58 pm CST
  • Last updated: 08/03/2018 12:08 pm CDT
Related Articles
Most Popular
Newest
Recently Updated
Copyright © 2015 – 2018 Your Company, LLC. All rights reserved.