Codes in datatype column of table PROPERTYTABLE
I am a total newbie in Agile PLM. For the first time I have been given access to agile PLM schema. So I am sorry if my question is not irrelevant or not upto the mark.
I want to know what does codes in datatype column of table PROPERTYTABLE represents.
In other words, I want to know which datatype is represented by 0,1,2,3,4,5.
PROPERTYTABLE.DATATYPE details the type (text/list/number/date) of the data value that is being defined in the record. Although I am not certain of this, I believe that the list shown below correctly defines what those values mean. The vast majority of the records show as 0, 1 or 2, with 3 not too far behind. Almost none are 4, and only a few being 5. And most of the ones with 4 or 5 are to define default values.
— 0 = Text/Multitext
— 1 = List
— 2 = MultiList
— 3 = Numeric
— 4 = Date
— 5 = Money/Cost