Where do I go to see UD table description and column descriptions for said UD table? (I’m not talking about UD fields appended to existing tables… I see those entries in the ‘Extended User Defined Table Management’ area).
We have UD01 and UD02 setup as ICE forms. It seems that whoever setup these up before me used columns in UD02 on multiple ICE forms. I’m trying to determine what these columns of data are. Outside of of opening each form manually and selecting each field to note what it is used for, is there a place that works like the Extended UD Table Management area, but for just plain ole UD Tables?
Someone correct me if I am wrong but you can’t change the names of the columns on the built-in UD tables.
Unfortunately, you will have to do it like you said.
I am looking to manage just the labels, not renaming the fields. I thought it would show up in Extended Properties Maint, but I’m not sure. When I ran the Analyzer, the area for UD Tables return a couple that are in use with a description, UD02 being “Labor Comment Codes”.
When I pull up UD02 in Extended Properties maint, I don’t see “Labor Comment Codes” anywhere. Searching the description column in dbo.zDataTable I don’t see any entry with “Labor Comment Codes”. Where is Analyzer getting this description from? Any ideas??