ODBC Driver for Wave Financial

Build 23.0.8839


List of customers 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 * FROM Customers WHERE Id = 'QnVzaW5lc3M6NjE2MtYzVlMS00YzkyLTg0Y2EtNzA0ZDM4MTcyNTdlO0N1c3RvbWVyOjMyNzkyMTY1'
SELECT * FROM Customers WHERE BusinessId = 'QnVYtYzVlMS00YzkyLTg0Y2EtNzA0ZDM4MTcyNTdl'
SELECT * FROM Customers WHERE ModifiedAt > '2019-10-30 07:14:55.0' AND ModifiedAt < '2019-10-30 07:18:03.0'


Name Type References SupportedOperators Description
Id [KEY] String Unique identifier for the customer.
BusinessId String


The unique identifier for the business.
Name String Name or business name of the customer.
FirstName String First name of the principal contact.
LastName String Last name of the principal contact.
Email String Email of the principal contact.
AddressAddressLine1 String Address line 1 (Street address/PO Box/Company name).
AddressAddressLine2 String Address line 2 (Apartment/Suite/Unit/Building).
AddressCity String City/District/Suburb/Town/Village.
AddressProvinceCode String


[ISO 3166-2](https://en.wikipedia.org/wiki/ISO_3166-2) identifier.
AddressCountryCode String


Country code.
AddressPostalCode String Zip/Postal Code.
DisplayId String User defined id for the customer. Commonly referred to as Account Number.
Mobile String Mobile telephone number of the principal contact.
Phone String Telephone number of the customer.
Fax String Fax number of the customer.
TollFree String Toll-free number of the customer.
Website String Website address of the customer.
InternalNotes String Internal notes about the customer.
CurrencyCode String


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


[ISO 3166-2](https://en.wikipedia.org/wiki/ISO_3166-2) identifier.
ShippingAddressCountryCode String


Country code.
ShippingAddressPostalCode String Zip/Postal Code.
ShippingPhone String Telephone number of the customer.
ShippingInstructions String Delivery instructions for handling.
CreatedAt Datetime When the customer was created.
ModifiedAt Datetime When the customer was last modified.
IsArchived Bool Whether or not the customer is archived.

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