BankAccounts
Retrieves list of all bank and credit card accounts for your organization.
Table Specific Information
Select
The 本製品 will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the 本製品.
- AccountId supports the '=' comparison.
- AccountCodeAccountName supports the '=' comparison.
- AccountType supports the '=' comparison.
- Status supports the '=' comparison.
SELECT * FROM BankAccounts WHERE Status = 'All'
SELECT * FROM BankAccounts WHERE AccountId = '1894343000000085314'
Columns
| Name | Type | References | SupportedOperators | Description |
| AccountId [KEY] | String | Id of the Bank Account. | ||
| AccountCode | String | Code of the Account. | ||
| AccountName | String | Name of the account. | ||
| AccountType | String | Type of the account. | ||
| Balance | Decimal | The unpaid amount. | ||
| BankBalance | Decimal | Total balance in Bank. | ||
| BankName | String | Name of the Bank. | ||
| BcyBalance | Decimal | Balance of Base Currency. | ||
| CanShowInZe | Boolean | Check if it can show in Zero Emission. | ||
| CanShowPaypalDirectIntegBanner | Boolean | Check if it can show direct integ banner. | ||
| CurrencyCode | String | Currency code of the customer's currency. | ||
| CurrencyId | String |
Currencies.CurrencyId | Currency ID of the customer's currency. | |
| CurrencySymbol | String | Currency symbol of the customer's currency. | ||
| Description | String | Description of the Account. | ||
| IsActive | Boolean | Check if bank account is active. | ||
| IsDirectPaypal | Boolean | Check if bank account is direct by paypal. | ||
| PricePrecision | Integer | The precision for the price. | ||
| TotalUnprintedChecks | Integer | Total number of unprinted checks. | ||
| UncategorizedTransactions | Integer | Number of uncategorized transactions. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| Status | String | Filter bills by any status.
使用できる値は次のとおりです。All, PartiallyPaid, Paid, Overdue, Void, Open |