Odoo 19.0 Community · Persistent

sale.order.line: fields, relations and API

The sale.order.line model ("Sales Order Line") is a persistent model declared by the Sales module, then extended by 35 other modules. It exposes 129 fields, 120 of them declared directly on the model; 25 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 19 JSON-2 API call.

View source code Search another model

Model identity

Technical name: sale.order.line
Label: Sales Order Line
Type: Persistent (models.Model)
SQL table: sale_order_line
Origin module: Sales (sale)
Extended by: delivery, sale_stock, stock_delivery, sale_management, event_sale, event_booth_sale, repair, sale_purchase, stock_dropshipping, pos_sale, pos_repair, pos_sale_loyalty, sale_margin, sale_mrp, sale_service, sale_project, sale_expense, sale_expense_margin, sale_gelato, sale_gelato_stock, sale_loyalty, sale_stock_margin, sale_pdf_quote_builder, sale_product_matrix, sale_project_stock, sale_purchase_project, sale_stock_product_expiry, sale_timesheet, sale_timesheet_margin, website_sale, website_sale_slides, website_event_booth_sale, website_event_sale, website_sale_stock, website_sale_loyalty
Default order (_order): order_id, sequence, id
Inherits from (mixins): analytic.mixin pos.load.mixin

Model fields

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

Hide inherited fields

129 of 129 fields shown

