`Project` table

Column Type

Column	Type
`Project_Id`	`String`
`Project_Name`	`String`
`Customer_Id`	`String`
`Customer_Name`	`String`
`Currency_Code`	`String`
`Description`	`String`
`Status`	`String`
`Billing_Type`	`String`
`Rate`	`Number`
`Budget_Type`	`String`
`Total_Hours`	`String`
`Total_Amount`	`Number`
`Billed_Hours`	`String`
`Billed_Amount`	`Number`
`Un_Billed_Hours`	`String`
`Un_Billed_Amount`	`Number`
`Billable_Hours`	`String`
`Billable_Amount`	`Number`
`Non_Billable_Hours`	`String`
`Cost_Budget_Amount`	`Number`
`Is_Recurrence_Associated`	`String`
`Created_Time`	`Timestamp`
`Last_Modified_Time`	`Timestamp`
`Show_In_Dashboard`	`Boolean`
`Project_Head_Id`	`String`
`Unused_Retainer_Payments`	`Number`
`Budget_Amount`	`Number`
`Customer_Email`	`String`
`Created_By_Id`	`String`
`Budget_Threshold`	`Number`
`Is_From_Zoho_Projects`	`Boolean`
`Currency_Id`	`String`
`Project_Code`	`String`
`Customer_Vat_Treatment`	`String`
`Customer_First_Name`	`String`
`Hours_Per_Day`	`String`
`Photo_Url`	`String`
`Billing_Rate_Frequency`	`String`
`Is_Budget_Threshold_Notification_Enabled`	`Boolean`
`Is_Client_Approval_Needed`	`Boolean`
`Zohoworkerly_Project_Id`	`String`
`Is_User_Approval_Needed`	`Boolean`
`Project_Head_Name`	`String`
`Is_Valid_Project_Head`	`Boolean`
`Budget_Threshold_Formatted`	`String`
`Is_Expense_Inclusive`	`Number`
`Total_Amount_Expense_Inclusive`	`String`
`Last_Modified_By_Id`	`String`
`Non_Billable_Amount`	`Number`
`Is_From_Zoho_People`	`Boolean`
`Has_Active_Recurring_Profiles`	`Boolean`
`Zohopeople_Project_Id`	`String`
`Can_Be_Invoiced`	`Boolean`
`Other_Service_App_Source`	`String`
`Has_Attachment`	`Boolean`
`Users_Working`	`Number`
`Recurring_Invoices`	`String`
`Tasks`	`Array`
`Users`	`Array`
`Documents`	`Array`
`Accounts_Budgets`	`Array`

Project_Id

String

Project_Name

String

Customer_Id

String

Customer_Name

String

Currency_Code

String

Description

String

Status

String

Billing_Type

String

Rate

Number

Budget_Type

String

Total_Hours

String

Total_Amount

Number

Billed_Hours

String

Billed_Amount

Number

Un_Billed_Hours

String

Un_Billed_Amount

Number

Billable_Hours

String

Billable_Amount

Number

Non_Billable_Hours

String

Cost_Budget_Amount

Number

Is_Recurrence_Associated

String

Created_Time

Timestamp

Last_Modified_Time

Timestamp

Show_In_Dashboard

Boolean

Project_Head_Id

String

Unused_Retainer_Payments

Number

Budget_Amount

Number

Customer_Email

String

Created_By_Id

String

Budget_Threshold

Number

Is_From_Zoho_Projects

Boolean

Currency_Id

String

Project_Code

String

Customer_Vat_Treatment

String

Customer_First_Name

String

Hours_Per_Day

String

Photo_Url

String

Billing_Rate_Frequency

String

Is_Budget_Threshold_Notification_Enabled

Boolean

Is_Client_Approval_Needed

Boolean

Zohoworkerly_Project_Id

String

Is_User_Approval_Needed

Boolean

Project_Head_Name

String

Is_Valid_Project_Head

Boolean

Budget_Threshold_Formatted

String

Is_Expense_Inclusive

Number

Total_Amount_Expense_Inclusive

String

Last_Modified_By_Id

String

Non_Billable_Amount

Number

Is_From_Zoho_People

Boolean

Has_Active_Recurring_Profiles

Boolean

Zohopeople_Project_Id

String

Can_Be_Invoiced

Boolean

Other_Service_App_Source

String

Has_Attachment

Boolean

Users_Working

Number

Recurring_Invoices

String

Tasks

Array

Users

Array

Documents

Array

Accounts_Budgets

Array

Examples

INSERT INTO Project (Project_Name, Customer_Id, Currency_Id, Billing_Rate_Frequency, Billing_Type, Rate, Description) VALUES ('PROJ-00002' , '579676000000093092' , '579676000000000059' , 'hourly' , 'based_on_project_hours' , '99.99' , 'Create Zoho Books API Examples')
UPDATE Project SET Rate=110 WHERE Project_Id='579676000000151003'
DELETE FROM Project WHERE Project_Id='579676000000151003'

Project table

Examples

`Project` table