| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier | |
| code |
Code of Hour (will be used for job_non_part_usage.line_code). Field also used for Embedded entity (store there your ERP PK) |
string |
Max length: 50 |
| commercial_description |
Commercial description of the hour type. (Will be used for job_non_part_usage.description) |
string |
Required Max length: 255 |
| archived |
Archive this hour_type to be sure no new user_timesheet/car_travel will be created with this hour_type |
boolean | |
| allow_in_job |
If set to true, this hour_type will be available inside a JobDetails to add new timesheet.Default=true |
boolean | |
| is_travel |
This hour_type is for travel |
boolean | |
| allow_time_for_money |
Indicates time recorded under this hour type can be marked "time for money" (billable rather than purely informational). |
boolean | |
| force_range |
is hour type range is forced |
boolean | |
| color |
Color of the hour type |
string | |
| hour_type_group_id |
Foreign key to hour_type_group, to group hour_type together |
globally unique identifier |
Optionally required : hour_type_group_id, hour_type_group_code or hour_type_group must be provided |
| convert_as_invoicable |
Convert as invoicable.If true, timesheet/car travel of this type will be generated to job_non_part_usage.Default=true |
boolean | |
| property_1_is_enabled |
CF Properties of HourType.Enable or not for this hour_type the property 1 |
boolean | |
| property_1_auto_checked |
User_timesheet+car_travel property_1_checked will be filled with this value |
boolean | |
| property_2_is_enabled |
CF Properties of HourType.Enable or not for this hour_type the property 2 |
boolean | |
| property_2_auto_checked |
User_timesheet+car_travel property_2_checked will be filled with this value |
boolean | |
| property_3_is_enabled |
CF Properties of HourType.Enable or not for this hour_type the property 3 |
boolean | |
| property_3_auto_checked |
User_timesheet+car_travel property_3_checked will be filled with this value |
boolean | |
| property_4_is_enabled |
CF Properties of HourType.Enable or not for this hour_type the property 4 |
boolean | |
| property_4_auto_checked |
User_timesheet+car_travel property_4_checked will be filled with this value |
boolean | |
| property_5_is_enabled |
CF Properties of HourType.Enable or not for this hour_type the property 5 |
boolean | |
| property_5_auto_checked |
User_timesheet+car_travel property_5_checked will be filled with this value |
boolean | |
| sales_organization_id |
FK of sales_organization. Filled if specific of one SO, empty if can be used by all |
globally unique identifier | |
| property_1_convert_as_invoicable_if_checked |
When custom property #1 is checked on an entry, forces that entry to be converted as invoicable regardless of . |
boolean | |
| property_2_convert_as_invoicable_if_checked |
When custom property #2 is checked on an entry, forces that entry to be converted as invoicable regardless of . |
boolean | |
| property_3_convert_as_invoicable_if_checked |
When custom property #3 is checked on an entry, forces that entry to be converted as invoicable regardless of . |
boolean | |
| property_4_convert_as_invoicable_if_checked |
When custom property #4 is checked on an entry, forces that entry to be converted as invoicable regardless of . |
boolean | |
| property_5_convert_as_invoicable_if_checked |
When custom property #5 is checked on an entry, forces that entry to be converted as invoicable regardless of . |
boolean | |
| is_default |
Indicates this is the default hour type pre-selected when adding new timesheet/travel entries. |
boolean | |
| is_other |
Indicates this is a catch-all "other" hour type used when no more specific type applies. |
boolean | |
| description |
Free-text description of this hour type. |
string | |
| is_billing_hour |
Indicates this hour type represents billable hours (as opposed to purely internal/non-billable time). |
boolean | |
| convert_to_hour_type_id |
Foreign key of another hour type that entries of this type should be converted to (e.g. when consolidating billing). |
globally unique identifier | |
| article_id |
Foreign key of the article used to bill hours of this type. |
globally unique identifier | |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date |