]project-open[ : @This Wiki
Portrait

Welcome, Unregistered Visitor

 · · · Index · Login/Register

Contents





6 registered users
 in last 24 hours

]po[ Gantt & Timesheet Tables

The following tables implement the storage of Gantt schedules, including details on timesheet (gantt) tasks and their dependency. They also capture the hours logged on timesheet tasks and vacations.

 

­

Table

Cols

Rows

Description

[im_hours]

12

750

Stores logged timesheet hours per user, day and project.

[im_materials]

8

26

Materials represent a type of service. They form a link between timesheet tasks and the price list per customer. Example: "Senior Consultant Hour".

[im_timesheet_conf_objects]

7

0

Timesheet confirmation objects represent a group of logged im_hour hours, to be submitted for approval. Usually, all hours of one work week are grouped into a single conf object.

[im_timesheet_invoices]

3

98

Sub-type if financial document. Deleting a timesheet invoice will take care of removing the dependencies of im_hour entries related to the timesheet invoice.

[im_timesheet_prices]

9

13

Timesheet prices define the price per material and company.

[im_timesheet_task_dependencies]

5

333

Dependencies of timesheet tasks for Gantt scheduling.

[im_timesheet_tasks]

11

172

Timesheet tasks are a sub-type of projects. They define a material per task, a unit of measure and estimations for the time necessary to complete the task.

[im_user_absences]

12

72

User absences represent vacations and other absences.

[timesheet_approval_workf_cases]

1

0

Cases for the default timesheet approval workflow

[vacation_approval_wf_cases]

1

20

Cases for the default vacation approval workflow
       

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

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
 
Privacy Policy
References to this Page: en:list_tables Categories: Database Tables (Contents)