---
title: "workorder (Odoo)"
description: "itgen_odoo_workorder"
language: it
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/it/datamodels/odoo/Odoo.mrp.workorder
original: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.mrp.workorder
updated: 2026-11-18T01:05:26Z
license: https://documentation.invantive.eu/it/
---

# 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_workorder_dependencies` | `boolean` | Allow Work Order Dependencies | [ ] |  |  |
| `blocked_by_workorder_ids` | `varchar2` |  | [ ] |  |  |
| `company_id` | `varchar2` |  | [ ] |  |  |
| `company_id_label` | `varchar2` |  | [ ] |  |  |
| `consumption` | `varchar2` | Consumption | [ ] |  |  |
| `costs_hour` | `numeric` | Cost per hour | [ ] |  |  |
| `create_date` | `datetime` | Creato il | [ ] |  |  |
| `create_uid` | `varchar2` |  | [ ] |  |  |
| `create_uid_label` | `varchar2` |  | [ ] |  |  |
| `date_finished` | `datetime` | Data di fine | [ ] |  |  |
| `date_planned_finished` | `datetime` | Scheduled End Date | [ ] |  |  |
| `date_planned_start` | `datetime` | Scheduled Start Date | [ ] |  |  |
| `date_start` | `datetime` | Data di inizio | [ ] |  |  |
| `display_name` | `varchar2` | Nome visualizzato | [ ] |  |  |
| `duration` | `numeric` | Real Duration | [ ] |  |  |
| `duration_expected` | `numeric` | Expected Duration | [ ] |  |  |
| `duration_percent` | `int32` | Duration Deviation (%) | [ ] |  |  |
| `duration_unit` | `numeric` | Duration Per Unit | [ ] |  |  |
| `finished_lot_id` | `varchar2` |  | [ ] |  |  |
| `finished_lot_id_label` | `varchar2` |  | [ ] |  |  |
| `id` | `int32` | ID | [ ] |  |  |
| `is_planned` | `boolean` | Its Operations are Planned | [ ] |  |  |
| `is_produced` | `boolean` | Has Been Produced | [ ] |  |  |
| `is_user_working` | `boolean` | Is the Current User Working | [ ] |  |  |
| `json_popover` | `varchar2` | Popover Data JSON | [ ] |  |  |
| `last_working_user_id` | `varchar2` |  | [ ] |  |  |
| `leave_id` | `varchar2` |  | [ ] |  | Slot into workcenter calendar once planned |
| `leave_id_label` | `varchar2` |  | [ ] |  | Slot into workcenter calendar once planned |
| `mo_analytic_account_line_id` | `varchar2` |  | [ ] |  |  |
| `mo_analytic_account_line_id_label` | `varchar2` |  | [ ] |  |  |
| `move_finished_ids` | `varchar2` |  | [ ] |  |  |
| `move_line_ids` | `varchar2` |  | [ ] |  | Inventory moves for which you must scan a lot number at this work order |
| `move_raw_ids` | `varchar2` |  | [ ] |  |  |
| `name` | `varchar2` | Work Order | [x] |  |  |
| `needed_by_workorder_ids` | `varchar2` |  | [ ] |  |  |
| `operation_id` | `varchar2` |  | [ ] |  |  |
| `operation_id_label` | `varchar2` |  | [ ] |  |  |
| `operation_note` | `varchar2` | Description | [ ] |  |  |
| `product_id` | `varchar2` |  | [ ] |  |  |
| `product_id_label` | `varchar2` |  | [ ] |  |  |
| `product_tracking` | `varchar2` | Tracking | [ ] |  | Ensure the traceability of a storable product in your warehouse. |
| `product_uom_id` | `varchar2` |  | [ ] |  |  |
| `product_uom_id_label` | `varchar2` |  | [ ] |  |  |
| `production_availability` | `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_bom_id` | `varchar2` |  | [ ] |  | Bills of Materials, also called recipes, are used to autocomplete components and work order instructions. |
| `production_bom_id_label` | `varchar2` |  | [ ] |  | Bills of Materials, also called recipes, are used to autocomplete components and work order instructions. |
| `production_date` | `datetime` | Data di produzione | [ ] |  | Date at which you plan to start the production. |
| `production_id` | `varchar2` |  | [ ] |  |  |
| `production_id_label` | `varchar2` |  | [ ] |  |  |
| `production_state` | `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_produced` | `numeric` | Quantity | [ ] |  | The number of products already handled by this work order |
| `qty_producing` | `numeric` | Currently Produced Quantity | [ ] |  |  |
| `qty_production` | `numeric` | Original Production Quantity | [ ] |  |  |
| `qty_remaining` | `numeric` | Quantity To Be Produced | [ ] |  |  |
| `qty_reported_from_previous_wo` | `numeric` | Carried Quantity | [ ] |  | The quantity already produced awaiting allocation in the backorders chain. |
| `scrap_count` | `int32` | Scrap Move | [ ] |  |  |
| `scrap_ids` | `varchar2` |  | [ ] |  |  |
| `show_json_popover` | `boolean` | Show Popover? | [ ] |  |  |
| `state` | `varchar2` | Status | [ ] |  |  |
| `time_ids` | `varchar2` |  | [ ] |  |  |
| `wc_analytic_account_line_id` | `varchar2` |  | [ ] |  |  |
| `wc_analytic_account_line_id_label` | `varchar2` |  | [ ] |  |  |
| `workcenter_id` | `varchar2` |  | [ ] |  |  |
| `workcenter_id_label` | `varchar2` |  | [ ] |  |  |
| `working_state` | `varchar2` | Workcenter Status | [ ] |  |  |
| `working_user_ids` | `varchar2` |  | [ ] |  |  |
| `worksheet` | `varbinary` | Worksheet | [ ] |  |  |
| `worksheet_google_slide` | `varchar2` | Worksheet URL | [ ] |  | Paste the url of your Google Slide.Make sure the access to the document is public. |
| `worksheet_type` | `varchar2` | Worksheet Type | [ ] |  |  |
| `write_date` | `datetime` | Last Updated on | [ ] |  |  |
| `write_uid` | `varchar2` |  | [ ] |  |  |
| `write_uid_label` | `varchar2` |  | [ ] |  |  |


## Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver:

- [Odoo](/it/release-notes/drivers?driver=odoo)
