PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 6/1/2023 4:08 PM by  LarryD
Database Table description and column names description
 4 Replies
 1 Subscribed to this topic
 22 Subscribed to this forum
Sort:
You are not authorized to post a reply.
Author Messages
Vyom
Data Engineer
Private
New Member
(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
    Veteran Member
    (1333 points)
    Veteran Member
    Posts:463


    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
    New Member
    (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
    Veteran Member
    (4175 points)
    Veteran Member
    Posts:1493


    Send Message:

    --
    5/19/2023 4:45 PM

    Thse should be in the GEN database.

    LarryD
    APPLICATIONS DEVELOPER
    Private
    Basic Member
    (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.