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
|
Description
|
Text
|
1500
|
Vat Type
|
Text
|
n/a (Select from the VAT descriptions that you already have in Onyx, for example Parts, Service, MOT etc)
|
Retail
|
Currency
|
n/a
|
Parts Definition
Title
|
Type
|
Max Length
|
Part Number
|
Text
|
30
|
Barcode
|
Text
|
20
|
Description
|
Text
|
1500
|
Vat Type
|
Text
|
n/a (Select from the VAT descriptions that you already have in Onyx, for example Parts, Service, MOT etc)
|
Retail
|
Currency
|
n/a
|
Supplier
|
Text
|
255
|
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
|
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
|
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
|