16.6 Interest Query

This topic describes the systematic instructions to view the loan interest.

1. On Home screen, click Oracle Banking Liquidity Management System. Under Oracle Banking Liquidity Management System, click Intercompany Loan.
2. Under Intercompany Loan, click Interest Query.
   The Interest Query screen displays.

   Figure 16-9 Interest Query

   
   

   
   Description of "Figure 16-9 Interest Query"

   
   
3. Specify the field on Interest Query screen.

   Note:

   The fields, which are marked with an asterisk, are mandatory.

   For more information on fields, refer to the field description table.

   Table 16-12 Interest Query – Field Description

   Field	Description
   Group Customer ID	Click Search to view and select the group customer ID. This selection ensures that All the transactions are related to this group customer ID only. Further selection of customer IDs are from the children of this group customer.
   Customer ID 1	Click Search to view and select the customer ID1 wherever this customer is involved.
   Customer ID 2	Click Search to view and select the customer ID2 where only these two customers are involved.
   Loan status	Select the loan status from the drop-down list. The available options are: Open Settled All
   ICL reference no.	Specify the ICL reference number to list the transactions related to only that specific ICL reference number.

4. Click Fetch to view the interest details of the loan.
   For more information on fields, refer to the field description table.

   Table 16-13 Interest Details – Field Description

   Field	Field Description
   Loan Ref No	Displays the loan reference number.
   ICL Ref No	Displays the ICL ref number.
   Loan Date	Displays the loan date.
   From Account	Displays the from account.
   To Account	Displays the to account.
   Loan Amount	Displays the loan amount.
   Loan Currency	Displays the loan currency.
   Exchange Rate	Displays the exchange rate.
   Maturity Date	Displays the maturity date.
   Loan Status	Displays the loan status.
   Action	Displays the actions to view transaction details.

5. Click View Transaction button to view the loan details.
   The Transaction Details screen displays.

   Figure 16-10 Transaction Detail - Open Loan

   
   

   
   Description of "Figure 16-10 Transaction Detail - Open Loan"

   
   

   Figure 16-11 Transaction Detail - Settled Loan

   
   

   
   Description of "Figure 16-11 Transaction Detail - Settled Loan"

   
   

   For more information on fields, refer to the field description table.

   Table 16-14 Transaction Details – Field Description

   Field	Description
   Transaction From Date	Select the transaction from date. By selecting these dates, the search is restricted for the transaction between these two dates. One can choose any one of these dates as well
   Transaction To Date	Select the transaction to date.
   Transaction Ref No	Displays the system generated Transaction Ref Number for each transaction happening on the chosen Loan.
   Transaction Date	Displays the date on which transaction has occurred (Sweep, Reallocation, Reverse Sweep, etc).
   From Account	Displays the from account.
   To Account	Displays the credit account
   Transaction Amount	Displays the transaction amount.
   Currency	Displays the transaction currency.
   Transaction Type	Displays the type of transaction. Example: Sweep - SWP, Interest Reallocation – RAC, Reverse Sweep – RSW