Odoo 20.0 Community · Persistent

mrp.workorder: fields, relations and API

The mrp.workorder model ("Work Order") is a persistent model declared by the Manufacturing module, then extended by 2 other modules. It exposes 90 fields, 60 of them declared directly on the model; 7 fields from other models point to it. Below you will find every field with its technical name, type, label and relations, followed by an Odoo 20 JSON-2 API call.

View source code Search another model

Model identity

Technical name: mrp.workorder
Label: Work Order
Type: Persistent (models.Model)
SQL table: mrp_workorder
Origin module: Manufacturing (mrp)
Extended by: mrp_account, project_mrp_account
Default order (_order): date_start, sequence, id
Inherits from (mixins): mail.thread mail.activity.mixin product.catalog.mixin

Model fields

60 own fields, 24 inherited from mixins and 6 automatic ORM fields. Click a name to get a direct link to that field.

Hide inherited fields

90 of 90 fields shown

Technical name	Label	Type	Details
allow_workorder_dependencies	Allow Workorder Dependencies	`boolean`	related: `production_id.allow_workorder_dependencies`
backorder_count	Count of linked backorders	`integer`	computed
barcode	Barcode	`char`	computed, stored
blocked_by_workorder_ids	Blocked By	`many2many` → mrp.workorder
color	Color	`integer`	related: `production_id.id`
company_id	Company	`many2one` → res.company	related: `production_id.company_id`
cost	Cost Total real cost of the work order based on duration and hourly cost.	`float`	computed, stored
cost_mode	Cost Mode	`selection`	Values: `actual` (Actual), `estimated` (Estimated)
costs_hour	Cost per hour	`float`
date_finished	End	`datetime`	computed, stored
date_start	Planned Date	`datetime`	computed, stored
decoration_dates	Decoration Dates	`char`	computed
duration	Real Duration	`float`	computed, stored
duration_expected	Expected Duration	`float`	computed, stored
duration_percent	Duration Deviation (%)	`integer`	read-onlycomputed, stored
duration_unit	Duration Per Unit	`float`	read-onlycomputed, stored
has_conflicts	Has conflicts	`boolean`	computed
has_planning_issues	Has planning issues	`boolean`	computed
is_planned	Is Planned	`boolean`	computed
is_produced	Has Been Produced	`boolean`	computed
is_user_working	Is the Current User Working	`boolean`	computed
last_working_user_id	Last user that worked on this work order.	`many2one` → res.users	computed
leave_id	Leave Slot into workcenter calendar once planned	`many2one` → resource.calendar.leaves
mo_analytic_account_line_ids	Mo Analytic Account Line	`many2many` → account.analytic.line	added by Accounting - MRP (`mrp_account`)
move_finished_ids	Finished Moves	`one2many` → stock.move	inverse: `workorder_id`
move_line_ids	Moves to Track Inventory moves for which you must scan a lot number at this work order	`one2many` → stock.move.line	inverse: `workorder_id`
move_raw_ids	Raw Moves	`one2many` → stock.move	inverse: `workorder_id`
name	Work Order	`char`	required
needed_by_workorder_ids	Blocks	`many2many` → mrp.workorder
operation_id	Operation	`many2one` → mrp.routing.workcenter
picking_type_id	Picking Type	`many2one` → stock.picking.type	related: `production_id.picking_type_id`
priority	Priority	`selection`	related: `production_id.priority`
product_id	Product	`many2one` → product.product	related: `production_id.product_id`
product_tracking	Product Tracking	`selection`	related: `product_id.tracking`
product_variant_attributes	Product Variant Attributes	`many2many` → product.template.attribute.value	related: `product_id.product_template_attribute_value_ids`
production_availability	Stock Availability	`selection`	read-only related: `production_id.reservation_state`
production_bom_id	Production Bom	`many2one` → mrp.bom	related: `production_id.bom_id`
production_date	Production Date	`datetime`	computed, stored
production_id	Manufacturing Order	`many2one` → mrp.production	requiredread-only
production_lot_producing_id	Production Lot Producing	`many2many` → stock.lot	related: `production_id.lot_producing_ids`
production_reference_ids	References	`many2many` → stock.reference	read-only related: `production_id.reference_ids`
production_state	Production State	`selection`	read-only related: `production_id.state`
progress	Progress Done (%)	`float`	computed
properties	Properties	`properties`
qty_produced	Quantity Done Quantity already processed in this work order. If continuous production is active on the bill of materials, recording quantities will unblock the next operation.	`float`
qty_producing	Currently Produced Quantity	`float`	computed
qty_production	Original Production Quantity	`float`	read-only related: `production_id.product_qty`
qty_ready	Quantity Ready	`float`	computed
qty_remaining	Quantity To Be Produced	`float`	computed
qty_reported_from_previous_wo	Carried Quantity The quantity already produced awaiting allocation in the backorders chain.	`float`
qty_to_produce	Quantity To Produce The quantity to produce in this workorder in the backorders chain.	`float`	computed
remaining_time	Remaining Working Time The remaining time to finish this work order.	`float`	computed
sequence	Sequence	`integer`	computed, stored
state	Status	`selection`	computed, stored Values: `blocked` (Blocked), `ready` (To Do), `progress` (In Progress), `done` (Done), `cancel` (Cancelled)
time_ids	Time	`one2many` → mrp.workcenter.productivity	inverse: `workorder_id`
uom_id	Uom	`many2one` → uom.uom	related: `production_id.uom_id`
wc_analytic_account_line_ids	Wc Analytic Account Line	`many2many` → account.analytic.line	added by Accounting - MRP (`mrp_account`)
workcenter_id	Work Center	`many2one` → mrp.workcenter	required
working_state	Workcenter Status	`selection`	related: `workcenter_id.working_state`
working_user_ids	Working user on this work order.	`one2many` → res.users	computed
activity_calendar_event_id	Next Activity Calendar Event	`many2one` → calendar.event	computed inherited from mail.activity.mixin
activity_date_deadline	Next Activity Deadline	`date`	read-onlycomputed inherited from mail.activity.mixin
activity_exception_decoration	Activity Exception Decoration Type of the exception activity on record.	`selection`	computed Values: `warning` (Alert), `danger` (Error) inherited from mail.activity.mixin
activity_exception_icon	Icon Icon to indicate an exception activity.	`char`	computed inherited from mail.activity.mixin
activity_ids	Activities	`one2many` → mail.activity	inverse: `res_id` inherited from mail.activity.mixin
activity_plans_ids	Activity Plans	`many2many` → mail.activity.plan	computed inherited from mail.activity.mixin
activity_state	Activity State Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities.	`selection`	computed Values: `overdue` (Overdue), `today` (Today), `planned` (Planned) inherited from mail.activity.mixin
activity_summary	Next Activity Summary	`char`	related: `activity_ids.summary` inherited from mail.activity.mixin
activity_type_icon	Activity Type Icon	`char`	related: `activity_ids.icon` inherited from mail.activity.mixin
activity_type_id	Next Activity Type	`many2one` → mail.activity.type	related: `activity_ids.activity_type_id` inherited from mail.activity.mixin
activity_user_id	Responsible User	`many2one` → res.users	read-onlycomputed inherited from mail.activity.mixin
has_message	Has Message	`boolean`	computed inherited from mail.thread
message_attachment_count	Attachment Count	`integer`	computed inherited from mail.thread
message_follower_ids	Followers	`one2many` → mail.followers	inverse: `res_id` inherited from mail.thread
message_has_error	Message Delivery error If checked, some messages have a delivery error.	`boolean`	computed inherited from mail.thread
message_has_error_counter	Number of errors Number of messages with delivery error	`integer`	computed inherited from mail.thread
message_has_sms_error	SMS Delivery error If checked, some messages have a delivery error.	`boolean`	computed inherited from mail.thread
message_ids	Messages	`one2many` → mail.message	inverse: `res_id` inherited from mail.thread
message_is_follower	Is Follower	`boolean`	computed inherited from mail.thread
message_needaction	Action Needed If checked, new messages require your attention.	`boolean`	computed inherited from mail.thread
message_needaction_counter	Number of Actions Number of messages requiring action	`integer`	computed inherited from mail.thread
message_partner_ids	Followers (Partners)	`many2many` → res.partner	computed inherited from mail.thread
my_activity_date_deadline	My Activity Deadline	`date`	read-onlycomputed inherited from mail.activity.mixin
rating_ids	Ratings	`one2many` → rating.rating	inverse: `res_id` inherited from mail.thread
create_date	Created on	`datetime`	read-onlyautomatic
create_uid	Created by	`many2one` → res.users	read-onlyautomatic
display_name	Display Name	`char`	read-onlycomputedautomatic
id	ID	`integer`	read-onlyautomatic
write_date	Last Updated on	`datetime`	read-onlyautomatic
write_uid	Last Updated by	`many2one` → res.users	read-onlyautomatic

