Payment Plan Statistics UML


Added On:  03/16/12 
SQL Table:  PAYMENT_PLAN_STATISTICS 
Module:  UniBill 
Type:  Entity  Status:  Active 
Java Class:  PaymentPlanStatistics 
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:  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:  UNBILLED_VALUE
Java Field:  unbilledValue
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Value of the payment plan without billing.
Added On:  03/16/12
SQL Column:  PAID_VALUE
Java Field:  paidValue
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Paid value of the payment plan.
Added On:  03/16/12
SQL Column:  UNPAID_VALUE
Java Field:  unpaidValue
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Unpaid value of the payment plan.
Added On:  03/16/12
SQL Column:  CANCELLED_VALUE
Java Field:  cancelledValue
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Value of the payment plan cancelled by the customer.
Added On:  03/16/12
SQL Column:  COLLECTIONS_VALUE
Java Field:  collectionsValue
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Value of the payment plan associated with collector.
Added On:  03/16/12
SQL Column:  UPGRADED_VALUE
Java Field:  upgradedValue
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Value of the payment plan upgraded by the customer.
Added On:  03/16/12
SQL Column:  PAYMENT_PLAN_FK
Java Field:  paymentPlan
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Payment Plan
Attributes:
Link to the payment plan.
Added On:  03/16/12
SQL Column:  INVOICE_FK
Java Field:  invoice
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Revenue Transaction
Attributes:
Link to the invoice associated with payment plan.