recurring_charge_entity - Recurring Charge Entity

Holds recurring charge information.

Column

Data Type

Column Info

Value Notes

Other

id

int(11)

The id of the entity

charge_application_type

char(25)

charge application type

loan.pastdue.standard, loan.latefeeapp.payoff

is_enabled

tinyint(1)

whether or not is enabled

1 - yes, 0 - no

apply_in_new_loan

tinyint(1)

Whether or not applies to new loans

1 - yes, 0 - no

title

varchar(100)

The name/title of the entity instance

info

varchar(100)

Extra information about an entity instance

calculation

char(41)

Encoded calculation information

fixed_amount

decimal(11,2)

fixed amount

percentage

decimal(5,2)

percentage

percentage_base

char(36)

percentage base

charge.recurring.percentagebase.apd, charge.recurring.percentagebase.cpb, charge.recurring.percentagebase.npa, charge.recurring.percentagebase.ola

contingency_bracket_id

char(33)

associated contingency bracket

trigger_type

char(35)

recurring charge trigger type

charge.recurring.triggertype.*

loan_type

char(30)

Loan type code for associated loans

loan.type.*

trigger_event

char(42)

Encoded trigger event information

trigger_sub_event

char(52)

trigger sub event

trigger_event_value

char(25)

trigger event value

trigger_event_value_updated

text

trigger_rule

text

trigger rule

Clojure

restriction_rule

text

restriction rule

Clojure

restriction_ui

text

restriction (UI)

interest_bearing

tinyint(1)

Whether or not is interest bearing

1 - yes, 0 - no

past_due_setting

varchar(100)

active

tinyint(1)

Whether or not the entity is active

1 - yes, 0 - no

deleted

tinyint(1)

Whether or not the entity was deleted

1 - yes, 0 - no

created

timestamp

Timestamp of when the entity was created

lastUpdated

timestamp

Timestamp of when the entity was last updated


How did we do?


Powered by HelpDocs (opens in a new tab)