Field Types
| Include Page | ||||
|---|---|---|---|---|
|
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 |
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
(8,2) the total number of digits before and after the decimal point.
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 |