| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary key |
globally unique identifier |
Required |
| task_type_id |
Task Type ID |
globally unique identifier | |
| company_id |
Company ID |
globally unique identifier | |
| contact_id |
Contact ID |
globally unique identifier | |
| to_db_table_id |
to db table id |
globally unique identifier | |
| to_id_in_table |
to do id in table |
globally unique identifier | |
| subject |
Subject |
string |
Required Max length: 150 |
| remark |
Remark of the Task (long text area field) |
string | |
| assigned_to_user_id |
Assigned to user id |
globally unique identifier | |
| assigned_to_user_group_id |
Assigned to user group id |
globally unique identifier | |
| date_create |
Date create |
date | |
| dateutc_create |
dateutc_create |
date | |
| date_update |
Date update |
date | |
| date_start |
date_start |
date | |
| due_date |
due date |
date | |
| date_closed |
date closed |
date | |
| archived |
Archived, means the task reachs a status "Complete" |
boolean | |
| id2 |
Internal ID (numeric). Will be used if reference_back_office is empty |
integer | |
| 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 | |
| company_name |
Company name on which this task is related (Filled even if the task is linked to a Work Order or an installation) |
string |
Required Max length: 64 |
| company_code |
Company code on which this task is related (Filled even if the task is linked to a Work Order or an installation) |
string |
Max length: 50 |
| db_address_phone |
Phone number of the company |
string |
Max length: 50 |
| db_address_email |
Email address of the company |
string |
Max length: 250 |
| contact_fullname |
Contact fullname of the task |
string |
Max length: 250 |
| contact_db_address_phone |
Contact Phone number of the task |
string |
Max length: 50 |
| contact_db_address_email |
Contact Email address number of the task |
string |
Max length: 250 |
| task_type_name |
Contact Phone number of the task |
string |
Max length: 50 |
| task_status_id |
Task Status ID |
globally unique identifier | |
| task_status_name |
Status name (translated) of the task (task.task_status_id=>task_status.name) |
string |
Max length: 50 |
| task_status_description |
Status description of the task (task.task_status_id=>task_status.description) |
string |
Max length: 250 |
| task_priority_id |
Task Priority Id |
globally unique identifier | |
| task_priority_name |
Priority name (translated) of the task (task.task_priority_id=>task_priority.name) |
string |
Max length: 50 |
| assigned_to_user_fullname |
If assigned to a user, User Fullname on which the task has been assigned (task.assigned_to_user_id=>User.fullname) |
string |
Max length: 250 |
| assigned_to_user_group_name |
If assigned to a user group, UserGroup name on which the task has been assigned (task.assigned_to_user_group_id=>UserGroup.name) |
string |
Max length: 250 |
| sales_organization_name |
Organization name on which belongs the company that owns this task |
string |
Max length: 250 |
| linked_object |
Automatically value binded depending the linked object (like a job) |
string | |
| jobs_id2 |
If linked to a jobs, his ID2 |
integer | |
| jobs_reference_back_office |
If linked to a jobs, his reference_back_office |
string |
Max length: 250 |
| jobs_name |
If linked to a jobs, his name |
string |
Max length: 250 |
| project_id2 |
If linked to a project, his ID2 |
integer | |
| project_reference_back_office |
If linked to a probject, his reference_back_office |
string |
Max length: 250 |
| project_name |
If linked to a project, his name |
string |
Max length: 250 |
| project_db_address_street |
If linked to a project, the street of the project |
string | |
| project_db_address_street_number |
If linked to a project, the street number of the project |
string | |
| project_db_address_city |
If linked to a project, the city of the project |
string | |
| project_db_address_zip |
If linked to a project, the zip of the project |
string | |
| project_db_address_phone |
If linked to a project, the phone of the project |
string | |
| 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 |
