Please note that although the definitions for the import files (if you are going to create them) are listed below, Onyx can use all manner of different files and will attempt to ‘map’ the data as intelligently as possible, please also note that not all fields are required.
Customers Definition
Title
|
Type
|
Max Length
|
Account Name
|
Text (if blank Onyx will create Account Names automatically)
|
25
|
Title
|
Text
|
10
|
Forenames
|
Text
|
60
|
Surname
|
Text
|
60
|
Company Name
|
Text
|
60
|
Address 1
|
Text
|
60
|
Address 2
|
Text
|
60
|
Address 3
|
Text
|
60
|
City
|
Text
|
60
|
County
|
Text
|
60
|
Postcode
|
Text
|
10
|
Home Tel
|
Text
|
25
|
Work Tel
|
Text
|
25
|
Mobile Tel
|
Text
|
25
|
Email Address
|
Text
|
60
|
Accepts Email
|
Boolean (Yes / No)
|
n/a
|
Accepts Email Adverts
|
Boolean (Yes / No)
|
n/a
|
Cash Only
|
Boolean (Yes / No)
|
n/a
|
Credit Term Days
|
Integer (whole number)
|
n/a
|
Default Discount
|
Float (percentage with decimal precision)
|
n/a
|
Insurance
|
Boolean (Yes / No)
|
n/a
|
Comments
|
Text
|
No limit
|
Stopped
|
Boolean (Yes / No)
|
n/a
|
Credit Limit
|
Currency
|
n/a
|
Parts (Simple, i.e. No stock monitoring) Definition
Title
|
Type
|
Max Length
|
Part Number
|
Text
|
30
|
Barcode
|
Text
|
20 (optional)
|
Description
|
Text
|
1500
|
Tax Type
|
Text
|
n/a (Select from the VAT descriptions that you already have in Onyx, for example Parts, Service, MOT etc) Optional, default will be used if not supplied
|
Retail
|
Currency
|
|
Retail A
|
Currency
|
Optional
|
Retail B
|
Currency
|
Optional
|
Retail C
|
Currency
|
Optional
|
Net Cost
|
Currency
|
Optional
|
Nominal Code
|
Text
|
(Select from the Nominal Codes in Onyx, use the code, i.e. 4000), optional, a default will be used if not supplied
|
Purchase Nominal Code
|
Text
|
As nominal code (optional, a default will be used if not supplied)
|
Department
|
Text
|
(Select from the departments already in Onyx), optional, a default will be used if not supplied
|
Replace By
|
Text
|
30, the part number of the part that will be selected in place of this part
|
Stock (these are in addition to the Parts definition)
Title
|
Type
|
Max Length
|
Supplier
|
Text
|
Select from existing suppliers in Onyx, optional, default will be used if not supplied
|
Current Stock
|
Float (can be fractional)
|
n/a
|
Reorder Level
|
Float (can be fractional)
|
n/a
|
Net Cost
|
Currency
|
n/a
|
Supplier Part Number
|
Text
|
30, optional, Part Number will be used if not supplied
|
Location
|
Text
|
60
|
Restockable
|
Boolean (Yes / No)
|
n/a
|
Alarm Level
|
Float (can be fractional)
|
n/a
|
Max Stock
|
Float (can be fractional)
|
n/a
|
Sub Category
|
Text
|
Select from existing categories in Onyx (Optional, default used if not supplied)
|
Exclude from Alarm
|
True/False
|
Optional, will default to false if not supplied
|
Vehicle Definition
Title
|
Type
|
Max Length
|
Registration
|
Text
|
25
|
Make
|
Text
|
30
|
Model
|
Text
|
30
|
First Registered
|
Date
|
n/a
|
Engine Size
|
Integer (Whole number)
|
n/a
|
Colour
|
Text
|
20
|
Fuel Type
|
Text
|
20
|
Mileage
|
Integer (Whole number)
|
n/a
|
MOT Number
|
Text
|
20
|
Service Due
|
Date
|
n/a
|
MOT Due
|
Date
|
n/a
|
Comments
|
Text
|
No limit
|
Linked to Acc Name*
|
Text
|
40
|
*If onyx finds an account with this name it will create a link between the account and the vehicle
|