Email UML

Added On: 03/16/12

SQL Table: EMAIL

Module: UniBill

Type: Entity Status: Active

Java Class: Email

Available Fields:

Account Transaction FK
Attachment Code
Balance Phase1
Balance Phase2
Balance Phase3
Balance Phase4
Collector Account Code
Create Date
Creator Code
Customer Account FK
Due Date

Email Address FK
Email Code FK
File Extention
First Name
Id
Is Visible Externally
Last Name
Merchant Account Code
Message
Payment Option FK
Payment Plan FK

Processed Date
Ref ID
Reference Code
Response
Start Phase2 Date
Start Phase3 Date
Start Phase4 Date
Status CL
Subject
Template Code
To Email

Account Transaction FK

Added On: 03/16/12

SQL Column: ACCOUNT_TRANSACTION_FK

Java Field: accountTransaction

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Account Transaction

Attributes:

Reference to the entity that represents account transaction.

Attachment Code

Added On: 03/16/12

SQL Column: ATTACHMENT_CODE

Java Field: attachmentCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Code of the attachment included in the email.

Balance Phase1

Added On: 03/16/12

SQL Column: BALANCE_PHASE1

Java Field: balancePhase1

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Balance state by the end of the period (phase).

Balance Phase2

Added On: 03/16/12

SQL Column: BALANCE_PHASE2

Java Field: balancePhase2

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Balance state by the end of the period (phase).

Balance Phase3

Added On: 03/16/12

SQL Column: BALANCE_PHASE3

Java Field: balancePhase3

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Balance state by the end of the period (phase).

Balance Phase4

Added On: 03/16/12

SQL Column: BALANCE_PHASE4

Java Field: balancePhase4

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Balance state by the end of the period (phase).

Collector Account Code

Added On: 03/16/12

SQL Column: COLLECTOR_ACCOUNT_CODE

Java Field: collectorAccountCode

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Code of the collector's account.

Create Date

Added On: 03/16/12

SQL Column: CREATE_DATE

Java Field: createDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the record was created.

Creator Code

Added On: 03/16/12

SQL Column: CREATOR_CODE

Java Field: creatorCode

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

User who created the email.

Customer Account FK

Added On: 03/16/12

SQL Column: CUSTOMER_ACCOUNT_FK

Java Field: customerAccount

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Customer Account

Attributes:

Reference to the entity that represents a customer’s account.

Due Date

Added On: 03/16/12

SQL Column: DUE_DATE

Java Field: dueDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Due date of the email.

Email Address FK

Added On: 10/02/12

SQL Column: EMAIL_ADDRESS_FK

Java Field: emailAddress

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Email Address

Attributes:

Reference to the entity that represents email address.

Email Code FK

Added On: 03/16/12

SQL Column: EMAIL_CODE_FK

Java Field: emailCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Email Code

Attributes:

Reference to the entity that represents email codes.

File Extention

Added On: 03/16/12

SQL Column: FILE_EXTENTION

Java Field: fileExtention

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

The extension of the file uploaded or attached to the email (e.g: .txt, .doc, .xlsx, etc).

First Name

Added On: 03/16/12

SQL Column: FIRST_NAME

Java Field: firstName

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

The first name of the user.

Added On: 03/16/12

SQL Column: ID

Java Field: id

Status: Active

SQL Type: bigint(20)

Java Type: Long

Identifier / Primary Key

Attributes: Required

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

Is Visible Externally

Added On: 03/16/12

SQL Column: IS_VISIBLE_EXTERNALLY

Java Field: isVisibleExternally

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:true

Indicates whether the email is visible outside of the system.

Last Name

Added On: 03/16/12

SQL Column: LAST_NAME

Java Field: lastName

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

The last name of the user.

Merchant Account Code

Added On: 03/16/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: 03/16/12

SQL Column: MESSAGE

Java Field: message

Status: Active

SQL Type: varchar(8192)

Java Type: String

Attributes:

The actual text message of the email.

Payment Option FK

Added On: 03/16/12

SQL Column: PAYMENT_OPTION_FK

Java Field: paymentOption

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Payment Option

Attributes:

Reference to the entity that represents payment option.

Payment Plan FK

Added On: 03/16/12

SQL Column: PAYMENT_PLAN_FK

Java Field: paymentPlan

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Payment Plan

Attributes:

Reference to the entity that represents a payment plan.

Processed Date

Added On: 03/16/12

SQL Column: PROCESSED_DATE

Java Field: processedDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the email was sent.

Ref ID

Added On: 09/16/16

SQL Column:

Java Field: refId

Status: Active

SQL Type:

Java Type: Long

Attributes: Transient

Reference Code

Added On: 03/16/12

SQL Column: REF_CODE

Java Field: refCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Secondary identifier, which can be used to cross-reference records between UniPay and integrated systems.

See Reference Code for additional information.

Response

Added On: 03/16/12

SQL Column: RESPONSE

Java Field: response

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Response code of the email.

Start Phase2 Date

Added On: 09/16/16

SQL Column:

Java Field: startPhase2Date

Status: Active

SQL Type:

Java Type: Date

Attributes: Transient

Start Phase3 Date

Added On: 09/16/16

SQL Column:

Java Field: startPhase3Date

Status: Active

SQL Type:

Java Type: Date

Attributes: Transient

Start Phase4 Date

Added On: 09/16/16

SQL Column:

Java Field: startPhase4Date

Status: Active

SQL Type:

Java Type: Date

Attributes: Transient

Status CL

Added On: 03/16/12

SQL Column: STATUS_CL

Java Field: statusCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Email Status Classifier

Attributes:

Enumerates the range of values of current email status.

Subject

Added On: 03/16/12

SQL Column: SUBJECT

Java Field: subject

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Subject line of the email.

Template Code

Added On: 03/16/12

SQL Column: TEMPLATE_CODE

Java Field: templateCode

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Code of the template used in email.

To Email

Added On: 03/16/12

SQL Column: TO_EMAIL

Java Field: toEmail

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Email address where email is sent.

All Logos and Trademarks used or mentioned on this page are copyrighted property of their respective owners and are used for display purposes only.