By using this website, you agree to our Terms of Use (click here)
Hi All,
I’m trying to put a production order attribute into a GI. It looks like it is on AMProdAttribute, but when I look there I only get a partial entry.
Example:
Production order WO000296, Attribute ID = PROSTAT, Value = Issue Materials
GI for AMProdAttribute - WO000296, Attribute ID = PROSTAT, Value = IssueMat
Any idea why the GI value does not equal the value in the production order or where I should look for it?
Thanks,
Matt
Matt,
It sounds like the attribute may be a combo box. If that is the case then you'll need to join to the CSAttributeDetail DAC on the AttributeID and Value to then pull in the description which should be 'Issue Materials'.
EDIT: Sorry I totally ignored that you had JAMS. There is a Descr field in the AMProdAttribute table. That may have what you need. We only have one client on JAMS and they aren't using the attributes right now.
Thanks,
Kurt
Hi Kurt,
Thanks for the help - you were correct, it was a combo box. I linked through CSAttributeDetail to get the full name of the production attribute.
For reference, the text value of attributes is stored in the value field of AMProdAttribute.
Thanks!
-Matt
Online Members
