Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

Cannot locate Lawson table for Commodity Code data

 5 Replies
 0 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
Bev Edwards
Veteran Member
Posts: 366
Veteran Member
1/29/2013 6:09 PM
    I have looked in the following tables w/no luck:

    COMMCODES
    POCLINE
    ITEMMAST
    POLINE

    Any idea where else Commodity Code might be?

    Bev
    Joanell
    Basic Member
    Posts: 4
    Basic Member
    1/29/2013 6:59 PM
      According to SchemaSpy this is it

      AMASTITEM


      SchemaSpy is a tool to see tables and relationships.


      Kat V
      Veteran Member
      Posts: 1020
      Veteran Member
      1/29/2013 8:06 PM
        I was told it took Strategic Sourcing or Contract Management modules to write to it - the AMASTITEM was just the "holding" side of it though.

        It is possible I was misled so I'd be interested to hear if you find it.
        Michelle Wetzel
        Veteran Member
        Posts: 183
        Veteran Member
        1/29/2013 8:24 PM
          Are you talking about the commodity code that is part of the UNSPSC information? That information displays on the IC11 and is stored in the ICITEMCODE table.
          David Williams
          Veteran Member
          Posts: 1127
          Veteran Member
          1/29/2013 8:34 PM
            My understanding is that this is fed from Contract Mgmt and can't be loaded except through there.
            David Williams
            Michelle Wetzel
            Veteran Member
            Posts: 183
            Veteran Member
            1/29/2013 8:43 PM
              We've been able to do an direct upload with this information (loading the table and then loading the values onto IC11).  However, we don't have Contract Management, so i fyou do, you may different limitations.