Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Performance Management
Lawson Business Intelligence/Reporting/Crystal
Guru Data Dictionary
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Wayne Willis
Past 24 Hours:
1
Prev. 24 Hours:
1
Overall:
5190
People Online:
Visitors:
244
Members:
0
Total:
244
Online Now:
New Topics
S3 Customization/Development
Cobol - Extract Current Time
4/24/2024 7:21 PM
How do you extract just the Current System Time in
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
IPA/ProcessFlow
IPA executing Job
3/13/2024 7:08 PM
New to the IPA world and was wondering, can an IPA
Lawson S3 HR/Payroll/Benefits
Life Age Reduction on benefits plans
3/12/2024 7:15 PM
For our optional life we have an age based coverag
Lawson S3 HR/Payroll/Benefits
BN53.1 Add-In
3/7/2024 3:31 PM
We are migrating to Solstice. They require a
Lawson Business Intelligence/Reporting/Crystal
Domain Name Change
3/5/2024 7:45 PM
Our domain name needs to change and was hoping I c
S3 Customization/Development
Cobol calling Shell Script
2/29/2024 1:27 PM
Has anyone created or modified a Lawson Cobol prog
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1351
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson Business Intelligence/Reporting/Crystal
Guru Data Dictionary
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
FireGeek21
Veteran Member
Posts: 84
2/1/2017 4:14 PM
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
Veteran Member
Posts: 1498
2/1/2017 4:30 PM
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
Senior Member
Posts: 3348
2/1/2017 5:08 PM
The requested data dictionary links should be working again.
FireGeek21
Veteran Member
Posts: 84
2/1/2017 10: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
Veteran Member
Posts: 1498
2/2/2017 2:03 PM
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
Senior Member
Posts: 3348
2/2/2017 3:53 PM
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.
John Henley
Senior Member
Posts: 3348
2/2/2017 3:54 PM
[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?
FireGeek21
Veteran Member
Posts: 84
2/2/2017 4:10 PM
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
Veteran Member
Posts: 1498
2/2/2017 4:16 PM
You can create your own (from your own database)....
see my comments from 05/27/2011 3:01 here:
https://www.lawsonguru.co...d=96&aft=8738&afpg=1
And you can create for any databases, not just Lawson's/Infor's.
It just takes a little time....
ccburt
New Member
Posts: 1
7/20/2017 5: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
Veteran Member
Posts: 1498
7/20/2017 6: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.co...y-po-comments-fields
And you can create for any databases, not just Lawson's/Infor's.
It just takes a little time....
Greg Moeller
Veteran Member
Posts: 1498
7/20/2017 6:32 PM
A direct link to my comments here:
https://www.lawsonguru.co...o-comments-fields/3/
Russ M
Advanced Member
Posts: 18
7/21/2017 11: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
Veteran Member
Posts: 53
7/21/2017 11:52 AM
I'm also heard V11 is different - in fact - that all tables have been rewrittern - especially GL.
Russ M
Advanced Member
Posts: 18
7/21/2017 12:12 PM
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
Senior Member
Posts: 3348
8/3/2017 6: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.
You are not authorized to post a reply.