TaxSummaryReport
This report summarizes your company's assets, liabilities and equity at a specific point in time.
Table Specific Information
Select
The connector uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:
- ToDate supports the '=' comparison.
- FromDate supports the '=' comparison.
The rest of the filter is executed client-side in the connector.
For example:
SELECT * FROM TaxSummaryReport WHERE ToDate = '2022-10-31'
SELECT * FROM TaxSummaryReport WHERE FromDate = '2022-10-10' AND ToDate = '2022-10-31'
Columns
| Name | Type | References | SupportedOperators | Description |
| InputTaxAccountId | Long | Input Tax Account Id. | ||
| IsTaxAccount | Boolean | Is Tax Account. | ||
| IsValueAdded | Boolean | Is Value Added. | ||
| OutputTaxAccountId | Long | Output Tax Account Id. | ||
| TaxAmount | String | Tax Amount. | ||
| TaxId | Long | Tax Id. | ||
| TaxName | String | Tax Name. | ||
| TaxPercentage | String | Tax Percentage. | ||
| TransactionAmount | String | Transaction Amount. |
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 | |
| ToDate | Date | To Date. | |
| FromDate | Date | From Date. |