Prev
Next
Forums Infor Workspace

Database Table description and column names description

Sort:
You are not authorized to post a reply.
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...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
    Veteran Member
    Posts: 468
    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.
            You are not authorized to post a reply.