BusinessPerformanceRatiosReport
Generated schema file.
Table Specific Information
Select
The component uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:
- TransactionDate supports the '=' comparison.
- ToMonth supports the '=' comparison.
- FromMonth supports the '=' comparison.
The rest of the filter is executed client-side in the component.
For example:
SELECT * FROM businessperformanceratiosreport
SELECT * FROM businessperformanceratiosreport WHERE TransactionDate = 'PreviousQuarter'
SELECT * FROM businessperformanceratiosreport WHERE TransactionDate = 'CustomDate' and FromMonth = '2022-10' and ToMonth = '2022-11'
Columns
| Name | Type | References | SupportedOperators | Description |
| DashboardMonth | String | DashboardMonth | ||
| Denominator | Integer | Denominator | ||
| DiffLastQuarter | Double | DiffLastQuarter | ||
| DiffLastSixMonths | Double | DiffLastSixMonths | ||
| DiffLastTwelveMonths | Double | DiffLastTwelveMonths | ||
| DiffLastYear | Double | DiffLastYear | ||
| LastQuarter | Integer | LastQuarter | ||
| LastSixMonths | Double | LastSixMonths | ||
| LastTwelveMonths | Double | LastTwelveMonths | ||
| LastYear | Double | LastYear | ||
| Numerator | Integer | Numerator | ||
| PreLastQuarter | Double | PreLastQuarter | ||
| PreLastSixMonths | Double | PreLastSixMonths | ||
| PreLastTwelveMonths | Double | PreLastTwelveMonths | ||
| PreLastYear | Double | PreLastYear | ||
| PreviousValues | String | PreviousValues | ||
| Ratio | Integer | Ratio | ||
| RatioPrev | Integer | RatioPrev |
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 | |
| TransactionDate | String | Filter transaction by any transaction date.
The allowed values are PreviousQuarter, PreviousYear, LastSixMonths, LastTwelveMonths, CustomDate. | |
| ToMonth | String | To Months | |
| FromMonth | String | From Month | |
| UseState | Boolean | UseState
The default value is true. |