- Forum
- T24 Technical Discussions
- T24 Arrangement Architecture
- What table store Loan Repayment History
×
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
Less
More
- Posts: 11
- Thank you received: 0
2 years 1 month ago - 2 years 1 month ago #23872
by j.zogbe
What table store Loan Repayment History was created 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
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
- Offline
- Elite Member
- TAFC|R12/R13, TAFJ|R20
Less
More
- Posts: 267
- Thank you received: 21
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
Less
More
- Posts: 11
- Thank you received: 0
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
Enq name is EM.AA.SCH.FULL.LOAN
Thank
Please Log in or Create an account to join the conversation.
- silvergem
- Offline
- Elite Member
- TAFC|R12/R13, TAFJ|R20
Less
More
- Posts: 267
- Thank you received: 21
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
Less
More
- Posts: 11
- Thank you received: 0
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
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
- Offline
- Elite Member
- TAFC|R12/R13, TAFJ|R20
Less
More
- Posts: 267
- Thank you received: 21
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?
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.
- Forum
- T24 Technical Discussions
- T24 Arrangement Architecture
- What table store Loan Repayment History
Time to create page: 0.089 seconds