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