Email UML


Added On:  03/16/12 
SQL Table:  EMAIL 
Module:  UniBill 
Type:  Entity  Status:  Active 
Java Class:  Email 
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.
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.
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).
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).
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).
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).
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.
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.
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.
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.
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.
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.
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.
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).
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.
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.
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.
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.
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.
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.
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.
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.
Added On:  09/16/16
SQL Column:  
Java Field:  refId
Status:  Active
SQL Type:  
Java Type:  Long
Attributes: Transient
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.
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.
Added On:  09/16/16
SQL Column:  
Java Field:  startPhase2Date
Status:  Active
SQL Type:  
Java Type:  Date
Attributes: Transient
Added On:  09/16/16
SQL Column:  
Java Field:  startPhase3Date
Status:  Active
SQL Type:  
Java Type:  Date
Attributes: Transient
Added On:  09/16/16
SQL Column:  
Java Field:  startPhase4Date
Status:  Active
SQL Type:  
Java Type:  Date
Attributes: Transient
Added On:  03/16/12
SQL Column:  STATUS_CL
Java Field:  statusCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Enumerates the range of values of current email status.
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.
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.
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.