Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
18%
200 - 500 GB
29%
500 - 800 GB
3%
800 - 1200 GB
8%
1200 - 1500 GB
8%
1500 - 2000 GB
13%
> 2000 GB
24%
Total votes: 80

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 26th June 2019, 15:44
Cybermin Cybermin is offline
Junior Member
 
Join Date: Nov 2017
Posts: 8
Cybermin is on a distinguished road
Baan: Baan IVc - DB: Oracle - OS: Windows 7 and 10
TFGLD410 tror and fitr fields

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
Reply With Quote
  #2  
Old 26th June 2019, 16:01
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,388
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
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

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #3  
Old 26th June 2019, 19:14
Cybermin Cybermin is offline
Junior Member
 
Join Date: Nov 2017
Posts: 8
Cybermin is on a distinguished road
Baan: Baan IVc - DB: Oracle - OS: Windows 7 and 10
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
Reply With Quote
  #4  
Old 26th June 2019, 19:37
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,388
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
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

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #5  
Old 26th June 2019, 20:03
Cybermin Cybermin is offline
Junior Member
 
Join Date: Nov 2017
Posts: 8
Cybermin is on a distinguished road
Baan: Baan IVc - DB: Oracle - OS: Windows 7 and 10
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
Reply With Quote
  #6  
Old 26th June 2019, 23:40
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,388
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
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.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #7  
Old 27th June 2019, 16:01
Cybermin Cybermin is offline
Junior Member
 
Join Date: Nov 2017
Posts: 8
Cybermin is on a distinguished road
Baan: Baan IVc - DB: Oracle - OS: Windows 7 and 10
Thank you for the information. I will keep threads open moving forward.
Reply With Quote
Sponsored Links
  #8  
Old 27th June 2019, 21:06
NPRao's Avatar
NPRao NPRao is offline
Guru
 
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,113
NPRao will become famous soon enough
Baan: Baan 4-5,5.2(Reger),LN-6.1,Infor LN-10.x - DB: Oracle,MS-SQL - OS: HPUX, Linux, Windows
Quote:
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

I cant use Tools sessions

Question Current package VRC unknown
__________________
The art of perfection does not lie in doing extraordinary things but, doing ordinary things extraordinarily well. [-N. Prashanth Rao]
How To Ask Questions The Smart Way,BaaNBoard,NPRao
Reply With Quote
  #9  
Old 1st July 2019, 19:24
avpatil avpatil is offline
Guru
 
Join Date: Feb 2002
Posts: 740
avpatil is on a distinguished road
Baan: IVc3 - DB: SQL2000 - OS: Win 2003
So if you view table in GTM it doesn't tell you domain and give description?
Reply With Quote
  #10  
Old 2nd July 2019, 16:56
Cybermin Cybermin is offline
Junior Member
 
Join Date: Nov 2017
Posts: 8
Cybermin is on a distinguished road
Baan: Baan IVc - DB: Oracle - OS: Windows 7 and 10
avpatil... Thank You for your question. I don't have access to run GTM.
Reply With Quote
  #11  
Old 11th July 2019, 19:27
richylh richylh is offline
Member
 
Join Date: Jan 2007
Location: UK
Posts: 31
richylh is on a distinguished road
Baan: IVc4, Vc, LN - DB: Oracle, SQL Server - OS: HP/UX, Windows, Linux
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.
__________________
19 years BaanIV/V/LN experience including 2 years in Infor/SSA as consultant. Welcome to share experience together!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +2. The time now is 09:30.


©2001-2018 - Baanboard.com - Baanforums.com