| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier | |
| user_id | globally unique identifier | ||
| hour_type_id |
Foreign key of the hour type |
globally unique identifier |
Required |
| date_from |
Date+Time timesheet FROM |
date |
Required |
| date_from_rounded |
Date+Time timesheet FROM |
date |
Required |
| date_to |
Date+Time timesheet TO |
date |
Required |
| date_to_rounded |
Date+Time timesheet TO |
date |
Required |
| remark |
Additional remark field |
string |
Max length: 4000 |
| is_approved |
Inform if this user_timesheet belongs to a week approved (readonly) |
boolean | |
| is_start_stop | boolean | ||
| is_time_for_money | boolean | ||
| db_table_id |
Foreign key to the table timesheet is linked. Can be a jobs,project,company or empty |
globally unique identifier | |
| id_in_table |
Foreign key of the object linked. Can be a jobs.id, project.id , company.id or empty |
globally unique identifier | |
| property_1_checked | boolean | ||
| property_2_checked | boolean | ||
| property_3_checked | boolean | ||
| property_4_checked | boolean | ||
| property_5_checked | boolean | ||
| start_latitude_decimal | decimal number | ||
| start_longitude_decimal | decimal number | ||
| end_latitude_decimal | decimal number | ||
| end_longitude_decimal | decimal number | ||
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date | |
| is_confirmed |
offline field: is_confirmed flag |
boolean |