Odoo model ·
sale.order.line
Sale Order Line
Everything the Oddll AI Brain can read and reason about on your sale.order.line records — safely, and only what the signed-in user is allowed to see.
Library / Sale Order Line
Part of:
Delivery Costs
Events Booths Sales
Events Sales
Sell Helpdesk Timesheet
Field Service - Sale
Field Service Stock
POS - Sales
Sales
Amazon Connector
Sales Expense Margin
Sale Loyalty
Sales
Margins in Sales Orders
Sales PDF Quotation Builder
Sale Planning
Sale Matrix
Sales - Project
Sale Purchase
Rental
Sales - Service
Sales and Warehouse Management
Rental Stock Management
Subscriptions
Sales Timesheet
Pay to Book with eCommerce
eCommerce
Questions about Sale Order Line
- How many Sale Order Line records are there?
- Show the most recent Sale Order Line records
- Break down Sale Order Line records by Offer
- Which Offer has the most Sale Order Line records?
- What is the total Amount Invoiced on Sale Order Line this month?
- Which Sale Order Line records have the highest Amount Invoiced?
- What is the total Amount To Invoice on Sale Order Line this month?
- Which Sale Order Line records have the highest Amount To Invoice?
- How many Sale Order Line records are marked Available Reserved Lots?
- Break down Sale Order Line records by Event
- Which Event has the most Sale Order Line records?
- Break down Sale Order Line records by Item
- Which Item has the most Sale Order Line records?
- How many Sale Order Line records are in each Company Price Include?
- Break down Sale Order Line records by Card
- Which Card has the most Sale Order Line records?
- What is the total Delivered Price Subtotal on Sale Order Line this month?
- Which Sale Order Line records have the highest Delivered Price Subtotal?
- What is the total Delivered Price Tax on Sale Order Line this month?
- Which Sale Order Line records have the highest Delivered Price Tax?
- What is the total Delivered Price Total on Sale Order Line this month?
- Which Sale Order Line records have the highest Delivered Price Total?
- How many Sale Order Line records are marked Display Qty Widget?
- How many Sale Order Line records are in each Display Type?
- Break down Sale Order Line records by Category
- Which Category has the most Sale Order Line records?
- Break down Sale Order Line records by Ticket
- Which Ticket has the most Sale Order Line records?
- Break down Sale Order Line records by Expense
- Which Expense has the most Sale Order Line records?
- How many Sale Order Line records were created this month?
- Break down Sale Order Line records by month
- Break down Sale Order Line records by Lot
- Which Lot has the most Sale Order Line records?
- How many Sale Order Line records are marked Has Displayed Warning Upsell?
- How many Sale Order Line records are in each Invoice Status?
- How many Sale Order Line records are marked Is Configurable Product?
- How many Sale Order Line records are marked Is Delivery?
- How many Sale Order Line records are marked Is Downpayment?
- How many Sale Order Line records are marked Is Event Booth?
- How many Sale Order Line records are marked Is Expense?
- How many Sale Order Line records are marked Is Mto?
- How many Sale Order Line records are marked Is Product Archived?
- How many Sale Order Line records are marked Is Product Rentable?
- How many Sale Order Line records are marked Is Rental?
- How many Sale Order Line records are marked Is Reward Line?
- How many Sale Order Line records are marked Is Service?
- How many Sale Order Line records are marked Is Storable?
- Break down Sale Order Line records by Line
- Which Line has the most Sale Order Line records?
- Break down Sale Order Line records by Order
- Which Order has the most Sale Order Line records?
- What is the total Points Cost on Sale Order Line this month?
- Which Sale Order Line records have the highest Points Cost?
- What is the total Price Reduce Taxexcl on Sale Order Line this month?
- Which Sale Order Line records have the highest Price Reduce Taxexcl?
- What is the total Price Reduce Taxinc on Sale Order Line this month?
- Which Sale Order Line records have the highest Price Reduce Taxinc?
- What is the total Price Subtotal on Sale Order Line this month?
- Which Sale Order Line records have the highest Price Subtotal?
- What is the total Price Tax on Sale Order Line this month?
- Which Sale Order Line records have the highest Price Tax?
- What is the total Price Total on Sale Order Line this month?
- Which Sale Order Line records have the highest Price Total?
- What is the total Price Unit on Sale Order Line this month?
- Which Sale Order Line records have the highest Price Unit?
- How many Sale Order Line records are in each Product Add Mode?
- Break down Sale Order Line records by Product
- Which Product has the most Sale Order Line records?
- Break down Sale Order Line records by Packaging
- Which Packaging has the most Sale Order Line records?
- Break down Sale Order Line records by Template
- Which Template has the most Sale Order Line records?
- How many Sale Order Line records are in each Product Type?
- Break down Sale Order Line records by Uom
- Which Uom has the most Sale Order Line records?
- How many Sale Order Line records are marked Product Uom Readonly?
- How many Sale Order Line records are marked Product Updatable?
- Break down Sale Order Line records by Project
- Which Project has the most Sale Order Line records?
- What is the total Purchase Price on Sale Order Line this month?
- Which Sale Order Line records have the highest Purchase Price?
- How many Sale Order Line records are in each Qty Delivered Method?
- How many Sale Order Line records are marked Recompute Delivery Price?
- How many Sale Order Line records are marked Recurring Invoice?
- What is the total Recurring Monthly on Sale Order Line this month?
- Which Sale Order Line records have the highest Recurring Monthly?
- How many Sale Order Line records are marked Remaining Hours Available?
- Break down Sale Order Line records by Reward
- Which Reward has the most Sale Order Line records?
- Break down Sale Order Line records by Route
- Which Route has the most Sale Order Line records?
- How many Sale Order Line records are in each Service Tracking?
- How many Sale Order Line records are in each State?
- Break down Sale Order Line records by Task
- Which Task has the most Sale Order Line records?
- How many Sale Order Line records are in each Tax Calculation Rounding Method?
- What is the total Technical Price Unit on Sale Order Line this month?
- Which Sale Order Line records have the highest Technical Price Unit?
- How many Sale Order Line records are in each Tracking?
- What is the total Untaxed Amount Invoiced on Sale Order Line this month?
- Which Sale Order Line records have the highest Untaxed Amount Invoiced?
- What is the total Untaxed Amount To Invoice on Sale Order Line this month?
- Which Sale Order Line records have the highest Untaxed Amount To Invoice?
- Break down Sale Order Line records by Warehouse
- Which Warehouse has the most Sale Order Line records?
Fields on this model
| Field | Type | Relates to |
|---|---|---|
amazon_item_ref |
char | — |
amazon_offer_id |
many2one |
amazon.offer
|
amount_invoiced |
monetary | — |
amount_to_invoice |
monetary | — |
analytic_line_ids |
one2many |
account.analytic.line
|
available_product_document_ids |
many2many |
product.document
|
available_reserved_lots |
boolean | — |
calendar_booking_ids |
one2many |
calendar.booking
|
calendar_event_id |
many2one |
calendar.event
|
color |
integer | — |
combo_item_id |
many2one |
product.combo.item
|
company_id |
many2one | — |
company_price_include |
selection | — |
coupon_id |
many2one |
loyalty.card
|
currency_id |
many2one | — |
customer_lead |
float | — |
delivered_price_subtotal |
monetary | — |
delivered_price_tax |
float | — |
delivered_price_total |
monetary | — |
discount |
float | — |
display_qty_widget |
boolean | — |
display_type |
selection | — |
event_booth_category_id |
many2one |
event.booth.category
|
event_booth_ids |
one2many |
event.booth
|
event_booth_pending_ids |
many2many |
event.booth
|
event_booth_registration_ids |
one2many |
event.booth.registration
|
event_id |
many2one |
event.event
|
event_ticket_id |
many2one |
event.event.ticket
|
expense_id |
many2one |
hr.expense
|
forecast_expected_date |
datetime | — |
free_qty_today |
float | — |
fsm_lot_id |
many2one |
stock.lot
|
has_displayed_warning_upsell |
boolean | — |
invoice_lines |
many2many |
account.move.line
|
invoice_status |
selection | — |
is_configurable_product |
boolean | — |
is_delivery |
boolean | — |
is_downpayment |
boolean | — |
is_event_booth |
boolean | — |
is_expense |
boolean | — |
is_mto |
boolean | — |
is_product_archived |
boolean | — |
is_product_rentable |
boolean | — |
is_rental |
boolean | — |
is_reward_line |
boolean | — |
is_service |
boolean | — |
is_storable |
boolean | — |
last_invoiced_date |
date | — |
linked_line_id |
many2one |
sale.order.line
|
linked_line_ids |
one2many |
sale.order.line
|
linked_virtual_id |
char | — |
margin |
float | — |
margin_percent |
float | — |
move_ids |
one2many |
stock.move
|
name |
text | — |
name_short |
char | — |
next_invoice_date |
date | — |
order_id |
many2one |
sale.order
|
order_partner_id |
many2one | — |
parent_line_id |
many2one |
sale.order.line
|
pickedup_lot_ids |
many2many |
stock.lot
|
planning_hours_planned |
float | — |
planning_hours_to_plan |
float | — |
planning_slot_ids |
one2many |
planning.slot
|
points_cost |
float | — |
pos_order_line_ids |
one2many |
pos.order.line
|
price_reduce_taxexcl |
monetary | — |
price_reduce_taxinc |
monetary | — |
price_subtotal |
monetary | — |
price_tax |
float | — |
price_total |
monetary | — |
price_unit |
float | — |
pricelist_id |
many2one | — |
pricelist_item_id |
many2one |
product.pricelist.item
|
product_add_mode |
selection | — |
product_custom_attribute_value_ids |
one2many |
product.attribute.custom.value
|
product_document_ids |
many2many |
product.document
|
product_id |
many2one |
product.product
|
product_no_variant_attribute_value_ids |
many2many |
product.template.attribute.value
|
product_packaging_id |
many2one |
product.packaging
|
product_packaging_qty |
float | — |
product_qty |
float | — |
product_template_attribute_value_ids |
many2many | — |
product_template_id |
many2one |
product.template
|
product_template_variant_value_ids |
many2many | — |
product_type |
selection | — |
product_uom |
many2one |
uom.uom
|
product_uom_category_id |
many2one | — |
product_uom_qty |
float | — |
product_uom_readonly |
boolean | — |
product_updatable |
boolean | — |
project_id |
many2one |
project.project
|
purchase_line_count |
integer | — |
purchase_line_ids |
one2many |
purchase.order.line
|
purchase_price |
float | — |
qty_available_today |
float | — |
qty_delivered |
float | — |
qty_delivered_method |
selection | — |
qty_invoiced |
float | — |
qty_invoiced_posted |
float | — |
qty_returned |
float | — |
qty_to_deliver |
float | — |
qty_to_invoice |
float | — |
reached_milestones_ids |
one2many |
project.milestone
|
recompute_delivery_price |
boolean | — |
recurring_invoice |
boolean | — |
recurring_monthly |
monetary | — |
registration_ids |
one2many |
event.registration
|
remaining_hours |
float | — |
remaining_hours_available |
boolean | — |
reservation_begin |
datetime | — |
reserved_lot_ids |
many2many |
stock.lot
|
return_date |
datetime | — |
returned_lot_ids |
many2many |
stock.lot
|
reward_id |
many2one |
loyalty.reward
|
reward_identifier_code |
char | — |
route_id |
many2one |
stock.route
|
sale_order_option_ids |
one2many |
sale.order.option
|
salesman_id |
many2one | — |
scheduled_date |
datetime | — |
selected_combo_items |
char | — |
sequence |
integer | — |
service_tracking |
selection | — |
shop_warning |
char | — |
start_date |
datetime | — |
state |
selection | — |
subscription_end_date |
date | — |
subscription_plan_id |
many2one | — |
subscription_start_date |
date | — |
task_id |
many2one |
project.task
|
tax_calculation_rounding_method |
selection | — |
tax_country_id |
many2one | — |
tax_id |
many2many |
account.tax
|
technical_price_unit |
float | — |
timesheet_ids |
one2many |
account.analytic.line
|
tracking |
selection | — |
translated_product_name |
text | — |
unavailable_lot_ids |
many2many |
stock.lot
|
untaxed_amount_invoiced |
monetary | — |
untaxed_amount_to_invoice |
monetary | — |
virtual_available_at_date |
float | — |
virtual_id |
char | — |
warehouse_id |
many2one |
stock.warehouse
|
Ask it in your own Odoo
The answer comes from your database — private, permission-checked, and audited. Oddll AI Brain never stores your business data.
Get Odoo + AI tips