]project-open[ : @This Wiki

Welcome, Unregistered Visitor

Contact ·  Index · Login · Register


Remote Training
SaaS Service

1 registered user
 in last 24 hours

]po[ Timesheet Task

When it comes to structuring projects, "timesheet task" represent the lowest level of units.

Main Fields

  • task_id: ObjectID of the task. This ID is the same number as the im_projects.project_id of the corresponding entry in the im_projects table.
  • material_id: Defines the material or "service type" of the task, for example "Senior Consultant Hour". The material form a link into the price list, so that the automatic invoicing can determine the agreed price for the service.
  • uom_id: Defines the Unit of Measure of the planned and billable units.
  • planned_units: Defines how many UoMs (usually: hours) the PM plans for this task.
  • billable_units: How many units (usually: hours) can be billed to the customer? For example, pre-sales time is usually not billable.
  • cost_center_id: Specifies the cost center for this task. For example, a "testing" task with in a larger project may be assigned to the cost center of the "Testing deparment". This way, it is possible to analyze the distribution of project consts according to cost centers.
  • invoice_id: Not used anymore.
  • priority: An integer to store a priority (used by the GanttProject integration to store GP's priority field, so that it doesn't get lost).
  • sort_order: An integer specifying the ordering of tasks inside a project.


Database Definition

      Column      |       Type       | Modifiers
 task_id          | integer          | not null
 material_id      | integer          | not null
 uom_id           | integer          | not null
 planned_units    | double precision |
 billable_units   | double precision |
 cost_center_id   | integer          |
 invoice_id       | integer          |
 priority         | integer          |
 gantt_project_id | integer          |
 sort_order       | integer          |

Please take a moment to complete this form to help us improve our service.

Please only provide feedback in regards to content this page shows. For support inquiries please refer either to the Community Support forum at Sourceforge or check out our 'Professional Support'

Did this page help you to achieve your goal?

 Yes  No  Don't know

Please provide us with comments to improve this page:

How useful is the information?

 1  2  3  4  5


Demo Server
Modules & Functionality
Business Processes supported


Getting started
User Manuals
Configuration Manuals
Community Support
Professional Support


RSS Community / Sourceforge
Register for Newsletter

Get in touch


Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 2.0 Generic License - Privacy Policy