Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

Cannot locate Lawson table for Commodity Code data

5 Replies

0 Subscribed to this topic

40 Subscribed to this forum

Sort:

Author

Messages

Bev Edwards

Veteran Member

Posts: 366

New Poster

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

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

New Poster

Engaged Reader

Avid Reader

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

New Poster

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

New Poster

1/29/2013 8:34 PM

My understanding is that this is fed from Contract Mgmt and can't be loaded except through there.

Michelle Wetzel

Veteran Member

Posts: 183

New Poster

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.