Change Account

Added On: 08/15/12

SQL Table: CHANGE_ACCOUNT

Module: UniSell

Type: Entity Status: Active

Java Class: ChangeAccount

Available Fields:

Birth Date
Bonus Bucks Amount
Cancellation Reason Code
Cell Phone
City
Contract Code
Create Date
Customer Account Code
Drawer Id
Driver License Number
Driver License Number Encoded
Email
Eye Color CL
First Name
Freeze Fee Amount
Freeze Length
Freeze Reason Code
Freeze Start Date
Freeze Start Index
Gender CL
Home Phone

Id
Is Address Changed
Is Billing Email Allowed
Is Cancelled Auto Renewal
Is Email Communication Terms Changed
Is Marketing Call Allowed
Is Marketing Email Allowed
Is Payment Option Changed
Is Personal Changed
Last Name
Last Update Date
Merchant Account Code
Middle Name
Payment CL
Payment Credit Card CL
Payment Option Accessory
Payment Option Accessory Masked
Payment Option Account Number
Payment Option Account Number Masked
Payment Option City
Payment Option Code

Payment Option Holder Name
Payment Option State
Payment Option Street1
Payment Option Street2
Payment Option Token Code
Payment Option Zip Code
Payment Plan Code
Poster Code
Sales Person Code
Sales Person Number1
Service Tax Amount
Service Tax Rate
Skin Type CL
Social Security
Social Security Encoded
State
Status CL
Store Number
Street1
Street2
Work Phone

ZIP Code

Birth Date

Added On: 08/15/12

SQL Column: BIRTH_DATE

Java Field: birthDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date of birth of the customer.

Bonus Bucks Amount

Added On: 09/23/14

SQL Column: BONUS_BUCKS_AMOUNT

Java Field: bonusBucksAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Cancellation Reason Code

Added On: 08/15/12

SQL Column: CANCELLATION_REASON_CODE

Java Field: cancellationReasonCode

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Cell Phone

Added On: 08/15/12

SQL Column: CELL_PHONE

Java Field: cellPhone

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Cell phone used to discuss any processing issues.

City

Added On: 08/15/12

SQL Column: CITY

Java Field: city

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

City of the mailing address.

Contract Code

Added On: 08/15/12

SQL Column: CONTRACT_CODE

Java Field: contractCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Create Date

Added On: 08/15/12

SQL Column: CREATE_DATE

Java Field: createDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the record was created

Customer Account Code

Added On: 08/15/12

SQL Column: CUSTOMER_ACCOUNT_CODE

Java Field: customerAccountCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Drawer Id

Added On: 08/15/12

SQL Column: DRAWER_ID

Java Field: drawerId

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Driver License Number

Added On: 08/15/12

SQL Column: DRIVER_LICENSE_NUMBER

Java Field: driverLicenseNumber

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Driver License Number Encoded

Added On: 08/15/12

SQL Column: DRIVER_LICENSE_NUMBER_ENCODED

Java Field: driverLicenseNumberEncoded

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes: Encoded

Added On: 08/15/12

SQL Column: EMAIL

Java Field: email

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Eye Color CL

Added On: 08/15/12

SQL Column: EYE_COLOR_CL

Java Field: eyeColorCl

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Represents the type of eye colour of the account holder.

First Name

Added On: 08/15/12

SQL Column: FIRST_NAME

Java Field: firstName

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

First name of the client.

Freeze Fee Amount

Added On: 08/15/12

SQL Column: FREEZE_FEE_AMOUNT

Java Field: freezeFeeAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Freeze Length

Added On: 08/15/12

SQL Column: FREEZE_LENGTH

Java Field: freezeLength

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Freeze Reason Code

Added On: 08/15/12

SQL Column: FREEZE_REASON_CODE

Java Field: freezeReasonCode

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Freeze Start Date

Added On: 08/15/12

SQL Column: FREEZE_START_DATE

Java Field: freezeStartDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Freeze Start Index

Added On: 08/15/12

SQL Column: FREEZE_START_INDEX

Java Field: freezeStartIndex

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Gender CL

Added On: 08/15/12

SQL Column: GENDER_CL

Java Field: genderCl

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Represents the gender of the account holder.

Home Phone

Added On: 08/15/12

SQL Column: HOME_PHONE

Java Field: homePhone

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Added On: 08/15/12

SQL Column: ID

Java Field: id

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes: Required

Identifier of the object used for references; auto-incremented integer value.

Is Address Changed

Added On: 08/15/12

SQL Column: IS_ADDRESS_CHANGED

Java Field: isAddressChanged

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

Is Billing Email Allowed

Added On: 08/15/12

SQL Column: IS_BILLING_EMAIL_ALLOWED

Java Field: isBillingEmailAllowed

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

Is Cancelled Auto Renewal

Added On: 08/15/12

SQL Column: IS_CANCELLED_AUTO_RENEWAL

Java Field: isCancelledAutoRenewal

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

Is Email Communication Terms Changed

Added On: 08/15/12

SQL Column: IS_EMAIL_COMMUNICATION_TERMS_CHANGED

Java Field: isEmailCommunicationTermsChanged

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

Is Marketing Call Allowed

Added On: 09/06/13

SQL Column: IS_MARKETING_CALL_ALLOWED

Java Field: isMarketingCallAllowed

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

Indicates whether the marketing call from the institution is allowed of not.

Is Marketing Email Allowed

Added On: 08/15/12

