invantive documentation
Invantive Support ForumsLog In / Sign Up

report: Odoo itgen_odoo_report

read only per partition

  • Catalog: Odoo
  • Schema: sale
  • Label: itgen_odoo_report

Sales Analysis Report

Can only retrieve data.

Table Columns

The columns of the table report 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
analytic_account_id varchar2
analytic_account_id_label varchar2
campaign_id varchar2
campaign_id_label varchar2
categ_id varchar2
categ_id_label varchar2
commercial_partner_id varchar2
commercial_partner_id_label varchar2
company_id varchar2
company_id_label varchar2
country_id varchar2
country_id_label varchar2
date datetime Order Date
discount numeric Discount %
discount_amount numeric Discount Amount
display_name varchar2 Display Name
id int32 ID
industry_id varchar2
industry_id_label varchar2
invoice_status varchar2 Invoice Status
is_abandoned_cart boolean Abandoned Cart
medium_id varchar2
medium_id_label varchar2
name varchar2 Order Reference
nbr int32 # of Lines
order_id varchar2
order_id_label varchar2
partner_id varchar2
partner_id_label varchar2
price_subtotal numeric Untaxed Total
price_total numeric Total
pricelist_id varchar2
pricelist_id_label varchar2
product_id varchar2
product_id_label varchar2
product_tmpl_id varchar2
product_tmpl_id_label varchar2
product_uom varchar2
product_uom_label varchar2
product_uom_qty numeric Qty Ordered
qty_delivered numeric Qty Delivered
qty_invoiced numeric Qty Invoiced
qty_to_deliver numeric Qty To Deliver
qty_to_invoice numeric Qty To Invoice
source_id varchar2
source_id_label varchar2
state varchar2 Status
team_id varchar2
team_id_label varchar2
untaxed_amount_invoiced numeric Untaxed Amount Invoiced
untaxed_amount_to_invoice numeric Untaxed Amount To Invoice
user_id varchar2
user_id_label varchar2
volume numeric Volume
warehouse_id varchar2
warehouse_id_label varchar2
website_id varchar2
website_id_label varchar2
weight numeric Gross Weight

Release Notes

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