| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier | |
| task_type_id |
Foreign key of task type for this task.If not filled,one default will be used |
globally unique identifier | |
| task_status_id |
Foreign key of task status for this task.When adding a task, the default task_status will be used |
globally unique identifier | |
| task_priority_id |
Foreign key of task priority for this task.If not filled,one default will be used |
globally unique identifier | |
| company_id |
The company linked to this task. Autofilled based on credentials |
globally unique identifier | |
| contact_id |
The contact that created this task. Filled automatically when adding a task |
globally unique identifier | |
| to_db_table_id |
Foreign key to the table that is linked to this task (Example:project or jobs) using Guid |
globally unique identifier | |
| to_db_table_name |
Foreign key to the table that is linked to this task (Example:project or jobs) using table name |
string | |
| to_id_in_table |
Foreign key of the object that is linked to this task using Odyssee Guid Primary Key (Exemple:project.id or jobs.id) |
globally unique identifier | |
| subject |
Subject of the Task |
string |
Required Max length: 150 |
| remark |
Remark of the Task (long text area field) |
string | |
| customer_reference |
Reference of this task for the customer |
string |
Max length: 50 |
| date_create |
Creation date+time. Automaticaly filled when adding if no value specified |
date | |
| date_start |
Starting date of the task (date_start in the future are not shown on the UI) |
date | |
| due_date |
Deadline to close the task |
date | |
| date_closed |
Date+Time when the task goes into archive (=completed) |
date | |
| archived |
Indicate that the task is now closed (has been updated to a task status 'Completed').Automatically filled when adding/updating a task based on the task_type |
boolean | |
| date_assigned |
Date+Time when the task has been assigned to a specific user |
date | |
| date_suggested_by_company |
Date+Time suggested by the company to start working on this task |
date | |
| id2 |
Internal ID (numeric). Will be used on the UI to identify easily the task |
integer | |
| reference_back_office |
The Id/Ref of the back office for this task |
string |
Max length: 50 |
| created_by_servicedesk_api |
ReadOnly,Specify that the task has been created by ServiceDesk |
boolean | |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date |
