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: 476
    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: 7
          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.