BalanceSheetsReport
This report summarizes your company's assets, liabilities and equity at a specific point in time
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 本製品.
- TransactionDate supports the '=' comparison.
- ToDate supports the '=' comparison.
- FromDate supports the '=' comparison.
- CashBased supports the '=' comparison.
SELECT * FROM BalanceSheetsReport SELECT * FROM BalanceSheetsReport WHERE TransactionDate = 'Today' SELECT * FROM BalanceSheetsReport WHERE ToDate = '2022-10-31' SELECT * FROM BalanceSheetsReport WHERE FromDate = '2022-10-10' and ToDate = '2022-10-31' SELECT * FROM BalanceSheetsReport WHERE CashBased = True
Columns
Name | Type | References | SupportedOperators | Description |
BalanceTypeName | String | Balance Type Name | ||
SubBalanceTypeName | String | SubBalance Type Name | ||
AccountTransactionTypeName | String | Account Transaction Type Name | ||
SubAccountTransactionTypeName | String | Sub Account Transaction Type Name | ||
AccountTransactionTotal | Decimal | Account Transaction Total | ||
SubAccountTransactionTotal | Decimal | Sub Account Transaction Total | ||
SubBalanceTypeTotal | Decimal | SubBalance Type Total | ||
BalanceTypeTotal | Decimal | Balance Type Total |
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 | |
CashBased | Boolean | Balance Type Total | |
TransactionDate | String | Filter transaction by any transaction date.
使用できる値は次のとおりです。Today, ThisWeek, ThisMonth, ThisQuarter, ThisYear, PreviousDay, PreviousWeek, PreviousMonth, PreviousQuarter, PreviousYear and CustomDate | |
ToDate | Date | To Date | |
FromDate | Date | From Date |