Table for the Lot Category Field in Item Maintenance Options

(0) Share

Report

Posted on by Community Member

Hello:

In SmartList Builder, I'm trying to add the table that contains the Lot Category field from the Item Maintenance Options window. But, I cannot find this table.

What table holds this field?

Thanks!

John

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Tim W 2,925 on at

Like (0)

Report

The Lot Category value stores as 'Lot Type' (LOTTYPE in SQL) in iv00101. It is the key to IV40500 where the attributes are stored. Lot Attribute Descriptions is an array of 5 strings so not sure how easily that displays in SmartList but this should get you started.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Thank you, Tim!

John

Was this reply helpful? Yes No