CData Python Connector for Zoho Books

Build 20.0.7740

Projects

Retrieves list of projects.

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

  • ProjectId supports the '=' comparison.
  • CustomerId supports the '=' comparison.
  • Status supports the '=' comparison.
For example:
    SELECT * FROM Projects WHERE CustomerId = '1894553000000078233' AND ProjectId = '1894553000000078363'

    SELECT * FROM Projects WHERE Status = 'Active'

Columns

Name Type References SupportedOperators Description
ProjectId [KEY] String Id of the project.
ProjectName String Name of the project.
Rate Decimal Hourly rate for a task.
Status String Status of the project.

使用できる値は次のとおりです。All, Active, Inactive

BillableHours String Total number of billable hours.
BillingType String Type of billing.
CanBeInvoiced Boolean Check if the projecy can be invoiced.
CreatedTime Datetime Time at which the project was created.
CustomerId String

Contacts.ContactId

ID of the customer or vendor. Search projects by customer id.
CustomerName String Name of the customer or vendor.
Description String Description of the projects
HasAttachment Boolean Check if the projects has attachment.
OtherServiceAppSource String Source of other service app.
TotalHours String Total hours spent in the project.
ShowInDashboard Boolean Check if the project can be shown in dashboard. This field will be populated with a value only when the Id is specified.
ProjectHeadId String ID of the project head. This field will be populated with a value only when the Id is specified.
ProjectHeadName String Name of the project head. This field will be populated with a value only when the Id is specified.
BillableAmount Decimal Amount which is billable for this project. This field will be populated with a value only when the Id is specified.
BilledAmount Decimal Total amount which was billed for the project. This field will be populated with a value only when the Id is specified.
BilledHours String Total number of billed hours. This field will be populated with a value only when the Id is specified.
BudgetThreshold Decimal To determine how much money to allocate to the reserve fund each fiscal year. This field will be populated with a value only when the Id is specified.
BudgetType String Type of budget. This field will be populated with a value only when the Id is specified.
CurrencyCode String Code of currency used in the project. This field will be populated with a value only when the Id is specified.
IsBudgetThresholdNotificationEnabled Boolean Check if the budget threshold notification is enabled or not. This field will be populated with a value only when the Id is specified.
IsClientApprovalNeeded Boolean Check if the client approval is needed. This field will be populated with a value only when the Id is specified.
IsExpenseInclusive Integer Check if the expense is inclusive in the project. This field will be populated with a value only when the Id is specified.
IsUserApprovalNeeded Boolean Check if the user approval is needed. This field will be populated with a value only when the Id is specified.
IsValidProjectHead Boolean Check if the project has valid project head. This field will be populated with a value only when the Id is specified.
NonBillableAmount Decimal Amount which are non billable for the project.. This field will be populated with a value only when the Id is specified.
NonBillableHours String Hours which are non billable for the project. This field will be populated with a value only when the Id is specified.
TotalAmount Decimal Total amount for the project. This field will be populated with a value only when the Id is specified.
TotalAmountExpenseInclusive Decimal Total amount for the project including the project. This field will be populated with a value only when the Id is specified.
UnBilledAmount Decimal Total amount unbilled for the project. This field will be populated with a value only when the Id is specified.
UnBilledHours String Total number of unbilled hours. This field will be populated with a value only when the Id is specified.
UnusedRetainerPayments Decimal Payment of the project which is unused. This field will be populated with a value only when the Id is specified.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7740