Email Transaction UML


Added On:  01/25/17 
SQL Table:  EMAIL_TRANSACTION 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  EmailTransaction 
Added On:  01/25/17
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.
Added On:  01/25/17
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:  01/25/17
SQL Column:  CREATE_DATE
Java Field:  createDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the record was created
Added On:  01/25/17
SQL Column:  TEMPLATE_CODE
Java Field:  templateCode
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  EXTERNAL_REFERENCE_CODE
Java Field:  externalReferenceCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  01/25/17
SQL Column:  FROM_EMAIL
Java Field:  fromEmail
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  CC_EMAIL
Java Field:  ccEmail
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  TO_EMAIL
Java Field:  toEmail
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  SUBJECT
Java Field:  subject
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  MESSAGE
Java Field:  message
Status:  Active
SQL Type:  varchar(8192)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  IS_PLAIN_MESSAGE
Java Field:  isPlainMessage
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Added On:  01/25/17
SQL Column:  ATTACHMENT_CODE
Java Field:  attachmentCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  01/25/17
SQL Column:  ATTACHMENT_CONTENT_SOURCE_CL
Java Field:  attachmentContentSourceCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  FILE_EXTENTION
Java Field:  fileExtention
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  FIRST_NAME
Java Field:  firstName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  LAST_NAME
Java Field:  lastName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  BILLING_STREET1
Java Field:  billingStreet1
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  BILLING_STREET2
Java Field:  billingStreet2
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  BILLING_CITY
Java Field:  billingCity
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  BILLING_STATE
Java Field:  billingState
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  BILLING_ZIP_CODE
Java Field:  billingZipCode
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  BILLING_COUNTRY_CODE
Java Field:  billingCountryCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  SHIPPING_STREET1
Java Field:  shippingStreet1
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  SHIPPING_STREET2
Java Field:  shippingStreet2
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  SHIPPING_CITY
Java Field:  shippingCity
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  SHIPPING_STATE
Java Field:  shippingState
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  SHIPPING_ZIP_CODE
Java Field:  shippingZipCode
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  SHIPPING_COUNTRY_CODE
Java Field:  shippingCountryCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  CUSTOMER_ACCOUNT_CODE
Java Field:  customerAccountCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  CUSTOMER_ACCOUNT_BALANCE
Java Field:  customerAccountBalance
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  01/25/17
SQL Column:  CUSTOMER_ACCOUNT_NOTES
Java Field:  customerAccountNotes
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  MERCHANT_NAME
Java Field:  merchantName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  MERCHANT_ACCOUNT_NAME
Java Field:  merchantAccountName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  TRANSACTION_CODE
Java Field:  transactionCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  TRANSACTION_TYPE
Java Field:  transactionType
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  TRANSACTION_AMOUNT
Java Field:  transactionAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  01/25/17
SQL Column:  TRANSACTION_BALANCE
Java Field:  transactionBalance
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  01/25/17
SQL Column:  TRANSACTION_DATE
Java Field:  transactionDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  01/25/17
SQL Column:  TRANSACTION_DUE_DATE
Java Field:  transactionDueDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  01/25/17
SQL Column:  NOTE
Java Field:  note
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  RESPONSE_CODE
Java Field:  responseCode
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  RETURN_REASON
Java Field:  returnReason
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  RETURN_FEE_AMOUNT
Java Field:  returnFeeAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  01/25/17
SQL Column:  LATE_FEE_AMOUNT
Java Field:  lateFeeAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  01/25/17
SQL Column:  PAYMENT_PLAN_CODE
Java Field:  paymentPlanCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  PAYMENT_PLAN_AMOUNT
Java Field:  paymentPlanAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  01/25/17
SQL Column:  PAYMENT_PLAN_ITEM_DESCRIPTION
Java Field:  paymentPlanItemDescription
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  FIRST_BILLING_DATE
Java Field:  firstBillingDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  01/25/17
SQL Column:  NEXT_BILLING_DATE
Java Field:  nextBillingDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  01/25/17
SQL Column:  PAYMENT_OPTION_HOLDER_NAME
Java Field:  paymentOptionHolderName
Status:  Active
SQL Type:  varchar(160)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  PAYMENT_OPTION_TYPE
Java Field:  paymentOptionType
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  PAYMENT_OPTION_NUMBER
Java Field:  paymentOptionNumber
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  BALANCE_PHASE1
Java Field:  balancePhase1
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  01/25/17
SQL Column:  BALANCE_PHASE2
Java Field:  balancePhase2
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  01/25/17
SQL Column:  BALANCE_PHASE3
Java Field:  balancePhase3
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  01/25/17
SQL Column:  BALANCE_PHASE4
Java Field:  balancePhase4
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  01/25/17
SQL Column:  RESPONSE
Java Field:  response
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  01/25/17
SQL Column:  BCC_EMAIL
Java Field:  bccEmail
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  01/27/17
SQL Column:  RETAIL_TRANSACTION_CYCLE_FK
Java Field:  retailTransactionCycle
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  01/27/17
SQL Column:  TERMINAL_ORDER_FK
Java Field:  terminalOrder
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Terminal Order
Attributes:
Added On:  01/25/17
SQL Column:  MESSAGE
Java Field:  message
Status:  Active
SQL Type:  varchar(12288)
Java Type:  String
Attributes: