Administration

More
2 years 11 months ago #21944 by Davy
Administration was created by Davy
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.

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • TAFC|R19/R21
More
2 years 11 months ago #21945 by VK
Replied by VK on topic Administration
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.

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

More
2 years 11 months ago #21948 by Davy
Replied by Davy on topic Administration
1. So customer account balances is stored on ACCOUNT.
2. customer account statements is stored in ACCT.STMT.PRINT.


Thanks for the help

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • TAFC|R19/R21
More
2 years 11 months ago #21949 by VK
Replied by VK on topic Administration
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.").

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

More
2 years 11 months ago #21951 by Davy
Replied by Davy on topic Administration
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.

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • TAFC|R19/R21
More
2 years 11 months ago #21958 by VK
Replied by VK on topic Administration
Hi
firstly take a look at:

jbc.temenos.com/

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

More
2 years 11 months ago #21959 by Davy
Replied by Davy on topic Administration
Av gone through it.....it deals much with programming and language conversions

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • TAFC|R19/R21
More
2 years 11 months ago #21961 by VK
Replied by VK on topic Administration

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

Time to create page: 0.157 seconds