# report Sales Analysis Report - Catalog: `Odoo` - Schema: `sale` The data in this table is partitioned per value of the column. This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API. ## Table Columns The columns of the table `report` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `analytic_account_id_label` | `string` | | ☐ | | | `analytic_account_id` | `string` | | ☐ | | | `campaign_id_label` | `string` | | ☐ | | | `campaign_id` | `string` | | ☐ | | | `categ_id_label` | `string` | | ☐ | | | `categ_id` | `string` | | ☐ | | | `commercial_partner_id_label` | `string` | | ☐ | | | `commercial_partner_id` | `string` | | ☐ | | | `company_id_label` | `string` | | ☐ | | | `company_id` | `string` | | ☐ | | | `country_id_label` | `string` | | ☐ | | | `country_id` | `string` | | ☐ | | | `date` | `datetime` | Order Date | ☐ | | | `discount_amount` | `decimal` | Discount Amount | ☐ | | | `discount` | `decimal` | Discount % | ☐ | | | `display_name` | `string` | Display Name | ☐ | | | `id` | `int32` | ID | ☐ | | | `industry_id_label` | `string` | | ☐ | | | `industry_id` | `string` | | ☐ | | | `invoice_status` | `string` | Invoice Status | ☐ | | | `is_abandoned_cart` | `boolean` | Abandoned Cart | ☐ | | | `medium_id_label` | `string` | | ☐ | | | `medium_id` | `string` | | ☐ | | | `name` | `string` | Order Reference | ☐ | | | `nbr` | `int32` | # of Lines | ☐ | | | `order_id_label` | `string` | | ☐ | | | `order_id` | `string` | | ☐ | | | `partner_id_label` | `string` | | ☐ | | | `partner_id` | `string` | | ☐ | | | `price_subtotal` | `decimal` | Untaxed Total | ☐ | | | `price_total` | `decimal` | Total | ☐ | | | `pricelist_id_label` | `string` | | ☐ | | | `pricelist_id` | `string` | | ☐ | | | `product_id_label` | `string` | | ☐ | | | `product_id` | `string` | | ☐ | | | `product_tmpl_id_label` | `string` | | ☐ | | | `product_tmpl_id` | `string` | | ☐ | | | `product_uom_label` | `string` | | ☐ | | | `product_uom_qty` | `decimal` | Qty Ordered | ☐ | | | `product_uom` | `string` | | ☐ | | | `qty_delivered` | `decimal` | Qty Delivered | ☐ | | | `qty_invoiced` | `decimal` | Qty Invoiced | ☐ | | | `qty_to_deliver` | `decimal` | Qty To Deliver | ☐ | | | `qty_to_invoice` | `decimal` | Qty To Invoice | ☐ | | | `source_id_label` | `string` | | ☐ | | | `source_id` | `string` | | ☐ | | | `state` | `string` | Status | ☐ | | | `team_id_label` | `string` | | ☐ | | | `team_id` | `string` | | ☐ | | | `untaxed_amount_invoiced` | `decimal` | Untaxed Amount Invoiced | ☐ | | | `untaxed_amount_to_invoice` | `decimal` | Untaxed Amount To Invoice | ☐ | | | `user_id_label` | `string` | | ☐ | | | `user_id` | `string` | | ☐ | | | `volume` | `decimal` | Volume | ☐ | | | `warehouse_id_label` | `string` | | ☐ | | | `warehouse_id` | `string` | | ☐ | | | `website_id_label` | `string` | | ☐ | | | `website_id` | `string` | | ☐ | | | `weight` | `decimal` | Gross Weight | ☐ | |