invantive documentation
Invantive Support ForumsLog In / Sign Up

order: Odoo itgen_odoo_order

read only per partition

  • Catalog: Odoo
  • Schema: lunch
  • Label: itgen_odoo_order

Lunch Order

Can only retrieve data.

Table Columns

The columns of the table order 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
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 varchar2
category_id_label varchar2
company_id varchar2
company_id_label varchar2
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
currency_id varchar2
currency_id_label varchar2
date datetime Order Date
display_name varchar2 Display Name
display_reorder_button boolean Display Reorder Button
display_toppings varchar2 Extras
id int32 ID
image_128 varbinary Image 128
image_1920 varbinary Image 1920
lunch_location_id varchar2
lunch_location_id_label varchar2
name varchar2 Product Name
note varchar2 Notes
notified boolean Notified
order_deadline_passed boolean Order Deadline Passed
price numeric Total Price
product_description varchar2 Description
product_id varchar2
product_id_label varchar2
quantity numeric Quantity
state varchar2 Status
supplier_id varchar2
supplier_id_label varchar2
topping_ids_1 varchar2
topping_ids_2 varchar2
topping_ids_3 varchar2
topping_label_1 varchar2 Extra 1 Label
topping_label_2 varchar2 Extra 2 Label
topping_label_3 varchar2 Extra 3 Label
topping_quantity_1 varchar2 Extra 1 Quantity
topping_quantity_2 varchar2 Extra 2 Quantity
topping_quantity_3 varchar2 Extra 3 Quantity
user_id varchar2
user_id_label varchar2
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2

Release Notes

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