Item Number "Alternate Item"

[iwells]

Hi,

In Sage 2014 there's a field on the Item screen which says "Alternate Item" and I've tried finding what table that information is stored in but can't ... can someone tell me where that's stored?

Thanks,
Ian

 

[Jay Converse]

ICITEM

Sage 300 Whisperer

 

[iwells]

if i do a select * from icitem for itemno = '01123-50830' i see nothing related to the alternate item no of "0112350830" with no dash ... what is the field name?

 

[Jay Converse]

ALTSET

Sage 300 Whisperer

 

[iwells]

yea i see that, but altset looks like an auto-increment counter that links to another table ... in my example above the altset value = 61 which is a lookup in another table ... which table? is it the rowid of the same table, doesn't look like it can be.

 

[Jay Converse]

It links to itself.

Sage 300 Whisperer

 

[iwells]

lol I see now ...