ProfitsAndLossesReport
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 ProfitsAndLossesReport SELECT * FROM ProfitsAndLossesReport WHERE TransactionDate = 'Today' SELECT * FROM ProfitsAndLossesReport WHERE ToDate = '2022-10-31' SELECT * FROM ProfitsAndLossesReport WHERE FromDate = '2022-10-10' and ToDate = '2022-10-31' SELECT * FROM ProfitsAndLossesReport 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 | ||
AccountTransactionTotal | Decimal | Account Transaction Total | ||
BalanceTypeTotal | Decimal | Balance Type Total | ||
SubBalanceTypeTotal | Decimal | Sub 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 | It has value either true or false | |
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 |