Notes
Example File
Some files contain example data in them, you should remove this before submitting back to us for loading.
Field Types
Name | Description |
BIT | 0 is NO / 1 is YES - BIT fields must have an entry and can not be blank |
Varchar(50) | Is an alpha numeric field of length 50, this can accept letters, number and symbols |
INT | Is a single number field (no decimals) e.g. 1,2,3,4,5 - Fields marked as INT must have an entry |
DECIMAL (8,5) | Is a decimal field which can contain 8 before and 5 after the .dot separator |
Field Notes
Default will be used unless you enter something in a field marked as DEFAULT
The CL column indicates the code list that this list can be found in within the document.
Mandatory fields are marked on the excel spreadsheets and in RED below
The field names in the import document can not be changed as these are used for matching.
Data Field Definition
Name | Type and Limitations | Mandatory | CL | Notes |
ProducerCode | [varchar](10) | YES and UNIQUE |
| This must be a unique code. - This is also used for the product import. |
Country | [int] | YES | 2 | Use the code list - ISO 2 digit country code e.g. CH, GB, JP, FR |
ProducerName | [varchar](50) | YES |
| |
ContactName | [varchar](50) |
|
| |
AddressLine1 | [varchar](50) |
|
| |
AddressLine2 | [varchar](50) |
|
| |
AddressLine3 | [varchar](50) |
|
| |
Town | [varchar](50) |
|
| |
PostCode | [varchar](15) |
|
| |
TelephoneNo | [varchar](20) |
|
| |
FaxNumber | [varchar](20) |
|
| |
EmailAddress | [varchar](50) |
|
| |
WebsiteAddress | [varchar](50) |
|
| |
|
|
|
|
|