# order
Lunch Order
- Catalog: `Odoo`
- Schema: `lunch`
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 `order` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `active` | `boolean` | Active | ☐ | |
| `available_today` | `boolean` | This is True when if the supplier is available today | ☐ | |
| `available_toppings_1` | `boolean` | Available Toppings 1 | ☐ | Are extras available for this product |
| `available_toppings_2` | `boolean` | Available Toppings 2 | ☐ | Are extras available for this product |
| `available_toppings_3` | `boolean` | Available Toppings 3 | ☐ | Are extras available for this product |
| `category_id_label` | `string` | | ☐ | |
| `category_id` | `string` | | ☐ | |
| `company_id_label` | `string` | | ☐ | |
| `company_id` | `string` | | ☐ | |
| `create_date` | `datetime` | Created on | ☐ | |
| `create_uid_label` | `string` | | ☐ | |
| `create_uid` | `string` | | ☐ | |
| `currency_id_label` | `string` | | ☐ | |
| `currency_id` | `string` | | ☐ | |
| `date` | `datetime` | Order Date | ☑ | |
| `display_name` | `string` | Display Name | ☐ | |
| `display_reorder_button` | `boolean` | Display Reorder Button | ☐ | |
| `display_toppings` | `string` | Extras | ☐ | |
| `id` | `int32` | ID | ☐ | |
| `image_128` | `byte[]` | Image 128 | ☐ | |
| `image_1920` | `byte[]` | Image 1920 | ☐ | |
| `lunch_location_id_label` | `string` | | ☐ | |
| `lunch_location_id` | `string` | | ☐ | |
| `name` | `string` | Product Name | ☐ | |
| `note` | `string` | Notes | ☐ | |
| `notified` | `boolean` | Notified | ☐ | |
| `order_deadline_passed` | `boolean` | Order Deadline Passed | ☐ | |
| `price` | `decimal` | Total Price | ☐ | |
| `product_description` | `string` | Description | ☐ | |
| `product_id_label` | `string` | | ☐ | |
| `product_id` | `string` | | ☐ | |
| `quantity` | `decimal` | Quantity | ☑ | |
| `state` | `string` | Status | ☐ | |
| `supplier_id_label` | `string` | | ☐ | |
| `supplier_id` | `string` | | ☐ | |
| `topping_ids_1` | `string` | | ☐ | |
| `topping_ids_2` | `string` | | ☐ | |
| `topping_ids_3` | `string` | | ☐ | |
| `topping_label_1` | `string` | Extra 1 Label | ☐ | |
| `topping_label_2` | `string` | Extra 2 Label | ☐ | |
| `topping_label_3` | `string` | Extra 3 Label | ☐ | |
| `topping_quantity_1` | `string` | Extra 1 Quantity | ☐ | |
| `topping_quantity_2` | `string` | Extra 2 Quantity | ☐ | |
| `topping_quantity_3` | `string` | Extra 3 Quantity | ☐ | |
| `user_id_label` | `string` | | ☐ | |
| `user_id` | `string` | | ☐ | |
| `write_date` | `datetime` | Last Updated on | ☐ | |
| `write_uid_label` | `string` | | ☐ | |
| `write_uid` | `string` | | ☐ | |