Email Address UML

Added On: 06/12/12

SQL Table: EMAIL_ADDRESS

Module: UniBill

Type: Entity Status: Active

Java Class: EmailAddress

Available Fields:

Address Source CL
Bad Reason
Create Date
Customer Account FK
Customer FK
Email
Email CL
Id

Is Bad
Is Collections Email Sent1
Is Collections Email Sent2
Is Collections Email Sent3
Is Collections Email Sent4
Is Collections Email Sent5
Is Notification Email Sent1
Is Notification Email Sent2

Is Notification Email Sent3
Last Invoice Notification Email Sent Date
Last Statement Email Sent Date
Last Update Date
Merchant Account Code
Ref Code
Ref Creator Code
Ref ID

Address Source CL

Added On: 06/12/12

SQL Column: ADDRESS_SOURCE_CL

Java Field: addressSourceCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Address Source Classifier

Attributes:

Represents the way the email address information was obtained.

Bad Reason

Added On: 06/12/12

SQL Column: BAD_REASON

Java Field: badReason

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

The reason why the email address was marked as invalid.

Create Date

Added On: 06/12/12

SQL Column: CREATE_DATE

Java Field: createDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the record was created

Customer Account FK

Added On: 07/08/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 customer account information.

Customer FK

Added On: 06/12/12

SQL Column: CUSTOMER_FK

Java Field: customer

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Customer

Attributes:

Reference to the entity that represents customer information.

Added On: 06/12/12

SQL Column: EMAIL

Java Field: email

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes: Max Length:100

Customer's email address.

Email CL

Added On: 06/12/12

SQL Column: EMAIL_CL

Java Field: emailCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Email Classifier

Attributes:

Represents current (or selected) type of the email address.

Added On: 06/12/12

SQL Column: ID

Java Field: id

Status: Active

SQL Type: bigint(20)

Java Type: Long

Identifier / Primary Key

Attributes: Unique, Required, CreateOnly, ReadOnly

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

Is Bad

Added On: 06/12/12

SQL Column: IS_BAD

Java Field: isBad

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:false

If checked, the email address is invalid.

Is Collections Email Sent1

Added On: 06/12/12

SQL Column: IS_COLLECTIONS_EMAIL_SENT1

Java Field: isCollectionsEmailSent1

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:false

Indicates whether the collections email 1 was sent.

Is Collections Email Sent2

Added On: 06/12/12

SQL Column: IS_COLLECTIONS_EMAIL_SENT2

Java Field: isCollectionsEmailSent2

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:false

Indicates whether the collections email 2 was sent.

Is Collections Email Sent3

Added On: 06/12/12

SQL Column: IS_COLLECTIONS_EMAIL_SENT3

Java Field: isCollectionsEmailSent3

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:false

Indicates whether the collections email 3 was sent.

Is Collections Email Sent4

Added On: 06/12/12

SQL Column: IS_COLLECTIONS_EMAIL_SENT4

Java Field: isCollectionsEmailSent4

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:false

Indicates whether the collections email 4 was sent.

Is Collections Email Sent5

Added On: 06/12/12

SQL Column: IS_COLLECTIONS_EMAIL_SENT5

Java Field: isCollectionsEmailSent5

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:false

Indicates whether the collections email 5 was sent.

Is Notification Email Sent1

Added On: 06/12/12

SQL Column: IS_NOTIFICATION_EMAIL_SENT1

Java Field: isNotificationEmailSent1

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:false

Indicates whether the notification email 1 was sent.

Is Notification Email Sent2

Added On: 06/12/12

SQL Column: IS_NOTIFICATION_EMAIL_SENT2

Java Field: isNotificationEmailSent2

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:false

Indicates whether the notification email 2 was sent.

Is Notification Email Sent3

Added On: 06/12/12

SQL Column: IS_NOTIFICATION_EMAIL_SENT3

Java Field: isNotificationEmailSent3

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:false

Indicates whether the notification email 3 was sent.

Last Invoice Notification Email Sent Date

Added On: 10/02/12

SQL Column: LAST_INVOICE_NOTIFICATION_EMAIL_SENT_DATE

Java Field: lastInvoiceNotificationEmailSentDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the notification email was send the last time.

Last Statement Email Sent Date

Added On: 10/02/12

SQL Column: LAST_STATEMENT_EMAIL_SENT_DATE

Java Field: lastStatementEmailSentDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the statement email was send the last time.

Last Update Date

Added On: 10/02/12

SQL Column: LAST_UPDATE_DATE

Java Field: lastUpdateDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the information was updated the last time.

Merchant Account Code

Added On: 06/12/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.

Ref Code

Added On: 07/10/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.

Ref Creator Code

Added On: 06/12/12

SQL Column: REF_CREATOR_CODE

Java Field: refCreatorCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Ref ID

Added On: 09/16/16

SQL Column:

Java Field: refId

Status: Active

SQL Type:

Java Type: Long

Attributes: Transient