---
title: "report (Odoo)"
description: "itgen_odoo_report"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.sale.report
original: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.sale.report
updated: 2023-03-01T15:29:04Z
license: https://documentation.invantive.eu/en/
---

# 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:

- [Odoo](/en/release-notes/drivers?driver=odoo)

