Baanboard.com

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

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
7%
1200 - 1500 GB
8%
1500 - 2000 GB
12%
> 2000 GB
23%
Total votes: 73

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 19th August 2019, 15:54
bgrgon bgrgon is offline
Newbie
 
Join Date: Aug 2019
Posts: 2
bgrgon is on a distinguished road
Baan: Infor LN - DB: SQL - OS: Windows
Lightbulb Data Type conversion table
Baan: ERP LN 6.1
C/S: None/Unknown

Hi All,

We have a requirement around being able to know the exact datatypes of every field. We know this information resides in ttADV400 in field 'type'. Which table stores the conversion from the number stored in this field to the relevant datatype description (numeric, decimal etc)?

PS. I am brand new to BAAN, InforLN so apologies if this is a very simple question

Thanks
Reply With Quote
Sponsored Links
  #2  
Old 19th August 2019, 18:31
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,329
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Not sure I get the question - the domain type (at least in 4c4) in ttadv400 contains any formatting or information needed for any table field or session field which uses this domain type.
__________________
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 20th August 2019, 08:34
JaapJD's Avatar
JaapJD JaapJD is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 837
JaapJD will become famous soon enoughJaapJD will become famous soon enough
Baan: BaanIV, BaanERP, ERP LN 6.1 - DB: Oracle, SQL Server - OS: Unix, Windows
That is in table ttadv401 and ttadv402 (BaanIV) or ttadv140 (LN). I would recommend to use the rdi.* functions (like rdi.column and rdi.table.column) to get the field type.
Reply With Quote
  #4  
Old 20th August 2019, 12:58
bgrgon bgrgon is offline
Newbie
 
Join Date: Aug 2019
Posts: 2
bgrgon is on a distinguished road
Baan: Infor LN - DB: SQL - OS: Windows
Thanks both for your reply.

I thought it might be as simple as there being an internal configuration table where it equates the number in the 'data type' field to a description of that number. For example 2 equates to an integer field, 5 for a decimal etc. Unfortunately we are waiting for access for the LN system so are relying on downloads of these data dictionary tables for now

I see there are also similar numbers assigned for rounding methods, conversion, alignment etc
Reply With Quote
  #5  
Old 20th August 2019, 14:35
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,329
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
I think I see what you are talking about. So like the data type of 5 is double, 7 is enumerated, etc. So if you find a 7 you know it is enumerated and then could look in ttadv401. And in this case data type is an enumerated field. So you could look in ttadv401 for ttadv.type - to get what the numbers mean: 1 is byte, 12 is blob, 5 is double, 9 is date, 7 is enumerated, 4 is float, 2 is integer. 3 is long, 8 is set. etc.

Be a lot easier once you have access to the system. PS - I am looking at 4c4, ln could be different.
__________________
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
  #6  
Old 20th August 2019, 16:36
vinceco252's Avatar
vinceco252 vinceco252 is offline
Guru
 
Join Date: Mar 2002
Location: Frederick, CO
Posts: 429
vinceco252 is on a distinguished road
Baan: Baan IVc3, IVc4, 5b, 5c, ERP LN 6.1, Infor ERP 10.x - DB: SQL Server, Oracle - OS: Windows, Linux, HPUX, AIX, (a little bit of) Solaris
Mark,

The basics of domains, tables, etc., are the same in LN.

Vince
__________________
Vincent Murphy
---------------
ERP Practice Manager / Senior Consultant
OST
vmurphy@ostusa.com
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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Application data dictionary vs. run-time data dictionary NPRao Tools Development 5 7th July 2009 08:16
Deleting table references... ruchi.verma Tools Administration & Installation 2 19th August 2008 18:58
Audit file structure baan_user Tools Development 8 4th May 2007 14:32
Import Data from File NPRao Tools Administration & Installation 5 30th August 2005 09:01
Tables used for MRP and PRP. BurghMan Tools Development 1 10th February 2005 14:08


All times are GMT +2. The time now is 18:02.


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