workorder: Odoo itgen_odoo_workorder
read only per partition
- Catálogo:
Odoo - Esquema:
mrp - Etiqueta: itgen_odoo_workorder
Work Order
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla workorder. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | 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 |
Creado en | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
date_ |
datetime |
Fecha Final | |||
date_ |
datetime |
Scheduled End Date | |||
date_ |
datetime |
Scheduled Start Date | |||
date_ |
datetime |
Fecha Inicial | |||
display_ |
varchar2 |
Nombre para mostrar | |||
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 |
Fecha de producción | Date at which you plan to start the production. | ||
production_ |
varchar2 |
||||
production_ |
varchar2 |
||||
production_ |
varchar2 |
Estado de la producción | * 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 |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: