Service Sales
Last Modified on 08/03/2018 12:08 pm CDT
Field mapping for the Custom Dealer System report
| Field Order | Field Name | Description | Example | Required? |
1
| CashierDate | The date the service was cashiered | 1/1/2018 | YES
|
| 2 | RONumber | Repair Order Number | 306504 | YES
|
| 3 | JobID | Job ID Number | 5917446504277140
| YES
|
| 4 | JobTitle | Title of the job | Check Alarm | YES
|
| 5 | JobDesc | Detailed description of the job | Alarm will not shut off | YES
|
| 6 | TotalPartsSellingPrice | Total price of parts sold for this job | 120 | YES
|
| 7 | PartsAfterDisc | Discounts applied to parts sold for this job | 50 | YES
|
| 8 | TotalLaborSellingPrice | Total cost of labor for this job | 350 | YES
|
| 9 | LaborAfterDisc | Discounts applied to labor for this job | 0 | YES
|
| 10 | JobWarranty | Is this a warranty job? True/False | TRUE | YES
|
| 11 | Notes | This field is normally blank |
| NO |
| 12 | RONotes | Notes for this repair order | Customer has to disconnect battery for the alarm to shut off. | NO |
| 13 | ServiceWriterName | The name of the service writer for this repair order. | John Smith | YES
|
| 14 | MajorUnitID | ID number of the bike for this repair order | U319418
| YES
|
| 15 | VIN | VIN number of the bike being repaired on this order. | 1HD1KBM36GB675217
| YES
|
| 16 | Year | Year of the bike being repaired on this order. | 1980 | YES
|
| 17 | Make | Make of the bike being repaired on this order. | Harley-Davidson | YES
|
| 18 | BikeModel | Model of the bike being repaired on this order. | FXDB | YES
|
| 19 | Odometer | Odometer reading of the bike being repaired on this order. | 500000
| YES
|
| 20 | CustomerCity | Customer's city | Temecula | YES
|
| 21 | CustomerState | Customer's State | CA | YES
|
| 22 | CustomerZip | Customer's ZIP code | 92593 | YES
|
| 23 | CustomerAddress1 | Customer's Street Address | | YES
|
| 24 | CustomerAddress2 | Add-ons to customer's address: Apt #, Suite #, Unit #, etc. | Apt 1125 | NO |
| 25 | CustomerFirstName | Customer's First Name | John | YES
|
| 26 | CustomerLastName | Customer's Last Name | Smith | YES
|
| 27 | CustomerHomePhone | Customer's Home Phone | 951-555-8873 | YES
|
| 28 | CustomerMobilePhone | Customer's Mobile Phone | 951-555-8854 | NO |
| 29 | CustomerEmail | Customer's Email Address | JSmith25@gmail.com | NO |
| 30 | CustomerBeeperPhone | This is the field in your DMS that the reward number gets entered into. | AA1234 | NO |
| 31 | CustomerID | Customer's ID number from your DMS. | 5618965 | YES
|