Field Mapping – Import Repair Order Updates

The following tables list the field mapping used when importing repair order header updates from a file.

Column names in the import file will be automatically matched to the corresponding field mapping by first looking for an exact field name match (with or without spaces), and then by looking at abbreviations and synonyms to guess at the closest match.

Field NameField Description
Repair Order NumberAn existing repair order number from 1 to 99999999. This field may not be skipped or left empty.
StatusA 1- or 2-character text string that matches an existing repair status code. If this field is skipped or is empty then the values imported as Approved Status or Refused Status may be assigned. Inventory and accounting transactions may be processed depending on the old and new status codes.
Approved StatusA 1- or 2-character text string that matches an existing repair status code. If the Status field is skipped or is empty then this value will be used for the Status, but only if the previous status was for an approved repair.
Refused StatusA 1- or 2-character text string that matches an existing repair status code. If the Status field is skipped or is empty then this value will be used for the Status, but only if the previous status was for a refused repair.
Reference 1A text string of up to 30 characters.
Reference 2A text string of up to 30 characters.
Reference 3A text string of up to 30 characters.
Reference 4A text string of up to 30 characters.
Storage BinA text string of up to 20 characters.
Ship ViaA text string of up to 40 characters.
Tracking CodeA text string of up to 30 characters.
Estimate and Repair NotesAn unlimited text string
Date Estimate Approved or RefusedA date value
How Estimate Approved or RefusedA text string of up to 20 characters
Estimated Completion DateA date value
Date Returned to CustomerA date value
Service CodeA text string of up to 30 characters. Imported values will be processed as service codes.
Package CodeA text string of up to 10 characters. Imported values will be processed as package codes.
Notes to PrintAn unlimited text string
Private NotesAn unlimited text string