invantive documentation
Invantive Support ForumsLog In / Sign Up

pos_order: Odoo itgen_odoo_pos_order

read only per partition

  • Catalog: Odoo
  • Schema: report
  • Label: itgen_odoo_pos_order

Point of Sale Orders Report

Can only retrieve data.

Table Columns

The columns of the table pos_order 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
average_price numeric Average Price
company_id varchar2
company_id_label varchar2
config_id varchar2
config_id_label varchar2
date datetime Order Date
delay_validation int32 Delay Validation
display_name varchar2 Display Name
employee_id varchar2
employee_id_label varchar2
id int32 ID
invoiced boolean Invoiced
journal_id varchar2
journal_id_label varchar2
margin numeric Margin
nbr_lines int32 Sale Line Count
order_id varchar2
order_id_label varchar2
partner_id varchar2
partner_id_label varchar2
pos_categ_id varchar2
pos_categ_id_label varchar2
price_sub_total numeric Subtotal w/o discount
price_total numeric Total Price
pricelist_id varchar2
pricelist_id_label varchar2
product_categ_id varchar2
product_categ_id_label varchar2
product_id varchar2
product_id_label varchar2
product_qty int32 Product Quantity
product_tmpl_id varchar2
product_tmpl_id_label varchar2
session_id varchar2
session_id_label varchar2
state varchar2 Status
total_discount numeric Total Discount
user_id varchar2
user_id_label varchar2

Release Notes

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