| 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 |
| from_db_address_id |
the FROM info are filled with the latest travel of this car |
globally unique identifier | |
| from_db_table_id | globally unique identifier | ||
| from_id_in_table | globally unique identifier | ||
| from_travel_type_code | string | ||
| from_db_address_other | string |
Max length: 255 |
|
| to_db_address_id |
The address used on navigation |
globally unique identifier | |
| to_db_table_id |
TO=> if navigate to a JOBS, to_db_table_id and to_in_table is filled with the jobs info |
globally unique identifier | |
| to_in_in_table | globally unique identifier | ||
| to_travel_type_code |
Kind of travel. Can be |
string |
Required |
| to_db_address_other | string |
Max length: 255 |
|
| hour_type_id |
Foreign key of the hour type |
globally unique identifier |
Required |
| date_from |
Local date+time when the travel started |
date | |
| date_from_rounded |
Date+Time travel FROM |
date |
Required |
| date_to |
local date+time when the travel finished |
date | |
| date_to_rounded |
Date+Time travel TO |
date |
Required |
| notes |
Additional notes field |
string |
Max length: 4000 |
| km |
2019-04-01: Old field not use it anymore (FSA-986) the Mileage of the car after the travel,* Be aware, value should be always bigger than the last one |
integer | |
| km_before |
Auto filled when a new record is added |
integer | |
| km_after |
the Mileage of the car after the travel,* Be aware, value should be always bigger than the last one |
integer | |
| km_private |
A value the user indicates that contains the total number of km for Private use. |
integer | |
| km_distance | integer | ||
| is_time_for_money | boolean | ||
| is_start_stop | boolean | ||
| 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 | ||
| added_dateutc |
added dateutc |
date | |
| is_approved |
is_approved flag |
boolean | |
| is_confirmed |
offline field: is_confirmed flag |
boolean | |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date |