| 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 |
Identifier of the database table that belongs to, when the departure point is linked to another record (e.g. a job). |
globally unique identifier | |
| from_id_in_table |
Primary key of the linked departure record in the table identified by . |
globally unique identifier | |
| from_travel_type_code |
Kind of departure point (e.g. home, office, previous job). |
string | |
| from_db_address_other |
Free-text departure address, used when the departure point isn't one of the standard linked records. |
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 |
Primary key of the linked destination record in the table identified by . |
globally unique identifier | |
| to_travel_type_code |
Kind of travel. Can be |
string |
Required |
| to_db_address_other |
Free-text destination address, used when the destination isn't one of the standard linked records. |
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 |
rounded to the nearest configured interval, used for billing/display. |
date |
Required |
| date_to |
local date+time when the travel finished |
date | |
| date_to_rounded |
rounded to the nearest configured interval, used for billing/display. |
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 |
Distance traveled, in kilometers, computed as minus . |
integer | |
| is_time_for_money |
Indicates this travel time is billable ("time for money") rather than purely informational. |
boolean | |
| is_start_stop |
Indicates this entry was recorded via a start/stop timer rather than manually keyed in. |
boolean | |
| 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 travel was started. |
decimal number | |
| start_longitude_decimal |
Longitude of the user's location when the travel was started. |
decimal number | |
| end_latitude_decimal |
Latitude of the user's location when the travel ended. |
decimal number | |
| end_longitude_decimal |
Longitude of the user's location when the travel ended. |
decimal number | |
| added_dateutc |
Readonly system field: UTC date and time this travel record was added. |
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 |