Billing Credit Agency Transaction UML


Added On:  01/23/17 
Module:  UniBill 
Type:  Entity  Status:  Active 
Java Class:  BillingCreditAgencyTransaction 
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.
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.
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
Added On:  01/23/17
SQL Column:  COLLECTOR_ACCOUNT_CODE
Java Field:  collectorAccountCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  01/23/17
SQL Column:  STATUS_CL
Java Field:  statusCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  01/23/17
SQL Column:  EFFECTIVE_DATE
Java Field:  effectiveDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  01/23/17
SQL Column:  CUSTOMER_ACCOUNT_CODE
Java Field:  customerAccountCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
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:  LAST_NAME
Java Field:  lastName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Added On:  01/23/17
SQL Column:  MIDDLE_NAME
Java Field:  middleName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Added On:  01/23/17
SQL Column:  STREET1
Java Field:  street1
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Added On:  01/23/17
SQL Column:  STREET2
Java Field:  street2
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Added On:  01/23/17
SQL Column:  CITY
Java Field:  city
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  01/23/17
SQL Column:  STATE
Java Field:  state
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  01/23/17
SQL Column:  ZIP_CODE
Java Field:  zipCode
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  01/23/17
SQL Column:  SOCIAL_SECURITY_NUMBER
Java Field:  socialSecurityNumber
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  01/23/17
SQL Column:  BIRTH_DATE
Java Field:  birthDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  01/23/17
SQL Column:  PHONE
Java Field:  phone
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  01/23/17
SQL Column:  OPEN_DATE
Java Field:  openDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  01/23/17
SQL Column:  CLOSE_DATE
Java Field:  closeDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  01/23/17
SQL Column:  ORIGINAL_DELINQUENCY_AMOUNT
Java Field:  originalDelinquencyAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  01/23/17
SQL Column:  ORIGINAL_DELINQUENCY_DATE
Java Field:  originalDelinquencyDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  01/23/17
SQL Column:  CURRENT_BALANCE
Java Field:  currentBalance
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  01/23/17
SQL Column:  ACTUAL_PAYMENT_AMOUNT
Java Field:  actualPaymentAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  01/23/17
SQL Column:  LAST_PAYMENT_DATE
Java Field:  lastPaymentDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
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
Added On:  01/23/17
SQL Column:  ORIGINAL_CREDITOR_NAME
Java Field:  originalCreditorName
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  01/23/17
SQL Column:  IS_DECEASED
Java Field:  isDeceased
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default: false
Added On:  01/23/17
SQL Column:  IS_CORRECTED
Java Field:  isCorrected
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default: false
Added On:  01/23/17
SQL Column:  CREDIT_AGENCY_DISPUTE_CL
Java Field:  creditAgencyDisputeCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  01/23/17
SQL Column:  DELETE_CL
Java Field:  deleteCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  01/23/17
SQL Column:  PREV_TRANSACTION_CODE
Java Field:  prevTransactionCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  01/23/17
SQL Column:  REF_CODE
Java Field:  refCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
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: