• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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.