ODBC Driver for Sage 200

Build 20.0.7587

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

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