infor.com
concierge
infor u
developer portal
Posts
Categories
Groups
Hubs
Developer
Healthcare
Hospitality
Public Sector
CloudSuites
Aerospace & Defense (LN)
Automotive (LN)
Chemicals (M3)
Corporate (FSM/HRT)
Distribution (Sx.e/CSD)
Distribution Enterprise (M3)
Engineering & Construction (LN)
Fashion (M3)
Food & Beverage (M3)
Healthcare (FSM/HRT)
Industrial (Syteline/CSI)
Industrial Enterprise (LN)
Manufacturing (M3)
Public Sector (FSM/HRT)
Solutions
Supply Chain Management (SCM)
Human Capital Management (HCM)
Events
Groups
Your Groups
User Groups
Migrated Forums
FSM/HCM/S3 - Infor Lawson 10.x
HCM/S3 - Learning and Development
HCM/S3 - Global HR
HCM/S3 - Talent Acquisition
HR Service Delivery
Human Capital Management (HCM) - EMEA
Infor Configuration Management for Service Industries
Lawson - Business Intelligence
Lawson - Financials
Lawson - Human Resources
Lawson - Supply Chain
Lawson - Supply Chain Management
Lawson - Technology
MSCM on Landmark
About
Community News
Email Community Support
Home
Groups
Lawson - Supply Chain Management Customer Community [READ ONLY]
Get MSCM data via LBI / SQL?
Legacy Contributor
Hi - the reports in MSCM seem to be pretty limited - especially the Operator Activity which appears to be limited to one user at a time. Has anyone had any luck getting MSCM data via LBI or SQL? Just wondering. Thx. DT
Find more posts tagged with
Comments
Legacy Contributor
Doug:
We do several reports and processes accessing MSCM with SQL.
Get a copy of the MSCM Data Model for your version. It is straight forward.
moellerg
Doug/Richard:
Or you can set up SchemaSpy and create your own web-searchable data model.
Give me a shout if you'd like more information.
-Greg Moeller
Legacy Contributor
We write some of our own Crystal reports for MSCM and post them to the Reports menu for the users to use. The MSCM Data model documents are very hard to get from Lawson.. someone gave me older version that explains how they connect and what some of the codes are that they are using and their meaning.
moellerg
For the MSCM data model, you can go here:
lawsonguru.com/.../DatabaseERDs.aspx
the last tab has a data model that I did of our MSCM database a while back... some fields may have been added, or what-not in more recent versions, but this should get you a very good start.
If you click on a table, and then scroll down in the resulting window, it should show you the relationships as well.
I'll do another one of our updated 10.1.7.3 version here next week. Perhaps I can convince John to publish that one in the same location.
Important Links
Community Hubs
Discussion Forums
Groups
Community News
Popular Tags
CPQ: Ask a Colleague
FAQs, How-To, and Best Practices
Idea
Infor OS Portal
UI Design
CPQ: Tips and Tricks
Infor Homepages
Widget Development
Infor EPM Migration
Infor Ming.le
