Customer Account UML


Added On:  03/16/12 
SQL Table:  CUSTOMER_ACCOUNT 
Module:  UniBill 
Type:  Entity  Status:  Active 
Java Class:  CustomerAccount 
Added On:  03/16/12
SQL Column:  ACCOUNT_GROUP_CODE_FK
Java Field:  accountGroupCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Account Group Code
Attributes:
Reference to the entity that represents optional group that the account belongs to (for marketing purposes, etc.).
Added On:  03/16/12
SQL Column:  BALANCE
Java Field:  balance
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Current balance of the customer's account.
Added On:  06/05/14
SQL Column:  BASE_OBJECT_CODE
Java Field:  baseObjectCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Code of the customer account that was used as the base object for cloning the current object.
Added On:  03/16/12
SQL Column:  BENEFICIARY_INFO
Java Field:  beneficiaryInfo
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Beneficiary information of the customer.
Added On:  03/16/12
SQL Column:  BUYER_BITH_DATE
Java Field:  buyerBithDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
The bith date of the buyer.
Added On:  03/16/12
SQL Column:  BUYER_CITY
Java Field:  buyerCity
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
City of mailing address of the buyer.
Added On:  03/16/12
SQL Column:  BUYER_CODE
Java Field:  buyerCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Code of the buyer.
Added On:  03/16/12
SQL Column:  BUYER_DRIVER_LICENSE_NUMBER
Java Field:  buyerDriverLicenseNumber
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Number of the buyer's driver license.
Added On:  03/16/12
SQL Column:  BUYER_DRIVER_LICENSE_NUMBER_ENCODED
Java Field:  buyerDriverLicenseNumberEncoded
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes: Encoded
Encoded number of the buyer's driver license.
Added On:  03/16/12
SQL Column:  BUYER_FIRST_NAME
Java Field:  buyerFirstName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
First name of the buyer.
Added On:  03/16/12
SQL Column:  BUYER_LAST_NAME
Java Field:  buyerLastName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Buyer's last name.
Added On:  03/16/12
SQL Column:  BUYER_MIDDLE_NAME
Java Field:  buyerMiddleName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Buyer's middle name.
Added On:  03/16/12
SQL Column:  BUYER_PHONE
Java Field:  buyerPhone
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Phone number of the buyer.
Added On:  03/16/12
SQL Column:  BUYER_SOCIAL_SECURITY
Java Field:  buyerSocialSecurity
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Number of the buyer's social security.
Added On:  03/16/12
SQL Column:  BUYER_SOCIAL_SECURITY_ENCODED
Java Field:  buyerSocialSecurityEncoded
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes: Encoded
Encoded number of buyer's social security.
Added On:  03/16/12
SQL Column:  BUYER_STATE
Java Field:  buyerState
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
State of mailing address of the buyer within the system.
Added On:  03/16/12
SQL Column:  BUYER_STREET1
Java Field:  buyerStreet1
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Street mailing address of the buyer within the system.
Added On:  03/16/12
SQL Column:  BUYER_STREET2
Java Field:  buyerStreet2
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Street mailing address of the buyer within the system.
Added On:  03/16/12
SQL Column:  BUYER_ZIP_CODE
Java Field:  buyerZipCode
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
ZIP or postal code of mailing address of the buyer within the system.
Added On:  03/16/12
SQL Column:  COLLECTIONS_PRIORITY_CL
Java Field:  collectionsPriorityCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Reference to the entity that represents current (or selected) type of priority of the account within the collection process.
Added On:  03/16/12
SQL Column:  COLLECTOR_ACCOUNT_CODE
Java Field:  collectorAccountCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Account code of the collector.
Added On:  03/16/12
SQL Column:  COLLECTOR_CODE
Java Field:  collectorCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Code of the collector in the system.
Added On:  01/25/17
SQL Column:  CONTRACT_DOCUMENT_FK
Java Field:  contractDocument
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  03/16/12
SQL Column:  CREATE_DATE
Java Field:  createDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the record was created.
Added On:  07/29/13
SQL Column:  CREDIT_AGENCY_DISPUTE_CL
Java Field:  creditAgencyDisputeCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Reference to the entity that represents enumeration of possible dispute information types that should be used during credit bureau reporting.
Added On:  03/16/12
SQL Column:  CREDIT_AGENCY_STATUS_CL
Java Field:  creditAgencyStatusCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Reference to the entity that represents enumeration of possible policy for credit bureau reporting for this account.
Added On:  03/16/12
SQL Column:  CUSTOM_DATE1
Java Field:  customDate1
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  03/16/12
SQL Column:  CUSTOM_FIELDS
Java Field:  customFields
Status:  Active
SQL Type:  varchar(1024)
Java Type:  String
Attributes:
Field for any additional information.
Added On:  03/16/12
SQL Column:  CUSTOMER_FK
Java Field:  customer
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Customer
Attributes:
Reference to the entity that represents customer information.
Added On:  03/16/12
SQL Column:  DEFAULT_BILLING_CYCLE_FK
Java Field:  defaultBillingCycle
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Billing Cycle
Attributes:
Reference to the entity that represents default billing cycle information for this customer account.
Added On:  03/16/12
SQL Column:  DEFAULT_CONTRACT_FK
Java Field:  defaultContract
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Contract
Attributes:
Reference to the entity that represents contact for this customer account.
Added On:  03/16/12
SQL Column:  DEFAULT_PAYMENT_OPTION_FK
Java Field:  defaultPaymentOption
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Payment Option
Attributes:
Reference to the entity that represents default payment option to use to collect outstanding invoices that do not have implicit payment option.
Added On:  03/16/12
SQL Column:  DEFAULT_PAYMENT_PLAN_FK
Java Field:  defaultPaymentPlan
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Payment Plan
Attributes:
Reference to the entity that represents a default payment plan.
Added On:  03/16/12
SQL Column:  EXTERNAL_IDENTIFIER
Java Field:  externalIdentifier
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
External identfier of the object.
Added On:  03/16/12
SQL Column:  FIRST_BILLING_DATE
Java Field:  firstBillingDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
The date when the account was billed for the first time.
Added On:  03/16/12
SQL Column:  ID
Java Field:  id
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Identifier / Primary Key
Attributes: Required
Identifier of the object used for references; auto-incremented integer value.
Added On:  03/16/12
SQL Column:  IMPORT_DATE
Java Field:  importDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the record was imported to the system.
Added On:  03/16/12
SQL Column:  IS_ACTIVE
Java Field:  isActive
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:true
Indicates whether the record is active in the system.
Added On:  03/16/12
SQL Column:  IS_COLLECTIONS_FEE_APPLIED
Java Field:  isCollectionsFeeApplied
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether the collections fee applied to customer account.
Added On:  03/16/12
SQL Column:  IS_DELINQUENT
Java Field:  isDelinquent
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether a customer is identified as delinquent.
Added On:  03/16/12
SQL Column:  IS_REINSTATED
Java Field:  isReinstated
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether the account has been reinstated from collections.
Added On:  03/16/12
SQL Column:  IS_TAX1_EXEMPT
Java Field:  isTax1Exempt
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Added On:  03/16/12
SQL Column:  IS_TAX2_EXEMPT
Java Field:  isTax2Exempt
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Added On:  03/16/12
SQL Column:  IS_TAX3_EXEMPT
Java Field:  isTax3Exempt
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Added On:  03/16/12
SQL Column:  IS_TAX4_EXEMPT
Java Field:  isTax4Exempt
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Added On:  03/16/12
SQL Column:  IS_TAX5_EXEMPT
Java Field:  isTax5Exempt
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Added On:  03/16/12
SQL Column:  LAST_ACTION_DATE
Java Field:  lastActionDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
The date when the last action was applied to the account.
Added On:  03/16/12
SQL Column:  LAST_ACTION_FK
Java Field:  lastAction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Action
Attributes:
Reference to the entity that represents last action that was taken on the account.
Added On:  01/25/17
SQL Column:  LAST_CREDIT_AGENCY_TRANSACTION_FK
Java Field:  lastCreditAgencyTransaction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  03/16/12
SQL Column:  LAST_CREDIT_REPORTING_DATE
Java Field:  lastCreditReportingDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date of the last credit reporting.
Added On:  03/16/12
SQL Column:  LAST_DECLINE_DATE
Java Field:  lastDeclineDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date of the last decline.
Added On:  03/16/12
SQL Column:  LAST_PAYMENT_DATE
Java Field:  lastPaymentDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
The date when the last successful payment was collected on the account.
Added On:  03/16/12
SQL Column:  LAST_REINSTATE_DATE
Java Field:  lastReinstateDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date of the last reinstate.
Added On:  03/16/12
SQL Column:  LAST_RETURN_REASON
Java Field:  lastReturnReason
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Response code of the last decline or ACH return received on the account.
Added On:  03/16/12
SQL Column:  LAST_SCHEDULED_PAYMENT_CREATE_DATE
Java Field:  lastScheduledPaymentCreateDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the last scheduled payment was created.
Added On:  03/16/12
SQL Column:  LAST_UPDATE_DATE
Java Field:  lastUpdateDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
The date when the account was updated the last time.
Added On:  03/16/12
SQL Column:  LATE_FEE_BALANCE
Java Field:  lateFeeBalance
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Balance of the late fee of the customer.
Added On:  03/16/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:  03/16/12
SQL Column:  NEEDS_BALANCING
Java Field:  needsBalancing
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether the customer account record needs balancing.
Added On:  03/16/12
SQL Column:  NEXT_BALANCING_DATE
Java Field:  nextBalancingDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date of the next balancing.
Added On:  03/16/12
SQL Column:  NOTES
Java Field:  notes
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Any additional notes or information that can be provided.
Added On:  03/16/12
SQL Column:  OLDEST_INVOICE_DUE_DATE
Java Field:  oldestInvoiceDueDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
The due date of the oldest invoicing.
Added On:  03/16/12
SQL Column:  ORIGINAL_DELINQUENCY_DATE
Java Field:  originalDelinquencyDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date of the original deliquency.
Added On:  09/21/16
SQL Column:  PAYMENT_OPTIONS
Java Field:  paymentOptions
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Payment Option
Attributes:
Reference to the entity that represents enumeration of payment options within the system.
Added On:  03/16/12
SQL Column:  PAYMENT_PLAN_VALUE
Java Field:  paymentPlanValue
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Number of payment plan option.
Added On:  07/29/13
SQL Column:  PREV_CREDIT_AGENCY_DISPUTE_CL
Java Field:  prevCreditAgencyDisputeCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Reference to the entity that represents enumeration of possible credit agency dispute information types.
Added On:  03/16/12
SQL Column:  REF_CODE
Java Field:  refCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Secondary identifier, which can be used to cross-reference records between UniPay and integrated systems.

