-
Forum
-
T24 Technical Discussions
-
T24 Development & Customization
-
List FT history file
List FT history file
-
Menhlong
-
Topic Author
-
Offline
-
New Member
-
Less
More
-
Posts: 6
-
Thank you received: 0
-
-
5 years 7 months ago #21891
by Menhlong
Hi all, I want to list FT history file but it takes so long time. so is there any fast way to list FT history file by knowing account number?
Please Log in or Create an account to join the conversation.
Less
More
-
Posts: 19
-
Thank you received: 5
-
-
-
5 years 5 months ago #21947
by MarkTaylor
It should be faster if you start from ACCT.STMT.PRINT, STMT.PRINTED (or directly from STMT.PRINTED) and STMT.ENTRY.
Based on the field TRANS.REFERENCE in STMT.ENTRY, you can filter the FT references
The following user(s) said Thank You: VK
Please Log in or Create an account to join the conversation.
-
jpb
-
-
Offline
-
Moderator
-
-
TAFj-R20 - 'unix'
Less
More
-
Posts: 2854
-
Thank you received: 649
-
-
-
5 years 5 months ago #21965
by jpb
Have you tried defining/using an INDEX, e.g.
CREATE-INDEX -n FBNK.FUNDS.TRANSFER$HIS DEB.ACCT.DATE BY DEBIT.ACCT.NO BY PROCESSING.DATE
CREATE-INDEX -n FBNK.FUNDS.TRANSFER$HIS CRE.ACCT.DATE BY CREDIT.ACCT.NO BY PROCESSING.DATE
This might have impact on performance.
Please Log in or Create an account to join the conversation.
-
Menhlong
-
Topic Author
-
Offline
-
New Member
-
Less
More
-
Posts: 6
-
Thank you received: 0
-
-
5 years 1 week ago #22064
by Menhlong
Can you explain me more detail how to use CREATE-INDEX ?
Please Log in or Create an account to join the conversation.
-
Forum
-
T24 Technical Discussions
-
T24 Development & Customization
-
List FT history file
Time to create page: 0.098 seconds