NameDescriptionTypeAdditional 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
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