Added On: 03/16/12
Module: UniBill
Type: Entity
Status: Active
Java Class: Customer
Represents information about the customer.
Added On: 03/16/12
SQL Column: ACCOUNT_CL
Java Field: accountCl
Status: Active
SQL Type: varchar(1)
Java Type: String
Represents the type of payment options (e.g. credit card or bank account) associated with the transaction.
Added On: 03/16/12
SQL Column: ACTIVE_ACCOUNT_COUNT
Java Field: activeAccountCount
Status: Active
SQL Type: int(11)
Java Type: Integer
The number of active accounts of the customer.
Added On: 03/16/12
SQL Column: BIRTH_DATE
Java Field: birthDate
Status: Active
SQL Type: datetime
Java Type: Date
Birth date of the customer.
Added On: 05/11/18
SQL Column: COUNTRY_CODE
Java Field: countryCode
Status: Active
SQL Type: varchar(2)
Java Type: String
Country code of the customer's address.
Added On: 03/16/12
SQL Column: CREATE_DATE
Java Field: createDate
Status: Active
SQL Type: datetime
Java Type: Date
Added On: 07/16/12
SQL Column: DEFAULT_ADDRESS_FK
Java Field: defaultAddress
Status: Active
SQL Type: bigint(20)
Java Type: Long
Reference to the entity that represents customer's mail address.
Added On: 10/02/12
SQL Column: DEFAULT_CELL_PHONE_FK
Java Field: defaultCellPhone
Status: Active
SQL Type: bigint(20)
Java Type: Long
Reference to the entity that represents number of the customer's cell phone.
Added On: 07/16/12
SQL Column: DEFAULT_EMAIL_FK
Java Field: defaultEmail
Status: Active
SQL Type: bigint(20)
Java Type: Long
Reference to the entity that represents customer's email address.
Added On: 07/16/12
SQL Column: DEFAULT_HOME_PHONE_FK
Java Field: defaultHomePhone
Status: Active
SQL Type: bigint(20)
Java Type: Long
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
Reference to the entity that represents number of the customer's work phone.
Added On: 03/16/12
SQL Column: DRIVER_LICENSE_NUMBER
Java Field: driverLicenseNumber
Status: Active
SQL Type: varchar(50)
Java Type: String
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
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
State where driver license was issued.
Added On: 03/16/12
SQL Column: FIRST_NAME
Java Field: firstName
Status: Active
SQL Type: varchar(125)
Java Type: String
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: 06/06/18
SQL Column: HOLDER_NAME
Java Field: holderName
Status: Active
SQL Type: varchar(500)
Java Type: String
Name of a payment card or bank account holder. The value is a concatenation of the firstName and lastName field values separated by a space.
Added On: 03/16/12
SQL Column: ID
Java Field: id
Status: Active
SQL Type: bigint(20)
Java Type: Long
Identifier of the object used for references; auto-incremented integer value.
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_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: 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_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: 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_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_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_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_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: 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.
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_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: LAST_NAME
Java Field: lastName
Status: Active
SQL Type: varchar(125)
Java Type: String
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: LAST_UPDATE_DATE
Java Field: lastUpdateDate
Status: Active
SQL Type: datetime
Java Type: Date
Date when the customer's profile was last updated.
Added On: 03/16/12
SQL Column: MERCHANT_ACCOUNT_CODE
Java Field: merchantAccountCode
Status: Active
SQL Type: int(11)
Java Type: Integer
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: MIDDLE_NAME
Java Field: middleName
Status: Active
SQL Type: varchar(255)
Java Type: String
Middle Name of the customer.
Added On: 05/11/18
SQL Column: ORGANIZATION_NAME
Java Field: organizationName
Status: Active
SQL Type: varchar(255)
Java Type: String
Name of the organization associated with a customer.
Added On: 03/16/12
SQL Column: REF_CODE
Java Field: refCode
Status: Active
SQL Type: varchar(60)
Java Type: String
Secondary identifier, which can be used to cross-reference records between TidyPay and integrated systems.
See
Reference field type for additional information.
Added On: 06/12/12
SQL Column: SKIP_TRACE_MODE_CL
Java Field: skipTraceModeCl
Status: Active
SQL Type: varchar(2)
Java Type: String
Enumeration of possible modes for skip trace operations.
Added On: 03/16/12
SQL Column: SOCIAL_SECURITY
Java Field: socialSecurity
Status: Active
SQL Type: varchar(50)
Java Type: String
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
Number of the customer's social security being encoded for security purposes.
Added On: 03/16/12
SQL Column: SUFFIX
Java Field: suffix
Status: Active
SQL Type: varchar(255)
Java Type: String
Added On: 03/16/12
SQL Column: TITLE
Java Field: title
Status: Active
SQL Type: varchar(255)
Java Type: String