Lookups

Related objects

Reference collections returned by the Projects service.

ProjectCategories

Project categories.

Field	Type	Description
`CategoryID`	NVARCHAR	Identifier
`CategoryText`	NVARCHAR	Name
`CategoryIcon`	NVARCHAR	Icon
`CategoryIconColor`	NVARCHAR	Color

ProjectTypes

Project types.

Field	Type	Description
`TypeID`	NVARCHAR(10)	Identifier
`TypeText`	NVARCHAR	Name
`TypeIcon`	NVARCHAR	Icon
`TypeIconColor`	NVARCHAR	Color

ProjectSchemes

Workflow schemes. When creating or updating a project, the scheme is identified by one of the keys — see operations Create and Update.

Field	Type	Description
`WorkFlowID`	NVARCHAR	Scheme identifier (internal)
`PartnerCode`	NVARCHAR	Scheme code
`IntegrationID`	NVARCHAR	External ID
`WorkFlowText`	NVARCHAR	Name

Customers

Customers (partners in the customer role).

Field	Type	Description
`CustomerID`	NVARCHAR(10)	Identifier
`CustomerText`	NVARCHAR	Name
`IntegrationID`	NVARCHAR	External ID

Companies

Internal companies.

Field	Type	Description
`CompanyID`	NVARCHAR(10)	Identifier
`CompanyText`	NVARCHAR	Name
`IntegrationID`	NVARCHAR	External ID

Accounts

Accounts (cost centers).

Field	Type	Description
`AccountID`	NVARCHAR(10)	Identifier
`AccountText`	NVARCHAR	Name
`IntegrationID`	NVARCHAR	External ID

LineOfBusinesses

Lines of business.

Field	Type	Description
`LineOfBusinessID`	NVARCHAR(10)	Identifier
`LineOfBusinessText`	NVARCHAR	Name
`LineOfBusinessIcon`	NVARCHAR	Icon
`LineOfBusinessIconColor`	NVARCHAR	Color

Users (in the Projects context)

A slice of users for selecting project members.

Field	Type	Description
`UserID`	NVARCHAR(10)	Identifier
`UserFullName`	NVARCHAR(121)	Full name
`AvatarURL`	NVARCHAR	Avatar URL

TaskStatuses

Task statuses (global, before project binding).

Field	Type
`StatusID`	NVARCHAR(10)
`StatusText`	NVARCHAR
`StatusIcon`	NVARCHAR
`StatusColor`	NVARCHAR

TasksTypes, TaskPriorities

Global task types and priorities — without project binding.

TasksTypes: TaskTypeID, TypeText, TypeIcon, TypeColor.
TaskPriorities: PriorityID, PriorityText, PriorityIcon, PriorityColor.

ProjectReleases

Project versions (releases).

Field	Type	Description
`ProjectReleaseID`	NVARCHAR	Version identifier
`ParentID`	NVARCHAR	Parent version
`ProjectReleasText`	NVARCHAR	Version name
`ProjectReleasDescription`	NVARCHAR	Description
`ReleaseStatusID`	NVARCHAR	Release status
`StartDate`	DATE	Start date
`ReleaseDate`	DATE	Release date
`IntegrationID`	NVARCHAR	External ID

ProjectComponents

Project components.

Field	Type	Description
`ProjectComponentID`	NVARCHAR	Identifier
`ParentID`	NVARCHAR	Parent component
`ComponentText`	NVARCHAR	Name
`ComponentDescription`	NVARCHAR	Description
`IntegrationID`	NVARCHAR	External ID

ProjectTaskPriorities, ProjectTaskTypes

"Project ↔ available priorities / task types" mappings.

Field	Type	Description
`ParentID`	NVARCHAR	ProjectID
`PriorityID or TaskTypeID`	NVARCHAR	Priority/type identifier
`…Text`	NVARCHAR	Name
`…Icon, …Color`	NVARCHAR	Styling
`Language`	NVARCHAR	Language

ProjectWorkflows

Project workflow transitions.

Field	Type	Description
`ParentID`	NVARCHAR	ProjectID
`FromStatusID`	NVARCHAR	Source status
`ToStatusID`	NVARCHAR	Target status
`TaskTypeID`	NVARCHAR	Task type the transition applies to

ProjectMembers

Project members.

Field	Type	Description
`EntityPermissionID`	NVARCHAR	Project membership record
`ProjectID`	NVARCHAR	Project
`UserID`	NVARCHAR	User
`RoleID`	NVARCHAR	Role
`UserFullName`	NVARCHAR	Full name

ProjectPermissions

Project permissions (role-to-functional-right bindings).

Field	Type
`EntityPermissionID`	NVARCHAR
`ProjectID`	NVARCHAR
`PermissionID`	NVARCHAR
`RoleID`	NVARCHAR

CustomProjectFields, ProjectAttributes

Custom project fields and attributes. Used to extend the project data model; keys are FieldID+ProjectID and ProjectAttributeID+PartnerID+TabID+RoleID respectively.