Database – Preconfigured Loan Settings Entity (preconfigured_loan_settings_entity)
Description
Holds information about loan settings to use when creating a loan from a preconfigured template.
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
card_fee_amount | decimal(11,2) | card fee amount | ||
card_fee_type | char(30) | card fee type | ||
card_fee_percent | decimal(11,2) | card fee percent | ||
agent | int(11) | loan servicing user | ||
loan_status_id | int(11) | loan status id | ||
loan_sub_status_id | int(11) | loan sub status id | ||
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. | ||
ebilling | tinyint(1) | Whether or not to EBilling is enabled | 1 - yes, 0 - no | |
ecoa_code | char(30) | borrower ECOA code | loan.ecoacodes.* | |
co_ecoa_code | char(30) | Co-borrower ECOA code | loan.ecoacodes.* | |
credit_status | char(30) | Loan credit status | loan.creditstatus.* | |
credit_bureau | char(30) | loan credit bureau | loan.creditbureau.* | |
reporting_type | char(30) | reporting typ | loan.reportingtype.* | |
secured | tinyint(1) | Whether or not the loan is secured | 1 - yes, 0 - no | |
autopay_enabled | tinyint(1) | Whether or not autopay is enabled | 1 - yes, 0 - no | |
merchant_processor_group_id | int(11) | |||
repo_date | int(11) | loan reposessed date | ||
closed_date | int(11) | closed date | ||
liquidation_date | int(11) | liquidation date | ||
followup_date | int(11) | |||
deleted | tinyint(1) | Whether or not the entity was deleted | 1 - yes, 0 - no | |
lastUpdated | timestamp | Timestamp of when the entity was last updated |