# sale_report Event Sales Report by event (type), ticket, etc. Each opened record will also give access to all this information. ## Documentation Event Registrations-based sales report, allowing to analyze sales and number of seats - Catalog: `Odoo` - Schema: `event` 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 `sale_report` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `active` | `boolean` | Is registration active (not archived)? | ☐ | | | `company_id_label` | `string` | | ☐ | | | `company_id` | `string` | | ☐ | | | `display_name` | `string` | Display Name | ☐ | | | `event_date_begin` | `datetime` | Event Start Date | ☐ | | | `event_date_end` | `datetime` | Event End Date | ☐ | | | `event_id_label` | `string` | | ☐ | | | `event_id` | `string` | | ☐ | | | `event_registration_create_date` | `datetime` | Registration Date | ☐ | | | `event_registration_id_label` | `string` | | ☐ | | | `event_registration_id` | `string` | | ☐ | | | `event_registration_name` | `string` | Attendee Name | ☐ | | | `event_registration_state` | `string` | Registration Status | ☐ | | | `event_ticket_id_label` | `string` | | ☐ | | | `event_ticket_id` | `string` | | ☐ | | | `event_ticket_price` | `decimal` | Ticket price | ☐ | | | `event_type_id_label` | `string` | | ☐ | | | `event_type_id` | `string` | | ☐ | | | `id` | `int32` | ID | ☐ | | | `invoice_partner_id_label` | `string` | | ☐ | | | `invoice_partner_id` | `string` | | ☐ | | | `is_paid` | `boolean` | Is Paid | ☐ | | | `is_published` | `boolean` | Published Events | ☐ | | | `payment_status` | `string` | Payment Status | ☐ | | | `product_id_label` | `string` | | ☐ | | | `product_id` | `string` | | ☐ | | | `sale_order_date` | `datetime` | Order Date | ☐ | | | `sale_order_id_label` | `string` | | ☐ | | | `sale_order_id` | `string` | | ☐ | | | `sale_order_line_id_label` | `string` | | ☐ | | | `sale_order_line_id` | `string` | | ☐ | | | `sale_order_partner_id_label` | `string` | | ☐ | | | `sale_order_partner_id` | `string` | | ☐ | | | `sale_order_state` | `string` | Sale Order Status | ☐ | | | `sale_order_user_id_label` | `string` | | ☐ | | | `sale_order_user_id` | `string` | | ☐ | | | `sale_price_untaxed` | `decimal` | Untaxed Revenues | ☐ | | | `sale_price` | `decimal` | Revenues | ☐ | |