Administration

Hi, hope you guys are well am a new DBA in t24. I have a question. Which table name stores customer account balance and customer account history statement in t24. Kindly advise.

Hi
strange question for DBA :))

Anyway, T24 application names are ACCOUNT and ACCT.STMT.PRINT respectively. To calculate table names you'll need to add prefix of company mnemonic. In most generic case that would be "FBNK."

If tables are stored in RDBMS (like MS SQL etc). change dots to underscores in table names.

1. So customer account balances is stored on ACCOUNT.
2. customer account statements is stored in ACCT.STMT.PRINT.


Thanks for the help

Hi
2. not statements themselves but their history (dates) - I might have interpreted your question wrongly... There is a lot of tables in T24 regarding statements (and generally delivery module) and depending on system setup the statements themselves might end up in different places. But their raw representation you can find in F.DE.O.HANDOFF (records starting with "950.").

Thanks alot my friend. Youve been helpful. Kindly share with me any technical t24 doc I study it and understand how t24 flows and how tables and data relate email This email address is being protected from spambots. You need JavaScript enabled to view it.

Hi
firstly take a look at:

jbc.temenos.com/

Av gone through it.....it deals much with programming and language conversions

Hi
then try this:

www.wikibanking.info/uploads/tihgw.pdf