Metro To Transaction UML

Added On: 02/13/12

SQL Table: METRO2_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: Metro2Transaction

Available Fields:

Account Information Date
Account Status
Actual Payment Amount
Address1
Address2
Birth Date
City
Close Date
Compliance Condition Code
Consumer Account Number
Consumer Information Indicator

Consumer Transaction Type
Correction Indicator
Credit Agency Transaction FK
Current Balance
Ecoa Code
First Delinquency Date
First Name
Id
Identification Number
Last Payment Date
Merchant Account Code

Middle Name
Open Date
Original Creditor Name
Original Loan Amount
Social Security Number
Special Comment
State
Surname
Telephone Number
Time Stamp
ZIP Code

Account Information Date

Added On: 02/13/12

SQL Column: ACCOUNT_INFORMATION_DATE

Java Field: accountInformationDate

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Account Status

Added On: 02/13/12

SQL Column: ACCOUNT_STATUS

Java Field: accountStatus

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Current status of the account.

Actual Payment Amount

Added On: 02/13/12

SQL Column: ACTUAL_PAYMENT_AMOUNT

Java Field: actualPaymentAmount

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Actual amount of payment.

Address1

Added On: 02/13/12

SQL Column: ADDRESS1

Java Field: address1

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes:

Address2

Added On: 02/13/12

SQL Column: ADDRESS2

Java Field: address2

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes:

Birth Date

Added On: 02/13/12

SQL Column: BIRTH_DATE

Java Field: birthDate

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Date of birth of the client.

City

Added On: 02/13/12

SQL Column: CITY

Java Field: city

Status: Active

SQL Type: varchar(20)

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: varchar(8)

Java Type: String

Attributes:

The date when the transaction cycle was closed.

Compliance Condition Code

Added On: 02/13/12

SQL Column: COMPLIANCE_CONDITION_CODE

Java Field: complianceConditionCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Consumer Account Number

Added On: 02/13/12

SQL Column: CONSUMER_ACCOUNT_NUMBER

Java Field: consumerAccountNumber

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Consumer Information Indicator

Added On: 02/13/12

SQL Column: CONSUMER_INFORMATION_INDICATOR

Java Field: consumerInformationIndicator

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Consumer Transaction Type

Added On: 02/13/12

SQL Column: CONSUMER_TRANSACTION_TYPE

Java Field: consumerTransactionType

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Correction Indicator

Added On: 02/13/12

SQL Column: CORRECTION_INDICATOR

Java Field: correctionIndicator

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Credit Agency Transaction FK

Added On: 02/13/12

SQL Column: CREDIT_AGENCY_TRANSACTION_FK

Java Field: creditAgencyTransaction

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Credit Agency Transaction

Attributes:

Current Balance

Added On: 02/13/12

SQL Column: CURRENT_BALANCE

Java Field: currentBalance

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Ecoa Code

Added On: 02/13/12

SQL Column: ECOA_CODE

Java Field: ecoaCode

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

First Delinquency Date

Added On: 02/13/12

SQL Column: FIRST_DELINQUENCY_DATE

Java Field: firstDelinquencyDate

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

First Name

Added On: 02/13/12

SQL Column: FIRST_NAME

Java Field: firstName

Status: Active

SQL Type: varchar(20)

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.

Identification Number

Added On: 02/13/12

SQL Column: IDENTIFICATION_NUMBER

Java Field: identificationNumber

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Last Payment Date

Added On: 02/13/12

SQL Column: LAST_PAYMENT_DATE

Java Field: lastPaymentDate

Status: Active

SQL Type: varchar(8)

Java Type: String

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(20)

Java Type: String

Attributes:

Open Date

Added On: 02/13/12

SQL Column: OPEN_DATE

Java Field: openDate

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Original Creditor Name

Added On: 02/13/12

SQL Column: ORIGINAL_CREDITOR_NAME

Java Field: originalCreditorName

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Original Loan Amount

Added On: 02/13/12

SQL Column: ORIGINAL_LOAN_AMOUNT

Java Field: originalLoanAmount

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

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:

Special Comment

Added On: 02/13/12

SQL Column: SPECIAL_COMMENT

Java Field: specialComment

Status: Active

SQL Type: varchar(2)

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:

Surname

Added On: 02/13/12

SQL Column: SURNAME

Java Field: surname

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

Telephone Number

Added On: 02/13/12

SQL Column: TELEPHONE_NUMBER

Java Field: telephoneNumber

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Time Stamp

Added On: 02/13/12

SQL Column: TIME_STAMP

Java Field: timeStamp

Status: Active

SQL Type: varchar(14)

Java Type: String

Attributes:

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 of the mailing address.