| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier | |
| user_id |
Foreign key of the user this timesheet entry belongs to. |
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 |
rounded to the nearest configured interval, used for billing/display. |
date |
Required |
| date_to |
Date+Time timesheet TO |
date |
Required |
| date_to_rounded |
rounded to the nearest configured interval, used for billing/display. |
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 |
Indicates this entry was recorded via a start/stop timer rather than manually keyed in. |
boolean | |
| is_time_for_money |
Indicates this time is billable ("time for money") rather than purely informational. |
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 |
Checked state of the hour type's configurable custom property #1 (see ) for this entry. |
boolean | |
| property_2_checked |
Checked state of the hour type's configurable custom property #2 for this entry. |
boolean | |
| property_3_checked |
Checked state of the hour type's configurable custom property #3 for this entry. |
boolean | |
| property_4_checked |
Checked state of the hour type's configurable custom property #4 for this entry. |
boolean | |
| property_5_checked |
Checked state of the hour type's configurable custom property #5 for this entry. |
boolean | |
| start_latitude_decimal |
Latitude of the user's location when the timer was started. |
decimal number | |
| start_longitude_decimal |
Longitude of the user's location when the timer was started. |
decimal number | |
| end_latitude_decimal |
Latitude of the user's location when the timer was stopped. |
decimal number | |
| end_longitude_decimal |
Longitude of the user's location when the timer was stopped. |
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 |