]project-open[ : @This Wiki
Portrait

Welcome, Unregistered Visitor

Contact ·  Index · Login · Register
 

Contents

Remote Training
Support
SaaS Service

3 registered users
 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.

Note:
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
Not
useful
      Extremely
useful
 
  

Explore

Installers
Demo Server
Modules & Functionality
Packages
Business Processes supported
FAQ's

Help

Getting started
User Manuals
Configuration Manuals
Community Support
Professional Support

News

News
Twitter
RSS Community / Sourceforge
Register for Newsletter

Get in touch

Contact
Register



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