Database – Loan Schedule Roll Entity (loan_schedule_roll_entity)
Description
Holds information concerning schedule rolls for a loan.
|
Column |
Data Type |
Column Info |
Value Notes |
Other |
|
id |
int(11) |
The ID of the entity |
||
|
entity_id |
int(11) |
ID of the associated entity |
||
|
entity_type |
varchar(100) |
Type of the associated entity |
||
|
mod_id |
int(11) |
The id of the associated loan modification |
||
|
term |
int(11) |
Schedule Roll term |
||
|
rate |
decimal(13,4) |
Interest rate of the loan |
Default: 0.0000 |
|
|
solve_using |
char(40) |
Solve calculation type used |
loan.rollScheduleSolve.* |
|
|
amount |
decimal(11,2) |
Schedule roll amount |
||
|
percent |
decimal(11,2) |
Schedule roll percentage |
||
|
advanced_terms |
int(11) |
Advanced terms ID |
||
|
solve_for |
char(40) |
solve for |
loan.rollScheduleSolveFor.* |
|
|
balance |
decimal(11,2) |
Schedule Roll balance |
||
|
balance_set |
decimal(11,2) |
Schedule Roll balance set |
||
|
difference |
decimal(11,2) |
Schedule roll difference |
||
|
force_balloon |
tinyint(1) |
Whether or not to force balloon |
1 - yes, 0 - no |
|
|
last_as_final |
tinyint(1) |
Whether or not the last scheduled payment is the final payment |
||
|
basic_revert |
tinyint(1) |
Schedule Roll basic revert |
1 - yes, 0 - no |
|
|
is_curtailment |
tinyint(1) |
Schedule Roll Is Curtailment |
1 - yes, 0 - no |
|
|
display_order |
int(11) |
Sort order used when displaying on the UI |
||
|
deleted |
tinyint(1) |
Whether or not the entity was deleted |
1 - yes, 0 - no |
|
|
lastUpdated |
timestamp |
Timestamp of when the entity was last updated |