SQL Column: IS_MARKETING_EMAIL_ALLOWED

Java Field: isMarketingEmailAllowed

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

Is Payment Option Changed

Added On: 08/15/12

SQL Column: IS_PAYMENT_OPTION_CHANGED

Java Field: isPaymentOptionChanged

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

Is Personal Changed

Added On: 08/15/12

SQL Column: IS_PERSONAL_CHANGED

Java Field: isPersonalChanged

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

Last Name

Added On: 08/15/12

SQL Column: LAST_NAME

Java Field: lastName

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Last name of the client.

Last Update Date

Added On: 08/15/12

SQL Column: LAST_UPDATE_DATE

Java Field: lastUpdateDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the account was changed the last time.

Merchant Account Code

Added On: 08/15/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.

Middle Name

Added On: 08/15/12

SQL Column: MIDDLE_NAME

Java Field: middleName

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Middle name of the client.

Payment CL

Added On: 08/15/12

SQL Column: PAYMENT_CL

Java Field: paymentCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Payment Classifier

Attributes:

Represents the type of payment for the account.

Payment Credit Card CL

Added On: 08/15/12

SQL Column: PAYMENT_CREDIT_CARD_CL

Java Field: paymentCreditCardCl

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Represents the type of credit card payment.

Payment Option Accessory

Added On: 08/15/12

SQL Column: PAYMENT_OPTION_ACCESSORY

Java Field: paymentOptionAccessory

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Payment Option Accessory Masked

Added On: 08/15/12

SQL Column: PAYMENT_OPTION_ACCESSORY_MASKED

Java Field: paymentOptionAccessoryMasked

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Payment Option Account Number

Added On: 08/15/12

SQL Column: PAYMENT_OPTION_ACCOUNT_NUMBER

Java Field: paymentOptionAccountNumber

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Payment Option Account Number Masked

Added On: 08/15/12

SQL Column: PAYMENT_OPTION_ACCOUNT_NUMBER_MASKED

Java Field: paymentOptionAccountNumberMasked

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Payment Option City

Added On: 08/15/12

SQL Column: PAYMENT_OPTION_CITY

Java Field: paymentOptionCity

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Payment Option Code

Added On: 08/15/12

SQL Column: PAYMENT_OPTION_CODE

Java Field: paymentOptionCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Payment Option Holder Name

Added On: 08/15/12

SQL Column: PAYMENT_OPTION_HOLDER_NAME

Java Field: paymentOptionHolderName

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Payment Option State

Added On: 08/15/12

SQL Column: PAYMENT_OPTION_STATE

Java Field: paymentOptionState

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Payment Option Street1

Added On: 08/15/12

SQL Column: PAYMENT_OPTION_STREET1

Java Field: paymentOptionStreet1

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Payment Option Street2

Added On: 08/15/12

SQL Column: PAYMENT_OPTION_STREET2

Java Field: paymentOptionStreet2

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Payment Option Token Code

Added On: 08/15/12

SQL Column: PAYMENT_OPTION_TOKEN_CODE

Java Field: paymentOptionTokenCode

Status: Active

SQL Type: varchar(26)

Java Type: String

Attributes:

Payment Option Zip Code

Added On: 08/15/12

SQL Column: PAYMENT_OPTION_ZIP_CODE

Java Field: paymentOptionZipCode

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Payment Plan Code

Added On: 08/15/12

SQL Column: PAYMENT_PLAN_CODE

Java Field: paymentPlanCode

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Poster Code

Added On: 08/15/12

SQL Column: POSTER_CODE

Java Field: posterCode

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Sales Person Code

Added On: 08/15/12

SQL Column: SALES_PERSON_CODE

Java Field: salesPersonCode

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Sales Person Number1

Added On: 08/15/12

SQL Column: SALES_PERSON_NUMBER1

Java Field: salesPersonNumber1

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Service Tax Amount

Added On: 08/15/12

SQL Column: SERVICE_TAX_AMOUNT

Java Field: serviceTaxAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Service Tax Rate

Added On: 08/15/12

SQL Column: SERVICE_TAX_RATE

Java Field: serviceTaxRate

Status: Active

SQL Type: float

Java Type: unknown

Attributes:

Skin Type CL

Added On: 08/15/12

SQL Column: SKIN_TYPE_CL

Java Field: skinTypeCl

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Represents the type of skin type of the account's holder.

Social Security

Added On: 08/15/12

SQL Column: SOCIAL_SECURITY

Java Field: socialSecurity

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Social security number.

Social Security Encoded

Added On: 08/15/12

SQL Column: SOCIAL_SECURITY_ENCODED

Java Field: socialSecurityEncoded

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes: Encoded

State

Added On: 08/15/12

SQL Column: STATE

Java Field: state

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Status CL

Added On: 08/15/12

SQL Column: STATUS_CL

Java Field: statusCl

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Represents current status of the account.

Store Number

Added On: 08/15/12

SQL Column: STORE_NUMBER

Java Field: storeNumber

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Street1

Added On: 08/15/12

SQL Column: STREET1

Java Field: street1

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Street2

Added On: 08/15/12

SQL Column: STREET2

Java Field: street2

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Work Phone

Added On: 08/15/12

SQL Column: WORK_PHONE

Java Field: workPhone

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

ZIP Code

Added On: 08/15/12

SQL Column: ZIP_CODE

Java Field: zipCode

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

ZIP or postal code of the mailing address.