Email Template

Added On:  02/13/12 

SQL Table:  EMAIL_TEMPLATE 

Module:  UniCharge 

Type:  Entity  Status:  Active 

Java Class:  EmailTemplate 

Entity that represents email template configuration information.

Available Fields:

• Content Cl
• Id
• Locale Cl

• Medium Cl
• Merchant Account Code
• Notification Code

• Owner Cl
• Subject
• Template Cl

• Template Code
• Template Content

Content Cl

Added On:  12/16/19

SQL Column:  CONTENT_CL

Java Field:  contentCl

Status:  Active

SQL Type:  varchar(4)

Java Type:  Object

References Content Classifier

Attributes:

Content type of the notification.

Id

Added On:  02/13/12

SQL Column:  ID

Java Field:  id

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Identifier / Primary Key

Attributes: Unique, Required

Identifier of the object used for references; auto-incremented integer value.

Locale Cl

Added On:  12/16/19

SQL Column:  LOCALE_CL

Java Field:  localeCl

Status:  Active

SQL Type:  varchar(5)

Java Type:  Object

References Locale Classifier

Attributes:

Locale of the notification. Used to format dates and numbers.

Medium Cl

Added On:  03/10/22

SQL Column:  MEDIUM_CL

Java Field:  mediumCl

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

References Medium Classifier

Attributes:

Merchant Account Code

Added On:  02/13/12

SQL Column:  MERCHANT_ACCOUNT_CODE

Java Field:  merchantAccountCode

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes: Required

Reference to the owner of the email template.

Notification Code

Added On:  12/16/19

SQL Column:  NOTIFICATION_CODE

Java Field:  notificationCode

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

Type of the notification for which this template is defined.

Owner Cl

Added On:  12/16/19

SQL Column:  OWNER_CL

Java Field:  ownerCl

Status:  Active

SQL Type:  varchar(1)

Java Type:  Object

References User Classifier

Attributes:

Type of the owner of the email template.

Subject

Added On:  02/13/12

SQL Column:  SUBJECT

Java Field:  subject

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes:

Subject of the notification.

Template Cl

Added On:  10/16/23

SQL Column:  TEMPLATE_CL

Java Field:  templateCl

Status:  Active

SQL Type:  varchar(1)

Java Type:  Object

References Template Classifier

Attributes:

Type of email template (whether the template is for the customer notification or for the merchant notification).

Template Code

Added On:  02/13/12

SQL Column:  TEMPLATE_CODE

Java Field:  templateCode

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes:

Internal code that identifies the template.

Template Content

Added On:  02/13/12

SQL Column:  TEMPLATE_CONTENT

Java Field:  templateContent

Status:  Active

SQL Type:  varchar(8192)

Java Type:  String

Attributes:

Content of the notification.