preconfigured_loan_entity - 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

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

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


How did we do?


Powered by HelpDocs (opens in a new tab)