Administration

  • Posts: 4
  • Thank you received: 0

Davy created the topic: 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.
#21944

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • TAFC|R13|R19|R20
  • Posts: 785
  • Thank you received: 110

VK replied the 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.
#21945

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

  • Posts: 4
  • Thank you received: 0

Davy replied the 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
#21948

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • TAFC|R13|R19|R20
  • Posts: 785
  • Thank you received: 110

VK replied the 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.").
#21949

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

  • Posts: 4
  • Thank you received: 0

Davy replied the 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.
#21951

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • TAFC|R13|R19|R20
  • Posts: 785
  • Thank you received: 110

VK replied the topic: Administration

Hi
firstly take a look at:

jbc.temenos.com/
#21958

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

  • Posts: 4
  • Thank you received: 0

Davy replied the topic: Administration

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

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • TAFC|R13|R19|R20
  • Posts: 785
  • Thank you received: 110

VK replied the topic: Administration

#21961

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

Time to create page: 0.185 seconds