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).

SSIS Components for Sage 200

CustomerContacts

Table Specific Information

Select

Columns