Versions Compared

Old Version 2

changes.mady.by.user Alan Gilchrist

Saved on

compared with

New Version Current

changes.mady.by.user Alan Gilchrist

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Notes

Producers or manufacturers are those who make the product which you sell and may not be who you purchase the product from, we need this before we can load the products into the system

Template Download

Some files contain example data in them, you should remove this before submitting back to us for loading.

Template / Example File

View file
nameVCImport_v3_Producer.xlsx

Some files contain example data in them, you should remove this before submitting back to us for loading.

Field Types

Key Field Information

Further Reading about field types and notes are contained in the expand sections below, expand if you need to know more details.

Expand
titleField Type Information

Field Type Information

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

Expand
titleField Notes

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)