| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier | |
| user_id |
Foreign key of User |
globally unique identifier |
Required |
| car_id |
Foreign key of Car |
globally unique identifier |
Required |
| hour_type_id |
Foreign key of the hour type |
globally unique identifier |
Required |
| date_from_rounded |
Date+Time travel FROM |
date |
Required |
| date_to_rounded |
Date+Time travel TO |
date |
Required |
| notes |
Additional notes field |
string | |
| to_travel_type_code |
Kind of travel. Can be |
string |
Required |
| is_approved |
Inform if this user_timesheet belongs to a week approved (readonly) |
boolean | |
| property_1_checked |
True/False status of property 1 |
boolean | |
| property_2_checked |
True/False status of property 2 |
boolean | |
| property_3_checked |
True/False status of property 3 |
boolean | |
| property_4_checked |
True/False status of property 4 |
boolean | |
| property_5_checked |
True/False status of property 5 |
boolean | |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date | |
| km_distance |
Distance traveled |
integer | |
| km_private |
Personal distance traveled |
integer | |
| from_travel_type_code |
Travel type when going to location |
string | |
| from_db_table_name |
Value of linked table |
string | |
| from_id_in_table |
Foreign key to object traveling from |
globally unique identifier | |
| to_db_table_name |
Value of linked table |
string | |
| to_id_in_table |
Foreign key to object traveling from |
globally unique identifier |