In the following overview, you will find all columns from the list views in the Projects, Tasks and Project tasks, Time 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
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
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 |
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 |
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 |