Previous Next JavaScript must be enabled to correctly display this content

## 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

Parent topic: Inter Company Loans