Task
Oversees task assignments within projects or jobs, specifying status, effort, budget, and stakeholder info for efficient tracking.
Columns
| Name | Type | ReadOnly | Description |
| Recordno [KEY] | String | False |
Unique identifier for the task record. |
| Parentkey | Int64 | False |
The identifier for the parent task, if applicable. |
| Name | String | False |
The name or title of the task. |
| Parenttaskname | String | False |
The name of the parent task, if applicable. |
| Projectkey | Int64 | False |
Unique identifier for the project to which the task belongs. |
| Projectid | String | False |
The ID of the project to which the task is associated. |
| Projectname | String | False |
The name of the project associated with the task. |
| Projectbegindate | Datetime | False |
The start date of the project associated with the task. |
| Projectenddate | Datetime | False |
The end date of the project associated with the task. |
| Customerkey | Int64 | False |
The unique identifier for the customer related to the task. |
| Customerid | String | False |
The customer ID associated with the task. |
| Customername | String | False |
The name of the customer related to the task. |
| Itemkey | Int64 | False |
The unique identifier for the item associated with the task. |
| Itemid | String | False |
The ID of the item associated with the task. |
| Itemname | String | False |
The name of the item associated with the task. |
| Pbegindate | Datetime | False |
The start date for the planned task duration. |
| Penddate | Datetime | False |
The end date for the planned task duration. |
| Abegindate | Datetime | False |
The actual start date for the task. |
| Aenddate | Datetime | False |
The actual end date for the task. |
| Budgetqty | Double | False |
The planned quantity for the task. |
| Estqty | Double | False |
The estimated quantity for the task. |
| Actualqty | Double | False |
The actual quantity for the task. |
| Remainingqty | Double | False |
The remaining quantity for the task. |
| Approvedqty | Double | False |
The approved quantity for the task. |
| Percentcomplete | Double | False |
The percentage of task completion based on the actual and planned quantities. |
| Obspercentcomplete | Double | False |
The observed percentage of task completion based on available data. |
| Description | String | False |
A detailed description of the task. |
| Ismilestone | Boolean | False |
Indicates whether the task is a milestone. |
| Utilized | Boolean | False |
Indicates whether the task has been utilized. |
| Billable | Boolean | False |
Indicates whether the task is billable. |
| Taskno | Int64 | False |
The task number identifier. |
| Priority | Int64 | False |
The priority level of the task. |
| Taskstatus | String | False |
The current status of the task. |
| Timetypekey | Int64 | False |
The identifier for the type of time associated with the task. |
| Timetypename | String | False |
The name of the time type associated with the task. |
| Classid | String | False |
The class identifier associated with the task. |
| Classname | String | False |
The name of the class associated with the task. |
| Classkey | Int64 | False |
The unique identifier for the class associated with the task. |
| Whencreated | Datetime | False |
The date and time when the task was created. |
| Whenmodified | Datetime | False |
The date and time when the task was last modified. |
| Createdby | Int64 | False |
The identifier of the user who created the task. |
| Modifiedby | Int64 | False |
The identifier of the user who last modified the task. |
| Record_url | String | False |
The URL for accessing the task record. |