PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 08/03/2017 2:29 PM by  John Henley
Guru Data Dictionary
 15 Replies
Sort:
You are not authorized to post a reply.
Author Messages
FireGeek21
Private
Private
Veteran Member
(133 points)
Veteran Member
Posts:55


Send Message:

--
02/01/2017 11:14 AM
    Does anyone know information about accessing the data dictionaries on here? Going to Tech -> Data Dictionary -> clicking on 9.0 for tables, getting an error - 404 - File or directory not found. They have been helpful for us in the past.

    Thanks!
    Greg Moeller
    Private
    Private
    Veteran Member
    (3873 points)
    Veteran Member
    Posts:1377


    Send Message:

    --
    02/01/2017 11:30 AM
    IF you're just looking for LBI stuff.... go to ERDS.
    If you are looking for Lawson tables, shoot me an email/message.
    John Henley
    Private
    Private
    Senior Member
    (9563 points)
    Senior Member
    Posts:3205


    Send Message:

    --
    02/01/2017 12:08 PM
    The requested data dictionary links should be working again.
    Thanks for using the LawsonGuru.com forums!
    John
    FireGeek21
    Private
    Private
    Veteran Member
    (133 points)
    Veteran Member
    Posts:55


    Send Message:

    --
    02/01/2017 5:48 PM
    Thank you John! Is there a plan to discontinue having these on the site?

    Greg, the ERDS show blank boxes. The couple ERDS that show something isn't all that is needed.
    Greg Moeller
    Private
    Private
    Veteran Member
    (3873 points)
    Veteran Member
    Posts:1377


    Send Message:

    --
    02/02/2017 9:03 AM
    I've noticed that blank boxes in any browser other than IE.
    Use IE 11, with NO compatibility view. LBI 9.0.3 and to the right tabs, show all that I've ever needed.
    John Henley
    Private
    Private
    Senior Member
    (9563 points)
    Senior Member
    Posts:3205


    Send Message:

    --
    02/02/2017 10:53 AM
    Should be fixed now. The issue is that I switched LawsonGuru.com from http: to https:, and some of the content was still using http:. If you have 'allow mixed content' setting turned on in IE, it would display.
    Thanks for using the LawsonGuru.com forums!
    John
    John Henley
    Private
    Private
    Senior Member
    (9563 points)
    Senior Member
    Posts:3205


    Send Message:

    --
    02/02/2017 10:54 AM
    [quote]
    Posted By <a href='https://www.lawsonguru.com/MyProfile/tabid/502/userid/7449/Default.aspx' class='af-profile-link'>FireGeek21</a> on 02/01/2017 5:48 PM
    Thank you John! Is there a plan to discontinue having these on the site?

    [/quote]
    Why do you ask?
    Thanks for using the LawsonGuru.com forums!
    John
    FireGeek21
    Private
    Private
    Veteran Member
    (133 points)
    Veteran Member
    Posts:55


    Send Message:

    --
    02/02/2017 11:10 AM
    I ask because I, personally, have found them helpful and have suggested their viewing to others. I haven't found another resource as complete. Not everyone has moved from version 9.0 (yet) and while version 10/11 is up and coming, the 9.0 dictionaries remain valuable until another current resource is available for S3/M3.
    Greg Moeller
    Private
    Private
    Veteran Member
    (3873 points)
    Veteran Member
    Posts:1377


    Send Message:

    --
    02/02/2017 11:16 AM
    You can create your own (from your own database)....
    see my comments from 05/27/2011 3:01 here: https://www.lawsonguru.com/default....738&afpg=1

    And you can create for any databases, not just Lawson's/Infor's.
    It just takes a little time....
    ccburt
    HRIS Specialist
    Private
    New Member
    (3 points)
    New Member
    Posts:1


    Send Message:

    --
    07/20/2017 1:55 PM
    Does a data dictionary exist for version 10? (or even an updated v9?) I find the data dictionary VERY helpful but none of the ACA tables and fields are included in it.
    Greg Moeller
    Private
    Private
    Veteran Member
    (3873 points)
    Veteran Member
    Posts:1377


    Send Message:

    --
    07/20/2017 2:09 PM
    See my comments above:
    02/02/2017 11:16 AM

    You can create your own (from your own database)....
    see my comments from 05/27/2011 3:01 here: https://www.lawsonguru.com/office-a...nts-fields

    And you can create for any databases, not just Lawson's/Infor's.
    It just takes a little time....
    Greg Moeller
    Private
    Private
    Veteran Member
    (3873 points)
    Veteran Member
    Posts:1377


    Send Message:

    --
    07/20/2017 2:32 PM
    A direct link to my comments here: https://www.lawsonguru.com/forums/u...-fields/3/
    Russ M
    BA
    Crowley
    Basic Member
    (25 points)
    Basic Member
    Posts:9


    Send Message:

    --
    07/21/2017 7:46 AM
    I saw an issue for some time with the links on this site, but they appear to have been cleaned up. The admin must be out to as I 've have submitted my availability to be posted a couple of days back and it's not there. I've been told that the tables in version 10 are not that different from version 9 with few exceptions. However, I have heard that version 11 is different.
    NatalieD
    Analyst, Report Writer
    ProMedica
    Advanced Member
    (81 points)
    Advanced Member
    Posts:41


    Send Message:

    --
    07/21/2017 7:52 AM
    I'm also heard V11 is different - in fact - that all tables have been rewrittern - especially GL.
    Russ M
    BA
    Crowley
    Basic Member
    (25 points)
    Basic Member
    Posts:9


    Send Message:

    --
    07/21/2017 8:12 AM
    That may be a good thing. I have always thought the navigation around GL was a bit convoluted. Hopefully the EDI portion of 11 is not to far from 10. Version 10 is different from 9 in that respect.
    John Henley
    Private
    Private
    Senior Member
    (9563 points)
    Senior Member
    Posts:3205


    Send Message:

    --
    08/03/2017 2:29 PM
    The data dictionaries and ERDs on this site are unofficial, and are provided by me as an independent consultant. They are not provided by Lawson/Infor. In order to do that, I require access to a client's database, preferably with all, or at least most, system codes. That is the difficult part, since most clients don't have every system code, and as an independent, I don't have access to a demo/development server from Lawson/Infor. If your organization has the majority of the Infor products, don't have many customizations, and would be willing to give me access, please let me know. Originally, the scope was just the S3 (legacy Lawson) tables and needed to be free of customizations (often this required hours of work to exclude them from the final result), and were generated by scripts to create a static, yet interactive, model. At this point, the scope should ideally also cover M3, Landmark LTM/GHR and IPA, etc. etc. Alternatively, I have been designing a way to interactively work against your own database (with just your installed products, and possibly your customizations) rather than a generic data model. This would potentially be part of my Examiner for Lawson S3, or perhaps a standalone product.
    Thanks for using the LawsonGuru.com forums!
    John
    You are not authorized to post a reply.