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


How did we do?


Powered by HelpDocs (opens in a new tab)