Field Name

Field Type

Nulls

Notes

DeferedNumber

nvarchar(50)

NULL

HMRC deferment number, leave blank if cash or warehouse pays customer

ExciseDuty

nvarchar(50)

NULL

Limit in 0.00

CustomsDuty

nvarchar(50)

NULL

Limit in 0.00

VATCode

nvarchar(50)

NULL

Normally this is always S – Standard

If anything other than this please speak to Ontech first.

HolderName

nvarchar(50)

NULL

HolderAddress1

nvarchar(50)

NULL

HolderAddress2

nvarchar(50)

NULL

HolderAddress3

nvarchar(50)

NULL

HolderAddress4

nvarchar(50)

NULL

HolderPostcode

nvarchar(50)

NULL

VATNumber

nvarchar(50)

NULL

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

Authorisation

nvarchar(50)

NULL

TurnNumber

nvarchar(50)

NULL

Annex7LetterReceived

nvarchar(50)

NULL

true / false (case sensitive!)

C1207NFormReceived

nvarchar(50)

NULL

true / false (case sensitive!)

CashDeferment

nvarchar(50)

NULL

True / False

ExciseLimit

nvarchar(50)

NULL

The excise duty limit for the deferment, monetary value

CustomsDutyLimit

nvarchar(50)

NULL

The customs duty limit for the deferment, monetary value

EmailAddress

nvarchar(50)

NULL

For the duty and vat

SageAccountCode

nvarchar(50)

NULL

Needed if posting to the finance system

WOWGRRegistration

nvarchar(50)

NULL

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

Surcharge

nvarchar(50)

NULL

% surcharge, only applicable for cash deferment customers (customers without their own deferment account)

DeferedLimit

nvarchar(50)

NULL

The excise duty limit for the deferment, monetary value

DefermentOnHold

nvarchar(50)

NULL

True / False

DirectDebit

nvarchar(50)

NULL

True / False

Nominal

nvarchar(50)

NULL

SiteCode

nvarchar(50)

NOT NULL

Must be one of the pre-agreed site codes