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