task |
Task
Catalog: Odoo
Schema: project
The data in this table is partitioned per value of the column.
This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API.
Table Columns
The columns of the table task are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
access_token |
string |
Security Token |
☐ |
|
access_url |
string |
Portal Access URL |
☐ |
Customer Portal URL |
access_warning |
string |
Access warning |
☐ |
|
active |
boolean |
Active |
☐ |
|
activity_calendar_event_id_label |
string |
|
☐ |
|
activity_calendar_event_id |
string |
|
☐ |
|
activity_date_deadline |
datetime |
Next Activity Deadline |
☐ |
|
activity_exception_decoration |
string |
Activity Exception Decoration |
☐ |
Type of the exception activity on record. |
activity_exception_icon |
string |
Icon |
☐ |
Icon to indicate an exception activity. |
activity_ids |
string |
|
☐ |
|
activity_state |
string |
Activity State |
☐ |
Status based on activitiesOverdue: Due date is already passedToday: Activity date is todayPlanned: Future activities. |
activity_summary |
string |
Next Activity Summary |
☐ |
|
activity_type_icon |
string |
Activity Type Icon |
☐ |
Font awesome icon e.g. fa-tasks |
activity_type_id_label |
string |
|
☐ |
|
activity_type_id |
string |
|
☐ |
|
activity_user_id_label |
string |
|
☐ |
|
activity_user_id |
string |
|
☐ |
|
allocated_hours |
decimal |
Allocated Hours |
☐ |
|
allocation_type |
string |
Allocation Type |
☐ |
|
allow_billable |
boolean |
Billable |
☐ |
|
allow_material |
boolean |
Products on Tasks |
☐ |
|
allow_milestones |
boolean |
Milestones |
☐ |
|
allow_quotations |
boolean |
Extra Quotations |
☐ |
|
allow_recurring_tasks |
boolean |
Recurring Tasks |
☐ |
|
allow_subtasks |
boolean |
Allow Sub-tasks |
☐ |
|
allow_task_dependencies |
boolean |
Task Dependencies |
☐ |
|
allow_timesheets |
boolean |
Allow timesheets |
☐ |
Timesheets can be logged on this task. |
allow_worksheets |
boolean |
Worksheets |
☐ |
|
analytic_account_active |
boolean |
Active Analytic Account |
☐ |
|
analytic_account_id_label |
string |
|
☐ |
Analytic account to which this task and its timesheets are linked.Track the costs and revenues of your task by setting its analytic account on your related documents (e.g. sales orders, invoices, purchase orders, vendor bills, expenses etc.).By default, the analytic account of the project is set. However, it can be changed on each task individually if necessary. |
analytic_account_id |
string |
|
☐ |
Analytic account to which this task and its timesheets are linked.Track the costs and revenues of your task by setting its analytic account on your related documents (e.g. sales orders, invoices, purchase orders, vendor bills, expenses etc.).By default, the analytic account of the project is set. However, it can be changed on each task individually if necessary. |
ancestor_id_label |
string |
|
☐ |
|
ancestor_id |
string |
|
☐ |
|
attachment_ids |
string |
|
☐ |
Attachments that don't come from a message. |
child_ids |
string |
|
☐ |
|
child_text |
string |
Child Text |
☐ |
|
color |
int32 |
Color Index |
☐ |
|
comment |
string |
Comments |
☐ |
|
commercial_partner_id_label |
string |
|
☐ |
|
commercial_partner_id |
string |
|
☐ |
|
company_id_label |
string |
|
☐ |
|
company_id |
string |
|
☐ |
|
create_date |
datetime |
Created On |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
currency_id_label |
string |
|
☐ |
|
currency_id |
string |
|
☐ |
|
date_assign |
datetime |
Assigning Date |
☐ |
Date on which this task was last assigned (or unassigned). Based on this, you can get statistics on the time it usually takes to assign tasks. |
date_deadline |
datetime |
Deadline |
☐ |
|
date_end |
datetime |
Ending Date |
☐ |
|
date_last_stage_update |
datetime |
Last Stage Update |
☐ |
Date on which the stage of your task has last been modified.Based on this information you can identify tasks that are stalling and get statistics on the time it usually takes to move tasks from one stage to another. |
depend_on_ids |
string |
|
☐ |
|
dependency_warning |
string |
Dependency Warning |
☐ |
|
dependent_ids |
string |
|
☐ |
|
dependent_tasks_count |
int32 |
Dependent Tasks |
☐ |
|
description |
string |
Description |
☐ |
|
display_create_invoice_primary |
boolean |
Display Create Invoice Primary |
☐ |
|
display_create_invoice_secondary |
boolean |
Display Create Invoice Secondary |
☐ |
|
display_enabled_conditions_count |
int32 |
Display Enabled Conditions Count |
☐ |
|
display_helpdesk_ticket_button |
boolean |
Display Ticket |
☐ |
|
display_mark_as_done_primary |
boolean |
Display Mark As Done Primary |
☐ |
|
display_mark_as_done_secondary |
boolean |
Display Mark As Done Secondary |
☐ |
|
display_name |
string |
Display Name |
☐ |
|
display_parent_task_button |
boolean |
Display Parent Task Button |
☐ |
|
display_project_id_label |
string |
|
☐ |
|
display_project_id |
string |
|
☐ |
|
display_sale_order_button |
boolean |
Display Sales Order |
☐ |
|
display_satisfied_conditions_count |
int32 |
Display Satisfied Conditions Count |
☐ |
|
display_send_report_primary |
boolean |
Display Send Report Primary |
☐ |
|
display_send_report_secondary |
boolean |
Display Send Report Secondary |
☐ |
|
display_sign_report_primary |
boolean |
Display Sign Report Primary |
☐ |
|
display_sign_report_secondary |
boolean |
Display Sign Report Secondary |
☐ |
|
display_timer_pause |
boolean |
Display Timer Pause |
☐ |
|
display_timer_resume |
boolean |
Display Timer Resume |
☐ |
|
display_timer_start_primary |
boolean |
Display Timer Start Primary |
☐ |
|
display_timer_start_secondary |
boolean |
Display Timer Start Secondary |
☐ |
|
display_timer_stop |
boolean |
Display Timer Stop |
☐ |
|
display_timesheet_timer |
boolean |
Display Timesheet Time |
☐ |
|
display_warning_dependency_in_gantt |
boolean |
Display Warning Dependency In Gantt |
☐ |
|
displayed_image_id_label |
string |
|
☐ |
|
displayed_image_id |
string |
|
☐ |
|
document_count |
int32 |
Number of documents in Task |
☐ |
|
document_ids |
string |
|
☐ |
|
documents_folder_id_label |
string |
|
☐ |
Workspace in which all of the documents of this project will be categorized. All of the attachments of your tasks will be automatically added as documents in this workspace as well. |
documents_folder_id |
string |
|
☐ |
Workspace in which all of the documents of this project will be categorized. All of the attachments of your tasks will be automatically added as documents in this workspace as well. |
duration |
decimal |
Duration |
☐ |
|
effective_hours |
decimal |
Hours Spent |
☐ |
|
email_cc |
string |
Email cc |
☐ |
Email addresses that were in the CC of the incoming emails from this task and that are not currently linked to an existing customer. |
email_from |
string |
Email From |
☐ |
These people will receive email. |
encode_uom_in_days |
boolean |
Encode Uom In Days |
☐ |
|
fri |
boolean |
Fri |
☐ |
|
fsm_done |
boolean |
Task Done |
☐ |
|
fsm_is_sent |
boolean |
Is Worksheet sent |
☐ |
|
has_late_and_unreached_milestone |
boolean |
Has Late And Unreached Milestone |
☐ |
|
has_message |
boolean |
Has Message |
☐ |
|
has_multi_sol |
boolean |
Has Multi Sol |
☐ |
|
helpdesk_ticket_id_label |
string |
|
☐ |
|
helpdesk_ticket_id |
string |
|
☐ |
|
id |
int32 |
ID |
☐ |
|
invoice_count |
int32 |
Number of invoices |
☐ |
|
invoice_status |
string |
Invoice Status |
☐ |
|
is_absent |
boolean |
Employees on Time Off |
☐ |
|
is_analytic_account_id_changed |
boolean |
Is Analytic Account Manually Changed |
☐ |
|
is_blocked |
boolean |
Is Blocked |
☐ |
|
is_closed |
boolean |
Closing Stage |
☐ |
Folded in Kanban stages are closing stages. |
is_fsm |
boolean |
Field Service |
☐ |
Display tasks in the Field Service module and allow planning with start/end dates. |
is_private |
boolean |
Is Private |
☐ |
|
is_project_map_empty |
boolean |
Is Project map empty |
☐ |
|
is_task_phone_update |
boolean |
Is Task Phone Update |
☐ |
|
is_timeoff_task |
boolean |
Is Time off Task |
☐ |
|
is_timer_running |
boolean |
Is Timer Running |
☐ |
|
kanban_state_label |
string |
Kanban State Label |
☐ |
|
kanban_state |
string |
Status |
☑ |
|
leave_types_count |
int32 |
Time Off Types Count |
☐ |
|
leave_warning |
string |
Leave Warning |
☐ |
|
legend_blocked |
string |
Kanban Blocked Explanation |
☐ |
|
legend_done |
string |
Kanban Valid Explanation |
☐ |
|
legend_normal |
string |
Kanban Ongoing Explanation |
☐ |
|
manager_id_label |
string |
|
☐ |
|
manager_id |
string |
|
☐ |
|
material_line_product_count |
int32 |
Material Line Product Count |
☐ |
|
material_line_total_price |
decimal |
Material Line Total Price |
☐ |
|
message_attachment_count |
int32 |
Attachment Count |
☐ |
|
message_follower_ids |
string |
|
☐ |
|
message_has_error_counter |
int32 |
Number of errors |
☐ |
Number of messages with delivery error |
message_has_error |
boolean |
Message Delivery error |
☐ |
If checked, some messages have a delivery error. |
message_has_sms_error |
boolean |
SMS Delivery error |
☐ |
If checked, some messages have a delivery error. |
message_ids |
string |
|
☐ |
|
message_is_follower |
boolean |
Is Follower |
☐ |
|
message_main_attachment_id_label |
string |
|
☐ |
|
message_main_attachment_id |
string |
|
☐ |
|
message_needaction_counter |
int32 |
Number of Actions |
☐ |
Number of messages which requires an action |
message_needaction |
boolean |
Action Needed |
☐ |
If checked, new messages require your attention. |
message_partner_ids |
string |
|
☐ |
|
milestone_id_label |
string |
|
☐ |
Deliver your services automatically when a milestone is reached by linking it to a sales order item. |
milestone_id |
string |
|
☐ |
Deliver your services automatically when a milestone is reached by linking it to a sales order item. |
mon |
boolean |
Mon |
☐ |
|
my_activity_date_deadline |
datetime |
My Activity Deadline |
☐ |
|
name |
string |
Title |
☑ |
|
overtime |
decimal |
Overtime |
☐ |
|
parent_id_label |
string |
|
☐ |
|
parent_id |
string |
|
☐ |
|
partner_city |
string |
City |
☐ |
|
partner_email |
string |
☐ |
|
|
partner_id_label |
string |
|
☐ |
|
partner_id |
string |
|
☐ |
|
partner_is_company |
boolean |
Is a Company |
☐ |
Check if the contact is a company, otherwise it is a person |
partner_mobile |
string |
Mobile |
☐ |
|
partner_phone |
string |
Phone |
☐ |
|
partner_street |
string |
Street |
☐ |
|
partner_zip |
string |
Zip |
☐ |
|
personal_stage_id_label |
string |
|
☐ |
The current user's personal stage. |
personal_stage_id |
string |
|
☐ |
The current user's personal stage. |
personal_stage_type_id_label |
string |
|
☐ |
The current user's personal task stage. |
personal_stage_type_id |
string |
|
☐ |
The current user's personal task stage. |
personal_stage_type_ids |
string |
|
☐ |
|
planned_date_begin |
datetime |
Start date |
☐ |
|
planned_date_end |
datetime |
End date |
☐ |
|
planned_hours |
decimal |
Initially Planned Hours |
☐ |
|
planning_overlap |
string |
Planning Overlap |
☐ |
|
portal_effective_hours |
decimal |
Portal Effective Hours |
☐ |
Time spent on this task, excluding its sub-tasks. |
portal_invoice_count |
int32 |
Invoice Count |
☐ |
|
portal_progress |
decimal |
Portal Progress |
☐ |
Display progress of current task. |
portal_quotation_count |
int32 |
Portal Quotation Count |
☐ |
|
portal_remaining_hours |
decimal |
Portal Remaining Hours |
☐ |
Total remaining time, can be re-estimated periodically by the assignee of the task. |
portal_subtask_effective_hours |
decimal |
Portal Subtask Effective Hours |
☐ |
Time spent on the sub-tasks (and their own sub-tasks) of this task. |
portal_total_hours_spent |
decimal |
Portal Total Hours Spent |
☐ |
Time spent on this task, including its sub-tasks. |
portal_user_names |
string |
Portal User Names |
☐ |
|
pricelist_id_label |
string |
|
☐ |
|
pricelist_id |
string |
|
☐ |
|
pricing_type |
string |
Pricing |
☐ |
The task rate is perfect if you would like to bill different services to different customers at different rates. The fixed rate is perfect if you bill a service at a fixed rate per hour or day worked regardless of the employee who performed it. The employee rate is preferable if your employees deliver the same service at a different rate. For instance, junior and senior consultants would deliver the same service (= consultancy), but at a different rate because of their level of seniority. |
priority |
string |
Priority |
☐ |
|
progress |
decimal |
Progress |
☐ |
|
project_analytic_account_id_label |
string |
|
☐ |
Analytic account to which this project, its tasks and its timesheets are linked. Track the costs and revenues of your project by setting this analytic account on your related documents (e.g. sales orders, invoices, purchase orders, vendor bills, expenses etc.).This analytic account can be changed on each task individually if necessary.An analytic account is required in order to use timesheets. |
project_analytic_account_id |
string |
|
☐ |
Analytic account to which this project, its tasks and its timesheets are linked. Track the costs and revenues of your project by setting this analytic account on your related documents (e.g. sales orders, invoices, purchase orders, vendor bills, expenses etc.).This analytic account can be changed on each task individually if necessary.An analytic account is required in order to use timesheets. |
project_color |
int32 |
Project color |
☐ |
|
project_id_label |
string |
|
☐ |
|
project_id |
string |
|
☐ |
|
project_privacy_visibility |
string |
Project Visibility |
☐ |
People to whom this project and its tasks will be visible.- Invited internal users: when following a project, internal users will get access to all of its tasks without distinction. Otherwise, they will only get access to the specific tasks they are following.A user with the project > administrator access right level can still access this project and its tasks, even if they are not explicitly part of the followers.- All internal users: all internal users can access the project and all of its tasks without distinction.- Invited portal users and all internal users: all internal users can access the project and all of its tasks without distinction.When following a project, portal users will get access to all of its tasks without distinction. Otherwise, they will only get access to the specific tasks they are following.When a project is shared in read-only, the portal user is redirected to their portal. They can view the tasks, but not edit them.When a project is shared in edit, the portal user is redirected to the kanban and list views of the tasks. They can modify a selected number of fields on the tasks.In any case, an internal user with no project access rights can still access a task, provided that they are given the corresponding URL (and that they are part of the followers if the project is private). |
project_sale_order_id_label |
string |
|
☐ |
Sales order to which the project is linked. |
project_sale_order_id |
string |
|
☐ |
Sales order to which the project is linked. |
project_use_documents |
boolean |
Use Documents |
☐ |
|
quotation_count |
int32 |
Quotation Count |
☐ |
|
rating_active |
boolean |
Project Rating Status |
☐ |
|
rating_avg_text |
string |
Rating Avg Text |
☐ |
|
rating_avg |
decimal |
Average Rating |
☐ |
|
rating_count |
int32 |
Rating count |
☐ |
|
rating_ids |
string |
|
☐ |
|
rating_last_feedback |
string |
Rating Last Feedback |
☐ |
|
rating_last_image |
byte[] |
Rating Last Image |
☐ |
|
rating_last_text |
string |
Rating Text |
☐ |
|
rating_last_value |
decimal |
Rating Last Value |
☐ |
|
rating_percentage_satisfaction |
decimal |
Rating Satisfaction |
☐ |
|
recurrence_id_label |
string |
|
☐ |
|
recurrence_id |
string |
|
☐ |
|
recurrence_message |
string |
Next Recurrencies |
☐ |
|
recurrence_update |
string |
Recurrence Update |
☐ |
|
recurring_count |
int32 |
Tasks in Recurrence |
☐ |
|
recurring_task |
boolean |
Recurrent |
☐ |
|
remaining_hours_available |
boolean |
Remaining Hours Available |
☐ |
|
remaining_hours_percentage |
decimal |
Remaining Hours Percentage |
☐ |
|
remaining_hours_so |
decimal |
Remaining Hours on SO |
☐ |
|
remaining_hours |
decimal |
Remaining Hours |
☐ |
Number of allocated hours minus the number of hours spent. |
repeat_day |
string |
Repeat Day |
☐ |
|
repeat_interval |
int32 |
Repeat Every |
☐ |
|
repeat_month |
string |
Repeat Month |
☐ |
|
repeat_number |
int32 |
Repetitions |
☐ |
|
repeat_on_month |
string |
Repeat On Month |
☐ |
|
repeat_on_year |
string |
Repeat On Year |
☐ |
|
repeat_show_day |
boolean |
Repeat Show Day |
☐ |
|
repeat_show_dow |
boolean |
Repeat Show Dow |
☐ |
|
repeat_show_month |
boolean |
Repeat Show Month |
☐ |
|
repeat_show_week |
boolean |
Repeat Show Week |
☐ |
|
repeat_type |
string |
Until |
☐ |
|
repeat_unit |
string |
Repeat Unit |
☐ |
|
repeat_until |
datetime |
End Date |
☐ |
|
repeat_week |
string |
Repeat Week |
☐ |
|
repeat_weekday |
string |
Day Of The Week |
☐ |
|
sale_line_id_label |
string |
|
☐ |
Sales Order Item to which the time spent on this task will be added in order to be invoiced to your customer.By default the sales order item set on the project will be selected. In the absence of one, the last prepaid sales order item that has time remaining will be used.Remove the sales order item in order to make this task non billable. You can also change or remove the sales order item of each timesheet entry individually. |
sale_line_id |
string |
|
☐ |
Sales Order Item to which the time spent on this task will be added in order to be invoiced to your customer.By default the sales order item set on the project will be selected. In the absence of one, the last prepaid sales order item that has time remaining will be used.Remove the sales order item in order to make this task non billable. You can also change or remove the sales order item of each timesheet entry individually. |
sale_order_id_label |
string |
|
☐ |
Sales order to which the task is linked. |
sale_order_id |
string |
|
☐ |
Sales order to which the task is linked. |
sat |
boolean |
Sat |
☐ |
|
sequence |
int32 |
Sequence |
☐ |
|
shared_document_ids |
string |
|
☐ |
|
so_analytic_account_id_label |
string |
|
☐ |
|
so_analytic_account_id |
string |
|
☐ |
|
stage_display |
string |
Stage Display |
☐ |
|
stage_id_label |
string |
|
☐ |
|
stage_id |
string |
|
☐ |
|
subtask_count |
int32 |
Sub-task Count |
☐ |
|
subtask_effective_hours |
decimal |
Hours Spent on Sub-Tasks |
☐ |
Time spent on the sub-tasks (and their own sub-tasks) of this task. |
subtask_planned_hours |
decimal |
Sub-tasks Planned Hours |
☐ |
Sum of the hours allocated for all the sub-tasks (and their own sub-tasks) linked to this task. Usually less than or equal to the allocated hours of this task. |
sun |
boolean |
Sun |
☐ |
|
tag_ids |
string |
|
☐ |
You can only see tags that are already present in your project. If you try creating a tag that is already existing in other projects, it won't generate any duplicates. |
task_properties |
string |
Properties |
☐ |
|
task_to_invoice |
boolean |
To invoice |
☐ |
|
thu |
boolean |
Thu |
☐ |
|
timer_pause |
datetime |
Timer Last Pause |
☐ |
|
timer_start |
datetime |
Timer Start |
☐ |
|
timesheet_ids |
string |
|
☐ |
|
timesheet_product_id_label |
string |
|
☐ |
Service that will be used by default when invoicing the time spent on a task. It can be modified on each task individually by selecting a specific sales order item. |
timesheet_product_id |
string |
|
☐ |
Service that will be used by default when invoicing the time spent on a task. It can be modified on each task individually by selecting a specific sales order item. |
total_hours_spent |
decimal |
Total Hours |
☐ |
Time spent on this task and its sub-tasks (and their own sub-tasks). |
tue |
boolean |
Tue |
☐ |
|
user_ids |
string |
|
☐ |
|
user_names |
string |
User Names |
☐ |
|
user_timer_id |
string |
|
☐ |
|
warning_message |
string |
Warning Message |
☐ |
|
website_message_ids |
string |
|
☐ |
Website communication history |
wed |
boolean |
Wed |
☐ |
|
working_days_close |
decimal |
Working Days to Close |
☐ |
|
working_days_open |
decimal |
Working Days to Assign |
☐ |
|
working_hours_close |
decimal |
Working Hours to Close |
☐ |
|
working_hours_open |
decimal |
Working Hours to Assign |
☐ |
|
worksheet_color |
int32 |
Color |
☐ |
|
worksheet_count |
int32 |
Worksheet Count |
☐ |
|
worksheet_signature |
byte[] |
Signature |
☐ |
|
worksheet_signed_by |
string |
Signed By |
☐ |
|
worksheet_template_id_label |
string |
|
☐ |
Create templates for each type of intervention you have and customize their content with your own custom fields. |
worksheet_template_id |
string |
|
☐ |
Create templates for each type of intervention you have and customize their content with your own custom fields. |
write_date |
datetime |
Last Updated On |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826