MSCM Table structure

 9 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
Andy
New Member Send Private Message
Posts: 4
New Member
We want to use Crystal reporting with MSCM outside of the canned reports. Does anybody out there have a listing of the table structure for MSCM or instruct me on how to obtain them?

Thanks
Bill Ianni
Veteran Member Send Private Message
Posts: 111
Veteran Member
Search for dbo.Lawson_Item or dbo.ITEM in the MSCM database. That should put you on the right path.


Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
I've got a picture of it... my first attempt. You'll need Oracle's Developer Data Modeler to view it though? I haven't had the time to convert the image yet. Maybe some items that aren't real clear without adjusting too?
Attachments
Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
Actually this may help?
Attachments
Andy
New Member Send Private Message
Posts: 4
New Member
WOW, thanks a million Greg, this really helps us, we just started to develop a few reports here.
jacobske
New Member Send Private Message
Posts: 2
New Member
We are also starting to write reports from MSCM outside of the canned ones.
I would be interested to know what reports you are writing. I am still somewhat struggeling getting the all of the correct data in some of the ones I am writing.
Andy
New Member Send Private Message
Posts: 4
New Member
I wrote two so far, based on what the client needs. First one is a report on how many Par Downloads are used on any given day, the next one was for RAD, to show outstanding deliveries. The document that Greg posted was excellent and this is where I first researched what tables I needed and what fields. It was hit and miss at first, but then once you figured it out, it was not too bad.
Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
You now can go to the ERDs section of this site. John has graciously posted the schema for MSCM with the tables/structures/relationships/etc so that we all may benefit.
Marisol
Basic Member Send Private Message
Posts: 6
Basic Member

I was granted access to all MSCM tables using Crystal reporting however, I cannot locate tables that tells me the time submitted/sync time.  Does anyone know how to obtain those?

Marisol
Basic Member Send Private Message
Posts: 6
Basic Member
I found it. "Creation DT" provides the date and time stamp.