SupplierContacts

Information can be stored for multiple contacts against each Supplier 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 SupplierContacts WHERE Id = 42101
SELECT * FROM SupplierContacts WHERE SupplierId = 325434364565
SELECT * FROM SupplierContacts WHERE FirstName = 'Sample'

Columns


Name	Type	References	Description
Id [KEY]	Long		Supplier contact record Id.
SupplierId	Long		Supplier 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 Supplier. See Supplier
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		Supplier emails. See Supplier_emails
Telephones	String		Supplier telephones. See Supplier_telephones
Mobiles	String		Supplier mobiles. See Supplier_mobiles
Faxes	String		Supplier faxes. See Supplier_faxes
Websites	String		Supplier websites. See Supplier_websites
DateTimeUpdated	Datetime		The date and time this entity was last updated (UTC).

JDBC Driver for Sage 200

SupplierContacts

Table Specific Information

Select

Columns