T24 - E.GET.STMT.ID.LIST

[FAISAL FAYYAZ]

Hi All,

 

Can anyone help me with this.

 

I want to fetch STMT ENTRIES from a specified range of Date. Someone told me i could use E.GET.STMT.ID.LIST. Can anyone provide me its description and parameter list.

 

Regards,

 

Faisal

[Jim Idle]

Is there no documentation for the T24 interface routines?

Jim

On Sep 17, 2009, at 12:15 AM, FAISAL FAYYAZ <sagittari...@gmail.com

[VK]

Hi,
Are you talking about local developments? If yes, subroutine
E.GET.STMT.ID.LIST is not in "Subroutine guide" and therefore can't be
used for local developments. Neither it is in GLOBUS.BP (there are
some subroutines that may be taken as a sample for local
developments).

VK

On Sep 17, 5:29 pm, Jim Idle <j...@temporal-wave.com> wrote:
> Is there no documentation for the T24 interface routines?
>
> Jim
>

> On Sep 17, 2009, at 12:15 AM, FAISAL FAYYAZ <sagittarius.fai...@gmail.com

[FAISAL FAYYAZ]

Hi VK,

 

This is a CORE Routine. I want to know about the parameters of routine through which i can use it. As i can use EB.ACCT.ENTRY.LIST, to get the STMT Entries within specified range of dates, But in this routine, Account number

is mandatory. Is there any other way to get the STMT Entries within specified range of dates, without the restriction

of Account Number?

 

Regards,

 

Faisal

[JOSE L MARTINEZ-AVIAL]

well, that routine is used in an enquiry to generate a list of STMT.ENTRY ID from the data you can obtain in a record. You should call using and argument like the following:

148930004379022.03   1-2

It's the same format you will find in the field STATEMENT.NOS  in most Globus application recorda (such as SEC.TRADE o FT, or FX), only the separator should be a space. The result will be this:

148930004379022.030001 148930004379022.030002

So given a STATEMENT.NOS of a certain record the routine will give you the whole list of STMT.ENTRY asociated to that record.  

2009/9/18 VK <kzm...@yahoo.com>

[Jim Idle]

On 09/18/2009 10:44 PM, FAISAL FAYYAZ wrote:
> Hi VK,
> This is a CORE Routine. I want to know about the parameters of routine
> through which i can use it.

I woudl think that if it is not a documented function, then you should
not be using it - you can potentially compromise the security of your
bank if you hack around with stuff. Step back, ask yourself what it is
you are trying to do, then ask TEMENOS what the proscribed way to do it is.

Jim

[Helen Tungol]

Hi Faizal,

Maybe you can try to use the core routine EB.ACCT.ENTRY.LIST if
this is available in your release to get stmt entry id list?

You just have to pass, the accountno, begin date, end date
and it will return the list of statement entry ids and the opening balance.

CALL EB.ACCT.ENTRY.LIST(ACCTNO,BEGIN.DATE,END.DATE,STMTIDLIST,OPENINGBAL,ER)

Regards
Helen

[VK]

Hi,
you shouldn't use core routines for local developments but if you need
to gather STMT.ENTRY IDs for certain period, this is not a
straightforward task. There is a CONCAT file called ACCT.ENT.TODAY but
it holds info for current workday only. There is also similar file
ACCT.ENT.LWORK.DAY that holds info for previous work day. SELECT on
STMT.ENTRY is an unacceptable solution. So you might want to create a
local CONCAT file where you store info about STMT.ENTRY records for
the period you might be interested in.

Anyway, this routine is not doing what you suppose it does...

[Rama chandran]

Hi ,

Try this

FN.STMT.ENTRY = "F":Y.ICP.COMP.MNE:".STMT.ENTRY"; F.STMT.ENTRY = ''
CALL OPF(FN.STMT.ENTRY,F.STMT.ENTRY)
D.FIELDS = ''
D.FIELDS<1> = 'ACCOUNT'
D.LOGICAL.OPERANDS<1> = 1
D.RANGE.AND.VALUE<1> = <ACCOUNT.NO>
D.FIELDS<2> = 'BOOKING.DATE'
D.LOGICAL.OPERANDS<2> = 2
D.RANGE.AND.VALUE<2> = <Y.START.DATE>:SM:<Y.END.DATE>
STMT.ID.LIST = ''
CALL E.STMT.ENQ.BY.CONCAT(STMT.ID.LIST)

Regds
Ram

--
என்றும் நினைவுகளுடன்!...
ராம்

[FAISAL FAYYAZ]

Hi,

 

I just want to use the CORE Routine as it is being used in System Enquiries. This routine is being used in Enquiries as Conversion.

 

I want STMT Entries for specific Dates Consolidated (Not Account Wise).

 

 

Regards,

 

Faisal

[Rashid K.P]

well first of all , what are you trying to achieve by getting all the STMT.ENTRY ids for a given date range (for all accounts) . I mean what is the requirement.

 

 If you are looking to design an enquiry to view the STMT.ENTRY id's then  it will invariably  timeout in T24 browser and if at all it doesnt , It will run to more than 200 pages which will not be displayed in browser.

 

 If you really cannot do without this requirement , then write a multi-threaded service that will select all the accounts and then in the record routine call any core routine (EB.ACCT.ENTRY.LIST or E.STMT.ENQ.BY.CONCAT) to get the entries for that account and write it into a file (agent wise file).  Then after the service is stopped ,merge the files to get the list of entries.  This again will have performance impact for high volume clients but your reuirement is a bit like that.

[Niels]

I would create an index on book date and/or value date on STMT.ENTRY
then create a build routine and build your own ID list. create a loop
with for each EQ value from your index. Add the id to the ED
previously found and you have your selection and very fast with lille
to none programming

[FAISAL FAYYAZ]

 

Thanks all for your replies. We have already tried both the suggestions "Multithreaded Service" and "Indexing" and were looking for any other better alternatives. But i think that there is none.

 

Regards,

 

Faisal