BusinessPerformanceRatiosReport
Generated schema file.
Table Specific Information
Select
The connector 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 connector.
- TransactionDate supports the '=' comparison.
- ToMonth supports the '=' comparison.
- FromMonth supports the '=' comparison.
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.
使用できる値は次のとおりです。PreviousQuarter, PreviousYear, LastSixMonths, LastTwelveMonths, CustomDate | |
ToMonth | String | To Months | |
FromMonth | String | From Month | |
UseState | Boolean | UseState
デフォルト値はtrueです。 |