projecttask
The projecttask table.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | Internal ID | |
| actualwork | Double | Actual Work | |
| constrainttype | String | Constraint Type | |
| contact | String | Contact | |
| enddate | Date | End Date | |
| enddatebaseline | Date | End Date Baseline | |
| estimatedwork | Double | Estimated Work | |
| estimatedworkbaseline | Double | Estimated Work Baseline | |
| eventid | Integer | Project Task ID | |
| externalid | String | External ID | |
| finishbydate | Date | Finish No Later Than | |
| ismilestone | Boolean | Milestone | |
| issummarytask | Boolean | Summary Task | |
| message | String | Comments | |
| nonbillabletask | Boolean | Non-billable | |
| owner | String | Created By | |
| parent | String | Parent Task | |
| percenttimecomplete | Double | Percent Complete | |
| priority | String | Priority | |
| project | String | Job | |
| remainingwork | Double | Remaining Work | |
| startdatebaseline | Date | Start Date Baseline | |
| startdatetime | Date | Start Date | |
| status | String | Status | |
| title | String | Name |