NameDescriptionTypeAdditional 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

description

Description of the hour type

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
is_travel

This hour_type is for travel

boolean
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

hour_type_group_code

Embedded entity "hour_type_group" using ERP PK when adding/updating hour_type

string

Optionally required : hour_type_group_id, hour_type_group_code or hour_type_group must be provided

hour_type_group

Embedded entity "hour_type_group" using ERP PK when adding/updating hour_type

hour_type_group

Optionally required : hour_type_group_id, hour_type_group_code or hour_type_group must be provided

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
sales_organization_code

Embedded entity "sales_organization" using ERP PK when adding/updating hour_type

string
sales_organization

Embedded entity "sales_organization" when adding/updating hour_type

sales_organization
is_billing_hour

Need to be TRUE if needed inside the Work Order Billable hours

boolean
is_other

When the technician is not driving and not working

boolean
modified_dateutc

Readonly system field managed by database, filled with GetUtcDate when adding,updating

date