NameDescriptionTypeAdditional information
id

Primary Key

 globally unique identifier
created_by_user_id

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_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_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
company_id

The company linked to this task

 globally unique identifier

Optionally required : company_id, company_code or company must be provided
contact_id

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_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: 4000
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_update

Updated 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
dateutc_assigned

Date+Time UTC 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
next_task_activity_id

globally unique identifier
next_task_activity_log_id

globally unique identifier
requested_by_company_id

globally unique identifier
requested_by_contact_id

globally unique identifier
bill_to_party

string

Max length: 255
dateutc_create

date
created_by_servicedesk_api

It is set to TRUE when the task has been created via servicedesk.

 boolean
modified_dateutc

Readonly system field managed by database, filled with GetUtcDate when adding,updating

 date
internal_remark

Internal remark of the Task

 string

Max length: 4000
dateutc_max_sla_hands_on_machine

Readonly system field managed by database, filled with GetUtcDate when adding,updating

 date
dateutc_max_sla_resolution

Readonly system field managed by database, filled with GetUtcDate when adding,updating

 date
dateutc_max_sla_contact

date
dont_apply_sla

boolean
udf1

string

Max length: 4000
udf2

string

Max length: 4000
udf3

string

Max length: 4000
udf4

string

Max length: 4000
udf5

string

Max length: 4000
udf6

string

Max length: 4000
udf7

string

Max length: 4000
udf8

string

Max length: 4000
udf9

string

Max length: 4000
udf10

string

Max length: 4000
udf11

string

Max length: 4000
udf12

string

Max length: 4000
udf13

string

Max length: 4000
udf14

string

Max length: 4000
udf15

string

Max length: 4000
udf16

string

Max length: 4000
udf17

string

Max length: 4000
udf18

string

Max length: 4000
udf19

string

Max length: 4000
udf20

string

Max length: 4000
udf21

string

Max length: 4000
udf22

string

Max length: 4000
udf23

string

Max length: 4000
udf24

string

Max length: 4000
udf25

string

Max length: 4000
udf26

string

Max length: 4000
udf27

string

Max length: 4000
udf28

string

Max length: 4000
udf29

string

Max length: 4000
udf30

string

Max length: 4000
udf31

string

Max length: 4000
udf32

string

Max length: 4000
udf33

string

Max length: 4000
udf34

string

Max length: 4000
udf35

string

Max length: 4000
udf36

string

Max length: 4000
udf37

string

Max length: 4000
udf38

string

Max length: 4000
udf39

string

Max length: 4000
udf40

string

Max length: 4000
udf41

string

Max length: 4000
udf42

string

Max length: 4000
udf43

string

Max length: 4000
udf44

string

Max length: 4000
udf45

string

Max length: 4000
udf46

string

Max length: 4000
udf47

string

Max length: 4000
udf48

string

Max length: 4000
udf49

string

Max length: 4000
udf50

string

Max length: 4000
udf51

string

Max length: 4000
udf52

string

Max length: 4000
udf53

string

Max length: 4000
udf54

string

Max length: 4000
udf55

string

Max length: 4000
udf56

string

Max length: 4000
udf57

string

Max length: 4000
udf58

string

Max length: 4000
udf59

string

Max length: 4000
udf60

string

Max length: 4000
udf61

string

Max length: 4000
udf62

string

Max length: 4000
udf63

string

Max length: 4000
udf64

string

Max length: 4000
udf65

string

Max length: 4000
udf66

string

Max length: 4000
udf67

string

Max length: 4000
udf68

string

Max length: 4000
udf69

string

Max length: 4000
udf70

string

Max length: 4000
udf71

string

Max length: 4000
udf72

string

Max length: 4000
udf73

string

Max length: 4000
udf74

string

Max length: 4000
udf75

string

Max length: 4000
udf76

string

Max length: 4000
udf77

string

Max length: 4000
udf78

string

Max length: 4000
udf79

string

Max length: 4000
udf80

string

Max length: 4000
udf81

string

Max length: 4000
udf82

string

Max length: 4000
udf83

string

Max length: 4000
udf84

string

Max length: 4000
udf85

string

Max length: 4000
udf86

string

Max length: 4000
udf87

string

Max length: 4000
udf88

string

Max length: 4000
udf89

string

Max length: 4000
udf90

string

Max length: 4000
udf91

string

Max length: 4000
udf92

string

Max length: 4000
udf93

string

Max length: 4000
udf94

string

Max length: 4000
udf95

string

Max length: 4000
udf96

string

Max length: 4000
udf97

string

Max length: 4000
udf98

string

Max length: 4000
udf99

string

Max length: 4000
udf100

string

Max length: 4000