Import - Customer Deferments
- Alan Gilchrist
Field Types
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 |
Â
Â
Copyright Ontech Solutions 2017-2024. All rights reserved, no part may be replicated or distributed without the express permission of the owner.