2011年3月1日星期二

Loan Product Master Detail

Product Code
the product code to identifying the loans product. Product code is a manually generated unique identifier of the loan product.

Name
A descriptive name for the product.

Product Currency
The type of currency to be used for the loans product. By default, the system displays the currency assigned to the product as the currency of the account opened under the product.

Product Category
the category of the product. Asset or Liability

Product Classification
the data for product classification. This field is used for grouping of products for reporting purposes.

Advertising Message
The advertising message to be used for the purpose of product promotion.

Product Expiry Date
Expiry date of the product. The user can not open new accounts under the product after the expiry date. But accounts existing under the product will continue to function normally.

Loan Type
Loan type of the product.  Three value options:
    Term Loan -- A loan from a bank for a specific amount that has a specified repayment schedule and a floating interest rate. Term loans almost always mature between one and 10 years.
     Revolving Loan (循环的,周转的) -- Revolving Loan is defined as the term signifies revolving in nature. In this context, the entity which is revolving is the Sanctioned Amount. The sanctioned amount for the account is available for utilization.  The introduction of revolving loans has emerged from the fact that the customer will have any given time a sanctioned amount which can be utilized for his/her heeds through any mode or channel available.
    Revolving Loan Fund's definition from wiki: RLF is a source of money from which loans are made for small business development projects. A loan is made to one person or business at a time and, as repayments are made, funds become available for new loans to other businesses. Hence, the money revolves from one person or business to another.
     Islamic Loan -- Type of loan in which customer doesn't have to pay interest but share the profit earned, with the bank.

Rate Revision Allowed
if revision of interest rate is to be allowed durign the life term of the product.

Interest Accrual Frequency
The frequency at which the interest will be accrued. The accrual entries are passed based on the accrual frequency set up at the product level.

Booking
Limits
  Minimum/Maximum Loan Amount
The minimum/Maximum loan amount that can be granted for an account opened under this product.
  Minimum/Maximum Terms in Months
The minimum/Maximum loan term in months that is permitted for all accounts under the given loan product. This period does not include the IOI stage.
  Minimum/Maximum Interest Variance
The minimum/Maximum interest variance allowed on the interest rate for the product.
  Minimum/Maximum Installment
The minimum/Maximum installment amount that can be accepted as an installment for an account opened under the product.
  Minimum/Maximum Grace Period (in Days)
The minimum/Maximum grace period in months. Only Islamic Loan has this attribute.  There can also be a grace period at the account level.
  Offer Validity Period
The number of days/months/years within which a given offer of a loan has to be accepted by the borrower. Offer validity period is the stage where the bank makes an offer to the customer and the customer accepts the terms and conditions of the loan, before the loan offer expires.
   Acceptance Validity Period
The number of days/months/years till which an acceptance of the offer is valid.

Defaults
  Document plan code
document plan code defined for maintaining the list of required documents for accounts under the given loan product.
  Statement Frequency
The frequency at which statement of the accounts under the given loan product will be sent to the customer.
  Pass contingent
If to pass the contingent entries. It allows the user to select the frequency of the contingent entries.
  Type of security required
type of security required for the loans product. 
Value options include:
  None---unsecured loans will be allowed
  Guarantor--a customer has to be linked to the account with GUA relationship.
  Collateral--A collateral has to be linked to the account
  Security -- a security has to be linked to the account
Collateral Review Frequency
the frequency at which the collateral that are deposited by the customer for the loan accounts under the given product are reviewed for revaluation. A report will be generated comparing the collateral provided against a credit on the account.

Exception Reporting
  Small/Large Loan Amount
If the loan is disbursed for a value below/above the specified amount, it is automatically reflected in the exception report for the day.
   Small/Large terms in Months
If the loan is disbursed for a period below/above the specified term, it's automatically reflected in the exception report for the day.
   Small/Large Rate
If the loan is disbursed for a value below/above the specified rate, it is automatically reflected in the exception report for the day.

Sanctioned Amount Revision
    Allow Upwards/Downwards
if the sanctioned limit of the account can be increased/decreased.
    Below Utilized Amount
if the sanctioned limit of the account can be decreased below the amount utilized.

Disbursements
  Limits
Allowed Disbursement Modes
the mode in which disbursement is allowed for the accounts under the given product.  Value options include:
    Current/Savings: disbursement through current/savings
    Cash: disbursement through cash
    Cheque:
     GL:
     ATM:
     POS:
     Outward Remittance:
     External Account:
Maximum No of Disbursements
maximum number of times the bank can disburse the loan. Only one disbursement can take place during a day.
Recession Period in Days
The recession period after the disbursal of the loan. The recession period starts after the first disbursal. If the customer wants to cancel the loan within the recession period, then all the deduction and the interest accrued/charged on the account will be reversed by the system.
Threshold on sanctioned amount
The threshold percentage. It's the percentage over sanctioned amount that can be disbursed without any additional checked or authorizations.

Defaults
  Disbursement deduction plan code
 a deduction plan is a list of deductions/billing/debits to be performed at the time of loan disbursement.
  Schedule Drawn On
based on which the schedule will be drawn. Value options include:
     Actual outstanding Amount--
     Sanction Amount--

Available amount for disbursement
Include Advances
 include the advances in the disbursal amount or not
  Exclude Unbilled interest
exclude the unbilled interest or not
  Move to regular stage after disbursement
if the account should move to regulare type after IOA stage.

Repayments
  Limits
Allowed Repayment Modes
  The mode by which repayment is allowed for the accounts under the given product.  Value options include:
     Current/Savings -- Repayment through current/savings.
     Cash -- Repayment through cash
     Cheque --
     GL --
     ATM --
     POS --
     Inward Remittance --
     External Account --
 
