Power BI Connector for Wave Financial

Build 24.0.9062

Accounts

Chart of Accounts 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 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.

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