invantive documentation
Invantive Support ForumsLog In / Sign Up

order_line: Odoo itgen_odoo_order_line

read only per partition

  • Catalog: Odoo
  • Schema: pos
  • Label: itgen_odoo_order_line

Point of Sale Order Lines

Can only retrieve data.

Table Columns

The columns of the table order_line are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
company_id varchar2
company_id_label varchar2
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
currency_id varchar2
currency_id_label varchar2
customer_note varchar2 Customer Note
discount numeric Discount (%)
display_name varchar2 Display Name
down_payment_details varchar2 Down Payment Details
full_product_name varchar2 Full Product Name
id int32 ID
is_total_cost_computed boolean Is Total Cost Computed Allows to know if the total cost has already been computed or not
margin numeric Margin
margin_percent numeric Margin (%)
name varchar2 Line No
notice varchar2 Discount Notice
order_id varchar2
order_id_label varchar2
pack_lot_ids varchar2
price_extra numeric Price extra
price_subtotal numeric Subtotal w/o Tax
price_subtotal_incl numeric Subtotal
price_unit numeric Unit Price
product_id varchar2
product_id_label varchar2
product_uom_id varchar2 Default unit of measure used for all stock operations.
product_uom_id_label varchar2 Default unit of measure used for all stock operations.
qty numeric Quantity
refund_orderline_ids varchar2 Orderlines in this field are the lines that refunded this orderline.
refunded_orderline_id varchar2 If this orderline is a refund, then the refunded orderline is specified in this field.
refunded_orderline_id_label varchar2 If this orderline is a refund, then the refunded orderline is specified in this field.
refunded_qty numeric Refunded Quantity Number of items refunded in this orderline.
sale_order_line_id varchar2
sale_order_line_id_label varchar2
sale_order_origin_id varchar2
sale_order_origin_id_label varchar2
tax_ids varchar2
tax_ids_after_fiscal_position varchar2
total_cost numeric Total cost
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: