invantive documentation
Invantive Support ForumsLog In / Sign Up

production: Odoo itgen_odoo_production

read only per partition

  • Catalog: Odoo
  • Schema: mrp
  • Label: itgen_odoo_production

Production Order

Can only retrieve data.

Summary

Manufacturing Orders

Table Columns

The columns of the table production are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type 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
create_date datetime Created on
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 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 varchar2 Display Name
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 Is Locked
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 Attachment Count
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 Number of Actions 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
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 Total Quantity
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

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: