order_alert: Odoo itgen_odoo_order_alert
read only per partition
- Catalogo:
Odoo - Schema:
sale - Etichetta: itgen_odoo_order_alert
Sale Order Alert
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella order_alert. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
action |
varchar2 |
Action | |||
action_ |
varchar2 |
||||
action_ |
varchar2 |
||||
active |
boolean |
Active | When unchecked, the rule is hidden and will not be executed. | ||
activity_ |
int32 |
Due Date In | |||
activity_ |
varchar2 |
Due type | |||
activity_ |
varchar2 |
Note | |||
activity_ |
varchar2 |
Summary | |||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
Assign To | |||
activity_ |
varchar2 |
User field name | |||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
Activity User Type | Use 'Specific User' to always assign the same user on the next activity.Use 'Generic User From Record' to specify the field name of the user to choose on the record. | ||
automation_ |
varchar2 |
||||
automation_ |
varchar2 |
||||
binding_ |
varchar2 |
Setting a value makes this action available in the sidebar for the given model. | |||
binding_ |
varchar2 |
Setting a value makes this action available in the sidebar for the given model. | |||
binding_ |
varchar2 |
Binding Type | |||
binding_ |
varchar2 |
Binding View Types | |||
child_ |
varchar2 |
Child server actions that will be executed.Note that the last return returned action value will be used as global return value. | |||
code |
varchar2 |
Python Code | Write Python code that the action will execute.Some variables are available for use; help about python expression is given in the help tab. | ||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
create_ |
datetime |
Creato il | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
cron_ |
datetime |
Cron Nextcall | |||
crud_ |
varchar2 |
Model for record creation / update.Set this field only to specify a different model than the base model. | |||
crud_ |
varchar2 |
Model for record creation / update.Set this field only to specify a different model than the base model. | |||
crud_ |
varchar2 |
Target Model Name | |||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
customer_ |
varchar2 |
||||
display_ |
varchar2 |
Nome visualizzato | |||
fields_ |
varchar2 |
||||
filter_ |
varchar2 |
Applicare su | If present, this condition must be satisfied before executing the action rule. | ||
filter_ |
varchar2 |
Before Update Domain | If present, this condition must be satisfied before the update of the record. | ||
groups_ |
varchar2 |
||||
health |
varchar2 |
Health | Show the health status | ||
help |
varchar2 |
Descrizione dell'azione | Optional help text for the users with a description of the target view, such as its usage and purpose. | ||
id |
int32 |
ID | |||
last_ |
datetime |
Last Run | |||
least_ |
varchar2 |
Least Delay Msg | |||
link_ |
varchar2 |
Provide the field used to link the newly created record on the record used by the server action. | |||
link_ |
varchar2 |
Provide the field used to link the newly created record on the record used by the server action. | |||
mail_ |
boolean |
Subscribe Recipients | |||
mail_ |
varchar2 |
Send as | Choose method for email sending: EMail: send directly emails Post as Message: post on document and notify followers Post as Note: log a note on document | ||
model_ |
varchar2 |
Model on which the server action runs. | |||
model_ |
varchar2 |
Model on which the server action runs. | |||
model_ |
varchar2 |
Nome del modello | |||
mrr_ |
numeric |
MRR Change Amount | |||
mrr_ |
varchar2 |
MRR Change Period | Period over which the KPI is calculated | ||
mrr_ |
varchar2 |
MRR Change Unit | |||
mrr_ |
numeric |
MRR Range Max | |||
mrr_ |
numeric |
MRR Range Min | |||
name |
varchar2 |
Nome dell'azione | |||
on_ |
varchar2 |
Fields that trigger the onchange. | |||
order_ |
varchar2 |
Status | |||
partner_ |
varchar2 |
||||
product_ |
varchar2 |
||||
rating_ |
varchar2 |
Rating Operator | |||
rating_ |
int32 |
Rating Percentage | Rating Satisfaction is the ratio of positive rating to total number of rating. | ||
sequence |
int32 |
Sequence | When dealing with multiple actions, the execution order is based on the sequence.Low number means high priority. | ||
sms_ |
varchar2 |
Send as (SMS) | Choose method for SMS sending: SMS: mass SMS Post as Message: log on document Post as Note: mass SMS with archives | ||
sms_ |
varchar2 |
||||
sms_ |
varchar2 |
||||
stage_ |
varchar2 |
Stage Category | |||
stage_ |
varchar2 |
Trigger on changes of stage.Trigger over all stages if not set | |||
stage_ |
varchar2 |
Trigger on changes of stage.Trigger over all stages if not set | |||
stage_ |
varchar2 |
||||
stage_ |
varchar2 |
||||
stage_ |
varchar2 |
||||
stage_ |
varchar2 |
||||
state |
varchar2 |
Action To Do | Type of server action.The following values are available: - 'Execute Python Code': a block of python code that will be executed - 'Create a new Record': create a new record with new values - 'Update a Record': update the values of a record - 'Execute several actions': define an action that triggers several other server actions - 'Send Email': post a message, a note or send an email (Discuss) - 'Add Followers': add followers to a record (Discuss) - 'Create Next Activity': create an activity (Discuss) - 'Send SMS Text Message': send SMS, log them on documents (SMS) | ||
subscription_ |
int32 |
Subscription Count | |||
subscription_ |
varchar2 |
||||
team_ |
varchar2 |
||||
template_ |
varchar2 |
||||
template_ |
varchar2 |
||||
trg_ |
varchar2 |
When calculating a day-based timed condition, it is possible to use a calendar to compute the date based on working days. | |||
trg_ |
varchar2 |
When calculating a day-based timed condition, it is possible to use a calendar to compute the date based on working days. | |||
trg_ |
varchar2 |
When should the condition be triggered.If present, will be checked by the scheduler.If empty, will be checked at creation and update. | |||
trg_ |
varchar2 |
When should the condition be triggered.If present, will be checked by the scheduler.If empty, will be checked at creation and update. | |||
trg_ |
int32 |
Delay after trigger date | Delay after the trigger date.You can put a negative number if you need a delay before the trigger date, like sending a reminder 15 minutes before a meeting. | ||
trg_ |
varchar2 |
Delay type | |||
trg_ |
varchar2 |
Use the user's working schedule. | |||
trg_ |
varchar2 |
Use the user's working schedule. | |||
trigger |
varchar2 |
Trigger | |||
trigger_ |
varchar2 |
Trigger On | |||
trigger_ |
varchar2 |
The action will be triggered if and only if one of these fields is updated.If empty, all fields are watched. | |||
type |
varchar2 |
Tipo di azione | |||
usage |
varchar2 |
Usage | |||
website_ |
varchar2 |
Website Path | |||
website_ |
boolean |
Available on the Website | A code server action can be executed from the website, using a dedicated controller.The address is /website/action/<website_path>.Set this field as True to allow users to run this action.If it is set to False the action cannot be run through the website. | ||
website_ |
varchar2 |
Website Url | The full URL to access the server action through the website. | ||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
||||
xml_id |
varchar2 |
ID esterno | ID of the action if defined in a XML file |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: