Field Types
Field Type | Explanantion |
|---|---|
int | integer fields |
bit | Yes or No fields 1 for Yes and 0 for No |
date | format dd/mm/yy or dd/mm/yyyy |
nvarchar (11) | text field with maximum length 11 |
decimal (8,2) | Decimal field must include the decimal and 00 e.g 42.00 17.00 18.43 26.40 |
Use
Customers Deferments, one deferment is needed per HMRC approval, or per cash customer
Cash customer is a customer who can use a W5 or will put their deferment liabilities onto the warehouse account.
Limitations
Notes
This import originated from an older system so some of the fields are not relevant but remain as part of the standard import tables.
Fields
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 |