Mail Template (Window ID-204)

From iDempiere en

Table of Contents

Window: Mail Template

Description: Maintain Mail Template

Help: Mail templates can contain variables of the user, business partner or a general object. The priority of parsing is User/Contact, Business Partner and then the underlying business object (like Request, Dunning, Workflow object).
So, @Name@ would resolve into the User name (if user is defined defined), then Business Partner name (if business partner is defined) and then the Name of the business object if it has a Name.
For Multi-Lingual systems, the template is translated based on the Business Partner's language selection.

Tab: Mail Template

Description: Maintain Mail Template

Help: A mail template can contain variables, e.g. @Name@. The variables are replaced based on the context. First, the the User is searched to find the variables. Additional objects are used for dunning (business partner, dunning entry), asset delivery (asset) and invoice print (business partner, invoice)

Mail Template - Mail Template - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. R_MailText.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. R_MailText.AD_Org_ID
numeric(10)
Table Direct
Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. R_MailText.Name
character varying(60)
String
Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

R_MailText.IsActive
character(1)
Yes-No
Subject Mail Header (Subject) The subject of the mail message R_MailText.MailHeader
character varying(2000)
String
Mail Text Text used for Mail message The Mail Text indicates the text used for mail messages. R_MailText.MailText
text
Text Long
Mail Text 2 Optional second text part used for Mail message The Mail Text indicates the text used for mail messages. R_MailText.MailText2
character varying(2000)
Text
Mail Text 3 Optional third text part used for Mail message The Mail Text indicates the text used for mail messages. R_MailText.MailText3
character varying(2000)
Text
HTML Text has HTML tags R_MailText.IsHtml
character(1)
Yes-No

Tab: Translation

Description: Translation

Help:

File:Mail Template - Translation - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. R_MailText_Trl.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. R_MailText_Trl.AD_Org_ID
numeric(10)
Table Direct
Mail Template Text templates for mailings The Mail Template indicates the mail template for return messages. Mail text can include variables. The priority of parsing is User/Contact, Business Partner and then the underlying business object (like Request, Dunning, Workflow object).

So, @Name@ would resolve into the User name (if user is defined defined), then Business Partner name (if business partner is defined) and then the Name of the business object if it has a Name.
For Multi-Lingual systems, the template is translated based on the Business Partner's language selection.

R_MailText_Trl.R_MailText_ID
numeric(10)
Table Direct
Language Language for this entity The Language identifies the language to use for display and formatting R_MailText_Trl.AD_Language
character varying(6)
Table
Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. R_MailText_Trl.Name
character varying(60)
String
Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

R_MailText_Trl.IsActive
character(1)
Yes-No
Translated This column is translated The Translated checkbox indicates if this column is translated. R_MailText_Trl.IsTranslated
character(1)
Yes-No
Subject Mail Header (Subject) The subject of the mail message R_MailText_Trl.MailHeader
character varying(2000)
Text
Mail Text Text used for Mail message The Mail Text indicates the text used for mail messages. R_MailText_Trl.MailText
text
Text Long
Mail Text 2 Optional second text part used for Mail message The Mail Text indicates the text used for mail messages. R_MailText_Trl.MailText2
character varying(2000)
Text
Mail Text 3 Optional third text part used for Mail message The Mail Text indicates the text used for mail messages. R_MailText_Trl.MailText3
character varying(2000)
Text

Tab: User Mail

Description: Mail sent to the user

Help:

Mail Template - User Mail - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_UserMail.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_UserMail.AD_Org_ID
numeric(10)
Table Direct
Mail Template Text templates for mailings The Mail Template indicates the mail template for return messages. Mail text can include variables. The priority of parsing is User/Contact, Business Partner and then the underlying business object (like Request, Dunning, Workflow object).

So, @Name@ would resolve into the User name (if user is defined defined), then Business Partner name (if business partner is defined) and then the Name of the business object if it has a Name.
For Multi-Lingual systems, the template is translated based on the Business Partner's language selection.

AD_UserMail.R_MailText_ID
numeric(10)
Table Direct
User/Contact User within the system - Internal or Business Partner Contact The User identifies a unique user in the system. This could be an internal user or a business partner contact AD_UserMail.AD_User_ID
numeric(10)
Search
Message ID EMail Message ID SMTP Message ID for tracking purposes AD_UserMail.MessageID
character varying(120)
String
Delivery Confirmation EMail Delivery confirmation AD_UserMail.DeliveryConfirmation
character varying(120)
String
Delivered AD_UserMail.IsDelivered
character(1)
List


Contributions / Posts

Cookies help us deliver our services. By using our services, you agree to our use of cookies.