Billing Credit Agency Transaction UML

Added On: 01/23/17

SQL Table: BILLING_CREDIT_AGENCY_TRANSACTION

Module: UniBill

Type: Entity Status: Active

Java Class: BillingCreditAgencyTransaction

Available Fields:

Actual Payment Amount
Birth Date
City
Close Date
Collector Account Code
Create Date
Credit Agency Dispute CL
Current Balance
Customer Account Code
Customer Account FK
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
Ref Code
Social Security Number
State
Status CL
Street 1
Street 2

ZIP Code

Actual Payment Amount

Added On: 01/23/17

SQL Column: ACTUAL_PAYMENT_AMOUNT

Java Field: actualPaymentAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Birth Date

Added On: 01/23/17

SQL Column: BIRTH_DATE

Java Field: birthDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

City

Added On: 01/23/17

SQL Column: CITY

Java Field: city

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Close Date

Added On: 01/23/17

SQL Column: CLOSE_DATE

Java Field: closeDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Collector Account Code

Added On: 01/23/17

SQL Column: COLLECTOR_ACCOUNT_CODE

Java Field: collectorAccountCode

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Create Date

Added On: 01/23/17

SQL Column: CREATE_DATE

Java Field: createDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the record was created

Credit Agency Dispute CL

Added On: 01/23/17

SQL Column: CREDIT_AGENCY_DISPUTE_CL

Java Field: creditAgencyDisputeCl

Status: Active

SQL Type: varchar(2)

Java Type: String

References Credit Agency Dispute Classifier

Attributes:

Current Balance

Added On: 01/23/17

SQL Column: CURRENT_BALANCE

Java Field: currentBalance

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Customer Account Code

Added On: 01/23/17

SQL Column: CUSTOMER_ACCOUNT_CODE

Java Field: customerAccountCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Customer Account FK

Added On: 01/25/17

SQL Column: CUSTOMER_ACCOUNT_FK

Java Field: customerAccount

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Customer Account

Attributes:

Delete CL

Added On: 01/23/17

SQL Column: DELETE_CL

Java Field: deleteCl

Status: Active

SQL Type: varchar(2)

Java Type: String

References Credit Agency Delete Classifier

Attributes:

Effective Date

Added On: 01/23/17

SQL Column: EFFECTIVE_DATE

Java Field: effectiveDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

First Name

Added On: 01/23/17

SQL Column: FIRST_NAME

Java Field: firstName

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Added On: 01/23/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.

Is Bankruptcy Filed

Added On: 01/23/17

SQL Column: IS_BANKRUPTCY_FILED

Java Field: isBankruptcyFiled

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:true

Is Corrected

Added On: 01/23/17

SQL Column: IS_CORRECTED

Java Field: isCorrected

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:false

Is Deceased

Added On: 01/23/17

SQL Column: IS_DECEASED

Java Field: isDeceased

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:false

Last Name

Added On: 01/23/17

SQL Column: LAST_NAME

Java Field: lastName

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Last Payment Date

Added On: 01/23/17

SQL Column: LAST_PAYMENT_DATE

Java Field: lastPaymentDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Merchant Account Code

Added On: 01/23/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.

Middle Name

Added On: 01/23/17

SQL Column: MIDDLE_NAME

Java Field: middleName

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Open Date

Added On: 01/23/17

SQL Column: OPEN_DATE

Java Field: openDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Original Creditor Name

Added On: 01/23/17

SQL Column: ORIGINAL_CREDITOR_NAME

Java Field: originalCreditorName

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Original Delinquency Amount

Added On: 01/23/17

SQL Column: ORIGINAL_DELINQUENCY_AMOUNT

Java Field: originalDelinquencyAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Original Delinquency Date

Added On: 01/23/17

SQL Column: ORIGINAL_DELINQUENCY_DATE

Java Field: originalDelinquencyDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Phone

Added On: 01/23/17

SQL Column: PHONE

Java Field: phone

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Prev Transaction Code

Added On: 01/23/17

SQL Column: PREV_TRANSACTION_CODE

Java Field: prevTransactionCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Ref Code

Added On: 01/23/17

SQL Column: REF_CODE

Java Field: refCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Social Security Number

Added On: 01/23/17

SQL Column: SOCIAL_SECURITY_NUMBER

Java Field: socialSecurityNumber

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

State

Added On: 01/23/17

SQL Column: STATE

Java Field: state

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Status CL

Added On: 01/23/17

SQL Column: STATUS_CL

Java Field: statusCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Credit Agency Transaction Status Classifier

Attributes:

Street 1

Added On: 01/23/17

SQL Column: STREET1

Java Field: street1

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Street 2

Added On: 01/23/17

SQL Column: STREET2

Java Field: street2

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

ZIP Code

Added On: 01/23/17

SQL Column: ZIP_CODE

Java Field: zipCode

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes: