Generic Email UML

Added On: 02/13/12

SQL Table: GENERIC_EMAIL

Module: UniCharge

Type: Entity Status: Active

Java Class: GenericEmail

Available Fields:

Attachment Code
Attachment Content Source CL
BCC Email
Cc Email
Email Transaction FK
External Reference Code

File Extention
From Email
Id
Is Plain Message
Merchant Account Code
Message

Message ID
Reply To Email
Response
Retail Transaction Cycle FK
Send Date
Subject

Submission Code
To Email

Attachment Code

Added On: 02/13/12

SQL Column: ATTACHMENT_CODE

Java Field: attachmentCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Code of the attachment to the email (if there is any).

Attachment Content Source CL

Added On: 03/06/12

SQL Column: ATTACHMENT_CONTENT_SOURCE_CL

Java Field: attachmentContentSourceCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Attachment Content Source Classifier

Attributes:

Represents the type of source from where the attachment content can be downloaded.

BCC Email

Added On: 12/21/15

SQL Column: BCC_EMAIL

Java Field: bccEmail

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Cc Email

Added On: 09/26/13

SQL Column: CC_EMAIL

Java Field: ccEmail

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Email Transaction FK

Added On: 02/13/12

SQL Column: EMAIL_TRANSACTION_FK

Java Field: emailTransaction

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Email Transaction

Attributes:

Reference to the entity that represents email information.

External Reference Code

Added On: 02/13/12

SQL Column: EXTERNAL_REFERENCE_CODE

Java Field: externalReferenceCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

File Extention

Added On: 02/13/12

SQL Column: FILE_EXTENTION

Java Field: fileExtention

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Extention of the email attachment.

From Email

Added On: 09/26/13

SQL Column: FROM_EMAIL

Java Field: fromEmail

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Addresser of the email.

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.

Is Plain Message

Added On: 10/10/13

SQL Column: IS_PLAIN_MESSAGE

Java Field: isPlainMessage

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:false

Indicates whether the email is a plain message.

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

Code of Merchant Account to which instance of this object is attributed to. Depending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code.
The field is primarily used for data partitioning and data management, to make it easy to determine the ownership of a record within the database.

Message

Added On: 02/13/12

SQL Column: MESSAGE

Java Field: message

Status: Active

SQL Type: varchar(12288)

Java Type: String

Attributes:

Content message of the email.

Message ID

Added On: 02/13/12

SQL Column: MESSAGE_ID

Java Field: messageId

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Identification number of the message in the system.

Reply To Email

Added On: 11/25/22

SQL Column: REPLY_TO_EMAIL

Java Field: replyToEmail

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Response

Added On: 02/13/12

SQL Column: RESPONSE

Java Field: response

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Retail Transaction Cycle FK

Added On: 02/13/12

SQL Column: RETAIL_TRANSACTION_CYCLE_FK

Java Field: retailTransactionCycle

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Retail Transaction Cycle

Attributes:

Reference to the entity that represents a group of real-time transactions which must be settled together.

Send Date

Added On: 02/13/12

SQL Column: SEND_DATE

Java Field: sendDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the email was sent.

Subject

Added On: 02/13/12

SQL Column: SUBJECT

Java Field: subject

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Subject (main title) of the email.

Submission Code

Added On: 02/13/12

SQL Column: SUBMISSION_CODE

Java Field: submissionCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

To Email

Added On: 02/13/12

SQL Column: TO_EMAIL

Java Field: toEmail

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

The addresser of the email.