BusinessPerformanceRatiosReport
Generated schema file.
Table Specific Information
Select
The add-in 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 add-in.
For example:
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. |