Metro To Transaction UML


Added On:  02/13/12 
SQL Table:  METRO2_TRANSACTION 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  Metro2Transaction 
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:  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:  TIME_STAMP
Java Field:  timeStamp
Status:  Active
SQL Type:  varchar(14)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  CORRECTION_INDICATOR
Java Field:  correctionIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  IDENTIFICATION_NUMBER
Java Field:  identificationNumber
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  CONSUMER_ACCOUNT_NUMBER
Java Field:  consumerAccountNumber
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  OPEN_DATE
Java Field:  openDate
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  ORIGINAL_LOAN_AMOUNT
Java Field:  originalLoanAmount
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
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.
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.
Added On:  02/13/12
SQL Column:  SPECIAL_COMMENT
Java Field:  specialComment
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  COMPLIANCE_CONDITION_CODE
Java Field:  complianceConditionCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  CURRENT_BALANCE
Java Field:  currentBalance
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  ACCOUNT_INFORMATION_DATE
Java Field:  accountInformationDate
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  FIRST_DELINQUENCY_DATE
Java Field:  firstDelinquencyDate
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
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.
Added On:  02/13/12
SQL Column:  LAST_PAYMENT_DATE
Java Field:  lastPaymentDate
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  CONSUMER_TRANSACTION_TYPE
Java Field:  consumerTransactionType
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  SURNAME
Java Field:  surname
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
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:  MIDDLE_NAME
Java Field:  middleName
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  SOCIAL_SECURITY_NUMBER
Java Field:  socialSecurityNumber
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
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.
Added On:  02/13/12
SQL Column:  TELEPHONE_NUMBER
Java Field:  telephoneNumber
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  ECOA_CODE
Java Field:  ecoaCode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  CONSUMER_INFORMATION_INDICATOR
Java Field:  consumerInformationIndicator
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  ADDRESS1
Java Field:  address1
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  ADDRESS2
Java Field:  address2
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
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.
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 of the mailing address.
Added On:  02/13/12
SQL Column:  ORIGINAL_CREDITOR_NAME
Java Field:  originalCreditorName
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  CREDIT_AGENCY_TRANSACTION_FK
Java Field:  creditAgencyTransaction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes: