Database – Pre Configured Loan Entity (preconfigured_loan_entity)
Holds core settings and calculation numbers to use when creating a loan from a preconfigured-loan template.
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
settings_id | int(11) | associated settings id | ||
title | varchar(255) | The name/title of the entity instance | ||
icon | char(40) | icon | ||
loan_amount | decimal(11,2) | loan amount | ||
discount | decimal(11,2) | discount | ||
underwriting | decimal(11,2) | Underwriting fee | ||
money_factor | char(20) | This is the money factor as entered by the user. Money factor is calculated as Interest Rate/2400. Money factor is used to calculate the rental or lease fee in a lease. | ||
residual | decimal(11,2) | Residual amount is the amount that leased property will be worth at the end of the lease term. | ||
loan_rate | decimal(11,4) | loan rate | ||
loan_term | decimal(11,4) | loan term | ||
contract_date | int(11) | contract date | ||
first_payment_date | int(11) | first payment date | ||
amount_down | decimal(11,2) | amount down | ||
reserve | decimal(11,2) | reserve amount | ||
sales_price | decimal(11,2) | sales price | ||
gap | decimal(11,2) | gap | ||
warranty | decimal(11,2) | warranty | ||
dealer_profit | decimal(11,2) | dealer profit | ||
credit_limit | decimal(11,2) | credit limit | ||
reporting_credit_limit | decimal(11,2) | reporting credit limit | ||
flooring_customer | int(11) | flooring customer | ||
loan_class | char(30) | The classification for the loan | loan.class.* | |
loan_type | char(30) | Loan type code for associated loans | loan.type.* | |
grace_days | int(11) | grace days (late feE) | ||
late_fee_type | char(30) | late fee type | loan.lateFee.* | |
late_fee_amount | decimal(11,2) | late fee amount | ||
late_fee_percent | decimal(11,2) | late fee percent | ||
late_fee_calc | char(30) | late fee calculation | loan.lageFeeCalc.* | |
card_fee_amount | decimal(11,2) | servicing fee amount | ||
card_fee_type | char(30) | servicing fee type | loan.cardfee.types.* | |
card_fee_percent | decimal(11,2) | servicing fee percentage | ||
agent | int(11) | ID of associated agent user | ||
source_company | int(11) | associated source company id | ||
payment_type_default | int(11) | The default payment type, as determined by either your company-wide settings or Rules Applied on a specific loan. | ||
loan_status | int(11) | loan status id | ||
loan_sub_status | int(11) | loan sub status id | ||
ebilling | tinyint(1) | Whether or not is signed up for ebilling | 1 - yes, 0 - no | |
ecoa_code | char(30) | borrower ECOA code | loan.ecoacodes.* | |
co_ecoa_code | char(30) | Co-borrower ECOA code | loan.ecoacodes.* | |
portfolio | text | loan portfolio | ||
credit_status | char(30) | loan credit status | loan.creditstatus.* | |
credit_bureau | char(30) | loan credit bureau | loan.creditbureau.* | |
reporting_type | char(30) | loan reporting type | loan.reportingtype.* | |
discount_split | tinyint(1) | Whether or not discount is split | 1 - yes, 0 - no | |
payment_frequency | char(30) | payment frequency | loan.frequency.* | |
calc_type | char(30) | loan calculation type | loan.calcType.* | |
days_in_year | char(30) | days in year calc | loan.daysInYear.* | |
interest_application | char(50) | loan interest application | loan.interestApplication.* | |
beg_end | char(20) | payment at begginging or end of period | loan.begend.* | |
first_period_days | char(40) | first period days calc type | loan.firstPeriodDays.* | |
first_day_interest | tinyint(1) | Whether or not to charge interest on first day | 1 - yes, 0 - no | |
discount_calc | char(40) | dicount calculation type | loan.discountCalc.* | |
diy_alt | tinyint(1) | Dans in year alternate | ||
payment_date_app | char(30) | payment date application | loan.pmtdateapp.* | |
days_in_period | char(30) | days in period | loan.daysinperiod.* | |
round_decimals | int(11) | round decimals calculation | ||
last_as_final | tinyint(1) | Whether or not to force last scheduled payment as final | 1 - yes, 0 - no | |
ndd_calc | char(30) | Next due date calcualtion | loan.nddCalc.* | |
end_interest | char(30) | end interest calculation | loan.endinterest.* | |
fixed_term_pmt | tinyint(1) | fixed term payment | 1 - yes, 0 - no | |
prorate_first_pmt | char(30) | prorate first payment | loan.proratefirst.* | |
latefee_percent_base | char(40) | Late fee percentage base | loan.latefeepercentbase.* | |
schedule_template | int(11) | schedule template id | ||
curtailment_template | int(11) | curtailment template id | ||
fees_paid_by | char(30) | fees paid by | loan.feesPaidBy.* | |
use_interest_tiers | tinyint(1) | Whether or not to use tiered interest | 1 - yes, 0 - no | |
loan_rate_type | char(30) | loan rate type | loan.rateType.* | |
smooth_payments | tinyint(1) | Whether or not to smooth payments | 1 - yes, 0 - no | |
apr_force_single_freq | tinyint(1) | Whether or not to force single freq for APR | 1 - yes, 0 - no | |
due_date_on_last_dom | tinyint(1) | Whether or not due date are on last day of month | 1 - yes, 0 - no | |
due_dates_on_business_days | varchar(40) | how to force due dates to be only on business days | loan.businessduedates.* | |
autopay_enabled | tinyint(1) | Whether or not autopay is enabled | 1 - yes, 0 - no | |
merchant_processor_group_id | int(11) | |||
created | timestamp | Timestamp of when the entity was created | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated | ||
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 |