Customer UML


Added On:  03/16/12 
SQL Table:  CUSTOMER 
Module:  UniBill 
Type:  Entity  Status:  Active 
Java Class:  Customer 
Represents information about the customer.
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:  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/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:  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:  FIRST_NAME
Java Field:  firstName
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
First name of the customer. This field is set for both person and organization types of customers. For organizations, this field is used for the first name of the company's contact person.
Added On:  03/16/12
SQL Column:  LAST_NAME
Java Field:  lastName
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Last name of the customer. This field is set for both person and organization types of customers. For organizations, this field is used for the last name of the company's contact person.
Added On:  03/16/12
SQL Column:  MIDDLE_NAME
Java Field:  middleName
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Middle Name of the customer.
Added On:  03/16/12
SQL Column:  TITLE
Java Field:  title
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Title of the customer.
Added On:  03/16/12
SQL Column:  SUFFIX
Java Field:  suffix
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Suffix of the customer.
Added On:  03/16/12
SQL Column:  ACCOUNT_CL
Java Field:  accountCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
References Customer Classifier
Attributes:
Represents the type of payment options (e.g. credit card or bank account) associated with the transaction.
Added On:  03/16/12
SQL Column:  SOCIAL_SECURITY
Java Field:  socialSecurity
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Number of the customer's social security.
Added On:  03/16/12
SQL Column:  SOCIAL_SECURITY_ENCODED
Java Field:  socialSecurityEncoded
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes: Encoded
Number of the customer's social security being encoded for security purposes.
Added On:  03/16/12
SQL Column:  DRIVER_LICENSE_NUMBER
Java Field:  driverLicenseNumber
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Number of the customer's driver license.
Added On:  03/16/12
SQL Column:  DRIVER_LICENSE_NUMBER_ENCODED
Java Field:  driverLicenseNumberEncoded
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes: Encoded
Number of the customer's driver license being encoded for security purposes.
Added On:  03/16/12
SQL Column:  DRIVER_LICENSE_STATE
Java Field:  driverLicenseState
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
State where driver license was issued.
Added On:  03/16/12
SQL Column:  BIRTH_DATE
Java Field:  birthDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Birth date of the customer.
Added On:  03/16/12
SQL Column:  IS_DECEASED
Java Field:  isDeceased
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default: false
Indicates whether the customer has been deceased.
Added On:  03/16/12
SQL Column:  IS_MAIL_DISALLOWED
Java Field:  isMailDisallowed
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default: false
Indicates whether the mail service is disallowed.
Added On:  03/16/12
SQL Column:  IS_EMAIL_DISALLOWED
Java Field:  isEmailDisallowed
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default: false
Indicates whether the email service is disallowed.
Added On:  03/16/12
SQL Column:  IS_CALLING_DISALLOWED
Java Field:  isCallingDisallowed
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default: false
Indicates whether incoming calls are disallowed.
Added On:  03/16/12
SQL Column:  IS_CHARGEBACK_REQUESTED
Java Field:  isChargebackRequested
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default: false
The customer has requested the chargeback.
Added On:  03/16/12
SQL Column:  IS_BANKRUPTCY_FILED
Java Field:  isBankruptcyFiled
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default: false
The customer is bankrupt.
Added On:  03/16/12
SQL Column:  IS_LEGAL_DISPUTE
Java Field:  isLegalDispute
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default: false
The customer is having a legal dispute with the merchant.
Added On:  03/16/12
SQL Column:  IS_CANCELLATION_DISPUTE
Java Field:  isCancellationDispute
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default: false
The customer is having a cancellation dispute with the merchant.
Added On:  03/16/12
SQL Column:  ACTIVE_ACCOUNT_COUNT
Java Field:  activeAccountCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The number of active accounts of the customer.
Added On:  03/16/12
SQL Column:  LAST_UPDATE_DATE
Java Field:  lastUpdateDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the customer's profile was last updated.
Added On:  03/16/12
SQL Column:  IS_SKIP_TRACE_REQUIRED
Java Field:  isSkipTraceRequired
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default: false
Flag indicating whether skip trace is required for this account.
Added On:  03/16/12
SQL Column:  IS_MARKETING_EMAIL_ALLOWED
Java Field:  isMarketingEmailAllowed
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default: false
Flag indicating whether customer can be contacted with marketing offers over the email.
Added On:  03/16/12
SQL Column:  IS_BILLING_EMAIL_ALLOWED
Java Field:  isBillingEmailAllowed
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default: false
Flag indicating whether customer can be contacted with billing issues over the email.
Added On:  06/12/12
SQL Column:  SKIP_TRACE_MODE_CL
Java Field:  skipTraceModeCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Enumeration of possible modes for skip trace operations.
Added On:  07/16/12
SQL Column:  DEFAULT_ADDRESS_FK
Java Field:  defaultAddress
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Address
Attributes:
Reference to the entity that represents customer's mail address.
Added On:  07/16/12
SQL Column:  DEFAULT_HOME_PHONE_FK
Java Field:  defaultHomePhone
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Phone
Attributes:
Reference to the entity that represents number of the customer's home phone.
Added On:  07/16/12
SQL Column:  DEFAULT_WORK_PHONE_FK
Java Field:  defaultWorkPhone
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Phone
Attributes:
Reference to the entity that represents number of the customer's work phone.
Added On:  07/16/12
SQL Column:  DEFAULT_EMAIL_FK
Java Field:  defaultEmail
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Email Address
Attributes:
Reference to the entity that represents customer's email address.
Added On:  10/02/12
SQL Column:  DEFAULT_CELL_PHONE_FK
Java Field:  defaultCellPhone
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Phone
Attributes:
Reference to the entity that represents number of the customer's cell phone.
Added On:  09/06/13
SQL Column:  IS_MARKETING_CALL_ALLOWED
Java Field:  isMarketingCallAllowed
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default: false
Flag indicating whether customer can be contacted with marketing offers over the phone.