Technical name	Label	Type	Details
allowed_uom_ids	Allowed Uom	`many2many` → uom.uom	computed
amount_invoiced	Invoiced Amount	`monetary`	computed
amount_to_invoice	Un-invoiced Balance	`monetary`	computed
amount_to_invoice_at_date	Amount	`float`	computed
analytic_line_ids	Analytic lines	`one2many` → account.analytic.line	inverse: `so_line`
available_product_document_ids	Available Product Documents	`many2many` → product.document	computed added by Sales PDF Quotation Builder (`sale_pdf_quote_builder`)
categ_id	Categ	`many2one` → product.category	related: `product_id.categ_id`
collapse_composition	Collapse Composition	`boolean`
collapse_prices	Collapse Prices	`boolean`
combo_item_id	Combo Item	`many2one` → product.combo.item
company_id	Company	`many2one` → res.company	related: `order_id.company_id`
company_price_include	Company Price Include	`selection`	related: `company_id.account_price_include`
coupon_id	Coupon	`many2one` → loyalty.card	read-only added by Sale Loyalty (`sale_loyalty`)
currency_id	Currency	`many2one` → res.currency	related: `order_id.currency_id`
customer_lead	Lead Time Number of days between the order confirmation and the shipping of the products to the customer	`float`	requiredcomputed, stored
discount	Discount (%)	`float`	computed, stored
display_qty_widget	Display Qty Widget	`boolean`	computed added by Sales and Warehouse Management (`sale_stock`)
display_type	Display Type	`selection`	Values: `line_section` (Section), `line_subsection` (Subsection), `line_note` (Note)
event_booth_category_id	Booths Category	`many2one` → event.booth.category	added by Events Booths Sales (`event_booth_sale`)
event_booth_ids	Confirmed Booths	`one2many` → event.booth	inverse: `sale_order_line_id` added by Events Booths Sales (`event_booth_sale`)
event_booth_pending_ids	Pending Booths Used to create registration when providing the desired event booth.	`many2many` → event.booth	computed added by Events Booths Sales (`event_booth_sale`)
event_booth_registration_ids	Confirmed Registration	`one2many` → event.booth.registration	inverse: `sale_order_line_id` added by Events Booths Sales (`event_booth_sale`)
event_id	Event Choose an event and it will automatically create a registration for this event.	`many2one` → event.event	computed, stored added by Events Sales (`event_sale`)
event_slot_id	Slot Choose an event slot and it will automatically create a registration for this event slot.	`many2one` → event.slot	computed, stored added by Events Sales (`event_sale`)
event_ticket_id	Ticket Type Choose an event ticket and it will automatically create a registration for this event ticket.	`many2one` → event.event.ticket	computed, stored added by Events Sales (`event_sale`)
expense_id	Expense	`many2one` → hr.expense	added by Sales Expense Margin (`sale_expense_margin`)
expense_ids	Expenses	`one2many` → hr.expense	read-only inverse: `sale_order_line_id` added by Sales Expense (`sale_expense`)
extra_tax_data	Extra Tax Data	`json`
forecast_expected_date	Forecast Expected Date	`datetime`	computed added by Sales and Warehouse Management (`sale_stock`)
free_qty_today	Free Qty Today	`float`	computed added by Sales and Warehouse Management (`sale_stock`)
has_displayed_warning_upsell	Has Displayed Warning Upsell	`boolean`	added by Sales Timesheet (`sale_timesheet`)
invoice_lines	Invoice Lines	`many2many` → account.move.line
invoice_status	Invoice Status	`selection`	computed, stored Values: `upselling` (Upselling Opportunity), `invoiced` (Fully Invoiced), `to invoice` (To Invoice), `no` (Nothing to Invoice)
is_configurable_product	Is the product configurable?	`boolean`	related: `product_template_id.has_configurable_attributes`
is_delivery	Is a Delivery	`boolean`	added by Delivery Costs (`delivery`)
is_downpayment	Is a down payment Down payments are made when creating invoices from a sales order. They are not copied when duplicating a sales order.	`boolean`
is_expense	Is expense Is true if the sales order line comes from an expense or a vendor bills	`boolean`
is_mto	Is Mto	`boolean`	computed added by Sales and Warehouse Management (`sale_stock`)
is_multi_slots	Is Multi Slots	`boolean`	related: `event_id.is_multi_slots` added by Events Sales (`event_sale`)
is_optional	Optional Line	`boolean`	added by Sales (`sale_management`)
is_product_archived	Is Product Archived	`boolean`	computed
is_repair_line	Is linked to repair	`boolean`	computed added by POS - Repair (`pos_repair`)
is_reward_line	Is a program reward line	`boolean`	computed added by Sale Loyalty (`sale_loyalty`)
is_service	Is a Service	`boolean`	computed, stored added by Sales - Service (`sale_service`)
is_storable	Is Storable	`boolean`	related: `product_id.is_storable` added by Sales and Warehouse Management (`sale_stock`)
linked_line_id	Linked Order Line	`many2one` → sale.order.line
linked_line_ids	Linked Order Lines	`one2many` → sale.order.line	inverse: `linked_line_id`
linked_virtual_id	Linked Virtual	`char`
margin	Margin	`float`	computed, stored added by Margins in Sales Orders (`sale_margin`)
margin_percent	Margin (%)	`float`	computed, stored added by Margins in Sales Orders (`sale_margin`)
move_ids	Stock Moves	`one2many` → stock.move	inverse: `sale_line_id` added by Sales and Warehouse Management (`sale_stock`)
name	Description	`text`	requiredcomputed, stored
name_short	Name Short	`char`	computed added by eCommerce (`website_sale`)
order_id	Order Reference	`many2one` → sale.order	required
order_partner_id	Customer	`many2one` → res.partner	related: `order_id.partner_id`
parent_id	Parent Section Line	`many2one` → sale.order.line	computed
points_cost	Points Cost How much point this reward costs on the loyalty card.	`float`	added by Sale Loyalty (`sale_loyalty`)
pos_order_line_ids	Order lines Transfered to Point of Sale	`one2many` → pos.order.line	read-only inverse: `sale_order_line_id` added by POS - Sales (`pos_sale`)
price_reduce_taxexcl	Price Reduce Tax excl	`monetary`	computed, stored
price_reduce_taxinc	Price Reduce Tax incl	`monetary`	computed, stored
price_subtotal	Subtotal	`monetary`	computed, stored
price_tax	Total Tax	`float`	computed, stored
price_total	Total	`monetary`	computed, stored
price_unit	Unit Price	`float`	requiredcomputed, stored
pricelist_item_id	Pricelist Item	`many2one` → product.pricelist.item	computed
product_add_mode	Product Add Mode	`selection`	related: `product_template_id.product_add_mode` added by Sale Matrix (`sale_product_matrix`)
product_custom_attribute_value_ids	Custom Values	`one2many` → product.attribute.custom.value	computed, stored inverse: `sale_order_line_id`
product_document_ids	Product Documents The product documents for this order line that will be merged in the PDF quote.	`many2many` → product.document	added by Sales PDF Quotation Builder (`sale_pdf_quote_builder`)
product_id	Product	`many2one` → product.product
product_no_variant_attribute_value_ids	Extra Values	`many2many` → product.template.attribute.value	computed, stored
product_qty	Product Qty	`float`	computed added by Delivery Costs (`delivery`)
product_template_attribute_value_ids	Product Template Attribute Value	`many2many` → product.template.attribute.value	related: `product_id.product_template_attribute_value_ids`
product_template_id	Product Template	`many2one` → product.template	computed
product_type	Product Type	`selection`	related: `product_id.type`
product_uom_id	Unit	`many2one` → uom.uom	computed, stored
product_uom_qty	Quantity	`float`	requiredcomputed, stored
product_uom_readonly	Product Uom Readonly	`boolean`	computed
product_updatable	Can Edit Product	`boolean`	computed
project_id	Generated Project	`many2one` → project.project	added by Sales - Project (`sale_project`)
purchase_line_count	Number of generated purchase items	`integer`	computed added by Sale Purchase (`sale_purchase`)
purchase_line_ids	Generated Purchase Lines Purchase line generated by this Sales item on order confirmation, or when the quantity was increased.	`one2many` → purchase.order.line	read-only inverse: `sale_line_id` added by Sale Purchase (`sale_purchase`)
purchase_price	Cost	`float`	computed, stored added by Margins in Sales Orders (`sale_margin`)
qty_available_today	Qty Available Today	`float`	computed added by Sales and Warehouse Management (`sale_stock`)
qty_delivered	Delivery Quantity	`float`	computed, stored
qty_delivered_at_date	Delivered	`float`	computed
qty_delivered_method	Method to update delivered qty According to product configuration, the delivered quantity can be automatically computed by mechanism: - Manual: the quantity is set manually on the line - Analytic From expenses: the quantity is the quantity sum from posted expenses - Timesheet: the quantity is the sum of hours recorded on tasks linked to this sale line - Stock Moves: the quantity comes from confirmed pickings	`selection`	computed, stored Values: `manual` (Manual), `analytic` (Analytic From Expenses)
qty_invoiced	Invoiced Quantity	`float`	computed, stored
qty_invoiced_at_date	Invoiced	`float`	computed
qty_invoiced_posted	Invoiced Quantity (posted)	`float`	computed
qty_to_deliver	Qty To Deliver	`float`	computed added by Sales and Warehouse Management (`sale_stock`)
qty_to_invoice	Quantity To Invoice	`float`	computed, stored
reached_milestones_ids	Reached Milestones	`one2many` → project.milestone	inverse: `sale_line_id` added by Sales - Project (`sale_project`)
recompute_delivery_price	Recompute Delivery Price	`boolean`	related: `order_id.recompute_delivery_price` added by Delivery Costs (`delivery`)
registration_ids	Registrations	`one2many` → event.registration	inverse: `sale_order_line_id` added by Events Sales (`event_sale`)
remaining_hours	Time Remaining on SO	`float`	computed, stored added by Sales Timesheet (`sale_timesheet`)
remaining_hours_available	Remaining Hours Available	`boolean`	computed added by Sales Timesheet (`sale_timesheet`)
reward_id	Reward	`many2one` → loyalty.reward	read-only added by Sale Loyalty (`sale_loyalty`)
reward_identifier_code	Reward Identifier Code Technical field used to link multiple reward lines from the same reward together.	`char`	added by Sale Loyalty (`sale_loyalty`)
route_ids	Routes	`many2many` → stock.route	added by Sales and Warehouse Management (`sale_stock`)
sale_line_warn_msg	Sale Line Warn Msg	`text`	computed
salesman_id	Salesperson	`many2one` → res.users	related: `order_id.user_id`
scheduled_date	Scheduled Date	`datetime`	computed added by Sales and Warehouse Management (`sale_stock`)
selected_combo_items	Selected Combo Items	`char`
sequence	Sequence	`integer`
service_tracking	Service Tracking	`selection`	related: `product_id.service_tracking`
shop_warning	Warning	`char`	added by eCommerce (`website_sale`)
state	Order Status	`selection`	related: `order_id.state`
task_id	Generated Task	`many2one` → project.task	added by Sales - Project (`sale_project`)
tax_calculation_rounding_method	Tax calculation rounding method	`selection`	read-only related: `company_id.tax_calculation_rounding_method`
tax_country_id	Tax Country	`many2one` → res.country	related: `order_id.tax_country_id`
tax_ids	Taxes	`many2many` → account.tax	computed, stored
technical_price_unit	Technical Price Unit	`float`
timesheet_ids	Timesheets	`one2many` → account.analytic.line	inverse: `so_line` added by Sales Timesheet (`sale_timesheet`)
translated_product_name	Translated Product Name	`text`	computed
untaxed_amount_invoiced	Untaxed Invoiced Amount	`monetary`	computed, stored
untaxed_amount_to_invoice	Untaxed Amount To Invoice	`monetary`	computed, stored
use_expiration_date	Use Expiration Date	`boolean`	related: `product_id.use_expiration_date` added by Sale Stock Product Expiry (`sale_stock_product_expiry`)
virtual_available_at_date	Virtual Available At Date	`float`	computed added by Sales and Warehouse Management (`sale_stock`)
virtual_id	Virtual	`char`
warehouse_id	Warehouse	`many2one` → stock.warehouse	computed, stored added by Sales and Warehouse Management (`sale_stock`)
analytic_distribution	Analytic Distribution	`json`	computed, stored inherited from analytic.mixin
analytic_precision	Analytic Precision	`integer`	inherited from analytic.mixin
distribution_analytic_account_ids	Distribution Analytic Account	`many2many` → account.analytic.account	computed inherited from analytic.mixin
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: analytic_line_ids, timesheet_ids
account.move.line: invoice_lines
account.tax: tax_ids
event.booth: event_booth_ids, event_booth_pending_ids
event.booth.category: event_booth_category_id
event.booth.registration: event_booth_registration_ids
event.event: event_id
event.event.ticket: event_ticket_id
event.registration: registration_ids
event.slot: event_slot_id
hr.expense: expense_id, expense_ids
loyalty.card: coupon_id
loyalty.reward: reward_id
pos.order.line: pos_order_line_ids
product.attribute.custom.value: product_custom_attribute_value_ids
product.category: categ_id
product.combo.item: combo_item_id
product.document: available_product_document_ids, product_document_ids
product.pricelist.item: pricelist_item_id
product.product: product_id
product.template: product_template_id
product.template.attribute.value: product_no_variant_attribute_value_ids, product_template_attribute_value_ids
project.milestone: reached_milestones_ids
project.project: project_id
project.task: task_id
purchase.order.line: purchase_line_ids
res.company: company_id
res.country: tax_country_id
res.currency: currency_id
res.partner: order_partner_id
res.users: salesman_id
sale.order: order_id
sale.order.line: linked_line_id, linked_line_ids, parent_id
stock.move: move_ids
stock.route: route_ids
stock.warehouse: warehouse_id
uom.uom: allowed_uom_ids, product_uom_id

