What table store Loan Repayment History

Hello All.

We want to extract the list of Loan Repayment History for of several arrangements (Loan).
However, after searching in T24, we are unable to find a table or core T24 applications that store this information.
Is there a way to store this information in a SQL view and display it by SQL query?
Or why to create a routine that stock the result in a file ?

For example, we want to list details of all past schedules processed and the projected future schedules for a loan.
hows all future principal, interest, commission, charge, fee and diary events throughout the
life of the contract.

   

thank

what is the enquiry name?

Hello Dear.

Enq name is EM.AA.SCH.FULL.LOAN

Thank

Per checking it uses NOFILE.EM.AA.SCH.FULL which has routine of EM.EN.AA.SCH.FULL.b It means the data came from multiple tables

Thank dear.

In EM.EN.AA.SCH.FULL.b routine, we can see all tables that are use to create this SELECT routine ?
I want to recreate the routine with a SQL Select on my database.
Thank

It is a core routine. you can if you have access on core routines.

Maybe you can use sql profiler to trace the SQL selects?