Membership

Added On:  08/15/12 

SQL Table:  MEMBERSHIP 

Module:  UniSell 

Type:  Entity  Status:  Active 

Java Class:  Membership 

Available Fields:

• Allow Freeze
• Avalaible From Date
• Avalaible To Date
• Cancellation Fee
• Code
• Combo Id
• Commission Dollar
• Commission Percent
• Contract CL
• Cust Sets Freeze
• Days Before Cancel
• Discount
• Discount Date End
• Discount Date Start
• Discount Default Percent

• Discount Overide Percent
• Dues Amount
• Expiration Days
• Freeze Fee
• Id
• Initiation Fee
• Is Active
• Is Employee Membership
• Is Open End
• Is Tax1 Applicable
• Is Tax2 Applicable
• Is Tax3 Applicable
• Is Tax4 Applicable
• Is Tax5 Applicable
• Level

• Member Fee At Pos
• Member Fee At Pos After
• Membership Category
• Name
• Pay First Month
• Pay First Month After
• Payment Count
• Prorate At Pos
• Prorate At Pos After
• Redeem Points
• Renewal Dues Amount
• Term
• Type CL
• Unfreeze Prorate At Pos
• Unfreeze Prorate At Pos After

Allow Freeze

Added On:  08/15/12

SQL Column:  ALLOW_FREEZE

Java Field:  allowFreeze

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes:

Avalaible From Date

Added On:  08/15/12

SQL Column:  AVALAIBLE_FROM_DATE

Java Field:  avalaibleFromDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Avalaible To Date

Added On:  08/15/12

SQL Column:  AVALAIBLE_TO_DATE

Java Field:  avalaibleToDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Cancellation Fee

Added On:  08/15/12

SQL Column:  CANCELLATION_FEE

Java Field:  cancellationFee

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Code

Added On:  08/15/12

SQL Column:  CODE

Java Field:  code

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes:

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

Combo Id

Added On:  08/15/12

SQL Column:  COMBO_ID

Java Field:  comboId

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes:

Commission Dollar

Added On:  08/15/12

SQL Column:  COMMISSION_DOLLAR

Java Field:  commissionDollar

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Commission Percent

Added On:  08/15/12

SQL Column:  COMMISSION_PERCENT

Java Field:  commissionPercent

Status:  Active

SQL Type:  float

Java Type:  unknown

Attributes:

Contract CL

Added On:  08/15/12

SQL Column:  CONTRACT_CL

Java Field:  contractCl

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes:

Represents the type of selected contract.

Cust Sets Freeze

Added On:  08/15/12

SQL Column:  CUST_SETS_FREEZE

Java Field:  custSetsFreeze

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes:

Days Before Cancel

Added On:  08/15/12

SQL Column:  DAYS_BEFORE_CANCEL

Java Field:  daysBeforeCancel

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Discount

Added On:  08/15/12

SQL Column:  DISCOUNT

Java Field:  discount

Status:  Active

SQL Type:  float

Java Type:  unknown

Attributes:

Discount Date End

Added On:  08/15/12

SQL Column:  DISCOUNT_DATE_END

Java Field:  discountDateEnd

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Discount Date Start

Added On:  08/15/12

SQL Column:  DISCOUNT_DATE_START

Java Field:  discountDateStart

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Discount Default Percent

Added On:  08/15/12

SQL Column:  DISCOUNT_DEFAULT_PERCENT

Java Field:  discountDefaultPercent

Status:  Active

SQL Type:  float

Java Type:  unknown

Attributes:

Discount Overide Percent

Added On:  08/15/12

SQL Column:  DISCOUNT_OVERIDE_PERCENT

Java Field:  discountOveridePercent

Status:  Active

SQL Type:  float

Java Type:  unknown

Attributes:

Dues Amount

Added On:  08/15/12

SQL Column:  DUES_AMOUNT

Java Field:  duesAmount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Expiration Days

Added On:  08/15/12

SQL Column:  EXPIRATION_DAYS

Java Field:  expirationDays

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Freeze Fee

Added On:  08/15/12

SQL Column:  FREEZE_FEE

Java Field:  freezeFee

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Id

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

Added On:  08/15/12

SQL Column:  INITIATION_FEE

Java Field:  initiationFee

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Is Active

Added On:  08/15/12

SQL Column:  IS_ACTIVE

Java Field:  isActive

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes:

Is Employee Membership

Added On:  08/15/12

SQL Column:  IS_EMPLOYEE_MEMBERSHIP

Java Field:  isEmployeeMembership

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:

Is Tax1 Applicable

Added On:  08/15/12

SQL Column:  IS_TAX1_APPLICABLE

Java Field:  isTax1Applicable

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes:

Is Tax2 Applicable

Added On:  08/15/12

SQL Column:  IS_TAX2_APPLICABLE

Java Field:  isTax2Applicable

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes:

Is Tax3 Applicable

Added On:  08/15/12

SQL Column:  IS_TAX3_APPLICABLE

Java Field:  isTax3Applicable

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes:

Is Tax4 Applicable

Added On:  08/15/12

SQL Column:  IS_TAX4_APPLICABLE

Java Field:  isTax4Applicable

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes:

Is Tax5 Applicable

Added On:  08/15/12

SQL Column:  IS_TAX5_APPLICABLE

Java Field:  isTax5Applicable

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes:

Level

Added On:  08/15/12

SQL Column:  LEVEL

Java Field:  level

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Member Fee At Pos

Added On:  08/15/12

SQL Column:  MEMBER_FEE_AT_POS

Java Field:  memberFeeAtPos

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes:

Member Fee At Pos After

Added On:  08/15/12

SQL Column:  MEMBER_FEE_AT_POS_AFTER

Java Field:  memberFeeAtPosAfter

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes:

Membership Category

Added On:  08/15/12

SQL Column:  MEMBERSHIP_CATEGORY

Java Field:  membershipCategory

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes:

Name

Added On:  08/15/12

SQL Column:  NAME

Java Field:  name

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes:

Pay First Month

Added On:  08/15/12

SQL Column:  PAY_FIRST_MONTH

Java Field:  payFirstMonth

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes:

Pay First Month After

Added On:  08/15/12

SQL Column:  PAY_FIRST_MONTH_AFTER

Java Field:  payFirstMonthAfter

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes:

Payment Count

Added On:  08/15/12

SQL Column:  PAYMENT_COUNT

Java Field:  paymentCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Prorate At Pos

Added On:  08/15/12

SQL Column:  PRORATE_AT_POS

Java Field:  prorateAtPos

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes:

Prorate At Pos After

Added On:  08/15/12

SQL Column:  PRORATE_AT_POS_AFTER

Java Field:  prorateAtPosAfter

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes:

Redeem Points

Added On:  08/15/12

SQL Column:  REDEEM_POINTS

Java Field:  redeemPoints

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

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:

Term

Added On:  08/15/12

SQL Column:  TERM

Java Field:  term

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Type CL

Added On:  08/15/12

SQL Column:  TYPE_CL

Java Field:  typeCl

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes:

Represents the type of membership.

Unfreeze Prorate At Pos

Added On:  08/15/12

SQL Column:  UNFREEZE_PRORATE_AT_POS

Java Field:  unfreezeProrateAtPos

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes:

Unfreeze Prorate At Pos After

Added On:  08/15/12

SQL Column:  UNFREEZE_PRORATE_AT_POS_AFTER

Java Field:  unfreezeProrateAtPosAfter

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes: