invantive documentation
Forum di supporto InvantiveAccedi / Registrati

task: Odoo itgen_odoo_task

read only per partition

  • Catalogo: Odoo
  • Schema: project
  • Etichetta: itgen_odoo_task

Attività

È possibile solo recuperare i dati.

Colonne della tabella

Di seguito sono riportate le colonne della tabella task. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati Label Required Marks Documentation
access_token varchar2 Security Token
access_url varchar2 Portal Access URL Customer Portal URL
access_warning varchar2 Access warning
active boolean Active
activity_calendar_event_id varchar2
activity_calendar_event_id_label varchar2
activity_date_deadline datetime Next Activity Deadline
activity_exception_decoration varchar2 Activity Exception Decoration Type of the exception activity on record.
activity_exception_icon varchar2 Icon Icon to indicate an exception activity.
activity_ids varchar2
activity_state varchar2 Activity State Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities.
activity_summary varchar2 Next Activity Summary
activity_type_icon varchar2 Activity Type Icon Font awesome icon e.g. fa-tasks
activity_type_id varchar2
activity_type_id_label varchar2
activity_user_id varchar2
activity_user_id_label varchar2
allocated_hours numeric Ore assegnate
allocation_type varchar2 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 varchar2 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_label varchar2 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 varchar2
ancestor_id_label varchar2
attachment_ids varchar2 Attachments that don't come from a message.
child_ids varchar2
child_text varchar2 Child Text
color int32 Color Index
comment varchar2 Comments
commercial_partner_id varchar2
commercial_partner_id_label varchar2
company_id varchar2
company_id_label varchar2
create_date datetime Data di creazione
create_uid varchar2
create_uid_label varchar2
currency_id varchar2
currency_id_label varchar2
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 varchar2
dependency_warning varchar2 Dependency Warning
dependent_ids varchar2
dependent_tasks_count int32 Dependent Tasks
description varchar2 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 varchar2 Nome visualizzato
display_parent_task_button boolean Display Parent Task Button
display_project_id varchar2
display_project_id_label varchar2
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 varchar2
displayed_image_id_label varchar2
document_count int32 Number of documents in Task
document_ids varchar2
documents_folder_id varchar2 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_label varchar2 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 numeric Duration
effective_hours numeric Hours Spent
email_cc varchar2 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 varchar2 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 varchar2
helpdesk_ticket_id_label varchar2
id int32 ID
invoice_count int32 Number of invoices
invoice_status varchar2 Stato della fattura
is_absent boolean Employees on Time Off
is_analytic_account_id_changed boolean Is Analytic Account Manually Changed
is_blocked boolean È bloccato
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 È privato
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 varchar2 Status
kanban_state_label varchar2 Kanban State Label
leave_types_count int32 Time Off Types Count
leave_warning varchar2 Leave Warning
legend_blocked varchar2 Kanban Blocked Explanation
legend_done varchar2 Kanban Valid Explanation
legend_normal varchar2 Kanban Ongoing Explanation
manager_id varchar2
manager_id_label varchar2
material_line_product_count int32 Material Line Product Count
material_line_total_price numeric Material Line Total Price
message_attachment_count int32 Numero di allegati
message_follower_ids varchar2
message_has_error boolean Message Delivery error If checked, some messages have a delivery error.
message_has_error_counter int32 Number of errors Number of messages with delivery error
message_has_sms_error boolean SMS Delivery error If checked, some messages have a delivery error.
message_ids varchar2
message_is_follower boolean Is Follower
message_main_attachment_id varchar2
message_main_attachment_id_label varchar2
message_needaction boolean Action Needed If checked, new messages require your attention.
message_needaction_counter int32 Numero di azioni Number of messages which requires an action
message_partner_ids varchar2
milestone_id varchar2 Deliver your services automatically when a milestone is reached by linking it to a sales order item.
milestone_id_label varchar2 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 varchar2 Title
overtime numeric Overtime
parent_id varchar2
parent_id_label varchar2
partner_city varchar2 City
partner_email varchar2 Email
partner_id varchar2
partner_id_label varchar2
partner_is_company boolean Is a Company Check if the contact is a company, otherwise it is a person
partner_mobile varchar2 Mobile
partner_phone varchar2 Phone
partner_street varchar2 Street
partner_zip varchar2 Zip
personal_stage_id varchar2 The current user's personal stage.
personal_stage_id_label varchar2 The current user's personal stage.
personal_stage_type_id varchar2 The current user's personal task stage.
personal_stage_type_id_label varchar2 The current user's personal task stage.
personal_stage_type_ids varchar2
planned_date_begin datetime Data di inizio
planned_date_end datetime Data di fine
planned_hours numeric Initially Planned Hours
planning_overlap varchar2 Planning Overlap
portal_effective_hours numeric Portal Effective Hours Time spent on this task, excluding its sub-tasks.
portal_invoice_count int32 Invoice Count
portal_progress numeric Portal Progress Display progress of current task.
portal_quotation_count int32 Portal Quotation Count
portal_remaining_hours numeric Portal Remaining Hours Total remaining time, can be re-estimated periodically by the assignee of the task.
portal_subtask_effective_hours numeric Portal Subtask Effective Hours Time spent on the sub-tasks (and their own sub-tasks) of this task.
portal_total_hours_spent numeric Portal Total Hours Spent Time spent on this task, including its sub-tasks.
portal_user_names varchar2 Portal User Names
pricelist_id varchar2
pricelist_id_label varchar2
pricing_type varchar2 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 varchar2 Priority
progress numeric Progress
project_analytic_account_id varchar2 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_label varchar2 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 varchar2
project_id_label varchar2
project_privacy_visibility varchar2 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 varchar2 Sales order to which the project is linked.
project_sale_order_id_label varchar2 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 numeric Valutazione media
rating_avg_text varchar2 Rating Avg Text
rating_count int32 Rating count
rating_ids varchar2
rating_last_feedback varchar2 Rating Last Feedback
rating_last_image varbinary Rating Last Image
rating_last_text varchar2 Rating Text
rating_last_value numeric Rating Last Value
rating_percentage_satisfaction numeric Rating Satisfaction
recurrence_id varchar2
recurrence_id_label varchar2
recurrence_message varchar2 Next Recurrencies
recurrence_update varchar2 Aggiornamento delle ricorrenze
recurring_count int32 Tasks in Recurrence
recurring_task boolean Recurrent
remaining_hours numeric Ore residue Number of allocated hours minus the number of hours spent.
remaining_hours_available boolean Remaining Hours Available
remaining_hours_percentage numeric Remaining Hours Percentage
remaining_hours_so numeric Remaining Hours on SO
repeat_day varchar2 Repeat Day
repeat_interval int32 Repeat Every
repeat_month varchar2 Repeat Month
repeat_number int32 Repetitions
repeat_on_month varchar2 Repeat On Month
repeat_on_year varchar2 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 varchar2 Until
repeat_unit varchar2 Repeat Unit
repeat_until datetime Data di fine
repeat_week varchar2 Repeat Week
repeat_weekday varchar2 Day Of The Week
sale_line_id varchar2 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_label varchar2 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 varchar2 Sales order to which the task is linked.
sale_order_id_label varchar2 Sales order to which the task is linked.
sat boolean Sat
sequence int32 Sequence
shared_document_ids varchar2
so_analytic_account_id varchar2
so_analytic_account_id_label varchar2
stage_display varchar2 Stage Display
stage_id varchar2
stage_id_label varchar2
subtask_count int32 Sub-task Count
subtask_effective_hours numeric Hours Spent on Sub-Tasks Time spent on the sub-tasks (and their own sub-tasks) of this task.
subtask_planned_hours numeric 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 varchar2 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 varchar2 Properties
task_to_invoice boolean To invoice
thu boolean Thu
timer_pause datetime Timer Last Pause
timer_start datetime Timer Start
timesheet_ids varchar2
timesheet_product_id varchar2 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_label varchar2 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 numeric Totale ore Time spent on this task and its sub-tasks (and their own sub-tasks).
tue boolean Tue
user_ids varchar2
user_names varchar2 User Names
user_timer_id varchar2
warning_message varchar2 Warning Message
website_message_ids varchar2 Website communication history
wed boolean Wed
working_days_close numeric Working Days to Close
working_days_open numeric Working Days to Assign
working_hours_close numeric Working Hours to Close
working_hours_open numeric Working Hours to Assign
worksheet_color int32 Color
worksheet_count int32 Worksheet Count
worksheet_signature varbinary Signature
worksheet_signed_by varchar2 Signed By
worksheet_template_id varchar2 Create templates for each type of intervention you have and customize their content with your own custom fields.
worksheet_template_id_label varchar2 Create templates for each type of intervention you have and customize their content with your own custom fields.
write_date datetime Ultimo aggiornamento il
write_uid varchar2
write_uid_label varchar2

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: