ProjectPerformanceSummaryReport
Generated schema file.
Table Specific Information
Select
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.
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 |