SSIS Components for Sage 200

Build 20.0.7587

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

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587