• Search Forums
    Advanced Search Topics Posts
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
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
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
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
Posts: 1498
Veteran Member
5/19/2023 4:45 PM

Thse should be in the GEN database.

LarryD
Basic Member
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.