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_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
datetime |
Next Activity Deadline | |||
activity_ |
varchar2 |
Activity Exception Decoration | Type of the exception activity on record. | ||
activity_ |
varchar2 |
Icon | Icon to indicate an exception activity. | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
Activity State | Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities. | ||
activity_ |
varchar2 |
Next Activity Summary | |||
activity_ |
varchar2 |
Activity Type Icon | Font awesome icon e.g. fa-tasks | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
automatic_ |
numeric |
Order Time | |||
available_ |
varchar2 |
||||
available_ |
boolean |
This is True when if the supplier is available today | |||
city |
varchar2 |
City | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
country_ |
varchar2 |
||||
country_ |
varchar2 |
||||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
cron_ |
varchar2 |
||||
cron_ |
varchar2 |
||||
delivery |
varchar2 |
Delivery | |||
display_ |
varchar2 |
Display Name | |||
email |
varchar2 |
||||
email_ |
varchar2 |
Formatted Email | Format email address "Name email@domain" | ||
fri |
boolean |
Fri | |||
has_ |
boolean |
Has Message | |||
id |
int32 |
ID | |||
message_ |
int32 |
Attachment Count | |||
message_ |
varchar2 |
||||
message_ |
boolean |
Message Delivery error | If checked, some messages have a delivery error. | ||
message_ |
int32 |
Number of errors | Number of messages with delivery error | ||
message_ |
boolean |
SMS Delivery error | If checked, some messages have a delivery error. | ||
message_ |
varchar2 |
||||
message_ |
boolean |
Is Follower | |||
message_ |
varchar2 |
||||
message_ |
varchar2 |
||||
message_ |
boolean |
Action Needed | If checked, new messages require your attention. | ||
message_ |
int32 |
Number of Actions | Number of messages which requires an action | ||
message_ |
varchar2 |
||||
moment |
varchar2 |
Moment | |||
mon |
boolean |
Mon | |||
my_ |
datetime |
My Activity Deadline | |||
name |
varchar2 |
Name | |||
order_ |
boolean |
Order Deadline Passed | |||
partner_ |
varchar2 |
||||
partner_ |
varchar2 |
||||
phone |
varchar2 |
Phone | |||
recurrency_ |
datetime |
Until | This field is used in order to | ||
responsible_ |
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_ |
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_ |
varchar2 |
Send Order By | |||
show_ |
boolean |
Show Confirm Button | |||
show_ |
boolean |
Show Order Button | |||
state_ |
varchar2 |
||||
state_ |
varchar2 |
||||
street |
varchar2 |
Street | |||
street2 |
varchar2 |
Street2 | |||
sun |
boolean |
Sun | |||
thu |
boolean |
Thu | |||
topping_ |
varchar2 |
||||
topping_ |
varchar2 |
||||
topping_ |
varchar2 |
||||
topping_ |
varchar2 |
Extra 1 Label | |||
topping_ |
varchar2 |
Extra 2 Label | |||
topping_ |
varchar2 |
Extra 3 Label | |||
topping_ |
varchar2 |
Extra 1 Quantity | |||
topping_ |
varchar2 |
Extra 2 Quantity | |||
topping_ |
varchar2 |
Extra 3 Quantity | |||
tue |
boolean |
Tue | |||
tz |
varchar2 |
Timezone | |||
website_ |
varchar2 |
Website communication history | |||
wed |
boolean |
Wed | |||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
||||
zip_ |
varchar2 |
Zip |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: