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 |