Dantom Letter UML


Added On:  02/13/12 
SQL Table:  DANTOM_LETTER 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  DantomLetter 
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, CreateOnly
Identifier of the object used for references; auto-incremented integer value.
Added On:  02/13/12
SQL Column:  CODE
Java Field:  code
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Identifier of the object used for references; auto-incremented integer value.
Added On:  02/13/12
SQL Column:  LETTER_CODE
Java Field:  letterCode
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  EXTERNAL_REFENCE_CODE
Java Field:  externalRefenceCode
Status:  Active
SQL Type:  varchar(45)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  FIRST_NAME
Java Field:  firstName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  LAST_NAME
Java Field:  lastName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  STREET1
Java Field:  street1
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  STREET2
Java Field:  street2
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  CITY
Java Field:  city
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
City of the mailing address.
Added On:  02/13/12
SQL Column:  STATE
Java Field:  state
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  ZIP_CODE
Java Field:  zipCode
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
ZIP or postal code.
Added On:  02/13/12
SQL Column:  CUSTOMER_ACCOUNT_CODE
Java Field:  customerAccountCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  CUSTOMER_ACCOUNT_BALANCE
Java Field:  customerAccountBalance
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  NOTICE_EFFECTIVE_DATE
Java Field:  noticeEffectiveDate
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  RETURN_REASON
Java Field:  returnReason
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Reason for the returning.
Added On:  02/13/12
SQL Column:  MERCHANT_NAME
Java Field:  merchantName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Name of the Merchant.
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.
Added On:  02/13/12
SQL Column:  MERCHANT_ACCOUNT_NAME
Java Field:  merchantAccountName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  TRANSACTION_AMOUNT
Java Field:  transactionAmount
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
The amount of the transaction.
Added On:  02/13/12
SQL Column:  TRANSACTION_BALANCE
Java Field:  transactionBalance
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  TRANSACTION_DATE
Java Field:  transactionDate
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Date when the transaction was made.
Added On:  02/13/12
SQL Column:  TRANSACTION_DUE_DATE
Java Field:  transactionDueDate
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Time within which payment for the transaction must be made.
Added On:  02/13/12
SQL Column:  RETURN_FEE_AMOUNT
Java Field:  returnFeeAmount
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  LATE_FEE_AMOUNT
Java Field:  lateFeeAmount
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  SOFT_DECLINE_TOTAL_AMOUNT
Java Field:  softDeclineTotalAmount
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  HARD_DECLINE_TOTAL_AMOUNT
Java Field:  hardDeclineTotalAmount
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  CHARGEBACK_TOTAL_AMOUNT
Java Field:  chargebackTotalAmount
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  SCHEDULED_PAYMENT_AMOUNT
Java Field:  scheduledPaymentAmount
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  AMOUNT0_11DAYS_LATE
Java Field:  amount0_11daysLate
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  AMOUNT11_30DAYS_LATE
Java Field:  amount11_30daysLate
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  AMOUNT30_60DAYS_LATE
Java Field:  amount30_60daysLate
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  AMOUNT_OVER60DAYS_LATE
Java Field:  amountOver60daysLate
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  PAYMENT_OPTION_HOLDER_NAME
Java Field:  paymentOptionHolderName
Status:  Active
SQL Type:  varchar(75)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  PAYMENT_OPTION_TYPE
Java Field:  paymentOptionType
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  PAYMENT_OPTION_NUMBER
Java Field:  paymentOptionNumber
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  PAYMENT_PLAN_AMOUNT
Java Field:  paymentPlanAmount
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  FIRST_BILLING_DATE
Java Field:  firstBillingDate
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  NEXT_BILLING_DATE
Java Field:  nextBillingDate
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  CUSTOM_FIELD1
Java Field:  customField1
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  CUSTOM_FIELD2
Java Field:  customField2
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  CUSTOM_FIELD3
Java Field:  customField3
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  CUSTOM_FIELD4
Java Field:  customField4
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  CUSTOM_FIELD5
Java Field:  customField5
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  COLLECTIONS_TRANSACTION_FK
Java Field:  collectionsTransaction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents collections transaction information.
Added On:  02/13/12
SQL Column:  LETTER_STATEMENT_CONTENT_FK
Java Field:  letterStatementContent
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents letter statement content.