ID | NVARCHAR | Project identifier (key) |
Version | NVARCHAR | Record version |
ProjectCode | NVARCHAR | Code |
ProjectIcon | NVARCHAR | Icon |
ProjectIconColor | NVARCHAR | Color |
IntegrationID | NVARCHAR | External ID |
StartDate | DATE | Start date |
EndDate | DATE | End date |
Documentation_F | NVARCHAR(1) | Whether the "Documentation" module is enabled |
Discussion_F | NVARCHAR(1) | Whether the "Discussion" module is enabled |
Attachments_F | NVARCHAR(1) | Whether attachments are enabled |
Timesheet_F | NVARCHAR(1) | Whether time tracking is enabled |
Subtasks_F | NVARCHAR(1) | Whether subtasks are enabled |
Watchers_F | NVARCHAR(1) | Whether watchers are enabled |
OutsideSubtasks_F | NVARCHAR(1) | Whether subtasks in other projects are allowed |
OutsideWatchers_F | NVARCHAR(1) | Whether watchers outside the project are allowed |
NoOverEstimate_F | NVARCHAR(1) | Prohibition on exceeding the estimate |
HomePageURL | NVARCHAR | URL of the project home page |
HiddenMembers_F | NVARCHAR(1) | Hide members from external users |
uAssignee_F, uReporter_F, uDueDate_F, uEstimate_F, uLabel_F, uComponent_F, uVersion_F, uEmptyWorklog_F | NVARCHAR(1) | Required-field flags for creation/logging |
Text, DueDateOffset, Estimate, Label, Component, FixVersion | various | "Default" values for new tasks |
OpenPeriodDays | INTEGER | How many days back time can be logged |
MaximumHoursDay | DECIMAL | Maximum hours per user per day |
PriorityID, StatusID, TypeID | NVARCHAR | Defaults for new tasks |
StartTextWith | NVARCHAR | Prefix for auto-generated titles |
ProjectSchemeID | NVARCHAR | Linked workflow scheme |
AssigneeID, ReporterID | NVARCHAR | Default assignee and reporter |
ProjectCategoryID | NVARCHAR | Category |
ProjectTypeID | NVARCHAR | Project type |
ProjectCompanyID | NVARCHAR | Owner company |
ProjectLineOfBusinessID | NVARCHAR | Line of business |
ProjectOrgUnitID | NVARCHAR | Org unit |
ProjectCustomerID | NVARCHAR | Customer |
ProjectAccountID | NVARCHAR | Account/cost center |
ProjectPMID | NVARCHAR | Project manager |
Language | NVARCHAR | Language |