Overview Columns in List Views


You are here: InLoox Support Knowledge Base Online Help InLoox Web App 11.0 All Topics | InLoox 11 Web App List views Overview Columns in List Views

In the following overview, you will find all columns from the list views in the Projects, Tasks and Project tasksTime and Documents sections. These columns are the default. If you create custom fields (InLoox Enterprise and InLoox On-Prem editions), these are also available in the column selection in the respective view.

Practical tipps for list views

  • The column name corresponds to the name that you use in InLoox in the views. The data set specifies the name of the column that you need to visualize the values in dashboards, for example. You will find additional information under Notes.
  • This list is continuously updated as new features and improvements are released in InLoox.
  • Since InLoox version 11.14, the lists show the sum total for numeric fields. For example, if you show the Effort (task) hours column in the project list and the project task list, InLoox adds up all the data from this column and displays the total. 

Columns in the projects list

Column name Data set Notes
Division Project_DivisionName  
All Time Entries Billed Project_AllPositionsBilled You will see the check mark symbol in this column for billed time recording entries belonging to this project ✓
Count Task Items Project_TasksCount Indicates a number. 
Count project notes Project_NotesCount Indicates a number.
Workload (All Tasks) Hours Project_TaskItemDuration Indicates the total effort from all tasks in this project in hours.
Workload (Gantt) Hours Project_PlannedWorkAmount Indicates the total effort from all planning elements in the Gantt chart of this project in hours.
Archived Project_IsArchived If the project has been archived, you will see the check mark symbol in this column ✓
Image Project_Image Displays only the project image, without the project name.
Financial Warning (Icon) Project_BudgetIndicator This column shows the budget icon instead of the column name.
Document Store Type Project_StoreType  
Document Library Project_FSDocumentLibrary  
Document Folder Project_DocumentFolder  
Done Project_Complete  
First Customer Project_FirstCustomer Shows only the first name of all the persons added to the field "Customer" on the project manage page.
First Partner Project_FirstPartner  
First Incomplete Activity Project_FirstNotCompletedPlanningDate  
First Additional Contact Project_FirstAdditionalContact  
First Team Member Project_FirstTeamMember  
Favorite (Icon) Project_IsFavorite  
% Complete (Project - Actual) Project_CompleteActual = (Total effort in completed tasks) / (Total effort in tasks) in percent
% Complete (Project - Plan) Project_CompletePlan = (Sum of all task efforts that are in planning under a planning element with end < now) / (sum of efforts in tasks) in percent
Complete (Project - Plan vs Actual) Project_CompletePlanActual = (percentage of completion (actual)) - (percentage of completion (planned))
% Complete (Project - Status) Project_CompleteStatus Shows the value that was defined for the current project status in the settings. It is identical to the “Project status in %” column
Progress (Auto) Project_ComputedProgress  
Reviewers Project_ReviewerProjectContact Names of contacts of type project application reviewer in the project, separated by semicolons.
Booked Hours (Project) Project_TimeEntriesDuration  
Size Project_SizeScore Indicates the “size” factor of the project evaluation. Further information on the project score »
Contacts (Customer) Project_CustomerProjectContact  
Contacts (Partner) Project_PartnerProjectContact  
Contacts (Manager) Project_ManagerProjectContact  
Contacts (Team) Project_TeamProjectContact  
Contacts (More) Project_MoreProjectContact  
Customer Project_ClientName  
Customer Number and Name Project_ClientNumberName  
Customer Number Project_ClientNumber  
Last Project Change on Project_LastChangedDateTime  
Last Project Change by Project_LastChangedByName  
Last Project Note Project_Note  
Locked (Icon) Project_Locked Shows when a project is locked and cannot be edited
Overall Score Project_CalculatedScore Score of the project evaluation
Planned Duration (Remaining)  Project_PlannedDurationRemaining Specifies the remaining duration from the current time to the planned end time of the last planning element of the project's Gantt chart. This calculation does not take place in real time, but is carried out at regular intervals.
Planned Duration Project_PlannedDuration Specifies the duration from the start time of the first planning element to the end time of the last planning element of the project's Gantt chart. This calculation does not take place in real time, but is carried out at regular intervals.
Planned End Gantt Project_PlannedEndDate  
Planned Start Gantt Project_PlannedStartDate  
Priority (Icon) Project_Priority  
Project Updated at Project_UpdatedAt  
Project Completed on Project_ClosedDateTime  
Project Completed by Project_ClosedByName  
Project Created on Project_CreatedDateTime  
Project Created by Project_CreatedByName  
Project Request Project_IsRequest  
Project Duration (Remaining) Project_ProjectDurationRemaining Specifies the duration from the current time to the end of the project, which was set on the project manage page.
Project Duration Project_ProjectDuration Indicates the period from project start to project end as set on the project manage page in calendar days.
Project End Project_EndDate  
Project Group Project_ClusterName  
Project Categories Project_Categories  
Project Key Figures Last Updated on Project_KeyFiguresLastUpdated The “Project_KeyFiguresLastUpdated” field contains the time of the last recalculation. The Project Key Figures are various meta-information for projects that are calculated asynchronously, i.e. with a time delay. 1
Project Running Number Project_NumberIncremential  
Project Manager Project_FirstManager  
Project Name Project_Name Displays the project image and the project name
Project Number Project_Number  
Project Number (Prefix) Project_NumberPrefix  
Project Number (Suffix) Project_NumberSuffix  
Project Number and Name Project_ProjectNumberAndName  
Project Start Project_StartDate  
Project Status Project_ProjectStatusName  
Project Status in % Project_PercentComplete Shows the value that was defined for the current project status in the settings. It is identical to the “Degree of completion (status)” column.
Backwards Scheduling Project_BackwardScheduling  
Risk Project_RiskScore Indicates the “risk” factor of the project evaluation. Further information on the project score »
SharePoint Document Library Project_SPSDocumentLibrary  
SharePoint Site Project_SPSSite  
SharePoint Subfolder Project_SPSSubfolders  
Total Effort (Completed) Work Days Project_TotalEffortComplete  
Total Effort (Plan) Work Days Project_TotalEffortPlan  
Total Effort (Plan, Due) Work Days Project_TotalEffortPlanDue = Sum of all task efforts that are in planning under a planning element with End < Now
Total Effort (Overdue) Work Days Project_TotalEffortOverdue  
Total Effort (Reamining) Work Days Project_TotalEffortRemaining  
Total Effort (Time Entries) Work Days Project_TotalEffortTimeEntries  
Total Effort Project_TotalEffort in work days
Total Expenses (Actual) Project_AmountActualCosts  
Total Expenses (Actual, Other) Project_AmountCostsOthers  
Total Expenses (Actual, Time Entries) Project_AmountActivityCosts  
Total Expenses (Plan) Project_AmountPlannedCosts  
Total Expenses (Plan, Resources) Project_AmountPlannedCostsResources  
Total Expenses (Plan, Others) Project_AmountPlannedCostsOther  
Total Revenues (Actual) Project_AmountRevenues  
Total Revenues (Plan) Project_AmountPlannedRevenues  
Total Margin (Actual) Project_AmountProfit  
Total Margin (Plan) Project_AmountPlannedProfit  
Total Cost Variance (Plan vs Actual) Project_AmountProfitDifference  
Total Operational Expenses (Actual) Project_AmountAcutalCostsOpex = Sum of all actual OpEx costs
Total Operational Expenses (Plan) Project_AmountPlannedCostsOpex = Sum of all planned OpEx costs
Fixed Deadline Project_IsEndDateFixed  
Time Warning Project_ProgressIndicator Occurs if both the project end date and the date of the last planning element are in the past.
Time Warning (Planning End) Project_TimeWarningPlanningEndExceeded Indicates that the date of the last planning element has already passed and therefore the planned deadline for the completion of all planning elements has expired.
Time Warning (Project End) Project_TimeWarningProjectEndExceeded Indicates that the specified end of the project, as defined on the Manage page, is in the past and the project has therefore exceeded its planned completion date.
Unassigned Expensed Hours (Time Entries) Project_UnassignedTimeEntriesDuration Amount of hours in time entries without an assigned resource
Value Project_ValueScore Indicates the “value” factor of the project evaluation. Further information on the project score »

