Prev
Next
Forums User Experience Infor Workspace

Database Table description and column names description

 4 Replies
 1 Subscribed to this topic
 6 Subscribed to this forum
Sort:
Author
Messages
Vyom
New Member Send Private Message
Posts: 3
New Member
5/18/2023 10:42 PM

Hi I have this data dictionary link https://www.lawsonguru.co...90/tables/index.html  which explains me about different tables and column names. Is there any other way from where i can pull in this information? Any certain table or certain database which i can look at where all this information is stored? Thanks Vyom

Ragu Raghavan
Veteran Member Send Private Message
Posts: 477
Veteran Member
5/18/2023 11:29 PM
do you have access to LID ? You can try the command 'dbdoc'. do you have access to the GEN DB? You can query on the tables DOCFILE, DOCSCRFLD, DOCTXT etc.
Vyom
New Member Send Private Message
Posts: 3
New Member
5/19/2023 4:26 PM

I am sorry i am very new to this. What database would these tables be in? 

Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
5/19/2023 4:45 PM

Thse should be in the GEN database.

LarryD
Basic Member Send Private Message
Posts: 9
Basic Member
6/1/2023 4:08 PM
Which RDBMS are you using with Lawson? Typically for Oracle, "GEN" is a schema within the database that also hosts the Lawson and Logan schemas. I recommend to check with your local DBAs on this.