Who's On?

	Membership:
	Latest: navav4
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5208

	People Online:
	Visitors: 276
	Members: 0
	Total: 276

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chesca	1042

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

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

New Poster

Engaged Poster

Avid Poster

Engaged Reader

Avid Reader

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

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

MVP

New Poster

Engaged Reader

Avid Reader

5/19/2023 4:45 PM

Thse should be in the GEN database.

LarryD

Basic Member

Posts: 9

Engaged Reader

Avid Reader

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.