| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier | |
| task_type_id |
Foreign key of task type for this task |
globally unique identifier |
Optionally required : task_type_id, task_type_code or task_type must be provided |
| task_type_code |
Embedded entity "task_type" using ERP PK when adding/updating task |
string |
Optionally required : task_type_id, task_type_code or task_type must be provided |
| task_type |
Embedded entity "task_type" when adding/updating task |
task_type |
Optionally required : task_type_id, task_type_code or task_type must be provided |
| task_status_id |
Foreign key of task status for this task.If nothing specified, the system will uses the default task_status available |
globally unique identifier | |
| task_status_reference_back_office |
Embedded entity "task_status" using ERP PK when adding/updating task |
string | |
| task_status |
Embedded entity "task_status" when adding/updating task |
task_status | |
| task_priority_id |
Foreign key of task priority for this task |
globally unique identifier |
Optionally required : task_priority_id, task_priority_code or task_priority must be provided |
| task_priority_code |
Embedded entity "task_priority" using ERP PK when adding/updating task |
string |
Optionally required : task_priority_id, task_priority_code or task_priority must be provided |
| task_priority |
Embedded entity "task_priority" when adding/updating task |
task_priority |
Optionally required : task_priority_id, task_priority_code or task_priority must be provided |
| company_id |
The company linked to this task |
globally unique identifier |
Optionally required : company_id, company_code or company must be provided |
| company_code |
Embedded entity "company" using ERP PK when adding/updating task |
string |
Optionally required : company_id, company_code or company must be provided |
| company |
Embedded entity "company" when adding/updating task |
company |
Optionally required : company_id, company_code or company must be provided |
| 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 | |
| internal_remark | string |
Max length: 4000 |
|
| customer_reference |
Reference of this task for the customer |
string |
Max length: 50 |
| assigned_to_user_id |
Foreign key of the user on which the task has been assigned. If not filled, the system can fill it automatically based on the task_type. When a task is assigned to somebody, the field date_assigned will be filled |
globally unique identifier | |
| assigned_to_user_group_id |
Foreign key of the user_group on which the task will be assigned. If not filled, the system can fill it automatically based on the task_type |
globally unique identifier | |
| 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. Used by Embedded entity |
string |
Max length: 50 |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date | |
| contact_id |
Foreign key of contact for this task. |
globally unique identifier | |
| contact_code |
Embedded entity "contact_code" using ERP PK when adding/updating task |
string | |
| contact |
Embedded entity "contact" when adding/updating task |
contact | |
| requested_by_company_id |
Foreign key of company that requested this task. |
globally unique identifier | |
| requested_by_company_code |
Embedded entity "company_code" using ERP PK when adding/updating task |
string | |
| requested_by_company |
Embedded entity "compay" when adding/updating task |
company | |
| bill_to_party |
Bill to party of the Task. |
string |