Please enable JavaScript to view this site.

Navigation: Schema: project > Tables

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

Email

 

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

X

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

  • Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
  • Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
  • Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
  • Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
  • Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
  • Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
  • Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
  • Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.

  
Disclaimer