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 | |
max_interest_amount | decimal (11,2) | This is the maximum interest amount on a loan. | ||
merchant_processor_group_id | This is the ID of the merchant processor group. | |||
finance_charge_as_mia | tinyint(1) | This is the field where you can keep track of the finance charge as the maximum interest accrual. This is where you can set the maximum interest accrual to the finance charge. | 1 - yes 0 - no |