invantive documentation
Forum di supporto InvantiveAccedi / Registrati

production: Odoo itgen_odoo_production

read only per partition

  • Catalogo: Odoo
  • Schema: mrp
  • Etichetta: itgen_odoo_production

Production Order

È possibile solo recuperare i dati.

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
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 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
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: