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