ProjectTask
Create, update, delete, and query the ProjectTask module in SugarCRM.
Columns
| Name | Type | ReadOnly | Description |
| Team_Id | String | False |
The Id of the primary team. |
| Team_Set_Id | String | False |
The Id of the team set. |
| Team_Count | String | False |
The count of the team set. |
| Team_Name | String | False |
The name of the primary team. |
| Id [KEY] | String | False |
The unique identifier of the project task. |
| Date_Entered | Datetime | False |
The date the project task was entered. |
| Date_Modified | Datetime | False |
The date the project task was modified. |
| Project_Id | String | False |
The Id of the project associated with the task. |
| Project_Task_Id | Int | False |
The Id of the project task. |
| Name | String | False |
The name of the project task. |
| Status | String | False |
The status of the project task. |
| Description | String | False |
The full text of the note. |
| Resource_Id | String | False |
The Id of the associated resource. |
| Resource_Name | String | False |
The name of the associated resource. |
| Predecessors | String | False |
The predecessors of the project task. |
| Date_Start | Datetime | False |
The start date of the project task. |
| Time_Start | Int | False |
The start time of the project task. |
| Time_Finish | Int | False |
The finish time of the project task. |
| Date_Finish | Datetime | False |
The finish date of the project task. |
| Duration | Int | False |
The duration of the project task. |
| Duration_Unit | String | False |
The duration unit of the project task. |
| Actual_Duration | Int | False |
The actual duration of the project task. |
| Percent_Complete | Int | False |
The percent that the project task is complete. |
| Date_Due | Datetime | False |
The due date of the project task. |
| Time_Due | String | False |
The time the project task is due. |
| Parent_Task_Id | Int | False |
The Id of the parent task. |
| Assigned_User_Id | String | False |
The Id of the user assigned to the project task. |
| Modified_User_Id | String | False |
The Id of the user who last modified the project task. |
| Modified_By_Name | String | False |
The user name of the user who last modified the project task. |
| Priority | String | False |
The priority of the project task. |
| Created_By | String | False |
The Id of the user who created the project task. |
| Created_By_Name | String | False |
The user name of the user who created the project task. |
| Milestone_Flag | Bool | False |
The name of the project task. |
| Order_Number | Int | False |
The order number of the project task. |
| Task_Number | Int | False |
The task number of the project task. |
| Estimated_Effort | Int | False |
The estimated effort of the project task. |
| Actual_Effort | Int | False |
The actual effort of the project task. |
| Deleted | Bool | False |
Whether the project task is deleted. |
| Utilization | Int | False |
The utilization of the project task. |
| Project_Name | String | False |
The name of the project task. |
| Assigned_User_Name | String | False |
The user name of the user assigned to the project task. |