workorder: Odoo itgen_odoo_workorder
read only per partition
- Catalog:
Odoo - Schema:
mrp - Label: itgen_odoo_workorder
Work Order
Can only retrieve data.
Table Columns
The columns of the table workorder 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 |
|---|---|---|---|---|---|
allow_ |
boolean |
Allow Work Order Dependencies | |||
blocked_ |
varchar2 |
||||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
consumption |
varchar2 |
Consumption | |||
costs_ |
numeric |
Cost per hour | |||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
date_ |
datetime |
End Date | |||
date_ |
datetime |
Scheduled End Date | |||
date_ |
datetime |
Scheduled Start Date | |||
date_ |
datetime |
Start Date | |||
display_ |
varchar2 |
Display Name | |||
duration |
numeric |
Real Duration | |||
duration_ |
numeric |
Expected Duration | |||
duration_ |
int32 |
Duration Deviation (%) | |||
duration_ |
numeric |
Duration Per Unit | |||
finished_ |
varchar2 |
||||
finished_ |
varchar2 |
||||
id |
int32 |
ID | |||
is_ |
boolean |
Its Operations are Planned | |||
is_ |
boolean |
Has Been Produced | |||
is_ |
boolean |
Is the Current User Working | |||
json_ |
varchar2 |
Popover Data JSON | |||
last_ |
varchar2 |
||||
leave_ |
varchar2 |
Slot into workcenter calendar once planned | |||
leave_ |
varchar2 |
Slot into workcenter calendar once planned | |||
mo_ |
varchar2 |
||||
mo_ |
varchar2 |
||||
move_ |
varchar2 |
||||
move_ |
varchar2 |
Inventory moves for which you must scan a lot number at this work order | |||
move_ |
varchar2 |
||||
name |
varchar2 |
Work Order | |||
needed_ |
varchar2 |
||||
operation_ |
varchar2 |
||||
operation_ |
varchar2 |
||||
operation_ |
varchar2 |
Description | |||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
varchar2 |
Tracking | Ensure the traceability of a storable product in your warehouse. | ||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
production_ |
varchar2 |
Stock Availability | Manufacturing readiness for this MO, as per bill of material configuration: * Ready: The material is available to start the production. * Waiting: The material is not available to start the production. | ||
production_ |
varchar2 |
Bills of Materials, also called recipes, are used to autocomplete components and work order instructions. | |||
production_ |
varchar2 |
Bills of Materials, also called recipes, are used to autocomplete components and work order instructions. | |||
production_ |
datetime |
Production Date | Date at which you plan to start the production. | ||
production_ |
varchar2 |
||||
production_ |
varchar2 |
||||
production_ |
varchar2 |
Production State | * Draft: The MO is not confirmed yet. * Confirmed: The MO is confirmed, the stock rules and the reordering of the components are trigerred. * In Progress: The production has started (on the MO or on the WO). * To Close: The production is done, the MO has to be closed. * Done: The MO is closed, the stock moves are posted. * Cancelled: The MO has been cancelled, can't be confirmed anymore. | ||
progress |
numeric |
Progress Done (%) | |||
qty_ |
numeric |
Quantity | The number of products already handled by this work order | ||
qty_ |
numeric |
Currently Produced Quantity | |||
qty_ |
numeric |
Original Production Quantity | |||
qty_ |
numeric |
Quantity To Be Produced | |||
qty_ |
numeric |
Carried Quantity | The quantity already produced awaiting allocation in the backorders chain. | ||
scrap_ |
int32 |
Scrap Move | |||
scrap_ |
varchar2 |
||||
show_ |
boolean |
Show Popover? | |||
state |
varchar2 |
Status | |||
time_ |
varchar2 |
||||
wc_ |
varchar2 |
||||
wc_ |
varchar2 |
||||
workcenter_ |
varchar2 |
||||
workcenter_ |
varchar2 |
||||
working_ |
varchar2 |
Workcenter Status | |||
working_ |
varchar2 |
||||
worksheet |
varbinary |
Worksheet | |||
worksheet_ |
varchar2 |
Worksheet URL | Paste the url of your Google Slide. Make sure the access to the document is public. | ||
worksheet_ |
varchar2 |
Worksheet Type | |||
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: