Contract

Added On: 08/15/12

SQL Table: CONTRACT

Module: UniSell

Type: Entity Status: Active

Java Class: Contract

Available Fields:

Barcode
Billing Date
Birth Date
Buyer Birth Date
Buyer City
Buyer Code
Buyer Driver License Number
Buyer Driver License Number Encoded
Buyer First Name
Buyer Gender CL
Buyer Last Name
Buyer Middle Name
Buyer Phone
Buyer Social Security
Buyer Social Security Encoded
Buyer State
Buyer Street1
Buyer Street2
Buyer Zip Code
Cell Phone
City
Code
Comment
Commission Amount
Contract CL
Contract Document Code
Create Date
Customer Account Code
Discount Code
Drawer Id
Driver License Number
Driver License Number Encoded
Dues Amount
Dues Tax Amount
Effective Date
Email
Expiration Date
Eye Color CL
First Name
Gender CL
Home Phone
Id
Initiation Fee Amount
Initiation Fee Price
Initiation Fee Tax Amount
Is Allow Check Payment
Is Allow Credit Card Payment
Is Billing Email Allowed
Is Cancel Existed Contract

Is Complimentary
Is Disallowed Contact
Is Exempt Biometrics
Is Exempt Product Tax
Is Exempt Service Tax
Is Marketing Email Allowed
Is Open End
Last Name
Last Update Date
Lead Case Fk
Lead Fk
Lead Source Code
Level
May Earn Bonus Buck
Membership FK
Merchant Account Code
Middle Name
Payment Count
Payment Processing Date
Payment1 Amount
Payment1 CL
Payment1 Credit Card CL
Payment1 Response Code
Payment1 Sequence Number
Payment1 Transaction Code
Payment2 Amount
Payment2 CL
Payment2 Credit Card CL
Payment2 Response Code
Payment2 Sequence Number
Payment2 Transaction Code
Poster Code
Primary Payment Option Accessory
Primary Payment Option Accessory Masked
Primary Payment Option Account Number
Primary Payment Option Account Number Masked
Primary Payment Option City
Primary Payment Option CL
Primary Payment Option Code
Primary Payment Option Holder Name
Primary Payment Option State
Primary Payment Option Street1
Primary Payment Option Street2
Primary Payment Option Token Code
Primary Payment Option Zip Code
Prorated Fee
Prorated Fee Tax Amount
Referral1 Case Objective Code
Referral1 Cell Phone

Referral1 Email
Referral1 First Name
Referral1 Last Name
Referral2 Case Objective Code
Referral2 Cell Phone
Referral2 Email
Referral2 First Name
Referral2 Last Name
Referral3 Case Objective Code
Referral3 Cell Phone
Referral3 Email
Referral3 First Name
Referral3 Last Name
Renewal Dues Amount
Renewal Dues Tax Amount
Sales Person Code1
Sales Person Code2
Sales Person Number1
Secondary Payment Option Accessory
Secondary Payment Option Accessory Masked
Secondary Payment Option Account Number
Secondary Payment Option Account Number Masked
Secondary Payment Option City
Secondary Payment Option CL
Secondary Payment Option Code
Secondary Payment Option Holder Name
Secondary Payment Option State
Secondary Payment Option Street1
Secondary Payment Option Street2
Secondary Payment Option Token Code
Secondary Payment Option Zip Code
Service Tax Amount
Service Tax Rate
Skin Type CL
Social Security
Social Security Encoded
State
Status CL
Store Number
Street1
Street2
Tan Tax Amount
Tan Tax Rate
Tax Rate
Term
Use Primary Payment Option
Use Secondary Payment Option
Work Phone
ZIP Code

Barcode

Added On: 08/15/12

SQL Column: BARCODE

Java Field: barcode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Billing Date

Added On: 08/15/12

SQL Column: BILLING_DATE

Java Field: billingDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Birth Date

Added On: 08/15/12

SQL Column: BIRTH_DATE

Java Field: birthDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Birth date of the customer purchasing the contract

Buyer Birth Date

Added On: 08/15/12

