× Discuss on any other topics

Need of dictionnaire database of T24

  • Barthelemy
  • Topic Author
  • Offline
  • New Member
  • New Member
More
7 months 4 days ago #24211 by Barthelemy
Need of dictionnaire database of T24 was created by Barthelemy
Hello
please can you skate with me the database dictionnary of T24.
thank you

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus|G09-G13 TAFC|R05-R23 TAFJ|R19,R23-test
More
7 months 4 days ago #24213 by VK
Replied by VK on topic Need of dictionnaire database of T24
Hi
if you mean the DB structure definition - it's usually in the distribution package;

e.g. for R23 it's Transact_DataModel_R23.zip containing xls files with descriptions.

Cheers
VK

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

  • Barthelemy
  • Topic Author
  • Offline
  • New Member
  • New Member
More
7 months 4 days ago #24214 by Barthelemy
Replied by Barthelemy on topic Need of dictionnaire database of T24
Hello VK
Is it possible to get this archive or temenos portail ? If yes, can you share with me the link ?
I have an account

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus|G09-G13 TAFC|R05-R23 TAFJ|R19,R23-test
More
7 months 4 days ago #24215 by VK
Replied by VK on topic Need of dictionnaire database of T24
Hi
there's no direct links; go to tcsp.temenos.com, then Menu => Transact (T24) => software downloads; "Distribution Test" / "Click here" => choose your environment => "Data_Model" => Download. Link is always "distribution.temenos.com/Distribution/Index#" so it can't be used...

Cheers
VK

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

  • Barthelemy
  • Topic Author
  • Offline
  • New Member
  • New Member
More
7 months 4 days ago - 7 months 4 days ago #24216 by Barthelemy
Replied by Barthelemy on topic Need of dictionnaire database of T24
Thank you bro
I get it.
Please can you help me by request SQL to obtain report below ?
1) List of customer account having negative balance at 30/06/2023
2) list of operations perfomed in account in périod of May 2023
Last edit: 7 months 4 days ago by Barthelemy. Reason: NB : we already use T24 T14

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus|G09-G13 TAFC|R05-R23 TAFJ|R19,R23-test
More
7 months 4 days ago - 7 months 4 days ago #24217 by VK
Replied by VK on topic Need of dictionnaire database of T24
Hi
do you have detailed business requirements? E.g. what is "operations"? or "which kind of balance"? there's several ones.

Then it's possible to move forward...

Cheers
VK
Last edit: 7 months 4 days ago by VK.

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

Time to create page: 0.127 seconds