1 Project Key Figures are: Categories, FirstManager, FirstTeamMember, FirstPartner, FirstCustomer, FirstAdditionalContact, ManagerProjectContact, TeamProjectContact, PartnerProjectContact, CustomerProjectContact, AdditionalProjectContact, ReviewerProjectContact, PlannedWorkAmount, UnassignedTimeEntriesDuration, TaskItemDuration, TaskItemDurationCompleted, TimeEntriesDuration, FirstNotCompletedPlanningDate, ComputedProgress, CreatedByName, CreatedByContactImageId, LastChangedByName, ChangedByContactImageId, AllPositionsBilled, ProjectStatusName, ProjectStatusProgress, DivisionName, DivisionDescription, ClientName, ClientNumber, ClusterName, TotalEffortPlanDue, TotalEffortOverdue, Note, KeyFiguresLastUpdated, ContactsTop10, ContactsCount, TasksCount, NotesCount

Columns in the task list

Column name Data set Notes
Billed TaskItem_IsBilled If the task has been billed, you will see the check mark symbol in this column ✓
Billable TaskItem_IsBillable If the task can be billed, you will see the check mark symbol in this column ✓
Division Project_DivisionName  
Updated at TaskItem_UpdatedAt  
All Predecessors Done Planning_AllTaskItemPredecessorDone If all previous planning elements have been completed, you will see the check mark symbol in this column ✓
Notes Count TaskItem_NotesCount Only displays the count number.
Workload (Project - Plan) Hours Project_PlannedWorkAmount  
Task TaskItem_Name  
Task Done (Icon) TaskItem_IsDone Is a checkbox used to mark Tasks as done. A done Task has a green check mark symbol ✓
Assigned by    
Assigned to    
Assigned to (Name)    
Task Item Key Figures Last Updated on TaskItem_KeyFiguresLastUpdated  
Task Status (Name) TaskItem_TaskItemStatusName  
Effort (Task) Hours TaskItem_WorkAmount  
Provision Date TaskItem_ProvisionDate  
Performed by TaskItem_PerformedByDisplayName  
Description    
Description (Task) TaskItem_DescriptionText  
Description (Budget) TaskItem_BudgetDescription  
Duration (Activity) Minutes Planning_DurationMinutes  
Duration (Activity) Hours Planning_DurationHours  
Direct Predecessor Done Planning_TaskItemPredecessorDone  
Documents (Count) TaskItem_DocumentsCount  
Document Store Type Project_StoreType  
Costs (per Hour) TaskItem_PricePerUnit A group with a purchase price must be selected in the task.
Constraint Date (Planning Element) Planning_ConstraintDate  
Constraint Type (Planning Element) Planning_ConstraintType  
End (Task) TaskItem_EndDateTime  
End (Planning Element) Planning_EndDateTime  
Expensed Hours (Task)    
Done on (Task) TaskItem_DoneDate  
Done on (Planning Element) Planning_DoneDate  
Created on (Task) TaskItem_CreatedAt  
Created on (Planning Element) Planning_CreatedAt  
Created by TaskItem_CreatedByDisplayName  
First Customers Contact Project_FirstCustomer  
First Partners Contact Project_FirstPartner  
First Additional Contact Project_FirstAdditionalContact  
First Additional Contact 1    
First Additional Contact 2    
First Additional Contact 3    
First Additional Contact 4    
First Additional Contact 5    
First Team Contact Project_FirstTeamMember  
Due Date TaskItem_CombinedEndDateTime  
Color (Task) TaskItem_CustomColor  
Color (Planning) Planning_CustomColor  
Color (Status) TaskItem_TaskItemStatusColor  
Favorite (Icon) Project_IsFavorite  
% Complete (Project - Actual) Project_CompleteActual  
% Complete (Project - Plan) Project_CompletePlan  
Complete (Project - Plan vs Actual) Project_CompletePlanActual  
Fiscal Month TaskItem_FiscalMonth  
Fixed Planning_IsFixed  
Progress (Auto) Project_ComputedProgress  
Reviewer Project_ReviewerProjectContact  
Changed on (Task) TaskItem_ChangedDate  
Geändert von TaskItem_ChangedByContact_DisplayName  
Gebuchte Stunden (Aufgabe) TaskItem_TimeEntriesDuration  
Booked Hours (Project) Project_TimeEntriesDuration  
Group (Task) TaskItem_GroupName  
Has End Date TaskItem_HasEndDate  
Has Start Date TaskItem_HasStartDate  
Is Read TaskItem_IsRead  
Is Custom Price (per Hour) TaskItem_IsCustomPricePerUnit  
Contacts (Customer) Project_CustomerProjectContact  
Contacts (Partner) Project_PartnerProjectContact  
Contacts (Manager) Project_ManagerProjectContact  
Contacts (Team) Project_TeamProjectContact  
Contacts (Additional) Project_AdditionalProjectContact  
Contacts (Additional 1)    
Contacts (Additional 2)    
Contacts (Additional 3)    
Contacts (Additional 4)    
Contacts (Additional 5)    
Critical Planning_IsCritical If the task is assigned to a planning element that is on the critical path, the check mark symbol ✓ is displayed here.
Customer Project_ClientName  
Customer Number and Name Project_ClientNumberName  
Customer Number Project_ClientNumber  
Sequence Number (Task) TaskItem_ConsecutiveNumber  
Last Project Change on Project_LastChangedDateTime  
Last Project Change by Project_LastChangedByName  
Last Project Note Project_Note  
Milestone Planning_IsMilestone  
Location Planning_Location  
Planned Duration (Remaining) Project_PlannedDurationRemaining  
Planned Duration Project_PlannedDuration  
Planned End Gantt Project_PlannedEndDate  
Planned Start Gantt Project_PlannedStartDate  
Planungsebene Planning_Level  
Planning Element Updated on Planning_UpdatedAt  
Planning Progress Planning_Progress  
Position in Kanban Status TaskItem_CardPositionNumber  
Position Number TaskItem_PositionNumber  
Priority (Symbol) Project_Priority  
Project Updated at Project_UpdatedAt  
Project Completed by Project_ClosedByName  
Project Created by Project_CreatedByName  
Locked (Symbol) Project_Locked Task is assigned to a locked project, which cannot be edited.
Project Duration (Remaining)  Project_ProjectDurationRemaining  
Project Duration  Project_ProjectDuration  
Project End Project_EndDate  
Project Group Project_ClusterName  
Project Categories Project_Categories  
Projektlaufnummer Project_NumberIncremential  
Project Manager Project_FirstManager  
Project Name Project_Name  
Project Number Project_Number  
Project Number (Prefix) Project_NumberPrefix  
Project Number (Suffix) Project_NumberSuffix  
Project Number and Name Project_ProjectNumberAndName  
Project Start Project_StartDate  
Project Status Project_ProjectStatusName  
Project Status in % Project_PercentComplete  
WBS Code (Manual) Planning_PSPCode  
WBS Code (Planning Element)    
Repeat   Shows the repetetion cycle of a task, if set.
Ressource TaskItem_ContactDisplayName  
Summary Activity Planning_IsGrouping  
Start TaskItem_CombinedStartDateTime  
Start (Task) TaskItem_StartDateTime  
Start (Planning Element) Planning_StartDateTime  
Total Effort (Completed) Work Days Project_TotalEffortComplete  
Total Effort (Plan) Work Days Project_TotalEffortPlan  
Total Effort (Plan, Due) Work Days Project_TotalEffortPlanDue  
Total Effort (Overdue) Work Days Project_TotalEffortOverdue  
Total Effort (Remaining) Work Days Project_TotalEffortRemaining  
Total Effort (Time Entries)  Project_TotalEffortTimeEntries This column applies to tasks that are assigned to a project.
Total Effort (Time Entries) Work Days TaskItem_TotalEffortTimeEntries This column applies to tasks without a project assignment.
Total Effort Project_TotalEffort  
TaskItem_Ordinalposition TaskItem_Ordinalposition  
Fixed Deadline Project_IsEndDateFixed  
Overdue TaskItem_IsOverdue  
Price (per Hour) TaskItem_SecondaryPricePerUnit A group with a sales price must be selected in the task.
Activity Planning_DisplayName  
Time Warning Project_ProgressIndicator  
Assigned by TaskItem_AssignedByDisplayName  
Assigned to (Name) TaskItem_AssignedToDisplayName  

