]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

       
  Contact Us
  Project Open Business Solutions S.L.

Calle Aprestadora 19, 12o-2a

E-08907 Hospitalet de Llobregat (Barcelona)

 Tel Europe: +34 932 202 088
 Tel US: +1 415 429 5995
 Mail: info@project-open.com