invantive documentation
Invantive Support ForumsLog In / Sign Up

report: Odoo itgen_odoo_report

read only per partition

  • Catalog: Odoo
  • Schema: purchase
  • Label: itgen_odoo_report

Purchase 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
category_id varchar2
category_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
currency_id varchar2
currency_id_label varchar2
date_approve datetime Confirmation Date
date_order datetime Order Date
delay numeric Days to Confirm Amount of time between purchase approval and order by date.
delay_pass numeric Days to Receive Amount of time between date planned and order by date for each purchase order line.
display_name varchar2 Display Name
effective_date datetime Effective Date
fiscal_position_id varchar2
fiscal_position_id_label varchar2
id int32 ID
nbr_lines int32 # of Lines
order_id varchar2
order_id_label varchar2
partner_id varchar2
partner_id_label varchar2
picking_type_id varchar2
picking_type_id_label varchar2
price_average numeric Average Cost
price_total numeric Total
product_id varchar2
product_id_label varchar2
product_tmpl_id varchar2
product_tmpl_id_label varchar2
product_uom varchar2
product_uom_label varchar2
qty_billed numeric Qty Billed
qty_ordered numeric Qty Ordered
qty_received numeric Qty Received
qty_to_be_billed numeric Qty to be Billed
state varchar2 Status
untaxed_total numeric Untaxed Total
user_id varchar2
user_id_label varchar2
volume numeric Volume
weight numeric Gross Weight

Release Notes

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