Dantom Letter UML

Added On: 02/13/12

SQL Table: DANTOM_LETTER

Module: UniCharge

Type: Entity Status: Active

Java Class: DantomLetter

Available Fields:

Amount Over60days Late
Amount0 11days Late
Amount11 30days Late
Amount30 60days Late
Chargeback Total Amount
City
Code
Collections Transaction FK
Custom Field1
Custom Field2
Custom Field3
Custom Field4
Custom Field5
Customer Account Balance
Customer Account Code

External Refence Code
First Billing Date
First Name
Hard Decline Total Amount
Id
Last Name
Late Fee Amount
Letter Code
Letter Statement Content FK
Merchant Account Code
Merchant Account Name
Merchant Name
Next Billing Date
Notice Effective Date
Payment Option Holder Name

Payment Option Number
Payment Option Type
Payment Plan Amount
Return Fee Amount
Return Reason
Scheduled Payment Amount
Soft Decline Total Amount
State
Street1
Street2
Transaction Amount
Transaction Balance
Transaction Date
Transaction Due Date
ZIP Code

Amount Over60days Late

Added On: 02/13/12

SQL Column: AMOUNT_OVER60DAYS_LATE

Java Field: amountOver60daysLate

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Amount0 11days Late

Added On: 02/13/12

SQL Column: AMOUNT0_11DAYS_LATE

Java Field: amount0_11daysLate

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Amount11 30days Late

Added On: 02/13/12

SQL Column: AMOUNT11_30DAYS_LATE

Java Field: amount11_30daysLate

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Amount30 60days Late

Added On: 02/13/12

SQL Column: AMOUNT30_60DAYS_LATE

Java Field: amount30_60daysLate

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Chargeback Total Amount

Added On: 02/13/12

SQL Column: CHARGEBACK_TOTAL_AMOUNT

Java Field: chargebackTotalAmount

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

City

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.

Code

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.

Collections Transaction FK

Added On: 02/13/12

SQL Column: COLLECTIONS_TRANSACTION_FK

Java Field: collectionsTransaction

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Collections Transaction

Attributes:

Reference to the entity that represents collections transaction information.

Custom Field1

Added On: 02/13/12

SQL Column: CUSTOM_FIELD1

Java Field: customField1

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Custom Field2

Added On: 02/13/12

SQL Column: CUSTOM_FIELD2

Java Field: customField2

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Custom Field3

Added On: 02/13/12

SQL Column: CUSTOM_FIELD3

Java Field: customField3

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Custom Field4

Added On: 02/13/12

SQL Column: CUSTOM_FIELD4

Java Field: customField4

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Custom Field5

Added On: 02/13/12

SQL Column: CUSTOM_FIELD5

Java Field: customField5

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Customer Account Balance

Added On: 02/13/12

SQL Column: CUSTOMER_ACCOUNT_BALANCE

Java Field: customerAccountBalance

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Customer Account Code

Added On: 02/13/12

SQL Column: CUSTOMER_ACCOUNT_CODE

Java Field: customerAccountCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

External Refence Code

Added On: 02/13/12

SQL Column: EXTERNAL_REFENCE_CODE

Java Field: externalRefenceCode

Status: Active

SQL Type: varchar(45)

Java Type: String

Attributes:

First Billing Date

Added On: 02/13/12

SQL Column: FIRST_BILLING_DATE

Java Field: firstBillingDate

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

First Name

Added On: 02/13/12

SQL Column: FIRST_NAME

Java Field: firstName

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Hard Decline Total Amount

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: ID

Java Field: id

Status: Active

SQL Type: bigint(20)

Java Type: Long

Identifier / Primary Key

Attributes: Unique, Required

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

Last Name

Added On: 02/13/12

SQL Column: LAST_NAME

Java Field: lastName

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Late Fee Amount

Added On: 02/13/12

SQL Column: LATE_FEE_AMOUNT

Java Field: lateFeeAmount

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Letter Code

Added On: 02/13/12

SQL Column: LETTER_CODE

Java Field: letterCode

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Letter Statement Content FK

Added On: 02/13/12

SQL Column: LETTER_STATEMENT_CONTENT_FK

Java Field: letterStatementContent

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Letter Statement Content

Attributes:

Reference to the entity that represents letter statement content.

Merchant Account Code

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.

Merchant Account Name

Added On: 02/13/12

SQL Column: MERCHANT_ACCOUNT_NAME

Java Field: merchantAccountName

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Merchant Name

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.

Next Billing Date

Added On: 02/13/12

SQL Column: NEXT_BILLING_DATE

Java Field: nextBillingDate

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Notice Effective Date

Added On: 02/13/12

SQL Column: NOTICE_EFFECTIVE_DATE

Java Field: noticeEffectiveDate

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Payment Option Holder Name

Added On: 02/13/12

SQL Column: PAYMENT_OPTION_HOLDER_NAME

Java Field: paymentOptionHolderName

Status: Active

SQL Type: varchar(75)

Java Type: String

Attributes:

Payment Option Number

Added On: 02/13/12

SQL Column: PAYMENT_OPTION_NUMBER

Java Field: paymentOptionNumber

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Payment Option Type

Added On: 02/13/12

SQL Column: PAYMENT_OPTION_TYPE

Java Field: paymentOptionType

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

Payment Plan Amount

Added On: 02/13/12

SQL Column: PAYMENT_PLAN_AMOUNT

Java Field: paymentPlanAmount

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Return Fee Amount

Added On: 02/13/12

SQL Column: RETURN_FEE_AMOUNT

Java Field: returnFeeAmount

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Return Reason

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.

Scheduled Payment Amount

Added On: 02/13/12

SQL Column: SCHEDULED_PAYMENT_AMOUNT

Java Field: scheduledPaymentAmount

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Soft Decline Total Amount

Added On: 02/13/12

SQL Column: SOFT_DECLINE_TOTAL_AMOUNT

Java Field: softDeclineTotalAmount

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

State

Added On: 02/13/12

SQL Column: STATE

Java Field: state

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Street1

Added On: 02/13/12

SQL Column: STREET1

Java Field: street1

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Street2

Added On: 02/13/12

SQL Column: STREET2

Java Field: street2

Status: Active

SQL Type: varchar(40)

Java Type: String

Attributes:

Transaction Amount

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.

Transaction Balance

Added On: 02/13/12

SQL Column: TRANSACTION_BALANCE

Java Field: transactionBalance

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Transaction Date

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.

Transaction Due Date

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.

ZIP Code

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.