production |
Production Order
Catalog: Odoo
Schema: mrp
Documentation:
Manufacturing Orders
The data in this table is partitioned per value of the column.
This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API.
Table Columns
The columns of the table production are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
activity_calendar_event_id_label |
string |
|
☐ |
|
activity_calendar_event_id |
string |
|
☐ |
|
activity_date_deadline |
datetime |
Next Activity Deadline |
☐ |
|
activity_exception_decoration |
string |
Activity Exception Decoration |
☐ |
Type of the exception activity on record. |
activity_exception_icon |
string |
Icon |
☐ |
Icon to indicate an exception activity. |
activity_ids |
string |
|
☐ |
|
activity_state |
string |
Activity State |
☐ |
Status based on activitiesOverdue: Due date is already passedToday: Activity date is todayPlanned: Future activities. |
activity_summary |
string |
Next Activity Summary |
☐ |
|
activity_type_icon |
string |
Activity Type Icon |
☐ |
Font awesome icon e.g. fa-tasks |
activity_type_id_label |
string |
|
☐ |
|
activity_type_id |
string |
|
☐ |
|
activity_user_id_label |
string |
|
☐ |
|
activity_user_id |
string |
|
☐ |
|
allow_workorder_dependencies |
boolean |
Allow Work Order Dependencies |
☐ |
|
analytic_account_id_label |
string |
|
☐ |
Analytic account in which cost and revenue entries will take place for financial management of the manufacturing order. |
analytic_account_id |
string |
|
☐ |
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_label |
string |
|
☐ |
Bills of Materials, also called recipes, are used to autocomplete components and work order instructions. |
bom_id |
string |
|
☐ |
Bills of Materials, also called recipes, are used to autocomplete components and work order instructions. |
check_ids |
string |
|
☐ |
|
company_id_label |
string |
|
☐ |
|
company_id |
string |
|
☐ |
|
components_availability_state |
string |
Components Availability State |
☐ |
|
components_availability |
string |
Component Status |
☐ |
Latest component availability status for this MO. If green, then the MO's readiness status is ready, as per BOM configuration. |
confirm_cancel |
boolean |
Confirm Cancel |
☐ |
|
consumption |
string |
Consumption |
☑ |
|
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
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 |
End Date |
☐ |
|
date_planned_finished |
datetime |
Scheduled End Date |
☐ |
Date at which you plan to finish the production. |
date_planned_start |
datetime |
Scheduled Date |
☑ |
Date at which you plan to start the production. |
date_start |
datetime |
Start Date |
☐ |
|
delay_alert_date |
datetime |
Delay Alert Date |
☐ |
|
delivery_count |
int32 |
Delivery Orders |
☐ |
|
display_name |
string |
Display Name |
☐ |
|
extra_cost |
decimal |
Extra Unit Cost |
☐ |
|
finished_move_line_ids |
string |
|
☐ |
|
forecasted_issue |
boolean |
Forecasted Issue |
☐ |
|
has_message |
boolean |
Has Message |
☐ |
|
id |
int32 |
ID |
☐ |
|
is_locked |
boolean |
Is Locked |
☐ |
|
is_planned |
boolean |
Its Operations are Planned |
☐ |
|
json_popover |
string |
JSON data for the popover widget |
☐ |
|
latest_bom_id_label |
string |
|
☐ |
|
latest_bom_id |
string |
|
☐ |
|
location_dest_id_label |
string |
|
☐ |
Location where the system will stock the finished products. |
location_dest_id |
string |
|
☐ |
Location where the system will stock the finished products. |
location_src_id_label |
string |
|
☐ |
Location where the system will look for components. |
location_src_id |
string |
|
☐ |
Location where the system will look for components. |
lot_producing_id_label |
string |
|
☐ |
|
lot_producing_id |
string |
|
☐ |
|
message_attachment_count |
int32 |
Attachment Count |
☐ |
|
message_follower_ids |
string |
|
☐ |
|
message_has_error_counter |
int32 |
Number of errors |
☐ |
Number of messages with delivery error |
message_has_error |
boolean |
Message Delivery error |
☐ |
If checked, some messages have a delivery error. |
message_has_sms_error |
boolean |
SMS Delivery error |
☐ |
If checked, some messages have a delivery error. |
message_ids |
string |
|
☐ |
|
message_is_follower |
boolean |
Is Follower |
☐ |
|
message_main_attachment_id_label |
string |
|
☐ |
|
message_main_attachment_id |
string |
|
☐ |
|
message_needaction_counter |
int32 |
Number of Actions |
☐ |
Number of messages which requires an action |
message_needaction |
boolean |
Action Needed |
☐ |
If checked, new messages require your attention. |
message_partner_ids |
string |
|
☐ |
|
move_byproduct_ids |
string |
|
☐ |
|
move_dest_ids |
string |
|
☐ |
|
move_finished_ids |
string |
|
☐ |
|
move_raw_ids |
string |
|
☐ |
|
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 |
string |
Reference |
☐ |
|
orderpoint_id_label |
string |
|
☐ |
|
orderpoint_id |
string |
|
☐ |
|
origin |
string |
Source |
☐ |
Reference of the document that generated this production order request. |
picking_ids |
string |
|
☐ |
|
picking_type_id_label |
string |
|
☐ |
|
picking_type_id |
string |
|
☐ |
|
priority |
string |
Priority |
☐ |
Components will be reserved first for the MO with the highest priorities. |
procurement_group_id_label |
string |
|
☐ |
|
procurement_group_id |
string |
|
☐ |
|
product_description_variants |
string |
Custom Description |
☐ |
|
product_id_label |
string |
|
☐ |
|
product_id |
string |
|
☐ |
|
product_qty |
decimal |
Quantity To Produce |
☑ |
|
product_tmpl_id_label |
string |
|
☐ |
|
product_tmpl_id |
string |
|
☐ |
|
product_tracking |
string |
Tracking |
☐ |
Ensure the traceability of a storable product in your warehouse. |
product_uom_category_id_label |
string |
|
☐ |
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 |
string |
|
☐ |
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_label |
string |
|
☐ |
|
product_uom_id |
string |
|
☐ |
|
product_uom_qty |
decimal |
Total Quantity |
☐ |
|
product_variant_attributes |
string |
|
☐ |
|
production_capacity |
decimal |
Production Capacity |
☐ |
Quantity that can be produced with the current stock of components |
production_duration_expected |
decimal |
Expected Duration |
☐ |
Total expected duration (in minutes) |
production_location_id_label |
string |
|
☐ |
|
production_location_id |
string |
|
☐ |
|
production_real_duration |
decimal |
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 |
decimal |
Quantity Produced |
☐ |
|
qty_producing |
decimal |
Quantity Producing |
☐ |
|
quality_alert_count |
int32 |
Quality Alert Count |
☐ |
|
quality_alert_ids |
string |
|
☐ |
|
quality_check_fail |
boolean |
Quality Check Fail |
☐ |
|
quality_check_todo |
boolean |
Quality Check Todo |
☐ |
|
reservation_state |
string |
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 |
string |
|
☐ |
|
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_all |
boolean |
Show Produce All |
☐ |
Technical field to check if produce all button can be shown |
show_produce |
boolean |
Show Produce |
☐ |
Technical field to check if produce button can be shown |
show_serial_mass_produce |
boolean |
Display the serial mass produce wizard action |
☐ |
|
show_valuation |
boolean |
Show Valuation |
☐ |
|
state |
string |
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 |
string |
|
☐ |
|
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_label |
string |
|
☐ |
|
user_id |
string |
|
☐ |
|
warehouse_id_label |
string |
|
☐ |
|
warehouse_id |
string |
|
☐ |
|
website_message_ids |
string |
|
☐ |
Website communication history |
workorder_ids |
string |
|
☐ |
|
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826