Please enable JavaScript to view this site.

Made in EU
Odoo Forums

Navigation: Schema: mrp > Tables

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

X

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

  • Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
  • Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
  • Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
  • Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
  • Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
  • Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
  • Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
  • Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.

  
Disclaimer