Defaults

Appropriation Sequence
  The appropriation sequence for normal loans,indicating the sequence in which the funds credited to the loan account shall be appropriated to the various arrear buckets.  The standard sequence is CIFPOLANUTSDEGM. It stands for:
    C - Principal Arrears (欠款,逾期债款)
    I - Interest Arrears
    F - Fee Arrears
    P - Premium Arrears
    O - Outgoing Arrears
    L - Late Fee Arrears (Suspended Penalty interest)
    A - Penalty Arrears
    N - Non Accrual Interest Arrears (Suspended interest)
    U - Suspended Post Maturity Interest
    T - Post Maturity Interest
    S - Legal Fees Arrears
    D - Suspended Fees
    E - Suspended legal fees
    G - Suspended Premimum
    M - Suspended outgoing
Longest Overdue First
   If to perform the appropriation sequence date-wise.
Payoff Benefit
   The date from which a reduction in interest should be effected when a partial payment is made by the customer. 
   Value options include:
    Immediate -- The partial payoff payment done will take effect on the interest amount on the same day as the payment day. It is applicable only when the interest calculation method is daily balance.
    Next Due Date  -- The partial payoff payment done should take effect on the interest amount on the next due date of the loan account.
    Next Rest Period -- The partial payoff payment done should take effect on the interest amount on the next due date of the loan account.
    No Effect --
Lead days for repayment Date
  the number of days available to the customer for repayment of dues. These are applicable for revolving loans.
Minimum Amount For PPF
   Setup the number of installments that must be paid by the customer to treat the repayment as partial pay off.

Auto Repayments
   Drawdown behavior
 The drawdown behavior of the loans product.  Value options include:
     Partial Amount Allowed -- drawdown partiall amount of installment in case for the entire installment is not available
     Full Payment Only -- Drawdown only full installment amount, else reject the drawdown
    Raise Earmark -- drawdown funds available in CASA account and raise earmark for the remaining un-available amount
    Force Debit -- Drawdown the required funds from CASA account by force debit on CASA account.
Drawdown In
 the appropriate drawdown options.  Value options include:
    EOD --
    BOD --
Drawdown retry in
 the appropriate drawdown retry option
    BOTH --
    EOD --
    BOD --
Maximum Retires (Daily Retry)
The maximum number of retries in case a drawdown is set up on a CASA account and the CASA account does not have the funds. The system will try to draw down from the CASA account for the specified number of times on consecutive days in the BOD. This field is applicable only for drawdown from CASA mode of repayment.
Drawdown on Next working day
 if to process the drawdown on the next working day in case the drawdown day is a holiday. If not, the drawdown would happen on the previous working day.

Rate Intimations
  Generate Intimations for Rate change
 if to generate the rate change intimation.
  Lead days for rate renewal
  Lead days for rate renewal.

Non Payments
  Limits
Repayment Grace Days
The maximum number of grace days for a customer to pay any arrears before incurring penalty on the outstanding unpaid arrears.
Waive Penalty on Min Due Payment
if to waive penalty on minimum due payment. If the MAD is paid, then the penalty is not calculated.
Compute Penalty on repayments
  If to compute penalty on repayments.
Defaults
  Reminder Plan
 the loan reminder plan code containing the nature of reminders to be sent to customers and/or their associates in case of non-payment of arrears.
  Minimum Arrears for Reminder
 The minimum arrears for reminder.
  NPL Appropriation sequence
 the sequence in which the balance in an NPL account will be appropriated, indicating the sequence in which the funds credited to a suspended loan account shall be appropriated to the various arrear buckets.
  Longest Overdue first
Perform the appropriation sequence date-wise.

Asset Classification Preferences
 Preferences Plan code
A preference plan code of the classification preferences determines the preference set for the product with respects CRR movement, provisioning and claw-back used for suspended accounts.
 Secured classification plan code
secured classification plan code.
  Unsecured classification plan code
 the unsecured classification plan code.

Arrear Reporting
 Minimum Arrear for Reporting
 The minimum arrear for reporting. The loan accounts which have value of arrears above the given value will be reported.

Closure
 Limits
Small Balance Waiver Limit
 setup the residual amount that can be waived after the maturity of the loan. This applies to debit balances in a loan account. If at maturity of the loan, the outstanding amount is less than the small balance waiver amount, then the outstanding amount will be waived and the account will be closed.
Small Balance Forfeiture limit
 The maximum amount that can be forfeited(没收) by the bank. This applies to credit balances in a loan account. If at maturity of the loan, the repayment is more than the outstanding by up to the forfeiture amount, then the amount is forfeited and the loan account closed.
Maximum Lockin Period (Initial Period)
 the lockin period, which is the minimum period before which an early settlement of loans can not be done. If an early and final settlement is desired even before the expiry of the initial period, then the borrow is charged interest till the initial period subject to other conditions like notice period.
Minimum Notice Period for early settlement
 The minimum duration or notice period in the given unit, before the early and final premature settlement of the loan, before which the customer is required to give a notice to the bank about the early settlement of the loan. If a notice period is provided, then interest on the loan is calculated till the notice period start date else the interest is calculated till the EFS date.
Roll Over: Roll over option for the given loans product. Rollover controls the renewal of revolving loan accounts under the product.  Value options include:
    Automatic: Allows the user to rollover the accounts if the arrears are not in the account;
    Manual: Allows the user to manually rollover. The maturity date can be extended manually.
    None: applicable for term loans where the maturity dates can not be extended.
Small Amount for MAD:
the part of the MAD amount raised as per the formula which is specified while defining the minimum due plan. It's applicable only for revolving loans.

GL Reporting

Assets

Liability

Expense 

Income