| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier | |
| created_by_user_id |
Foreign key of the user who created this task. |
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 |
Foreign key of the contact linked to this 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_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 |
Foreign key of the next planned to follow up on this task. |
globally unique identifier | |
| next_task_activity_log_id |
Foreign key of the next planned to follow up on this task. |
globally unique identifier | |
| requested_by_company_id |
Foreign key of the company that requested this task. |
globally unique identifier | |
| requested_by_contact_id |
Foreign key of the contact that requested this task. |
globally unique identifier | |
| bill_to_party |
Used to know which party is the bill to. |
string |
Max length: 255 |
| dateutc_create |
Readonly system field: UTC creation date and time of this task. |
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 |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date | |
| dont_apply_sla |
When true, SLA deadlines are not enforced/computed for this task. |
boolean | |
| udf1 |
Custom user-defined text field #1. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf2 |
Custom user-defined text field #2. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf3 |
Custom user-defined text field #3. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf4 |
Custom user-defined text field #4. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf5 |
Custom user-defined text field #5. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf6 |
Custom user-defined text field #6. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf7 |
Custom user-defined text field #7. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf8 |
Custom user-defined text field #8. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf9 |
Custom user-defined text field #9. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf10 |
Custom user-defined text field #10. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf11 |
Custom user-defined text field #11. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf12 |
Custom user-defined text field #12. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf13 |
Custom user-defined text field #13. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf14 |
Custom user-defined text field #14. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf15 |
Custom user-defined text field #15. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf16 |
Custom user-defined text field #16. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf17 |
Custom user-defined text field #17. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf18 |
Custom user-defined text field #18. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf19 |
Custom user-defined text field #19. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf20 |
Custom user-defined text field #20. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf21 |
Custom user-defined text field #21. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf22 |
Custom user-defined text field #22. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf23 |
Custom user-defined text field #23. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf24 |
Custom user-defined text field #24. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf25 |
Custom user-defined text field #25. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf26 |
Custom user-defined text field #26. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf27 |
Custom user-defined text field #27. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf28 |
Custom user-defined text field #28. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf29 |
Custom user-defined text field #29. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf30 |
Custom user-defined text field #30. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf31 |
Custom user-defined text field #31. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf32 |
Custom user-defined text field #32. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf33 |
Custom user-defined text field #33. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf34 |
Custom user-defined text field #34. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf35 |
Custom user-defined text field #35. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf36 |
Custom user-defined text field #36. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf37 |
Custom user-defined text field #37. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf38 |
Custom user-defined text field #38. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf39 |
Custom user-defined text field #39. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf40 |
Custom user-defined text field #40. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf41 |
Custom user-defined text field #41. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf42 |
Custom user-defined text field #42. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf43 |
Custom user-defined text field #43. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf44 |
Custom user-defined text field #44. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf45 |
Custom user-defined text field #45. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf46 |
Custom user-defined text field #46. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf47 |
Custom user-defined text field #47. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf48 |
Custom user-defined text field #48. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf49 |
Custom user-defined text field #49. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf50 |
Custom user-defined text field #50. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf51 |
Custom user-defined text field #51. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf52 |
Custom user-defined text field #52. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf53 |
Custom user-defined text field #53. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf54 |
Custom user-defined text field #54. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf55 |
Custom user-defined text field #55. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf56 |
Custom user-defined text field #56. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf57 |
Custom user-defined text field #57. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf58 |
Custom user-defined text field #58. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf59 |
Custom user-defined text field #59. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf60 |
Custom user-defined text field #60. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf61 |
Custom user-defined text field #61. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf62 |
Custom user-defined text field #62. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf63 |
Custom user-defined text field #63. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf64 |
Custom user-defined text field #64. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf65 |
Custom user-defined text field #65. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf66 |
Custom user-defined text field #66. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf67 |
Custom user-defined text field #67. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf68 |
Custom user-defined text field #68. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf69 |
Custom user-defined text field #69. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf70 |
Custom user-defined text field #70. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf71 |
Custom user-defined text field #71. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf72 |
Custom user-defined text field #72. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf73 |
Custom user-defined text field #73. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf74 |
Custom user-defined text field #74. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf75 |
Custom user-defined text field #75. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf76 |
Custom user-defined text field #76. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf77 |
Custom user-defined text field #77. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf78 |
Custom user-defined text field #78. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf79 |
Custom user-defined text field #79. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf80 |
Custom user-defined text field #80. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf81 |
Custom user-defined text field #81. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf82 |
Custom user-defined text field #82. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf83 |
Custom user-defined text field #83. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf84 |
Custom user-defined text field #84. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf85 |
Custom user-defined text field #85. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf86 |
Custom user-defined text field #86. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf87 |
Custom user-defined text field #87. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf88 |
Custom user-defined text field #88. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf89 |
Custom user-defined text field #89. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf90 |
Custom user-defined text field #90. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf91 |
Custom user-defined text field #91. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf92 |
Custom user-defined text field #92. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf93 |
Custom user-defined text field #93. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf94 |
Custom user-defined text field #94. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf95 |
Custom user-defined text field #95. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf96 |
Custom user-defined text field #96. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf97 |
Custom user-defined text field #97. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf98 |
Custom user-defined text field #98. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf99 |
Custom user-defined text field #99. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |
| udf100 |
Custom user-defined text field #100. Meaning and usage are configured per implementation/organization and are not fixed by the platform. |
string |
Max length: 4000 |