]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 Price

Timesheet Price represents the price list for services delivered by logging hours to projects and timesheet.

 

Timesheet Price Fields

 

  • Price ID:
    Object ID of the price entry.

  • UoM ID:
    Unit of measure of the price item. Should be "hour" usually, in order to allow for the timesheet invoicing wizard to create financial documents semi-automatically.

  • Company ID:
    The company of the price list. Choosing the [internal company] here will define the price as a system wide default.

  • Task Type ID:
    The type of the task. Currently not used in ]po[.

  • Material ID:
    The material or "service type" of the task. Example: "Senior Consulting Hour".

  • Valid From:
    Currently not used in ]po[.

  • Valid Through:
    Currently not used in ]po[.

  • Currency:
    Currency of the price. There is no conversions of prices defined between different currencies, so you need to define a price for each currency.

  • Price:
    The price for the service.

 

Data-Model

 

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)
);­

­

References

 Related Object Types:

 

Related Packages:

  • The [timesheet invoicing package] includes a wizard that uses timesheet prices to convert logged hours into invoices and quotes.

 



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