× Discuss on Arrangement Architecture (AA), AA Core, Lending, Deposits, Accounts, Proxy services, Internet Services, etc…

What table store Loan Repayment History

  • j.zogbe
  • Topic Author
  • Offline
  • New Member
  • New Member
More
2 years 1 month ago - 2 years 1 month ago #23872 by j.zogbe
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
Attachments:
Last edit: 2 years 1 month ago by j.zogbe. Reason: Add attachement

Please Log in or Create an account to join the conversation.

  • silvergem
  • silvergem's Avatar
  • Offline
  • Elite Member
  • Elite Member
  • TAFC|R12/R13, TAFJ|R20
More
1 year 11 months ago #23948 by silvergem
Replied by silvergem on topic What table store Loan Repayment History
what is the enquiry name?

Please Log in or Create an account to join the conversation.

  • j.zogbe
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 11 months ago #23958 by j.zogbe
Replied by j.zogbe on topic What table store Loan Repayment History
Hello Dear.

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

Thank

Please Log in or Create an account to join the conversation.

  • silvergem
  • silvergem's Avatar
  • Offline
  • Elite Member
  • Elite Member
  • TAFC|R12/R13, TAFJ|R20
More
1 year 11 months ago #23960 by silvergem
Replied by silvergem on topic What table store Loan Repayment History
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

Please Log in or Create an account to join the conversation.

  • j.zogbe
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 11 months ago #23965 by j.zogbe
Replied by j.zogbe on topic What table store Loan Repayment History
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

Please Log in or Create an account to join the conversation.

  • silvergem
  • silvergem's Avatar
  • Offline
  • Elite Member
  • Elite Member
  • TAFC|R12/R13, TAFJ|R20
More
1 year 11 months ago - 1 year 11 months ago #23966 by silvergem
Replied by silvergem on topic What table store Loan Repayment History
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?
Last edit: 1 year 11 months ago by silvergem.

Please Log in or Create an account to join the conversation.

Time to create page: 0.089 seconds