invantive documentation
Invantive Support ForumsLog In / Sign Up

eco: Odoo itgen_odoo_eco

read only per partition

  • Catalog: Odoo
  • Schema: mrp
  • Label: itgen_odoo_eco

Engineering Change Order (ECO)

Can only retrieve data.

Table Columns

The columns of the table eco are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
active boolean Active If the active field is set to False, it will allow you to hide the engineering change order without removing it.
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
allow_apply_change boolean Show Apply Change
allow_change_kanban_state boolean Allow Change Kanban State
allow_change_stage boolean Allow Change Stage
approval_ids varchar2 Approvals by stage
bom_change_ids varchar2 Difference between old BoM and new BoM revision
bom_id varchar2
bom_id_label varchar2
bom_rebase_ids varchar2
color int32 Color
company_id varchar2
company_id_label varchar2
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
current_bom_id varchar2
current_bom_id_label varchar2
display_name varchar2 Display Name
displayed_image_attachment_id varchar2
displayed_image_attachment_id_label varchar2
displayed_image_id varchar2
displayed_image_id_label varchar2
effectivity varchar2 Effective Date on which the changes should be applied. For reference only.
effectivity_date datetime Effective Date For reference only.
email_cc varchar2 Email cc
has_message boolean Has Message
id int32 ID
kanban_state varchar2 Kanban State
kanban_state_label varchar2 Kanban State Label
legend_blocked varchar2 Kanban Blocked Explanation Override the default value displayed for the blocked state for kanban selection, when the ECO is in that stage.
legend_done varchar2 Kanban Valid Explanation Override the default value displayed for the done state for kanban selection, when the ECO is in that stage.
legend_normal varchar2 Kanban Ongoing Explanation Override the default value displayed for the normal state for kanban selection, when the ECO is in that stage.
message_attachment_count int32 Attachment Count
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 Number of Actions Number of messages which requires an action
message_partner_ids varchar2
mrp_document_count int32 # Attachments
mrp_document_ids varchar2
my_activity_date_deadline datetime My Activity Deadline
name varchar2 Reference
new_bom_id varchar2
new_bom_id_label varchar2
new_bom_revision int32 BoM Revision
note varchar2 Note
previous_change_ids varchar2
priority varchar2 Priority
product_tmpl_id varchar2
product_tmpl_id_label varchar2
routing_change_ids varchar2 Difference between old operation and new operation revision
stage_id varchar2
stage_id_label varchar2
state varchar2 Status
tag_ids varchar2
type varchar2 Apply on
type_id varchar2
type_id_label varchar2
user_can_approve boolean Can Approve Technical field to check if approval by current user is required
user_can_reject boolean Can Reject Technical field to check if reject by current user is possible
user_id varchar2
user_id_label varchar2
website_message_ids varchar2 Website communication history
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: