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_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
datetime |
Next Activity Deadline | |||
activity_ |
varchar2 |
Activity Exception Decoration | Type of the exception activity on record. | ||
activity_ |
varchar2 |
Icon | Icon to indicate an exception activity. | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
Activity State | Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities. | ||
activity_ |
varchar2 |
Next Activity Summary | |||
activity_ |
varchar2 |
Activity Type Icon | Font awesome icon e.g. fa-tasks | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
allow_ |
boolean |
Show Apply Change | |||
allow_ |
boolean |
Allow Change Kanban State | |||
allow_ |
boolean |
Allow Change Stage | |||
approval_ |
varchar2 |
Approvals by stage | |||
bom_ |
varchar2 |
Difference between old BoM and new BoM revision | |||
bom_id |
varchar2 |
||||
bom_ |
varchar2 |
||||
bom_ |
varchar2 |
||||
color |
int32 |
Color | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
current_ |
varchar2 |
||||
current_ |
varchar2 |
||||
display_ |
varchar2 |
Display Name | |||
displayed_ |
varchar2 |
||||
displayed_ |
varchar2 |
||||
displayed_ |
varchar2 |
||||
displayed_ |
varchar2 |
||||
effectivity |
varchar2 |
Effective | Date on which the changes should be applied. For reference only. | ||
effectivity_ |
datetime |
Effective Date | For reference only. | ||
email_ |
varchar2 |
Email cc | |||
has_ |
boolean |
Has Message | |||
id |
int32 |
ID | |||
kanban_ |
varchar2 |
Kanban State | |||
kanban_ |
varchar2 |
Kanban State Label | |||
legend_ |
varchar2 |
Kanban Blocked Explanation | Override the default value displayed for the blocked state for kanban selection, when the ECO is in that stage. | ||
legend_ |
varchar2 |
Kanban Valid Explanation | Override the default value displayed for the done state for kanban selection, when the ECO is in that stage. | ||
legend_ |
varchar2 |
Kanban Ongoing Explanation | Override the default value displayed for the normal state for kanban selection, when the ECO is in that stage. | ||
message_ |
int32 |
Attachment Count | |||
message_ |
varchar2 |
||||
message_ |
boolean |
Message Delivery error | If checked, some messages have a delivery error. | ||
message_ |
int32 |
Number of errors | Number of messages with delivery error | ||
message_ |
boolean |
SMS Delivery error | If checked, some messages have a delivery error. | ||
message_ |
varchar2 |
||||
message_ |
boolean |
Is Follower | |||
message_ |
varchar2 |
||||
message_ |
varchar2 |
||||
message_ |
boolean |
Action Needed | If checked, new messages require your attention. | ||
message_ |
int32 |
Number of Actions | Number of messages which requires an action | ||
message_ |
varchar2 |
||||
mrp_ |
int32 |
# Attachments | |||
mrp_ |
varchar2 |
||||
my_ |
datetime |
My Activity Deadline | |||
name |
varchar2 |
Reference | |||
new_ |
varchar2 |
||||
new_ |
varchar2 |
||||
new_ |
int32 |
BoM Revision | |||
note |
varchar2 |
Note | |||
previous_ |
varchar2 |
||||
priority |
varchar2 |
Priority | |||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
routing_ |
varchar2 |
Difference between old operation and new operation revision | |||
stage_ |
varchar2 |
||||
stage_ |
varchar2 |
||||
state |
varchar2 |
Status | |||
tag_ |
varchar2 |
||||
type |
varchar2 |
Apply on | |||
type_ |
varchar2 |
||||
type_ |
varchar2 |
||||
user_ |
boolean |
Can Approve | Technical field to check if approval by current user is required | ||
user_ |
boolean |
Can Reject | Technical field to check if reject by current user is possible | ||
user_ |
varchar2 |
||||
user_ |
varchar2 |
||||
website_ |
varchar2 |
Website communication history | |||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: