invantive documentation
Invantive Support ForumsLog In / Sign Up

supplier: Odoo itgen_odoo_supplier

read only per partition

  • Catalog: Odoo
  • Schema: lunch
  • Label: itgen_odoo_supplier

Lunch Supplier

Can only retrieve data.

Table Columns

The columns of the table supplier 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
activity_calendar_event_id varchar2
activity_calendar_event_id_label varchar2
activity_date_deadline datetime Next Activity Deadline
activity_exception_decoration varchar2 Activity Exception Decoration Type of the exception activity on record.
activity_exception_icon varchar2 Icon Icon to indicate an exception activity.
activity_ids varchar2
activity_state varchar2 Activity State Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities.
activity_summary varchar2 Next Activity Summary
activity_type_icon varchar2 Activity Type Icon Font awesome icon e.g. fa-tasks
activity_type_id varchar2
activity_type_id_label varchar2
activity_user_id varchar2
activity_user_id_label varchar2
automatic_email_time numeric Order Time
available_location_ids varchar2
available_today boolean This is True when if the supplier is available today
city varchar2 City
company_id varchar2
company_id_label varchar2
country_id varchar2
country_id_label varchar2
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
cron_id varchar2
cron_id_label varchar2
delivery varchar2 Delivery
display_name varchar2 Display Name
email varchar2 Email
email_formatted varchar2 Formatted Email Format email address "Name email@domain"
fri boolean Fri
has_message boolean Has Message
id int32 ID
message_attachment_count int32 Attachment Count
message_follower_ids varchar2
message_has_error boolean Message Delivery error If checked, some messages have a delivery error.
message_has_error_counter int32 Number of errors Number of messages with delivery error
message_has_sms_error boolean SMS Delivery error If checked, some messages have a delivery error.
message_ids varchar2
message_is_follower boolean Is Follower
message_main_attachment_id varchar2
message_main_attachment_id_label varchar2
message_needaction boolean Action Needed If checked, new messages require your attention.
message_needaction_counter int32 Number of Actions Number of messages which requires an action
message_partner_ids varchar2
moment varchar2 Moment
mon boolean Mon
my_activity_date_deadline datetime My Activity Deadline
name varchar2 Name
order_deadline_passed boolean Order Deadline Passed
partner_id varchar2
partner_id_label varchar2
phone varchar2 Phone
recurrency_end_date datetime Until This field is used in order to
responsible_id varchar2 The responsible is the person that will order lunch for everyone. It will be used as the 'from' when sending the automatic email.
responsible_id_label varchar2 The responsible is the person that will order lunch for everyone. It will be used as the 'from' when sending the automatic email.
sat boolean Sat
send_by varchar2 Send Order By
show_confirm_button boolean Show Confirm Button
show_order_button boolean Show Order Button
state_id varchar2
state_id_label varchar2
street varchar2 Street
street2 varchar2 Street2
sun boolean Sun
thu boolean Thu
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
tue boolean Tue
tz varchar2 Timezone
website_message_ids varchar2 Website communication history
wed boolean Wed
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2
zip_code varchar2 Zip

Release Notes

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