Chart of Accounts 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 Accounts WHERE Id = 'QWNjb3VudDo4MDEyMDg4OD3MWUwYWYtZDZiZS00OGI3LWE1ZTAtNmYyNzU4N2IwNGNi'
SELECT * FROM Accounts WHERE BusinessId = 'QnVzaW5lc3M6MDU3MWUwYWYtZDZiZS00OGI3LWE1ZTAtNmYyNzU4N2IwNGNi'
SELECT * FROM Accounts WHERE Name = 'Accounting Fees'
SELECT * FROM Accounts WHERE TypeValue = 'EXPENSE'
SELECT * FROM Accounts WHERE SubtypeValue = 'CASH_AND_BANK'
SELECT * FROM Accounts WHERE IsArchived = true
SELECT * FROM Accounts WHERE TypeValue IN ('EXPENSE', 'LIABILITY')
SELECT * FROM Accounts WHERE SubtypeValue IN ('COST_OF_GOODS_SOLD', 'EXPENSE')

Columns

Name	Type	References	SupportedOperators	Description
Id [KEY]	String			Unique identifier for the account.
BusinessId	String	Businesses.id		The unique identifier for the business.
Name	String			Name of the account.
Description	String			User defined description for the account.
DisplayId	String			User defined id for the account.
CurrencyCode	String	Currencies.Code		Currency code.
TypeValue	String			Account type value.
SubtypeValue	String			Account subtype value.
NormalBalanceType	String			Credit or Debit.
IsArchived	Bool			Indicates whether the account is hidden from view by default.
Sequence	Int			Numerically increasing version, each representing a revision of account data. As soon as something modifies an account, its sequence is incremented.
Balance	Decimal			The balance of the account as of the current date.
BalanceInBusinessCurrency	Decimal			The balance of the account as of the current date in the business currency.