Field Name

Field Type

Length

Mandatory

Notes

CustomerCode

nvarchar

8

YES

Unique customer code (needs to be unique for the entire site.

CustomerName

nvarchar

50

YES

Address1

nvarchar

50

YES

Street Number and name

Address2

nvarchar

50

YES

Building Name

Address3

nvarchar

50

YES

Locality

Address4

nvarchar

50

YES

Town

Postcode

nvarchar

10

YES

VATNo

nvarchar

20

Do not prefix with the country. If the customer has a WOWGR then the VAT No cannot be empty.

Must be a valid VAT number, if the customer doesn’t have one then leave empty, do not set to anything else such as PR.

VATOffice

nvarchar

50

NULL

DEFERNo

nvarchar

10

CONDITIONAL

If the customer doesn’t have their own deferment and uses the warehouse’s instead, enter 7x zeros, 0000000.  Otherwise enter the deferment number

If not an excise customer then leave empty.

VATonInvoices

int

Options available are
0 - No

1 - Std Rate Sales Tax

MinRent

decimal

8.2

Value as 0.00

RHDNominal

nvarchar

20

Finance system nominals

RentNominal

nvarchar

20

Finance system nominals

InsuranceNominal

nvarchar

20

Finance system nominals

WarrantNominal

nvarchar

20

Finance system nominals

MiscellaneousNominal

nvarchar

20

Finance system nominals

ReserveCustomerAccounts

bit

YES

Do you have Reserve account

DeliveryNotes

bit

Yes

Does this customer have their OWN customized delivery notes

DefermentAgreement

bit

Yes

Does this customer have HMRC deferment agreement

TelephoneNo

nvarchar

30

FaxNo

nvarchar

30

CustomerContact

nvarchar

50

YES

Main Contact name for the account.
other contacts are elsewhere

CustomsDuty

nvarchar

YES

If the customer doesn’t have their own deferment and uses the warehouse’s instead, enter 7x zeros, 0000000.  Otherwise enter the deferment number

If not an excise customer then leave empty.

SageAccountsCode

nvarchar(50)

CONDITIONAL

Finance System Accounts code.

Only specify is NOT the same as the account code.

DefaultLocation

nvarchar

20

Provide a warehouse unique ID where this customer is based.
You provided this along with the warehouse locations in the earlier stages of configuration.

When customers transfer to each other if this is the same then transfers can take place with no need to move stock, if they are in different default locations then movement of stock is always required.

MinimumRHD

nvarchar(

Per Invoice min charge.
Would not apply to prorate QTR / Annual

DirectRepresentation

nvarchar

Redundant, leave empty, please use FKDeclarant instead.

FaxContactName

nvarchar

No longer used

GoodsReceivedContact

nvarchar

Redundant, leave empty, please see the Customer Contact import instead

DeliveryNLCode

nvarchar

HandleNLCode

nvarchar

ExcludeBulkPick

nvarchar

Redundant, leave empty, please use BulkPickOption instead.

VATRegistered

nvarchar

TURNNumber

nvarchar

Now called the EORI

RPARegistrationNo

nvarchar

SupervisingOffice

nvarchar

WOWGRRegistrationNumber

nvarchar

If the customer has a WOWGR then the VAT No cannot be empty

Country

nvarchar

ISO 3166 alpha-2 code required

SiteCode

nvarchar

Must be one of the pre-agreed site codes

Email

nvarchar

Main contact email (single valid email address only)

CreditLimit

nvarchar

FKCustomsDuty

nvarchar

Options are

1 – Day each time an order is placed

2 – Day on arrival

3 – Pay on first use

4 – Pay on arrival only if preference or quota

5 – Pay on first use only if preference or quote.

FKDeclarant

nvarchar

Enter a number, Options are:

1 = Declarant, 2 = Direct Representative, 3 = Indirect Representative

UseBatchOrdering

bit

YES

if this customer wants to order using the batch reference fields (this is different to the rotation number)

IsBondedCustomer

bit

YES

Will store excise or customs applicable goods ?

CanSplitReceiptLines

bit

YES

suggest NO for HMRC warehouse (especially for ARC’s)

IsByLineCharging

bit

YES

if No then charging can be per load for goods received

UseAutoPutAway

bit

YES

IsDPOrderInvoicing

bit

YES

specified whether additional delivery point invoicing module is being operated.

OrderByLayer

bit

YES

IncludeUnallocatedOrders

bit

YES

stock availability should include

UseStandardPrinter

bit

YES

default would be Y, only use No where specialist printing is being used

SendStockLossEmail

bit

YES

UseMasterProductTable

bit

YES

Will this customer supply their own product codes, if not then can the system product table be used (this requires a link to LWIN)

CanStoreFreeCirculationStock

bit

YES

If they can store NON free circulation stock

“Yes” they can or “No” they cannot (all has to be customs duty paid).

SendDespatchConfirmationSummary

bit

YES

SendDeliveryConfirmationEmail

bit

YES

SendDeliveryIssueEmail

bit

YES

SendDailyDeliverySchedule

bit

YES

SendBookingDelayedEmail

bit

YES

FKVATCode

nvarcha

Set this to S for standard vatable customer or Z for non vatable.

FKPickingOrder

nvarchar

Provide a number, default is 1 – FIFO:

• Options are 1 - FIFO, 2 - CFIFO, 3 - PFIFO, 4 - PCFIFO

StandardOrderCharge

nvarchar

Value would be 0.00

DedicatedPrinterName

nvarchar

No longer used

DedicatedPrinterIPAddress

nvarchar

Not used

DedicatedPrinterQueueName

nvarchar

Not Used

NominalCode

nvarchar

Default fall back nominal – usually posting suspense

UsesPallets

bit

YES

Customer uses pallets as their default ordering, so provide information for pallets to them on VCIS

BulkPickOption

bit

Will this customer use Bulk pick (just used to highlight those customers)

OrderPassword

nvarchar

30

Enter a password

For private customers – order security

ResCert

Not available

TransportMasterCustomerCode

Specify a master charge account if charges are being grouped automatically for deliveries

TransportMasterSiteCode

Specify a master charge account if charges are being grouped automatically for deliveries

ReceiptAdviceSendOption

Enter a number, options:

1 – Yes after each receipt

2 – Ask each time you receipt stock

3 – never (usually customer using goods in EDI)

VCISAccessDefault_to_PrivateSite

bit

Will this customer use the private site template – only available if specified

FixedProductDimensionOnReceipt

bit

Set this to Yes unless you are really sure you want to use this.

Allows products to have stock SPC different to products SPC

IncludeOrderLineDetailsInBulkPickNote

bit

AutoReceiptTransfersToMyself

bit

CompanyWebsiteURL

SecondGRLabel

bit

UsesUniqueRotations

bit

FKInvoicePeriod

This is the point when the invoice is raised.  Enter a number, choices are:

6 = Daily, 7 = Weekly, 8 = Monthly, 9 = Quarterly, 10 = Annually, 11 = Period (where it’s not fixed like the earlier period types)

ConditionReportCharge

Value 0.00

PalletCharge

Pallet charge for goods in

LooseItemCharge

Value 0.00

RotationQtyBandedStorage

bit

MarketValueReportCharge

Value 0.00

CreatedDateTime

Created Date and Time

AccountsFrozen

bit

Currency_Default

Currency Code (eg. GBP)

CustomerFrozen

bit

Deleted

bit

DespatchAdviceSendOption

Numeric Value

DespatchesNeedSSCC

bit

DutyPaidUse

bit

DutyRepresentative

Duty Representative ID

ExportOrderToBM

bit

IsCRChargePerCase

bit

LegalType

Enter a Number (optional)

     1 – Individual

     2 - Business

MinRent

Minimum Storage Value (decimal value)

NextStorageRateReview

Date of Next Storage Rate Review

NonStockHolding

bit

OutstandingDebt

Decimal Value

RotationStockBy

Value can be any of the following

        DateReceived

        ProductCode

        ProductDescription

        RotationNo

UseCertificates

bit

UseCFSP

bit

UsesInvoiceOptions

bit

VCISChargedAsEDIOrder

bit

GDPROption

int

1

No

Can be NULL

If used value can be any of the following (optional)

        1 - Anonymous

        2 - Forgotten

PIICheckLastSent

Date

PIILastVerified

Date

PIICheckLastSent_UserLogin

User ID

PIILastVerifiedBy

User ID

AWRSURN

GenerateDespatchSpecialMessages

bit

GenerateDespatchProductNotes

bit