Database – Schedule template lines entity (schedule_template_lines_entity)
Holds custom schedule line template information
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
template_id | int(11) | associated template id | ||
term | int(11) | template line term | ||
rate | decimal(11,2) | interest rate | ||
solve_for | varchar(40) | solve for | loan.rollScheduleSolveFor.* | |
solve_using | char(40) | solve using | loan.rollScheduleSolve.* | |
amount | decimal(11,2) | payment amount | ||
balance | decimal(11,2) | balance | ||
percent | decimal(11,2) | percent | ||
advanced_terms | int(11) | advanced terms | ||
force_balloon | tinyint(1) | Whether or not to force balloon | 1 - yes, 0 - no | |
deleted | tinyint(1) | Whether or not the entity was deleted | 1 - yes, 0 - no | |
lastUpdated | timestamp | Timestamp of when the entity was last updated |