Versions Compared

Old Version 1

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.

We need the suppliers as the first file in the import, we need to have these loaded before the products are loaded.

Notes

We expect the supplier code to be the same as the one in your finance system.

If you are using most finance systems then either contact name or company name are used to establish a link on the first connection.

Example File

Field Types

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

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

  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

Limit

Limitations

Mandatory

Code List

CL

Notes

Account

ProducerCode

[varchar](

8

10)

YES

and UNIQUE

 

Enter

This must be a unique code

for this supplier, this will be used on

. - This is also used for the product import

to identify this supplierVAT

Currency

[int]

YES

3

ISO  three digit

.

Country

[int]

YES

1

Use S for Standard VAT

See Code List

2

Use the code list - ISO 2 digit country code e.g.

USD, GBP, EUR

Country

[int]

YES

2

ISO two digit code GB, US, CH, FR

AccountNameAddressLine1

CH, GB, JP, FR

ProducerName

[varchar](50)

YES

 

Mandatory

The name of your supplier

ContactName

[varchar](50)

 

 

AddressLine2

AddressLine1

[varchar](50)

 

 

AddressLine3

AddressLine2

[varchar](50)

 

 

County

AddressLine3

[varchar](50)

 

 

Provide the

Town

in this field

PostCode

[varchar](30)

 

 

TelephoneNumber

[varchar](30)

 

 

Main Telephone number for the supplier

FaxNumber

[varchar](30)

 

 

Main fax number for the supplier

Contact

[varchar](30)

 

 

The Main Contact for the account

EmailAddress

[varchar](50)

 

 

The main email address for the supplier

WebSite

PostCode

[varchar](

50

15)

 

 

VATRegNo

[varchar](30)

 

 

ContactName

[varchar](30)

 

 

If you have a specific contact you wish to store then you can enter the specific contacts information here, this is their name

TradeContact

TelephoneNo

[varchar](

30)

 

 

An additional field if there is an alternate to the Contact name.

ContactTelephone

[varchar](

ContactFAX

20)

 

 

Specific  contact details.  Only fill if different to the main telephone

ContactEmail

FaxNumber

[varchar](20)

 

 

Specific  contact details.  Only fill if different to the main fax

EmailAddress

[varchar](50)

 

 

Specific  contact details.  Only fill if different to the main email

ContactWebSite

WebsiteAddress

[varchar](50

)

 

 

Specific  contact details.  Only fill if different to the main website, e.g. an alternative ordering portal as an example.

NominalAccount

[varchar](8)

Conditional

 

required only if posting by supplier for purchases otherwise will use the default.

CostCentre

[varchar](3

)

 

 

Optional for posting

Department

[varchar](3)

 

 

Optional for posting

IsEmailEnable

[bit]

YES

 

Send them an email when you enter a PO ?

Default will depend whether you have an email address and its in the ExportOptionEmail, if so then this should be set to 1

Otherwise set to 0

IsPrintEnable

[bit]

YES

 

Print a PO when you enter it ?

Default is 0

But if you need the paper then set this to 1

ExportOptionEmail

[varchar](150)

Yes if you are sending the Po via email

 

Is you set the ISEmailEnabled to YES then we will sent the purchase order to this email address.

So this becomes mandatory if you want to send PO via email.

What address will the PO be sent to.