MSCM Table structure

Search for dbo.Lawson_Item or dbo.ITEM in the MSCM database. That should put you on the right path.

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?

Actually this may help?

WOW, thanks a million Greg, this really helps us, we just started to develop a few reports here.

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.

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.

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.

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?

I found it. "Creation DT" provides the date and time stamp.