Field Types
Data Type | Data Code | Description | Example Data |
|---|---|---|---|
Alpha | A | Alpha Only, no numeric allowed at all, must only be characters. | BLUE |
Alpha Numeric Also known as | AN | Stores alphanumeric combinations and text. No symbols or other characters allowed with some basic exceptions which are dot,comma, colon, ampersand. | Bytesize 1234 |
String | ST | String is really a group of characters stored together as one it can contain numbers, letters and symbols. | Hello World ! [2023] |
Bit | B | Boolean data types are very straightforward. A Boolean data type is simply something that only has two possible values, true or false. The computer will store true as a 1 and false as a 0. | Y or N 0 or 1 |
Character | CH | Stores a single character which can be a letter, number or symbol | £ |
Currency | CU | Same as decimal but to 2dp is required | 17.01 |
Date | DT | dd/mm/yy or dd/mm/yyyy | 18/05/18 |
Decimal | DC | Stores numbers that contain decimal places/values and can also store integers known as REAL, SINGLE, DOUBLE or FLOAT instead. | 17.65665 |
EMl | Should be standard email format containing the @ | ||
Integer | IN | Stores positive or negative whole numbers | 17 |
Numeric | N | Numbers only, including phone numbers | 01324 722663 |
Time | TM | hh:mm | 11:00 |
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 |