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)
...
| Include Page |
|---|
...
|
Use
Customers Contacts
Limitations
...
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 |