Timesheet Price represents the price list for services delivered by logging hours to projects and timesheet.
Structure of the im_timesheet_prices database table:
create table im_timesheet_prices ( price_id integer constraint im_timesheet_prices_pk primary key, -- -- "Input variables" uom_id integer not null constraint im_timesheet_prices_uom_id references im_categories, company_id integer not null constraint im_timesheet_prices_company_id references im_companies, task_type_id integer constraint im_timesheet_prices_task_type_id references im_categories, material_id integer constraint im_timesheet_prices_material_fk references im_materials, valid_from timestamptz, valid_through timestamptz, -- make sure the end date is after start date constraint im_timesheet_prices_date_const check(valid_through - valid_from >= 0), -- -- "Output variables" currency char(3) references currency_codes(ISO), price numeric(12,4) );
Related Object Types:
Related Packages:
Calle Aprestadora 19, 12o-2a
08902 Hospitalet de Llobregat (Barcelona)
Spain
Tel Europe: +34 609 953 751
Tel US: +1 415 200 2465
Mail: info@project-open.com