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

# production: Odoo itgen_odoo_production

`read only` `per partition`

- Catalogo: `Odoo`
- Schema: `mrp`
- Etichetta: itgen_odoo_production

Production Order

È possibile solo recuperare i dati.

## Riepilogo

Manufacturing Orders

## Colonne della tabella

Di seguito sono riportate le colonne della tabella `production`. 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 |
|---|---|---|:---:|---|---|
| `activity_calendar_event_id` | `varchar2` |  | [ ] |  |  |
| `activity_calendar_event_id_label` | `varchar2` |  | [ ] |  |  |
| `activity_date_deadline` | `datetime` | Next Activity Deadline | [ ] |  |  |
| `activity_exception_decoration` | `varchar2` | Activity Exception Decoration | [ ] |  | Type of the exception activity on record. |
| `activity_exception_icon` | `varchar2` | Icon | [ ] |  | Icon to indicate an exception activity. |
| `activity_ids` | `varchar2` |  | [ ] |  |  |
| `activity_state` | `varchar2` | Activity State | [ ] |  | Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities. |
| `activity_summary` | `varchar2` | Next Activity Summary | [ ] |  |  |
| `activity_type_icon` | `varchar2` | Activity Type Icon | [ ] |  | Font awesome icon e.g. fa-tasks |
| `activity_type_id` | `varchar2` |  | [ ] |  |  |
| `activity_type_id_label` | `varchar2` |  | [ ] |  |  |
| `activity_user_id` | `varchar2` |  | [ ] |  |  |
| `activity_user_id_label` | `varchar2` |  | [ ] |  |  |
| `allow_workorder_dependencies` | `boolean` | Allow Work Order Dependencies | [ ] |  |  |
| `analytic_account_id` | `varchar2` |  | [ ] |  | Analytic account in which cost and revenue entries will take        place for financial management of the manufacturing order. |
| `analytic_account_id_label` | `varchar2` |  | [ ] |  | Analytic account in which cost and revenue entries will take        place for financial management of the manufacturing order. |
| `backorder_sequence` | `int32` | Backorder Sequence | [ ] |  | Backorder sequence, if equals to 0 means there is not related backorder |
| `bom_id` | `varchar2` |  | [ ] |  | Bills of Materials, also called recipes, are used to autocomplete components and work order instructions. |
| `bom_id_label` | `varchar2` |  | [ ] |  | Bills of Materials, also called recipes, are used to autocomplete components and work order instructions. |
| `check_ids` | `varchar2` |  | [ ] |  |  |
| `company_id` | `varchar2` |  | [ ] |  |  |
| `company_id_label` | `varchar2` |  | [ ] |  |  |
| `components_availability` | `varchar2` | Component Status | [ ] |  | Latest component availability status for this MO.If green, then the MO's readiness status is ready, as per BOM configuration. |
| `components_availability_state` | `varchar2` | Components Availability State | [ ] |  |  |
| `confirm_cancel` | `boolean` | Confirm Cancel | [ ] |  |  |
| `consumption` | `varchar2` | Consumption | [x] |  |  |
| `create_date` | `datetime` | Creato il | [ ] |  |  |
| `create_uid` | `varchar2` |  | [ ] |  |  |
| `create_uid_label` | `varchar2` |  | [ ] |  |  |
| `date_deadline` | `datetime` | Deadline | [ ] |  | Informative date allowing to define when the manufacturing order should be processed at the latest to fulfill delivery on time. |
| `date_finished` | `datetime` | Data di fine | [ ] |  |  |
| `date_planned_finished` | `datetime` | Scheduled End Date | [ ] |  | Date at which you plan to finish the production. |
| `date_planned_start` | `datetime` | Data programmata | [x] |  | Date at which you plan to start the production. |
| `date_start` | `datetime` | Data di inizio | [ ] |  |  |
| `delay_alert_date` | `datetime` | Delay Alert Date | [ ] |  |  |
| `delivery_count` | `int32` | Delivery Orders | [ ] |  |  |
| `display_name` | `varchar2` | Nome visualizzato | [ ] |  |  |
| `extra_cost` | `numeric` | Extra Unit Cost | [ ] |  |  |
| `finished_move_line_ids` | `varchar2` |  | [ ] |  |  |
| `forecasted_issue` | `boolean` | Forecasted Issue | [ ] |  |  |
| `has_message` | `boolean` | Has Message | [ ] |  |  |
| `id` | `int32` | ID | [ ] |  |  |
| `is_locked` | `boolean` | È bloccato | [ ] |  |  |
| `is_planned` | `boolean` | Its Operations are Planned | [ ] |  |  |
| `json_popover` | `varchar2` | JSON data for the popover widget | [ ] |  |  |
| `latest_bom_id` | `varchar2` |  | [ ] |  |  |
| `latest_bom_id_label` | `varchar2` |  | [ ] |  |  |
| `location_dest_id` | `varchar2` |  | [ ] |  | Location where the system will stock the finished products. |
| `location_dest_id_label` | `varchar2` |  | [ ] |  | Location where the system will stock the finished products. |
| `location_src_id` | `varchar2` |  | [ ] |  | Location where the system will look for components. |
| `location_src_id_label` | `varchar2` |  | [ ] |  | Location where the system will look for components. |
| `lot_producing_id` | `varchar2` |  | [ ] |  |  |
| `lot_producing_id_label` | `varchar2` |  | [ ] |  |  |
| `message_attachment_count` | `int32` | Numero di allegati | [ ] |  |  |
| `message_follower_ids` | `varchar2` |  | [ ] |  |  |
| `message_has_error` | `boolean` | Message Delivery error | [ ] |  | If checked, some messages have a delivery error. |
| `message_has_error_counter` | `int32` | Number of errors | [ ] |  | Number of messages with delivery error |
| `message_has_sms_error` | `boolean` | SMS Delivery error | [ ] |  | If checked, some messages have a delivery error. |
| `message_ids` | `varchar2` |  | [ ] |  |  |
| `message_is_follower` | `boolean` | Is Follower | [ ] |  |  |
| `message_main_attachment_id` | `varchar2` |  | [ ] |  |  |
| `message_main_attachment_id_label` | `varchar2` |  | [ ] |  |  |
| `message_needaction` | `boolean` | Action Needed | [ ] |  | If checked, new messages require your attention. |
| `message_needaction_counter` | `int32` | Numero di azioni | [ ] |  | Number of messages which requires an action |
| `message_partner_ids` | `varchar2` |  | [ ] |  |  |
| `move_byproduct_ids` | `varchar2` |  | [ ] |  |  |
| `move_dest_ids` | `varchar2` |  | [ ] |  |  |
| `move_finished_ids` | `varchar2` |  | [ ] |  |  |
| `move_raw_ids` | `varchar2` |  | [ ] |  |  |
| `mrp_production_backorder_count` | `int32` | Count of linked backorder | [ ] |  |  |
| `mrp_production_child_count` | `int32` | Number of generated MO | [ ] |  |  |
| `mrp_production_source_count` | `int32` | Number of source MO | [ ] |  |  |
| `my_activity_date_deadline` | `datetime` | My Activity Deadline | [ ] |  |  |
| `name` | `varchar2` | Reference | [ ] |  |  |
| `orderpoint_id` | `varchar2` |  | [ ] |  |  |
| `orderpoint_id_label` | `varchar2` |  | [ ] |  |  |
| `origin` | `varchar2` | Source | [ ] |  | Reference of the document that generated this production order request. |
| `picking_ids` | `varchar2` |  | [ ] |  |  |
| `picking_type_id` | `varchar2` |  | [ ] |  |  |
| `picking_type_id_label` | `varchar2` |  | [ ] |  |  |
| `priority` | `varchar2` | Priority | [ ] |  | Components will be reserved first for the MO with the highest priorities. |
| `procurement_group_id` | `varchar2` |  | [ ] |  |  |
| `procurement_group_id_label` | `varchar2` |  | [ ] |  |  |
| `product_description_variants` | `varchar2` | Custom Description | [ ] |  |  |
| `product_id` | `varchar2` |  | [ ] |  |  |
| `product_id_label` | `varchar2` |  | [ ] |  |  |
| `product_qty` | `numeric` | Quantity To Produce | [x] |  |  |
| `product_tmpl_id` | `varchar2` |  | [ ] |  |  |
| `product_tmpl_id_label` | `varchar2` |  | [ ] |  |  |
| `product_tracking` | `varchar2` | Tracking | [ ] |  | Ensure the traceability of a storable product in your warehouse. |
| `product_uom_category_id` | `varchar2` |  | [ ] |  | Conversion between Units of Measure can only occur if they belong to the same category.The conversion will be made based on the ratios. |
| `product_uom_category_id_label` | `varchar2` |  | [ ] |  | Conversion between Units of Measure can only occur if they belong to the same category.The conversion will be made based on the ratios. |
| `product_uom_id` | `varchar2` |  | [ ] |  |  |
| `product_uom_id_label` | `varchar2` |  | [ ] |  |  |
| `product_uom_qty` | `numeric` | Quantità totale | [ ] |  |  |
| `product_variant_attributes` | `varchar2` |  | [ ] |  |  |
| `production_capacity` | `numeric` | Production Capacity | [ ] |  | Quantity that can be produced with the current stock of components |
| `production_duration_expected` | `numeric` | Expected Duration | [ ] |  | Total expected duration (in minutes) |
| `production_location_id` | `varchar2` |  | [ ] |  |  |
| `production_location_id_label` | `varchar2` |  | [ ] |  |  |
| `production_real_duration` | `numeric` | Real Duration | [ ] |  | Total real duration (in minutes) |
| `propagate_cancel` | `boolean` | Propagate cancel and split | [ ] |  | If checked, when the previous move of the move (which was generated by a next procurement) is cancelled or split, the move generated by this move will too |
| `purchase_order_count` | `int32` | Count of generated PO | [ ] |  |  |
| `qty_produced` | `numeric` | Quantity Produced | [ ] |  |  |
| `qty_producing` | `numeric` | Quantity Producing | [ ] |  |  |
| `quality_alert_count` | `int32` | Quality Alert Count | [ ] |  |  |
| `quality_alert_ids` | `varchar2` |  | [ ] |  |  |
| `quality_check_fail` | `boolean` | Quality Check Fail | [ ] |  |  |
| `quality_check_todo` | `boolean` | Quality Check Todo | [ ] |  |  |
| `reservation_state` | `varchar2` | MO Readiness | [ ] |  | 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. |
| `reserve_visible` | `boolean` | Allowed to Reserve Production | [ ] |  | Technical field to check when we can reserve quantities |
| `sale_order_count` | `int32` | Count of Source SO | [ ] |  |  |
| `scrap_count` | `int32` | Scrap Move | [ ] |  |  |
| `scrap_ids` | `varchar2` |  | [ ] |  |  |
| `show_allocation` | `boolean` | Show Allocation | [ ] |  | Technical Field used to decide whether the button "Allocation" should be displayed. |
| `show_final_lots` | `boolean` | Show Final Lots | [ ] |  |  |
| `show_lock` | `boolean` | Show Lock/unlock buttons | [ ] |  |  |
| `show_lot_ids` | `boolean` | Display the serial number shortcut on the moves | [ ] |  |  |
| `show_produce` | `boolean` | Show Produce | [ ] |  | Technical field to check if produce button can be shown |
| `show_produce_all` | `boolean` | Show Produce All | [ ] |  | Technical field to check if produce all button can be shown |
| `show_serial_mass_produce` | `boolean` | Display the serial mass produce wizard action | [ ] |  |  |
| `show_valuation` | `boolean` | Show Valuation | [ ] |  |  |
| `state` | `varchar2` | 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. |
| `unbuild_count` | `int32` | Number of Unbuilds | [ ] |  |  |
| `unbuild_ids` | `varchar2` |  | [ ] |  |  |
| `unreserve_visible` | `boolean` | Allowed to Unreserve Production | [ ] |  | Technical field to check when we can unreserve |
| `use_auto_consume_components_lots` | `boolean` | Consume Reserved Lots/Serial Numbers automatically | [ ] |  | Allow automatic consumption of tracked components that are reserved |
| `use_create_components_lots` | `boolean` | Create New Lots/Serial Numbers for Components | [ ] |  | Allow to create new lot/serial numbers for the components |
| `user_id` | `varchar2` |  | [ ] |  |  |
| `user_id_label` | `varchar2` |  | [ ] |  |  |
| `warehouse_id` | `varchar2` |  | [ ] |  |  |
| `warehouse_id_label` | `varchar2` |  | [ ] |  |  |
| `website_message_ids` | `varchar2` |  | [ ] |  | Website communication history |
| `workorder_ids` | `varchar2` |  | [ ] |  |  |
| `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)