Relations

Models linked from this model

account.analytic.line: mo_analytic_account_line_ids, wc_analytic_account_line_ids
mrp.bom: production_bom_id
mrp.production: production_id
mrp.routing.workcenter: operation_id
mrp.workcenter: workcenter_id
mrp.workcenter.productivity: time_ids
mrp.workorder: blocked_by_workorder_ids, needed_by_workorder_ids
product.product: product_id
product.template.attribute.value: product_variant_attributes
res.company: company_id
res.users: last_working_user_id, working_user_ids
resource.calendar.leaves: leave_id
stock.lot: production_lot_producing_id
stock.move: move_finished_ids, move_raw_ids
stock.move.line: move_line_ids
stock.picking.type: picking_type_id
stock.reference: production_reference_ids
uom.uom: uom_id

Fields of other models pointing here

expiry.picking.confirmation: workorder_id
mrp.production.serials: workorder_id
mrp.workcenter.productivity: workorder_id
mrp.workorder: blocked_by_workorder_ids, needed_by_workorder_ids
stock.move: workorder_id
stock.move.line: workorder_id

Reading this model through the API

Odoo 20 JSON-2 API call reading the first five records with real fields of the model. Replace the instance, database and API key with your own.

curl

curl -X POST "https://your-instance.odoo.com/json/2/mrp.workorder/search_read" \
  -H "Authorization: bearer $ODOO_API_KEY" \
  -H "X-Odoo-Database: your-db" \
  -H "Content-Type: application/json" \
  -d '{"domain":[],"fields":["name","production_id","workcenter_id","state","company_id"],"limit":5}'

Python (requests)

import requests

BASE_URL = "https://your-instance.odoo.com/json/2"
headers = {"Authorization": f"bearer {API_KEY}", "X-Odoo-Database": "your-db"}

res = requests.post(
    f"{BASE_URL}/mrp.workorder/search_read",
    headers=headers,
    json={"domain": [], "fields": ["name","production_id","workcenter_id","state","company_id"], "limit": 5},
)
res.raise_for_status()
print(res.json())

External API access requires Odoo's Custom plan.
XML-RPC and JSON-RPC will be removed in Odoo 22 (fall 2028): use JSON-2.
The access rights and record rules of the key's user apply.

Cite this tool

Writing a tutorial, internal documentation or a forum answer? Copy this link to send your readers to the up-to-date reference.

<a href="https://aidoo.ai/en/outils/explorateur-modeles-odoo/mrp-workorder">mrp.workorder (Odoo 20.0)</a>

Sources

Data verified on September 25, 2026 · Odoo 20.0 Community

Have an Odoo project, or want to put your ERP to work with AI? Let's talk

Implementation, custom module development, connecting Claude or ChatGPT to your data: tell us about your context and we will reply within 24 business hours.