mailing: Odoo itgen_odoo_mailing
read only per partition
- Catalogo:
Odoo - Schema:
mailing - Etichetta: itgen_odoo_mailing
Mass Mailing
È possibile solo recuperare i dati.
Riepilogo
MassMailing models a wave of emails for a mass mailign campaign. A mass mailing is an occurence of sending emails.
Colonne della tabella
Di seguito sono riportate le colonne della tabella mailing. 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 |
|---|---|---|---|---|---|
ab_ |
boolean |
A/B Testing Campaign Finished | |||
ab_ |
varchar2 |
A/B Testing Description | |||
ab_ |
boolean |
Allow A/B Testing | If checked, recipients will be mailed only once for the whole campaign.This lets you send different mailings to randomly selected recipients and test the effectiveness of the mailings, without causing duplicate messages. | ||
ab_ |
int32 |
A/B Test Mailings # | |||
ab_ |
int32 |
A/B Testing percentage | Percentage of the contacts that will be mailed.Recipients will be chosen randomly. | ||
ab_ |
datetime |
Send Final On | Date that will be used to know when to determine and send the winner mailing | ||
ab_ |
varchar2 |
SMS Winner Selection | |||
ab_ |
varchar2 |
Winner Selection | Selection to determine the winner mailing that will be sent. | ||
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 |
||||
attachment_ |
varchar2 |
||||
body_ |
varchar2 |
Body | |||
body_ |
varchar2 |
Body converted to be sent by mail | |||
body_ |
varchar2 |
SMS Body | |||
bounced |
int32 |
Bounced | |||
bounced_ |
int32 |
Bounced Ratio | |||
calendar_ |
datetime |
Calendar Date | Date at which the mailing was or will be sent. | ||
campaign_ |
varchar2 |
||||
campaign_ |
varchar2 |
||||
canceled |
int32 |
Canceled | |||
clicked |
int32 |
Clicked | |||
clicks_ |
int32 |
Number of Clicks | |||
color |
int32 |
Color Index | |||
contact_ |
varchar2 |
||||
create_ |
datetime |
Creato il | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
crm_ |
int32 |
Leads/Opportunities Count | |||
delivered |
int32 |
Delivered | |||
display_ |
varchar2 |
Nome visualizzato | |||
email_ |
varchar2 |
Send From | |||
expected |
int32 |
Expected | |||
failed |
int32 |
Failed | |||
favorite |
boolean |
Favorite | |||
favorite_ |
datetime |
Favorite Date | When this mailing was added in the favorites | ||
has_ |
boolean |
Has Message | |||
id |
int32 |
ID | |||
is_ |
boolean |
Is Body Empty | |||
keep_ |
boolean |
Keep Archives | |||
kpi_ |
boolean |
KPI mail required | |||
lang |
varchar2 |
Language | Optional translation language (ISO code) to select when sending out an email.If not set, the english version will be used.This should usually be a placeholder expression that provides the appropriate language, e.g. {{ object.partner_id.lang }}. | ||
mail_ |
boolean |
Mail Server Available | Technical field used to know if the user has activated the outgoing mail server option in the settings | ||
mail_ |
varchar2 |
Use a specific mail server in priority.Otherwise Odoo relies on the first outgoing mail server available (based on their sequencing) as it does for normal mails. | |||
mail_ |
varchar2 |
Use a specific mail server in priority.Otherwise Odoo relies on the first outgoing mail server available (based on their sequencing) as it does for normal mails. | |||
mailing_ |
varchar2 |
Domain | |||
mailing_ |
int32 |
# Favorite Filters | |||
mailing_ |
varchar2 |
Favorite filter domain | |||
mailing_ |
varchar2 |
||||
mailing_ |
varchar2 |
||||
mailing_ |
varchar2 |
||||
mailing_ |
varchar2 |
||||
mailing_ |
varchar2 |
Recipients Model Name | |||
mailing_ |
varchar2 |
Recipients Real Model | |||
mailing_ |
boolean |
Based on Mailing Lists | |||
mailing_ |
varchar2 |
||||
mailing_ |
varchar2 |
Mailing Type | |||
mailing_ |
varchar2 |
Mailing Type Description | |||
marketing_ |
varchar2 |
||||
medium_ |
varchar2 |
UTM Medium: delivery method (email, sms, ...) | |||
medium_ |
varchar2 |
UTM Medium: delivery method (email, sms, ...) | |||
message_ |
int32 |
Numero di allegati | |||
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 |
Numero di azioni | Number of messages which requires an action | ||
message_ |
varchar2 |
||||
my_ |
datetime |
My Activity Deadline | |||
name |
varchar2 |
Name | |||
next_ |
datetime |
Scheduled date | |||
opened |
int32 |
Opened | |||
opened_ |
int32 |
Opened Ratio | |||
preview |
varchar2 |
Preview | Catchy preview sentence that encourages recipients to open this email.In most inboxes, this is displayed next to the subject.Keep it empty if you prefer the first characters of your email content to appear instead. | ||
received_ |
int32 |
Received Ratio | |||
render_ |
varchar2 |
Rendering Model | |||
replied |
int32 |
Replied | |||
replied_ |
int32 |
Replied Ratio | |||
reply_ |
varchar2 |
Rispondi a | Preferred Reply-To Address | ||
reply_ |
varchar2 |
Reply-To Mode | Thread: replies go to target document.Email: replies are routed to a given email. | ||
sale_ |
int32 |
Importo fatturato | |||
sale_ |
int32 |
Quotation Count | |||
schedule_ |
datetime |
Scheduled for | |||
schedule_ |
varchar2 |
Schedule | |||
scheduled |
int32 |
Scheduled | |||
sent |
int32 |
Sent | |||
sent_ |
datetime |
Data di invio | |||
sms_ |
boolean |
Include opt-out link | |||
sms_ |
boolean |
Send Directly | Immediately send the SMS Mailing instead of queuing up.Use at your own risk. | ||
sms_ |
boolean |
Insufficient IAP credits | |||
sms_ |
boolean |
Unregistered IAP account | |||
sms_ |
varchar2 |
Title | For an email, the subject your recipients will see in their inbox.For an SMS, the internal title of the message. | ||
sms_ |
varchar2 |
||||
sms_ |
varchar2 |
||||
source_ |
varchar2 |
||||
source_ |
varchar2 |
||||
state |
varchar2 |
Status | |||
subject |
varchar2 |
Subject | |||
total |
int32 |
Total | |||
use_ |
boolean |
Specific mailing used in marketing campaign | Marketing campaigns use mass mailings with some specific behavior; this field is used to indicate its statistics may be suspicious. | ||
use_ |
boolean |
Use Leads | |||
user_ |
varchar2 |
||||
user_ |
varchar2 |
||||
warning_ |
varchar2 |
Warning Message | Warning message displayed in the mailing form view | ||
website_ |
varchar2 |
Website communication history | |||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: