Good morning. I may not be searching correctly but I can't find a posting about this.

In the TFGLD410 table there are two fields T$TROR and T$FITR fields that show numeric entries. When you look at the associated Baan Sessions, Baan shows text.

Where is the translation table to convert the T$TROR and T$FITR entries from numeric and text?

Thank You,
Alex

I would say pull up the definitions of that table. Look at the domains on those fields then go pull up the domains. On our system the domains are tcfitr and tctror. Both are enumerated domains. If I wanted I could maintain the domains and change the description on the domain. That domain is how you get from a number to words.

Mark,
Thank You for your reply and after looking at the definitions of the table, our environment is set up the same way as yours. The problem we have is we have a lease agreement with the company we purchased the plant from and don't have access to the domain information and the tadv tables.

Is there another way to obtain the desired information?

Alex

Not sure how could get the information without at least access to the domains or tools sessions or a least some kind of query capability.

Mark,
I found where to modify and view domains but I do not have the ability to change the VRC. I appreciate your help.

Alex

You are welcome. Plus we leave threads open just incase someone else has a similar problem, wants to add more information or just ask a question.

Thank you for the information. I will keep threads open moving forward.

I found where to modify and view domains but I do not have the ability to change the VRC. I appreciate your help.

Alex,

Refer to the threads -

Unknown Package vrc (http://www.baanboard.com/baanboard/showthread.php?t=65163&highlight=ttadv0140m000)

I cant use Tools sessions (http://www.baanboard.com/baanboard/showthread.php?t=24&highlight=ttadv0140m000)

Question Current package VRC unknown (http://www.baanboard.com/baanboard/showthread.php?t=1451&highlight=ttadv0140m000)

So if you view table in GTM it doesn't tell you domain and give description?

avpatil... Thank You for your question. I don't have access to run GTM.

The best way is as mark_h and avpatil suggested via the Tools domain definition and GTM window.

Not sure if you have access to the database table or not. If you have access, you can easily get the domain/enum information from table ttadv400 and ttadv401.