PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 12/20/2016 10:06 AM by  Marisol
MSCM Table structure
 9 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Andy
Private
Private
New Member
(8 points)
New Member
Posts:4


Send Message:

--
08/01/2010 7:37 AM
    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
    Tags: MSCM Tables
    Bill Ianni
    Private
    Private
    Veteran Member
    (294 points)
    Veteran Member
    Posts:98


    Send Message:

    --
    08/02/2010 7:30 AM
    Search for dbo.Lawson_Item or dbo.ITEM in the MSCM database. That should put you on the right path.


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


    Send Message:

    --
    03/03/2011 11:42 AM
    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
    Private
    Private
    Veteran Member
    (3873 points)
    Veteran Member
    Posts:1377


    Send Message:

    --
    03/03/2011 11:56 AM
    Actually this may help?
    Attachments
    Andy
    Private
    Private
    New Member
    (8 points)
    New Member
    Posts:4


    Send Message:

    --
    03/04/2011 1:46 PM
    WOW, thanks a million Greg, this really helps us, we just started to develop a few reports here.
    jacobske
    Private
    Private
    New Member
    (4 points)
    New Member
    Posts:2


    Send Message:

    --
    05/17/2011 7:45 AM
    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
    Private
    Private
    New Member
    (8 points)
    New Member
    Posts:4


    Send Message:

    --
    05/17/2011 8:16 AM
    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
    Private
    Private
    Veteran Member
    (3873 points)
    Veteran Member
    Posts:1377


    Send Message:

    --
    05/19/2011 11:29 AM
    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
    BA
    Private
    Basic Member
    (10 points)
    Basic Member
    Posts:4


    Send Message:

    --
    12/20/2016 9:47 AM

    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
    BA
    Private
    Basic Member
    (10 points)
    Basic Member
    Posts:4


    Send Message:

    --
    12/20/2016 10:06 AM
    I found it. "Creation DT" provides the date and time stamp.
    You are not authorized to post a reply.