Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

9.0 Table Schemas?

 7 Replies
 1 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
JMED
Basic Member
Posts: 5
Basic Member
10/29/2014 1:46 PM

    Hi Everyone!

    I was wondering if anyone is aware of a location where I could find the table schemas for a handful of Lawson 9.0 tables? I was referencing the Data Dictionary under the TECH tab here, but was wondering if there was a SQL schema somewhere to ensure I am capturing the right columns, data types, and constraints properly. 

    PS. I currently do not have direct access to the Lawson DB, so I'm relying heavily on the documentation and forums to gain an understanding.

    Thanks! :-)

    JMED

    Greg Moeller
    Veteran Member
    Posts: 1498
    Veteran Member
    10/29/2014 1:58 PM
      I have some... but they are too big to email or upload. More details later.... I've got a minor emergency that I need to leave for now.
      JMED
      Basic Member
      Posts: 5
      Basic Member
      10/29/2014 2:06 PM
        Thank you so much for your response! Below are the tables I'm really looking for the most:
        POVAGRMTHD
        POVAGRMTLN
        REQHEADER
        REQLINE
        PURCHORDER
        POLINE
        APINVOICE
        MAINVDTL
        APVENMAST
        ICMANCODE
        DEPTCODE
        ITEMMAST

        I started going through the tables by hand based on the Data Dictionary, but I'm not sure if thats the best approach. Thanks again in advance :-)
        ACCESS GNOME
        Basic Member
        Posts: 8
        Basic Member
        10/29/2014 2:24 PM
          If you're able to ask someone who has access to the Lawson DB, I highly recommend looking into a table named "PUBLIC_ALL_TAB_COLUMNS". You'll be able to enter key words into field "COLUMN_NAME" which will return all tables names (under field "TABLE_NAME") associated with your key words. I used this table a lot in the past to help me locate/identify tables of interest to create queries.
          Greg Moeller
          Veteran Member
          Posts: 1498
          Veteran Member
          10/29/2014 3:40 PM
            Send me your email in a Private Message, and I'll ship you what I have for these tables.
            Greg Moeller
            Veteran Member
            Posts: 1498
            Veteran Member
            10/29/2014 4:18 PM

              Heck, I'll just attach them here...   They don't look very good without the backgroud css and other directory structure stuff... but I think you'll get the point.

              If I could, I might suggest getting someone there that does have the access to install SchemaSpy and required programs, and generate your own interactive html pages....  (Similar to under the ERDS section for LBI)

               Here's these 12 tables to get you started, though. 

               Having issues with the 'Attachment' feature... 

              JMED
              Basic Member
              Posts: 5
              Basic Member
              10/29/2014 4:22 PM
                Thanks! However, I'm not seeing the attachment :-( did you get my private message with my email?
                John Henley
                Posts: 3353
                11/4/2014 12:55 PM

                  uploading file.

                  Attachments
                  Thanks for using the LawsonGuru.com forums!
                  John