Credit Agency Transaction UML

Added On: 02/13/12

SQL Table: CREDIT_AGENCY_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: CreditAgencyTransaction

Available Fields:

Actual Payment Amount
Birth Date
City
Close Date
Current Balance
Customer Account Code
Delete CL
Effective Date
First Name
Id

Is Bankruptcy Filed
Is Corrected
Is Deceased
Last Name
Last Payment Date
Merchant Account Code
Middle Name
Open Date
Original Creditor Name
Original Delinquency Amount

Original Delinquency Date
Phone
Prev Transaction Code
Prev Transaction FK
Social Security Number
State
Street1
Street2
Transaction Code
ZIP Code

Actual Payment Amount

Added On: 02/13/12

SQL Column: ACTUAL_PAYMENT_AMOUNT

Java Field: actualPaymentAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Actual amount of payment.

Birth Date

Added On: 02/13/12

SQL Column: BIRTH_DATE

Java Field: birthDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date of birth of the client.

City

Added On: 02/13/12

SQL Column: CITY

Java Field: city

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

City of the mailing address.

Close Date

Added On: 02/13/12

SQL Column: CLOSE_DATE

Java Field: closeDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

The date when the transaction cycle was closed.

Current Balance

Added On: 02/13/12

SQL Column: CURRENT_BALANCE

Java Field: currentBalance

Status: Active

SQL Type: int(11)

Java Type: Integer

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:

Delete CL

Added On: 02/13/12

SQL Column: DELETE_CL

Java Field: deleteCl

Status: Active

SQL Type: varchar(2)

Java Type: String

References Credit Agency Delete Classifier

Attributes:

Represents the type of reason to delete credit agency account.

Effective Date

Added On: 02/13/12

SQL Column: EFFECTIVE_DATE

Java Field: effectiveDate

Status: Active

SQL Type: datetime

Java Type: Date

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:

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.

Is Bankruptcy Filed

Added On: 02/13/12

SQL Column: IS_BANKRUPTCY_FILED

Java Field: isBankruptcyFiled

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:false

Is Corrected

Added On: 02/13/12

SQL Column: IS_CORRECTED

Java Field: isCorrected

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:false

Is Deceased

Added On: 02/13/12

SQL Column: IS_DECEASED

Java Field: isDeceased

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:false

Last Name

Added On: 02/13/12

SQL Column: LAST_NAME

Java Field: lastName

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Last Payment Date

Added On: 02/13/12

SQL Column: LAST_PAYMENT_DATE

Java Field: lastPaymentDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

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.

Middle Name

Added On: 02/13/12

SQL Column: MIDDLE_NAME

Java Field: middleName

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Open Date

Added On: 02/13/12

SQL Column: OPEN_DATE

Java Field: openDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Original Creditor Name

Added On: 02/13/12

SQL Column: ORIGINAL_CREDITOR_NAME

Java Field: originalCreditorName

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Original Delinquency Amount

Added On: 02/13/12

SQL Column: ORIGINAL_DELINQUENCY_AMOUNT

Java Field: originalDelinquencyAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Original Delinquency Date

Added On: 02/13/12

SQL Column: ORIGINAL_DELINQUENCY_DATE

Java Field: originalDelinquencyDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Phone

Added On: 02/13/12

SQL Column: PHONE

Java Field: phone

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Prev Transaction Code

Added On: 02/13/12

SQL Column: PREV_TRANSACTION_CODE

Java Field: prevTransactionCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Code of the previous transaction processed.

Prev Transaction FK

Added On: 02/13/12

SQL Column: PREV_TRANSACTION_FK

Java Field: prevTransaction

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Credit Agency Transaction

Attributes:

Reference to the entity that represents previous transaction information.

Social Security Number

Added On: 02/13/12

SQL Column: SOCIAL_SECURITY_NUMBER

Java Field: socialSecurityNumber

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

State

Added On: 02/13/12

SQL Column: STATE

Java Field: state

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Street1

Added On: 02/13/12

SQL Column: STREET1

Java Field: street1

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Street2

Added On: 02/13/12

SQL Column: STREET2

Java Field: street2

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Transaction Code

Added On: 02/13/12

SQL Column: TRANSACTION_CODE

Java Field: transactionCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

ZIP Code

Added On: 02/13/12

SQL Column: ZIP_CODE

Java Field: zipCode

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

ZIP code or postal code of the credit agency.