JDBC Driver for Zoho Books

Build 22.0.8479


Generated schema file.

Table Specific Information


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 本製品.

  • BillingType supports the '=, !=' comparison.
  • ProjectId supports the 'IN, NOT IN' comparison.
  • CustomerId supports the 'IN, NOT IN' comparison.
  • Status supports the '=' comparison.
For example:
    SELECT * FROM ProjectPerformanceSummaryReport

	SELECT * FROM ProjectPerformanceSummaryReport WHERE Status='active'
	SELECT * FROM ProjectPerformanceSummaryReport WHERE CustomerId IN ('3285934000000104002')
	SELECT * FROM ProjectPerformanceSummaryReport WHERE ProjectId IN ('3285934000000312337')
	SELECT * FROM ProjectPerformanceSummaryReport WHERE BillingType != 'based_on_staff_hours'


Name Type References SupportedOperators Description
ActualCostAmount Integer Actual Cost Amount
ActualRevenueAmountBcy Integer Actual Revenue AmountBcy
ActualRevenueAmountFcy Integer Actual Revenue AmountFcy
BudgetedCostAmount Integer Budgeted Cost Amount
BudgetedRevenueAmount Integer Budgeted Revenue Amount
CustomerName String Customer Name
Description String Description
DifferenceInCostAmount Integer Difference In Cost Amount
DifferenceInCostPercentage Integer Difference In Cost Percentage
DifferenceInRevenueAmount Integer Difference In Revenue Amount
DifferenceInRevenuePercentage Integer Difference In Revenue Percentage
ProfitAmount Integer Profit Amount
ProfitMargin String Profit Margin
ProfitPercentage String Profit Percentage
ProjectName String Project Name
Status String = Status

使用できる値は次のとおりです。active, inactive

ProjectId String IN, NOT IN Project Id
CustomerId String IN, NOT IN Customer Id
BillingType String =, != Billing Type

使用できる値は次のとおりです。based_on_staff_hours, based_on_project_hours, fixed_cost_for_project, based_on_task_hours

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479