Updated: 2010-04-30



Version: Control 4.4



Table Purpose, Usage, and Notes 

**//Note://** This table is no longer used in Control versions **04.40.1004.0301** and later. The data is stored in the UDFXML field of the Part table and this table is renamed to Old_PartUserField



Information on Table Data 
  * ClassTypeIDs Stores in Table: 
    * 12015 - Part UDFs



Table Structure 



||~ Table.FieldName ||~ Data Type ||~ Description ||~ Links To ||
|| PartUserField.ClassTypeID || int || Identifier for the Type of Object ||   ||
|| PartUserField.ID || int || Primary Key for the Table || Part.ID ||
|| PartUserField.IsActive || bit || Not Used for This Table ||   ||
|| PartUserField.IsSystem || bit || Used to Mark Required Records ||   ||
|| PartUserField.ModifiedByComputer || nvarchar(25) || HostName of computer that last modified this record ||   ||
|| PartUserField.ModifiedByUser || nvarchar(25) || Windows User who last modified this record ||   ||
|| PartUserField.ModifiedDate || datetime || DateTime this Record was last modified ||   ||
|| PartUserField.SeqID || int ||   ||   ||
|| PartUserField.StoreID || int || Not Used. ||   ||
Additional Fields are added at the end of all UDF tables based on the UDFs created by the user. The basic data types of these UDFs are: \\ ||~ UDF Type ||~ SQL Data Type ||
|| Numeric || float ||
|| String, Editbox, Drop-Down || Text ||
|| Date, Time, DateTime || datetime ||
|| Yes/No || nvarchar(1) ||
Related Tables 



[[sql_structure_-_part_table]]