BNPL | CreditLine Transactions Statement Generation

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

  • Get Statement of all the Transactions between the given StartDate and EndDate for the CreditLine Account Number.

  • StartDate and EndDate are Passed as Epoch Values(Type Long).

Find below the changes need to be done in the database tables.

  1. Insert into f_credit_line_transaction_config.

    INSERT INTO `f_credit_line_transaction_config` (id,applicable_charge_config,version,transaction_statement_generation_config) VALUES (1,NULL,0,'{ \"outputType\":\"PDF\" \n , \"reportName\": \"transaction_statement\" \n, \"endDateParamKey\":\"endDate\" \n, \"startDateParamKey\":\"startDate\" \n, \"accountNumberParamKey\":\"acount\" }');

     

 

2. Mapping of f_product_config_mapping and f_credit_line_transaction_config

  • Map the column` id ` in f_credit_line_transaction_config with column `transaction_config_id` in f_product_config_mapping.
    ie. f_credit_line_transaction_config.id = f_product_config_mapping.transaction_config_id .