ProjectPerformanceSummaryReport
Generated schema file.
Table Specific Information
Select
The 本製品 uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:
- BillingType supports the '=, !=' comparison.
- ProjectId supports the 'IN, NOT IN' comparison.
- CustomerId supports the 'IN, NOT IN' comparison.
- Status supports the '=' comparison.
The rest of the filter is executed client-side in the 本製品
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'
Columns
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 |