dProject (new 2014-02-26)
| Based on (table.column) | Type | Column alias | Localised english name | Comment |
| project. | E | ProjectId | No. projects | May be used for filtering by column filter. Not for display. |
| - | E | Total | Total | Used for grouping. Not for display. |
| project.name | E | ProjectName |
ProjectName
|
The name of the project. |
| project.text_id -> text.text | E | ProjectDescription |
ProjectDescription
|
The project description. |
|
person.firstname, person.middlename, person.lastname |
E | PersonName(FirstLast) |
PersonName(FirstLast)
|
Name of project owner/creator. |
| projstatus.name | E | ProjectStatus | ProjectStatus | Status of project. |
| projtype.name | E | ProjectType | ProjectType | Type of project. |
| sale.sale_id | C | Open | No. open | No. of open cases related to this project. |
|
sale.sale_id
|
C |
Won
|
No. won | No. of won cases related to this project. |
| sale.sale_id | C |
Lost
|
No. lost
|
No. of lost cases related to this project. |
| sale.sale_id | C | Stalled |
No. stalled
|
No. of stalled cases related to this project. |
| sale.amount | C |
OpenAmount
|
Open amount
|
Total open amount related to this project. |
| sale.amount | C |
WonAmount
|
Won amount
|
Total won amount related to this project. |
| sale.amount | C | LostAmount | Lost amount | Total lost amount related to this project. |
| sale.amount | C | StalledAmount | Stalled amount | Total stalled amount related to this project. |
| appointment.appointment_id | C | Appointments | No. Appointments | No. of appointments (non-documents) related to this project. |
| appointment.appointment_id | C | Documents | No. Documents | No. of documents related to this project. |
| projectmember.project_id | C | Members | No. Members | No. of members in this project. |
| project.registered | E | Registered | Registered | Registered date. |
| project.registered | E | Registered2 | Registered2 | Registered date. Used for pivoting / comparing this/last year. |
| project.updated | E | Updated | Updated | Updated date. |
| project.updated | E | Updated2 |
Updated2
|
Updated date. Used for pivoting / comparing this/last year. |
| project.enddate | E | Enddate | Enddate | Updated date. |
| project.enddate | E | Enddate2 | Enddate2 | Updated date. Used for pivoting / comparing this/last year. |
| project.done | E | Completed(Text) |
Completed(Text)
|
0=false, 1=true in localized text. |
| project.done | E | CompletedId |
CompletedId
|
0=false, 1=true integer value only. Usefull for column filters. |
| project.project_id | E | LinkProject | LinkProject | Owl-link that brings up the project dialog when presesd. |
| project.project_number | E | Project nr | Project nr | Project number. |
| project.updatedCount | E | Updated count | Updated count | The number of times this project has been updated. |
| project.associate_id | E | Associate Id | Associate Id | The associate_id of the owner / creator of the project. |
| project.associate_id -> associate.group_idx | E | Usergroup Id | Usergroup Id | |
| project.group_id | E | Usergroup Id - Created by | Usergroup Id - Created by |
The usergroup_id of the Primary group of the associate that crated the project. PS! This may not be his present primary group. |