See Reference Code for additional information.
Added On:  03/23/12
SQL Column:  REF_CODE_REVERSED
Java Field:  refCodeReversed
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Reversed reference code.
Added On:  03/16/12
SQL Column:  RETURN_FEE_BALANCE
Java Field:  returnFeeBalance
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Balance of the late fee of the customer.
Added On:  01/25/17
SQL Column:  SCAN_ID_FK
Java Field:  scanId
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  03/16/12
SQL Column:  SCHEDULED_PAYMENT_VALUE
Java Field:  scheduledPaymentValue
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Value of the sceduled payment.
Added On:  03/16/12
SQL Column:  SENT_COLLECTIONS_BALANCE
Java Field:  sentCollectionsBalance
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The balance that was sent to third party collections.
Added On:  03/16/12
SQL Column:  SENT_COLLECTIONS_DATE
Java Field:  sentCollectionsDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
The date when the account was sent to third party collections.
Added On:  03/16/12
SQL Column:  STATUS
Java Field:  status
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Reference to the entity that represents possible statuses of the customer account.
Added On:  03/16/12
SQL Column:  STATUS_CHANGE_DATE
Java Field:  statusChangeDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the status was changed.
Added On:  03/16/12
SQL Column:  SYNCHRONIZATION_CODE
Java Field:  synchronizationCode
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Code for the customer account synchronization.
Added On:  03/16/12
SQL Column:  WRITE_OFF_BALANCE
Java Field:  writeOffBalance
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Allows to write off the account and associated debt.