CustomerContacts
Information can be stored for multiple contacts against each customer account. Each contact can have its own details such as telephone numbers, fax numbers, email address and website.
Table Specific Information
Select
The driver uses the Sage 200c Standard Online API to process all search criteria.
Supported operators are: =, < , <= , > , >= , != , AND, LIKE , IS NULL , IS NOT NULL.
For example, the following queries are processed server side:
SELECT * FROM CustomerContacts WHERE Id = 42101 SELECT * FROM CustomerContacts WHERE CustomerId = '0000000001' SELECT * FROM CustomerContacts WHERE Name = 'Sample'
Columns
Name | Type | References | Description |
Id [KEY] | Long | Customer contact record Id. | |
CustomerId | Long | Customer record Id. | |
Name | String | Contact Name - Concatenated first_name, middle_name and last_name. | |
FirstName | String | Contact first name. | |
MiddleName | String | Contact middle name. | |
LastName | String | Contact surname. | |
IsDefault | Bool | Is this the default contact for the parent customer. See customer | |
DefaultTelephone | String | Default telephone number. | |
DefaultEmail | String | Default email address. | |
SalutationId | Long | Contact salutation id. | |
SalutationIsDefault | Boolean | Contact salutation. | |
SalutationCode | String | Contact salutation code. | |
SalutationDescription | String | Contact salutation description. | |
Emails | String | Customer emails. See customer_emails | |
Telephones | String | Customer telephones. See customer_telephones | |
Mobiles | String | Customer mobiles. See customer_mobiles | |
Faxes | String | Customer faxes. See customer_faxes | |
Websites | String | Customer websites. See customer_websites | |
DateTimeUpdated | Datetime | The date and time this entity was last updated (UTC). |