Please enable JavaScript to view this site.

Made in EU
Odoo Forums

Navigation: Schema: sale > Tables

order_line

Sales Order Line

Catalog: Odoo

Schema: sale

The data in this table is partitioned per value of the column.

This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API.

Table Columns

The columns of the table order_line are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

amazon_item_ref

string

Amazon Item Ref

The Amazon-defined item reference.

amazon_offer_id_label

string

 

 

amazon_offer_id

string

 

 

analytic_distribution

string

Analytic Distribution

 

analytic_line_ids

string

 

 

analytic_precision

int32

Analytic Precision

 

company_id_label

string

 

 

company_id

string

 

 

create_date

datetime

Created on

 

create_uid_label

string

 

 

create_uid

string

 

 

currency_id_label

string

 

 

currency_id

string

 

 

customer_lead

decimal

Lead Time

Number of days between the order confirmation and the shipping of the products to the customer

delivered_price_subtotal

decimal

Delivered Subtotal

 

delivered_price_tax

decimal

Delivered Total Tax

 

delivered_price_total

decimal

Delivered Total

 

discount

decimal

Discount (%)

 

display_name

string

Display Name

 

display_qty_widget

boolean

Display Qty Widget

 

display_type

string

Display Type

 

event_id_label

string

 

Choose an event and it will automatically create a registration for this event.

event_id

string

 

Choose an event and it will automatically create a registration for this event.

event_ok

boolean

Event Ok

 

event_ticket_id_label

string

 

Choose an event ticket and it will automatically create a registration for this event ticket.

event_ticket_id

string

 

Choose an event ticket and it will automatically create a registration for this event ticket.

forecast_expected_date

datetime

Forecast Expected Date

 

free_qty_today

decimal

Free Qty Today

 

fsm_lot_id_label

string

 

 

fsm_lot_id

string

 

 

has_displayed_warning_upsell

boolean

Has Displayed Warning Upsell

 

id

int32

ID

 

invoice_lines

string

 

 

invoice_status

string

Invoice Status

 

is_configurable_product

boolean

Is the product configurable?

 

is_delivery

boolean

Is a Delivery

 

is_downpayment

boolean

Is a down payment

Down payments are made when creating invoices from a sales order. They are not copied when duplicating a sales order.

is_expense

boolean

Is expense

Is true if the sales order line comes from an expense or a vendor bills

is_late

boolean

Is overdue

The products haven't been returned in time

is_mto

boolean

Is Mto

 

is_product_rentable

boolean

Can be Rented

Allow renting of this product.

is_rental

boolean

Is Rental

 

is_service

boolean

Is a Service

 

linked_line_id_label

string

 

 

linked_line_id

string

 

 

move_ids

string

 

 

name_short

string

Name Short

 

name

string

Description

 

option_line_ids

string

 

 

order_id_label

string

 

 

order_id

string

 

 

order_partner_id_label

string

 

 

order_partner_id

string

 

 

parent_line_id_label

string

 

 

parent_line_id

string

 

 

pickedup_lot_ids

string

 

 

planning_hours_planned

decimal

Planning Hours Planned

 

planning_hours_to_plan

decimal

Planning Hours To Plan

 

planning_slot_ids

string

 

 

pos_order_line_ids

string

 

 

price_reduce_taxexcl

decimal

Price Reduce Tax excl

 

price_reduce_taxinc

decimal

Price Reduce Tax incl

 

price_subtotal

decimal

Subtotal

 

price_tax

decimal

Total Tax

 

price_total

decimal

Total

 

price_unit

decimal

Unit Price

 

pricelist_item_id_label

string

 

 

pricelist_item_id

string

 

 

pricing_id_label

string

 

 

pricing_id

string

 

 

product_custom_attribute_value_ids

string

 

 

product_id_label

string

 

 

product_id

string

 

 

product_no_variant_attribute_value_ids

string

 

 

product_packaging_id_label

string

 

 

product_packaging_id

string

 

 

product_packaging_qty

decimal

Packaging Quantity

 

product_qty

decimal

Product Qty

 

product_template_attribute_value_ids

string

 

 

product_template_id_label

string

 

 

product_template_id

string

 

 

product_type

string

Product Type

A storable product is a product for which you manage stock. The Inventory app has to be installed.A consumable product is a product for which stock is not managed.A service is a non-material product you provide.

product_uom_category_id_label

string

 

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

string

 

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_label

string

 

 

product_uom_qty

decimal

Quantity

 

product_uom_readonly

boolean

Product Uom Readonly

 

product_uom

string

 

 

product_updatable

boolean

Can Edit Product

 

project_id_label

string

 

 

project_id

string

 

 

purchase_line_count

int32

Number of generated purchase items

 

purchase_line_ids

string

 

Purchase line generated by this Sales item on order confirmation, or when the quantity was increased.

qty_available_today

decimal

Qty Available Today

 

qty_delivered_method

string

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

qty_delivered

decimal

Delivery Quantity

 

qty_invoiced

decimal

Invoiced Quantity

 

qty_returned

decimal

Returned

 

qty_to_deliver

decimal

Qty To Deliver

 

qty_to_invoice

decimal

Quantity To Invoice

 

reached_milestones_ids

string

 

 

recompute_delivery_price

boolean

Delivery cost should be recomputed

 

recurring_monthly

decimal

Monthly Recurring Revenue

 

remaining_hours_available

boolean

Remaining Hours Available

 

remaining_hours

decimal

Remaining Hours on SO

 

reservation_begin

datetime

Pickup date - padding time

 

reserved_lot_ids

string

 

 

return_date

datetime

Return

 

returned_lot_ids

string

 

 

route_id_label

string

 

 

route_id

string

 

 

sale_order_option_ids

string

 

 

salesman_id_label

string

 

 

salesman_id

string

 

 

scheduled_date

datetime

Scheduled Date

 

sequence

int32

Sequence

 

shop_warning

string

Warning

 

start_date

datetime

Start Date

 

state

string

Order Status

 

task_id_label

string

 

 

task_id

string

 

 

tax_id

string

 

 

temporal_type

string

Temporal Type

 

timesheet_ids

string

 

 

tracking

string

Tracking

Ensure the traceability of a storable product in your warehouse.

unavailable_lot_ids

string

 

 

untaxed_amount_invoiced

decimal

Untaxed Invoiced Amount

 

untaxed_amount_to_invoice

decimal

Untaxed Amount To Invoice

 

virtual_available_at_date

decimal

Virtual Available At Date

 

warehouse_id_label

string

 

 

warehouse_id

string

 

 

write_date

datetime

Last Updated on

 

write_uid_label

string

 

 

write_uid

string

 

 

 

01-03-2023 15:29 Version 22.1.135-BETA+3826

X

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

  • Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
  • Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
  • Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
  • Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
  • Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
  • Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
  • Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
  • Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.

  
Disclaimer