MSCM Table structure

Sort:
You are not authorized to post a reply.
Author
Messages
Andy
New Member
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
    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
      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
        Posts: 1498
        Veteran Member
          Actually this may help?
          Attachments
          Andy
          New Member
          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
            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
              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
                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
                  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
                    Posts: 6
                    Basic Member
                      I found it. "Creation DT" provides the date and time stamp.
                      You are not authorized to post a reply.