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 Contacts
Limitations
One line one contact, but a customer can have up to 32000 contacts
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 |
|
SiteCode | nvarchar(50) | NULL | Must match to the customer import. |
CustomerCode | nvarchar(50) | NULL | Must match to the customer import. |
FirstName | nvarchar(50) | NULL | |
LastName | nvarchar(50) | NULL | |
Title | nvarchar(50) | NULL | Mr / Mrs / Miss / Ms etc… |
Phone | nvarchar(50) | NULL | |
Fax | nvarchar(50) | NULL | |
emailAddress | nvarchar(50) | NULL | |
nvarchar(50) | NULL | True / False – will this contact be a goods receipt advice contact | |
Password | nvarchar(50) | NULL | |
VCISAccess | nvarchar(50) | NULL | True / False |
VCISAdministrator | nvarchar(50) | NULL | True / False |
VCISMaintenance | nvarchar(50) | NULL | True / False |
VCISOrderAccess | nvarchar(50) | NULL | True / False |
EmailGoodsInInvoices | nvarchar(50) | NULL | True / False |
EmailGoodsOutInvoices | nvarchar(50) | NULL | True / False |
EmailStockStorageInvoices | nvarchar(50) | NULL | True / False |
EmailTransportInvoices | nvarchar(50) | NULL | True / False |