Database Table description and column names description -

Prev Go to previous topic

Go to next topic

Last Post 6/1/2023 4:08 PM by LarryD

Database Table description and column names description

4 Replies

Sort:


You are not authorized to post a reply.

Author

Messages

Vyom
Data Engineer
Private

(5 points)
New Member
Posts:3

Send Message:

5/18/2023 10:42 PM
Hi I have this data dictionary link https://www.lawsonguru.co...les/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
Private
Private

(1318 points)
Veteran Member
Posts:458

Send Message:

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
Data Engineer
Private

(5 points)
New Member
Posts:3

Send Message:

5/19/2023 4:26 PM
I am sorry i am very new to this. What database would these tables be in?

Greg Moeller
Private
Private

(4163 points)
Veteran Member
Posts:1487

Send Message:

5/19/2023 4:45 PM
Thse should be in the GEN database.

LarryD
APPLICATIONS DEVELOPER
Private

(21 points)
Basic Member
Posts:7

Send Message:

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.

You are not authorized to post a reply.