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. |