Columns in the list of time entries 

Column name Data set Notes
Is Billed TimeEntry_IsBilled  
Is Billable TimeEntry_IsBillable  
Division Project_DivisionName  
Task TaskItem_Name  
Task Completed TaskItem_IsDone  
Task Status (Name) TaskItem_TaskItemStatusName  
Effort (Task) Hours TaskItem_WorkAmount  
Provision Date TaskItem_ProvisionDate Date and time of task completion
Performed by TimeEntry_PerformedByDisplayName  
Description TimeEntry_DescriptionText  
Duration (hours) TimeEntry_DurationHours Duration of the time entry in hours
Duration TimeEntry_DurationMinutes PLEASE NOTE: This column is also available in dashboards and reports. There, the data from the column Duration (hours) is converted into minutes.
Documents TimeEntry_HasDocuments  
End TimeEntry_EndDateTime  
Provision Date TimeEntry_ProvisionDate Date and time of creation of the time entry
Created on    
Created by TimeEntry_CreatedByDisplayName  
Favorite (Icon) Project_IsFavorite  
Fiscal Month TimeEntry_FiscalMonth  
Changed on TimeEntry_ChangedDate  
Group (Task) TaskItem_GroupName  
Group (Time Entry) TimeEntry_GroupName  
Flag (Icon) TimeEntry_ColorFlag  
Customer Project_ClientName  
Customer Number and Name Project_ClientNumberName  
Customer Number Project_ClientNumber  
Last Changed by (Name) TimeEntry_ChangedByDisplayName  
Last Project Note Project_Note  
Name (Time Entry) TimeEntry_DisplayName  
Planning Progress Planning_Progress  
Project Created by Project_CreatedByName  
Project End Project_EndDate  
Project Categories Project_Categories  
Project Name Project_Name  
Project Number Project_Number  
Project Number and Name Project_ProjectNumberAndName  
Project Start Project_StartDate  
Project Status Project_ProjectStatusName  
Project Status in % Project_PercentComplete  
Start TimeEntry_StartDateTime  
Activity Planning_DisplayName  

Columns in the document list

Column name Data set Notes
Changed at (Document) Document_FileChangedDate  
Changed by ChangedBy_DisplayName  
Created by CreatedBy_DisplayName  
Created on (Document) Document_FileCreatedDate  
Description (Document) Document_DescriptionText  
Email received at Document_OutlookReceivedDate  
Email sender Document_OutlookSender  
Email subject Document_OutlookSubject  
Email CC recipients Document_OutlookCCRecipient  
Email recipient Document_OutlookRecipient  
File name Document_FileName  
Folder name DocumentFolder_FolderName  
Internet link path Document_InternetLinkPath  
Relative folder path DocumentFolder_RelativePath  
Size Document_FileSize  
Source Folder Document_SourceFolder  
Status (Document) Document_State  
Type (Document) Document_FileType