Payment Plan Statistics UML

Added On: 03/16/12

SQL Table: PAYMENT_PLAN_STATISTICS

Module: UniBill

Type: Entity Status: Active

Java Class: PaymentPlanStatistics

Available Fields:

Cancelled Value
Collections Value
Create Date

Id
Invoice FK
Merchant Account Code

Paid Value
Payment Plan FK
Unbilled Value

Unpaid Value
Upgraded Value

Cancelled Value

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.

Collections Value

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.

Create Date

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

Invoice FK

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.

Merchant Account Code

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.

Paid Value

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.

Payment Plan FK

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.

Unbilled Value

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.

Unpaid Value

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.

Upgraded Value

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.