SQL Column: BUYER_BIRTH_DATE

Java Field: buyerBirthDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Buyer City

Added On: 08/15/12

SQL Column: BUYER_CITY

Java Field: buyerCity

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Buyer Code

Added On: 08/15/12

SQL Column: BUYER_CODE

Java Field: buyerCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Buyer Driver License Number

Added On: 08/15/12

SQL Column: BUYER_DRIVER_LICENSE_NUMBER

Java Field: buyerDriverLicenseNumber

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Buyer Driver License Number Encoded

Added On: 08/15/12

SQL Column: BUYER_DRIVER_LICENSE_NUMBER_ENCODED

Java Field: buyerDriverLicenseNumberEncoded

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes: Encoded

Buyer First Name

Added On: 08/15/12

SQL Column: BUYER_FIRST_NAME

Java Field: buyerFirstName

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Buyer Gender CL

Added On: 08/15/12

SQL Column: BUYER_GENDER_CL

Java Field: buyerGenderCl

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Represents gender of the customer purchasing the contract.

Buyer Last Name

Added On: 08/15/12

SQL Column: BUYER_LAST_NAME

Java Field: buyerLastName

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Buyer Middle Name

Added On: 08/15/12

SQL Column: BUYER_MIDDLE_NAME

Java Field: buyerMiddleName

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Buyer Phone

Added On: 08/15/12

SQL Column: BUYER_PHONE

Java Field: buyerPhone

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Buyer Social Security

Added On: 08/15/12

SQL Column: BUYER_SOCIAL_SECURITY

Java Field: buyerSocialSecurity

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Buyer Social Security Encoded

Added On: 08/15/12

SQL Column: BUYER_SOCIAL_SECURITY_ENCODED

Java Field: buyerSocialSecurityEncoded

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes: Encoded

Buyer State

Added On: 08/15/12

SQL Column: BUYER_STATE

Java Field: buyerState

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Buyer Street1

Added On: 08/15/12

SQL Column: BUYER_STREET1

Java Field: buyerStreet1

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Buyer Street2

Added On: 08/15/12

SQL Column: BUYER_STREET2

Java Field: buyerStreet2

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Buyer Zip Code

Added On: 08/15/12

SQL Column: BUYER_ZIP_CODE

Java Field: buyerZipCode

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Cell Phone

Added On: 08/15/12

SQL Column: CELL_PHONE

Java Field: cellPhone

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Cell phone of the customer purchasing the contract

City

Added On: 08/15/12

SQL Column: CITY

Java Field: city

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

City of postal address of the customer purchasing the contract

Code

Added On: 08/15/12

SQL Column: CODE

Java Field: code

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

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

Comment

Added On: 08/15/12

SQL Column: COMMENT

Java Field: comment

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Commission Amount

Added On: 08/15/12

SQL Column: COMMISSION_AMOUNT

Java Field: commissionAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Contract CL

Added On: 08/15/12

SQL Column: CONTRACT_CL

Java Field: contractCl

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Represents the type of selected contract.

Contract Document Code

Added On: 08/15/12

SQL Column: CONTRACT_DOCUMENT_CODE

Java Field: contractDocumentCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

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:

Java Type: String

Attributes:

Unique identifier of the customer record associated with this contract.

The customer might exist before the contract is created or it might be created after the contract is finalized.

Discount Code

Added On: 04/12/14

SQL Column: DISCOUNT_CODE

Java Field: discountCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Unique identifier of a discount.

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(255)

Java Type: String

Attributes: Encoded

Dues Amount

Added On: 08/15/12

SQL Column: DUES_AMOUNT

Java Field: duesAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Dues Tax Amount

Added On: 08/15/12

SQL Column: DUES_TAX_AMOUNT

Java Field: duesTaxAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Effective Date

Added On: 08/15/12

SQL Column: EFFECTIVE_DATE

Java Field: effectiveDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Added On: 08/15/12

SQL Column: EMAIL

Java Field: email

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Email of the customer purchasing the contract

Expiration Date

Added On: 08/15/12

SQL Column: EXPIRATION_DATE

Java Field: expirationDate

Status: Active

SQL Type: datetime

Java Type: Date

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 eye colour of the customer purchasing the contract.

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 customer purchasing the contract

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 customer purchasing the contract.

Home Phone

Added On: 08/15/12

SQL Column: HOME_PHONE

Java Field: homePhone

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Home phone of the customer purchasing the contract

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.

Initiation Fee Amount

Added On: 08/15/12

SQL Column: INITIATION_FEE_AMOUNT

Java Field: initiationFeeAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Initiation Fee Price

Added On: 08/15/12

SQL Column: INITIATION_FEE_PRICE

Java Field: initiationFeePrice

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Initiation Fee Tax Amount

Added On: 08/15/12

SQL Column: INITIATION_FEE_TAX_AMOUNT

Java Field: initiationFeeTaxAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Is Allow Check Payment

Added On: 08/15/12

SQL Column: IS_ALLOW_CHECK_PAYMENT

Java Field: isAllowCheckPayment

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

Is Allow Credit Card Payment

Added On: 08/15/12

SQL Column: IS_ALLOW_CREDIT_CARD_PAYMENT

Java Field: isAllowCreditCardPayment

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 Cancel Existed Contract

Added On: 08/15/12

SQL Column: IS_CANCEL_EXISTED_CONTRACT

Java Field: isCancelExistedContract

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

Is Complimentary

Added On: 08/15/12

SQL Column: IS_COMPLIMENTARY

Java Field: isComplimentary

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

Is Disallowed Contact

Added On: 08/15/12

SQL Column: IS_DISALLOWED_CONTACT

Java Field: isDisallowedContact

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

Is Exempt Biometrics

Added On: 08/15/12

SQL Column: IS_EXEMPT_BIOMETRICS

Java Field: isExemptBiometrics

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

Is Exempt Product Tax

Added On: 08/15/12

SQL Column: IS_EXEMPT_PRODUCT_TAX

Java Field: isExemptProductTax

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

Is Exempt Service Tax

Added On: 08/15/12

SQL Column: IS_EXEMPT_SERVICE_TAX

Java Field: isExemptServiceTax

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

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 Open End

Added On: 08/15/12

SQL Column: IS_OPEN_END

Java Field: isOpenEnd

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 customer purchasing the contract

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:

Lead Case Fk

Added On: 11/23/12

SQL Column: LEAD_CASE_FK

Java Field: leadCase

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Lead Case

Attributes:

Lead Fk

Added On: 11/23/12

SQL Column: LEAD_FK

Java Field: lead

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Lead

Attributes:

Lead Source Code

Added On: 08/15/12

SQL Column: LEAD_SOURCE_CODE

Java Field: leadSourceCode

Status: Active

SQL Type: varchar(60)

Java Type: String

References Lead Source Code

Attributes:

Level

Added On: 08/15/12

SQL Column: LEVEL

Java Field: level

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

May Earn Bonus Buck

Added On: 08/15/12

SQL Column: MAY_EARN_BONUS_BUCK

Java Field: mayEarnBonusBuck

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

Membership FK

Added On: 08/15/12

SQL Column: MEMBERSHIP_FK

Java Field: membershipFk

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Membership

Attributes:

Reference to the entity that represents membership information.

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/initial of the customer purchasing the contract

Payment Count

Added On: 08/15/12

SQL Column: PAYMENT_COUNT

Java Field: paymentCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Payment Processing Date

Added On: 08/15/12

SQL Column: PAYMENT_PROCESSING_DATE

Java Field: paymentProcessingDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Payment1 Amount

Added On: 08/15/12

SQL Column: PAYMENT1_AMOUNT

Java Field: payment1Amount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Payment1 CL

Added On: 08/15/12

SQL Column: PAYMENT1_CL

Java Field: payment1Cl

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Payment1 Credit Card CL

Added On: 08/15/12

SQL Column: PAYMENT1_CREDIT_CARD_CL

Java Field: payment1CreditCardCl

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Payment1 Response Code

Added On: 08/15/12

SQL Column: PAYMENT1_RESPONSE_CODE

Java Field: payment1ResponseCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Payment1 Sequence Number

Added On: 08/15/12

SQL Column: PAYMENT1_SEQUENCE_NUMBER

Java Field: payment1SequenceNumber

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Payment1 Transaction Code

Added On: 08/15/12

SQL Column: PAYMENT1_TRANSACTION_CODE

Java Field: payment1TransactionCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Payment2 Amount

Added On: 08/15/12

SQL Column: PAYMENT2_AMOUNT

Java Field: payment2Amount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Payment2 CL

Added On: 08/15/12

SQL Column: PAYMENT2_CL

Java Field: payment2Cl

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Payment2 Credit Card CL

Added On: 08/15/12

SQL Column: PAYMENT2_CREDIT_CARD_CL

Java Field: payment2CreditCardCl

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Payment2 Response Code

Added On: 08/15/12

SQL Column: PAYMENT2_RESPONSE_CODE

Java Field: payment2ResponseCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Payment2 Sequence Number

Added On: 08/15/12

SQL Column: PAYMENT2_SEQUENCE_NUMBER

Java Field: payment2SequenceNumber

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Payment2 Transaction Code

Added On: 08/15/12

SQL Column: PAYMENT2_TRANSACTION_CODE

Java Field: payment2TransactionCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Poster Code

Added On: 08/15/12

SQL Column: POSTER_CODE

Java Field: posterCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Primary Payment Option Accessory

Added On: 08/15/12

SQL Column: PRIMARY_PAYMENT_OPTION_ACCESSORY

Java Field: primaryPaymentOptionAccessory

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Primary Payment Option Accessory Masked

Added On: 08/15/12

SQL Column: PRIMARY_PAYMENT_OPTION_ACCESSORY_MASKED

Java Field: primaryPaymentOptionAccessoryMasked

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Primary Payment Option Account Number

Added On: 08/15/12

SQL Column: PRIMARY_PAYMENT_OPTION_ACCOUNT_NUMBER

Java Field: primaryPaymentOptionAccountNumber

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Primary Payment Option Account Number Masked

Added On: 08/15/12

SQL Column: PRIMARY_PAYMENT_OPTION_ACCOUNT_NUMBER_MASKED

Java Field: primaryPaymentOptionAccountNumberMasked

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Primary Payment Option City

Added On: 08/15/12

SQL Column: PRIMARY_PAYMENT_OPTION_CITY

Java Field: primaryPaymentOptionCity

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Primary Payment Option CL

Added On: 08/15/12

SQL Column: PRIMARY_PAYMENT_OPTION_CL

Java Field: primaryPaymentOptionCl

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Represents the type of primary payment option.

Primary Payment Option Code

Added On: 08/15/12

SQL Column: PRIMARY_PAYMENT_OPTION_CODE

Java Field: primaryPaymentOptionCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Primary Payment Option Holder Name

Added On: 08/15/12

SQL Column: PRIMARY_PAYMENT_OPTION_HOLDER_NAME

Java Field: primaryPaymentOptionHolderName

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Primary Payment Option State

Added On: 08/15/12

SQL Column: PRIMARY_PAYMENT_OPTION_STATE

Java Field: primaryPaymentOptionState

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Primary Payment Option Street1

Added On: 08/15/12

SQL Column: PRIMARY_PAYMENT_OPTION_STREET1

Java Field: primaryPaymentOptionStreet1

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Primary Payment Option Street2

Added On: 08/15/12

SQL Column: PRIMARY_PAYMENT_OPTION_STREET2

Java Field: primaryPaymentOptionStreet2

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Primary Payment Option Token Code

Added On: 08/15/12

SQL Column: PRIMARY_PAYMENT_OPTION_TOKEN_CODE

Java Field: primaryPaymentOptionTokenCode

Status: Active

SQL Type: varchar(26)

Java Type: String

Attributes:

Primary Payment Option Zip Code

Added On: 08/15/12

SQL Column: PRIMARY_PAYMENT_OPTION_ZIP_CODE

Java Field: primaryPaymentOptionZipCode

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Prorated Fee

Added On: 08/15/12

SQL Column: PRORATED_FEE

Java Field: proratedFee

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Prorated Fee Tax Amount

Added On: 08/15/12

SQL Column: PRORATED_FEE_TAX_AMOUNT

Java Field: proratedFeeTaxAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Referral1 Case Objective Code

Added On: 11/23/12

SQL Column: REFERRAL1_CASE_OBJECTIVE_CODE

Java Field: referral1CaseObjectiveCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Referral1 Cell Phone

Added On: 11/23/12

SQL Column: REFERRAL1_CELL_PHONE

Java Field: referral1CellPhone

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Referral1 Email

Added On: 11/23/12

SQL Column: REFERRAL1_EMAIL

Java Field: referral1Email

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Referral1 First Name

Added On: 11/23/12

SQL Column: REFERRAL1_FIRST_NAME

Java Field: referral1FirstName

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Referral1 Last Name

Added On: 11/23/12

SQL Column: REFERRAL1_LAST_NAME

Java Field: referral1LastName

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Referral2 Case Objective Code

Added On: 11/23/12

SQL Column: REFERRAL2_CASE_OBJECTIVE_CODE

Java Field: referral2CaseObjectiveCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Referral2 Cell Phone

Added On: 11/23/12

SQL Column: REFERRAL2_CELL_PHONE

Java Field: referral2CellPhone

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Referral2 Email

Added On: 11/23/12

SQL Column: REFERRAL2_EMAIL

Java Field: referral2Email

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Referral2 First Name

Added On: 11/23/12

SQL Column: REFERRAL2_FIRST_NAME

Java Field: referral2FirstName

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Referral2 Last Name

Added On: 11/23/12

SQL Column: REFERRAL2_LAST_NAME

Java Field: referral2LastName

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Referral3 Case Objective Code

Added On: 11/23/12

SQL Column: REFERRAL3_CASE_OBJECTIVE_CODE

Java Field: referral3CaseObjectiveCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Referral3 Cell Phone

Added On: 11/23/12

SQL Column: REFERRAL3_CELL_PHONE

Java Field: referral3CellPhone

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Referral3 Email

Added On: 11/23/12

SQL Column: REFERRAL3_EMAIL

Java Field: referral3Email

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Referral3 First Name

Added On: 11/23/12

SQL Column: REFERRAL3_FIRST_NAME

Java Field: referral3FirstName

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Referral3 Last Name

Added On: 11/23/12

SQL Column: REFERRAL3_LAST_NAME

Java Field: referral3LastName

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Renewal Dues Amount

Added On: 08/15/12

SQL Column: RENEWAL_DUES_AMOUNT

Java Field: renewalDuesAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Renewal Dues Tax Amount

Added On: 08/15/12

SQL Column: RENEWAL_DUES_TAX_AMOUNT

Java Field: renewalDuesTaxAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Sales Person Code1

Added On: 08/15/12

SQL Column: SALES_PERSON_CODE1

Java Field: salesPersonCode1

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Sales Person Code2

Added On: 08/15/12

SQL Column: SALES_PERSON_CODE2

Java Field: salesPersonCode2

Status: Active

SQL Type: varchar(60)

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(60)

Java Type: String

Attributes:

Secondary Payment Option Accessory

Added On: 08/15/12

SQL Column: SECONDARY_PAYMENT_OPTION_ACCESSORY

Java Field: secondaryPaymentOptionAccessory

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Secondary Payment Option Accessory Masked

Added On: 08/15/12

SQL Column: SECONDARY_PAYMENT_OPTION_ACCESSORY_MASKED

Java Field: secondaryPaymentOptionAccessoryMasked

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Secondary Payment Option Account Number

Added On: 08/15/12

SQL Column: SECONDARY_PAYMENT_OPTION_ACCOUNT_NUMBER

Java Field: secondaryPaymentOptionAccountNumber

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Secondary Payment Option Account Number Masked

Added On: 08/15/12

SQL Column: SECONDARY_PAYMENT_OPTION_ACCOUNT_NUMBER_MASKED

Java Field: secondaryPaymentOptionAccountNumberMasked

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Secondary Payment Option City

Added On: 08/15/12

SQL Column: SECONDARY_PAYMENT_OPTION_CITY

Java Field: secondaryPaymentOptionCity

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Secondary Payment Option CL

Added On: 08/15/12

SQL Column: SECONDARY_PAYMENT_OPTION_CL

Java Field: secondaryPaymentOptionCl

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Represents the type of secondary payment option.

Secondary Payment Option Code

Added On: 08/15/12

SQL Column: SECONDARY_PAYMENT_OPTION_CODE

Java Field: secondaryPaymentOptionCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Secondary Payment Option Holder Name

Added On: 08/15/12

SQL Column: SECONDARY_PAYMENT_OPTION_HOLDER_NAME

Java Field: secondaryPaymentOptionHolderName

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Secondary Payment Option State

Added On: 08/15/12

SQL Column: SECONDARY_PAYMENT_OPTION_STATE

Java Field: secondaryPaymentOptionState

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Secondary Payment Option Street1

Added On: 08/15/12

SQL Column: SECONDARY_PAYMENT_OPTION_STREET1

Java Field: secondaryPaymentOptionStreet1

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Secondary Payment Option Street2

Added On: 08/15/12

SQL Column: SECONDARY_PAYMENT_OPTION_STREET2

Java Field: secondaryPaymentOptionStreet2

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Secondary Payment Option Token Code

Added On: 08/15/12

SQL Column: SECONDARY_PAYMENT_OPTION_TOKEN_CODE

Java Field: secondaryPaymentOptionTokenCode

Status: Active

SQL Type: varchar(26)

Java Type: String

Attributes:

Secondary Payment Option Zip Code

Added On: 08/15/12

SQL Column: SECONDARY_PAYMENT_OPTION_ZIP_CODE

Java Field: secondaryPaymentOptionZipCode

Status: Active

SQL Type: varchar(10)

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 of the customer purchasing the contract.

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 Encoded

Added On: 08/15/12

SQL Column: SOCIAL_SECURITY_ENCODED

Java Field: socialSecurityEncoded

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes: Encoded

State

Added On: 08/15/12

SQL Column: STATE

Java Field: state

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

State of postal address of the customer purchasing the contract

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 contract.

Store Number

Added On: 08/15/12

SQL Column: STORE_NUMBER

Java Field: storeNumber

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Street1

Added On: 08/15/12

SQL Column: STREET1

Java Field: street1

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Street (line 1) of postal address of the customer purchasing the contract

Street2

Added On: 08/15/12

SQL Column: STREET2

Java Field: street2

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Street (line 2) of postal address of the customer purchasing the contract

Tan Tax Amount

Added On: 08/15/12

SQL Column: TAN_TAX_AMOUNT

Java Field: tanTaxAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Tan Tax Rate

Added On: 08/15/12

SQL Column: TAN_TAX_RATE

Java Field: tanTaxRate

Status: Active

SQL Type: float

Java Type: unknown

Attributes:

Tax Rate

Added On: 08/15/12

SQL Column: TAX_RATE

Java Field: taxRate

Status: Active

SQL Type: float

Java Type: unknown

Attributes:

Term

Added On: 08/15/12

SQL Column: TERM

Java Field: term

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Use Primary Payment Option

Added On: 08/15/12

SQL Column: USE_PRIMARY_PAYMENT_OPTION

Java Field: usePrimaryPaymentOption

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

Use Secondary Payment Option

Added On: 08/15/12

SQL Column: USE_SECONDARY_PAYMENT_OPTION

Java Field: useSecondaryPaymentOption

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

Work Phone

Added On: 08/15/12

SQL Column: WORK_PHONE

Java Field: workPhone

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Work phone of the customer purchasing the contract

ZIP Code

Added On: 08/15/12

SQL Column: ZIP_CODE

Java Field: zipCode

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

ZIP code of postal address of the customer purchasing the contract.