Database Table description and column names description

 4 Replies
 1 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Vyom
New Member
Posts: 3
New Member

    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: 473
    Veteran Member
      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

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

        Greg Moeller
        Veteran Member
        Posts: 1498
        Veteran Member

          Thse should be in the GEN database.

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