BNPL | Interest and Charges - Should not impact Limits

Owned by Abhishek H S (Unlicensed)
Oct 17, 2023
3 min read

 

Any transaction which has income for the system is treated as an income-based transaction.
Charge based and Interest based transactions are by default considered as Income based transactions.
Income-based transactions don’t have any impact on the available limit.

Transactions affected - ADD_FEE
ADD_PENALTY
WAIVE_CHARGE
CHARGE_REVERSAL
                                   PAYIN/ EXCESS_PAYMENT/ RETURNS
EMI_INTEREST
APPLY_INTEREST
WAIVE_INTEREST
INTEREST_AUTO_WAIVE

 

  • Any charge which is applicable for the product should have an entry in m_credit_line_charge_details.

 

  • Database config for any charge-based transaction which shouldn’t impact Limits.

If any charge-based transaction is treated as an income-based transaction,

  • In m_credit_line_charge_details table insert charge details where charge_id in m_credit_line_charge_details equals id in table m_charge

  • In m_credit_line_charge_details table, the column should_impact_available_limit says whether impacting the Limit or not.
    boolean 0 (false) - not impacting Limits.
    boolean 1 (true) - impacting Limits.

 

  • Database config for interest based transactions which shouldn’t impact Limits

 

  1. Interest-based transaction which shouldn’t impact the Limits, run the below query

    update f_available_amount_computation_strategy acs JOIN f_account_config_mapping ac ON ac.available_amount_computation_strategy = acs.id set acs.based_on_interest = 'EXCLUDE_INTEREST';

  2. Interest-based transaction which should impact the Limits, run the below query

    update f_available_amount_computation_strategy acs JOIN f_account_config_mapping ac ON ac.available_amount_computation_strategy = acs.id set acs.based_on_interest = 'INCLUDE_INTEREST';