Table: Pre Configured loan entity

Table: Pre Configured 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
idint(11)The id of the entity
settings_idint(11)associated settings id
titlevarchar(255)The name/title of the entity instance
iconchar(40)icon
loan_amountdecimal(11,2)loan amount
discountdecimal(11,2)discount
underwritingdecimal(11,2)underwriting
loan_ratedecimal(11,4)loan rate
loan_termdecimal(11,4)loan term
contract_dateint(11)contract date
first_payment_dateint(11)first payment date
amount_downdecimal(11,2)amount down
reservedecimal(11,2)reserve amount
sales_pricedecimal(11,2)sales price
gapdecimal(11,2)gap
warrantydecimal(11,2)warranty
dealer_profitdecimal(11,2)dealer profit
credit_limitdecimal(11,2)credit limit
reporting_credit_limitdecimal(11,2)reporting credit limit
flooring_customerint(11)flooring customer
loan_classchar(30)The classification for the loanloan.class.*
loan_typechar(30)Loan type code for associated loansloan.type.*
grace_daysint(11)grace days (late feE)
late_fee_typechar(30)late fee typeloan.lateFee.*
late_fee_amountdecimal(11,2)late fee amount
late_fee_percentdecimal(11,2)late fee percent
late_fee_calcchar(30)late fee calculationloan.lageFeeCalc.*
card_fee_amountdecimal(11,2)servicing fee amount
card_fee_typechar(30)servicing fee typeloan.cardfee.types.*
card_fee_percentdecimal(11,2)servicing fee percentage
agentint(11)ID of associated agent user
source_companyint(11)associated source company id
loan_statusint(11)loan status id
loan_sub_statusint(11)loan sub status id
ebillingtinyint(1)Whether or not is signed up for ebilling1 - yes, 0 - no
ecoa_codechar(30)borrower ECOA codeloan.ecoacodes.*
co_ecoa_codechar(30)Co-borrower ECOA codeloan.ecoacodes.*
portfoliotextloan portfolio
credit_statuschar(30)loan credit statusloan.creditstatus.*
credit_bureauchar(30)loan credit bureauloan.creditbureau.*
reporting_typechar(30)loan reporting typeloan.reportingtype.*
discount_splittinyint(1)Whether or not discount is split1 - yes, 0 - no
payment_frequencychar(30)payment frequencyloan.frequency.*
calc_typechar(30)loan calculation typeloan.calcType.*
days_in_yearchar(30)days in year calcloan.daysInYear.*
interest_applicationchar(50)loan interest applicationloan.interestApplication.*
beg_endchar(20)payment at begginging or end of periodloan.begend.*
first_period_dayschar(40)first period days calc typeloan.firstPeriodDays.*
first_day_interesttinyint(1)Whether or not to charge interest on first day1 - yes, 0 - no
discount_calcchar(40)dicount calculation typeloan.discountCalc.*
diy_alttinyint(1)Dans in year alternate
payment_date_appchar(30)payment date applicationloan.pmtdateapp.*
days_in_periodchar(30)days in period loan.daysinperiod.*
round_decimalsint(11)round decimals calculation
last_as_finaltinyint(1)Whether or not to force last scheduled payment as final1 - yes, 0 - no
ndd_calcchar(30)Next due date calcualtionloan.nddCalc.*
end_interestchar(30)end interest calculationloan.endinterest.*
fixed_term_pmttinyint(1)fixed term payment1 - yes, 0 - no
prorate_first_pmtchar(30)prorate first paymentloan.proratefirst.*
latefee_percent_basechar(40)Late fee percentage baseloan.latefeepercentbase.*
schedule_templateint(11)schedule template id
curtailment_templateint(11)curtailment template id
fees_paid_bychar(30)fees paid byloan.feesPaidBy.*
use_interest_tierstinyint(1)Whether or not to use tiered interest1 - yes, 0 - no
loan_rate_typechar(30)loan rate typeloan.rateType.*
smooth_paymentstinyint(1)Whether or not to smooth payments1 - yes, 0 - no
apr_force_single_freqtinyint(1)Whether or not to force single freq for APR1 - yes, 0 - no
due_date_on_last_domtinyint(1)Whether or not due date are on last day of month1 - yes, 0 - no
due_dates_on_business_daysvarchar(40)how to force due dates to be only on business daysloan.businessduedates.*
autopay_enabledtinyint(1)Whether or not autopay is enabled1 - yes, 0 - no
createdtimestampTimestamp of when the entity was created
lastUpdatedtimestampTimestamp of when the entity was last updated
activetinyint(1)Whether or not the entity is active1 - yes, 0 - no
deletedtinyint(1)Whether or not the entity was deleted1 - yes, 0 - no

< Back to List