Billing Cycle

Added On: 03/16/12

SQL Table: BILLING_CYCLE

Module: UniBill

Type: Entity Status: Active

Java Class: BillingCycle

Entity that represents settings of the billing cycle.

Available Fields:

Close Sales Period
Create Date
Day

Id
Is Active
Is Auto

Merchant Account Code
Next Billing Date
Prev Billing Date

Reference Code
Time Cycle CL

Close Sales Period

Added On: 03/16/12

SQL Column: CLOSE_SALES_PERIOD

Java Field: closeSalesPeriod

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Period that defines the number of days before the billing when it is not allowed to add any changes to payment plan associated with billing cycle.

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.

Day

Added On: 03/16/12

SQL Column: DAY

Java Field: day

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

The day of a month when billing occurs.

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.

Is Active

Added On: 03/16/12

SQL Column: IS_ACTIVE

Java Field: isActive

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:true

Indicates whether the billing cycle is active within the system.

Is Auto

Added On: 03/16/12

SQL Column: IS_AUTO

Java Field: isAuto

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

Indicates whether the billing cycle repeats automatically.

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.

Next Billing Date

Added On: 03/16/12

SQL Column: NEXT_BILLING_DATE

Java Field: nextBillingDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the next billing will occur.

Prev Billing Date

Added On: 03/16/12

SQL Column: PREV_BILLING_DATE

Java Field: prevBillingDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the previous billing occured.

Reference Code

Added On: 03/16/12

SQL Column: REF_CODE

Java Field: refCode

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Secondary identifier that is used to cross-reference records between UniPay and integrated systems.

See Reference Code definition for additional information.

Time Cycle CL

Added On: 03/16/12

SQL Column: TIME_CYCLE_CL

Java Field: timeCycleCl

Status: Active

SQL Type: varchar(255)

Java Type: String

References Time Cycle Classifier

Attributes:

Enumeration of possible values for periods of the billing cycle repeating.