List of vendors for the business.

Table Specific Information

The connector uses the Wave Financial API to process some of the filters. The connector processes other filters client-side within the connector. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause inconsistent data. For example, the following queries are processed server side.

SELECT

SELECT * FROM Vendors WHERE Id = 'QnVzaW5lc3M6NjE2MTYtYzVlMS00YzkyLTg0Y2DM4MTcyNTdl'
SELECT * FROM Vendors WHERE ModifiedAt < '2020-02-26 18:02:06.171'

Columns

Name	Type	References	SupportedOperators	Description
Id [KEY]	String			Unique identifier for the customer.
BusinessId	String	Businesses.id		The unique identifier for the business.
Name	String			Name or business name of the vendor.
AddressLine1	String			Address line 1 (Street address/PO Box/Company name).
AddressLine2	String			Address line 2 (Apartment/Suite/Unit/Building).
AddressCity	String			City/District/Suburb/Town/Village.
AddressProvinceCode	String	Provinces.Code		[ISO 3166-2](https://en.wikipedia.org/wiki/ISO_3166-2) identifier.
AddressCountryCode	String	Countries.Code		Country code.
AddressPostalCode	String			Zip/Postal Code.
FirstName	String			The first name of the principal contact.
LastName	String			The last name of the principal contact.
DisplayId	String			User defined id for the vendor. Commonly referred to as Account Number.
Email	String			Email of the principal vendor.
Mobile	String			The mobile number of the vendor.
Phone	String			The phone number of the vendor.
Fax	String			Fax number of the vendor.
TollFree	String			Toll-free number of the vendor.
Website	String			Website address of the vendor.
InternalNotes	String			Internal notes about the vendor.
CurrencyCode	String	Currencies.Code		Currency code.
ShippingName	String			Name or business name of the customer.
ShippingAddressLine1	String			Address line 1 (Street address/PO Box/Company name).
ShippingAddressLine2	String			Address line 2 (Apartment/Suite/Unit/Building).
ShippingAddressCity	String			City/District/Suburb/Town/Village.
ShippingAddressProvinceCode	String	Provinces.Code		[ISO 3166-2](https://en.wikipedia.org/wiki/ISO_3166-2) identifier.
ShippingAddressCountryCode	String	Countries.Code		Country code.
ShippingAddressPostalCode	String			Zip/Postal Code.
ShippingPhone	String			Telephone number of the customer.
ShippingInstructions	String			Delivery instructions for handling.
CreatedAt	Datetime			When the vendor was created.
ModifiedAt	Datetime			When the vendor was last modified.
IsArchived	Bool			Whether or not the vendor is archived.