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.