Power BI Connector for Wave Financial

Build 24.0.9062

Vendors

List of vendors for the business.

Table Specific Information

The 本製品 uses the Wave Financial API to process some of the filters. The 本製品 processes other filters client-side within the 本製品. 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062