Definitions

Top  Previous  Next

 

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