{$page}

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

See Also

You could leave a comment if you were logged in.