Fields of other models pointing here

account.analytic.line: so_line
account.move.line: sale_line_ids
event.booth: sale_order_line_id, sale_order_line_registration_ids
event.booth.configurator: sale_order_line_id
event.booth.registration: sale_order_line_id
event.registration: sale_order_line_id
event.sale.report: sale_order_line_id
hr.expense: sale_order_line_id
mrp.production: sale_line_id
pos.order.line: sale_order_line_id
product.attribute.custom.value: sale_order_line_id
project.milestone: sale_line_id
project.project: sale_line_id
project.sale.line.employee.map: sale_line_id
project.task: last_sol_of_customer, sale_line_id
purchase.order.line: sale_line_id
registration.editor.line: sale_order_line_id
repair.order: sale_order_line_id
report.project.task.user: sale_line_id
sale.order.line: linked_line_id, parent_id
stock.move: sale_line_id
timesheets.analysis.report: so_line

Reading this model through the API

Odoo 19 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/sale.order.line/search_read" \
  -H "Authorization: bearer $ODOO_API_KEY" \
  -H "X-Odoo-Database: your-db" \
  -H "Content-Type: application/json" \
  -d '{"domain":[],"fields":["name","customer_lead","order_id","price_unit","product_uom_qty"],"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}/sale.order.line/search_read",
    headers=headers,
    json={"domain": [], "fields": ["name","customer_lead","order_id","price_unit","product_uom_qty"], "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/sale-order-line">sale.order.line (Odoo 19.0)</a>

Sources

Data verified on September 23, 2026 · Odoo 19.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.