TrialBalanceReport
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 TrialBalanceReport SELECT * FROM TrialBalanceReport WHERE TransactionDate = 'Today' SELECT * FROM TrialBalanceReport WHERE ToDate = '2022-10-31' SELECT * FROM TrialBalanceReport WHERE FromDate = '2022-10-10' and ToDate = '2022-10-31' SELECT * FROM TrialBalanceReport WHERE CashBased = True
Columns
Name | Type | References | SupportedOperators | Description |
BalanceTypeName | String | Balance Type Name | ||
SubBalanceTypeName | String | Sub Balance Type Name | ||
AccountTransactionTypeName | String | Account Transaction Type Name | ||
AccountTransactionCreditTotal | Decimal | Credit Total | ||
AccountTransactionDebitTotal | Decimal | Debit Total | ||
SubAccountCreditTotal | Decimal | Sub Account Credit Total | ||
SubAccountDebitTotal | Decimal | Sub Account Debit Total | ||
CreditTotal | Decimal | Account Transaction Type Credit Total | ||
DebitTotal | Decimal | Account Transaction Type Debit 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 | Cash Based | |
TransactionDate | String | Filter transaction by any transaction date.
使用できる値は次のとおりです。Today, ThisWeek, ThisMonth, ThisQuarter, ThisYear, PreviousDay, PreviousWeek, PreviousMonth, PreviousQuarter, PreviousYear and CustomDate | |
ToDate | Date | ToDate | |
FromDate | Date | FromDate |