workorder: Odoo itgen_odoo_workorder
read only per partition
- Catalogo:
Odoo - Schema:
mrp - Etichetta: itgen_odoo_workorder
Work Order
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella workorder. 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 |
|---|---|---|---|---|---|
allow_ |
boolean |
Allow Work Order Dependencies | |||
blocked_ |
varchar2 |
||||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
consumption |
varchar2 |
Consumption | |||
costs_ |
numeric |
Cost per hour | |||
create_ |
datetime |
Creato il | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
date_ |
datetime |
Data di fine | |||
date_ |
datetime |
Scheduled End Date | |||
date_ |
datetime |
Scheduled Start Date | |||
date_ |
datetime |
Data di inizio | |||
display_ |
varchar2 |
Nome visualizzato | |||
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 |
Data di produzione | Date at which you plan to start the production. | ||
production_ |
varchar2 |
||||
production_ |
varchar2 |
||||
production_ |
varchar2 |
Stato della produzione | * 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 |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: