{$page} 



Updated: 2009-09-21



Version: Control 4.4



Table Purpose, Usage, and Notes 



This table is ...



Information on Table Data 
  * ClassTypeIDs Stores in Table:
    * 22000 - User Field
  * AssociatedClassTypeIDs
    * 2000 Customer
    * 3000 Contact
    * 10000 TransHeader
    * 12000 Product
    * 12014 PartUDFs



Table Structure 



||~ Table.FieldName ||~ Data Type ||~ Description ||~ Links To ||
|| UserFieldDef.Alignment || int ||  ||   ||
|| UserFieldDef.AllowMultiSelect || bit ||  ||   ||
|| UserFieldDef.AnswerColor || int ||  ||   ||
|| UserFieldDef.AnswerFontColor || int ||  ||   ||
|| UserFieldDef.AnswerRequired || bit ||  ||   ||
|| UserFieldDef.AnswerRequiredEst || bit ||  ||   ||
|| UserFieldDef.AnswerRequiredOrd || bit ||  ||   ||
|| UserFieldDef.AnswerRequiredST || bit ||  ||   ||
|| UserFieldDef.AnswerRequiredTemp || bit ||  ||   ||
|| UserFieldDef.AssociatedClassTypeID || int || Identifies the table this UDF is for. ||   ||
|| UserFieldDef.CategoryName || varchar(40) ||  ||   ||
|| UserFieldDef.ClassTypeID || int || Identifier for the Type of Object ||   ||
|| UserFieldDef.ClearOnClone || bit ||  ||   ||
|| UserFieldDef.ClearOnConvert || bit ||  ||   ||
|| UserFieldDef.DataType || int ||  ||   ||
|| UserFieldDef.DependentListName || varchar(100) ||  ||   ||
|| UserFieldDef.DependentUDFName || varchar(100) ||  ||   ||
|| UserFieldDef.Description || nvarchar(300) ||  ||   ||
|| UserFieldDef.DescriptionColor || int ||  ||   ||
|| UserFieldDef.DescriptionFontColor || int ||  ||   ||
|| UserFieldDef.DisplayFormatString || nvarchar(25) ||  ||   ||
|| UserFieldDef.DropdownValues || text ||  ||   ||
|| UserFieldDef.FieldIndex || int ||  ||   ||
|| UserFieldDef.FieldName || nvarchar(50) ||  ||   ||
|| UserFieldDef.ID || int || Primary Key for the Table ||   ||
|| UserFieldDef.IsActive || bit || Indicates if Enabled.  1Record is Active, 0Record is Not Active ||   ||
|| UserFieldDef.IsSystem || bit || Used to Mark Required Records ||   ||
|| UserFieldDef.LimitToList || bit ||  ||   ||
|| UserFieldDef.ModifiedByComputer || nvarchar(25) || HostName of computer that last modified this record ||   ||
|| UserFieldDef.ModifiedByUser || nvarchar(25) || Windows User who last modified this record ||   ||
|| UserFieldDef.ModifiedDate || datetime || DateTime this Record was last modified ||   ||
|| UserFieldDef.SelectionListID || int ||  ||   ||
|| UserFieldDef.SeqID || int ||  ||   ||
|| UserFieldDef.ShowClient || bit ||  ||   ||
|| UserFieldDef.ShowEquipmentPart || bit ||  ||   ||
|| UserFieldDef.ShowEstimate || bit ||  ||   ||
|| UserFieldDef.ShowFreightPart || bit ||  ||   ||
|| UserFieldDef.ShowFullContact || bit ||  ||   ||
|| UserFieldDef.ShowLaborPart || bit ||  ||   ||
|| UserFieldDef.ShowLimitedContact || bit ||  ||   ||
|| UserFieldDef.ShowLocationPart || bit ||  ||   ||
|| UserFieldDef.ShowMaterialPart || bit ||  ||   ||
|| UserFieldDef.ShowOrder || bit ||  ||   ||
|| UserFieldDef.ShowOtherPart || bit ||  ||   ||
|| UserFieldDef.ShowOutsourcePart || bit ||  ||   ||
|| UserFieldDef.ShowPersonal || bit ||  ||   ||
|| UserFieldDef.ShowProspect || bit ||  ||   ||
|| UserFieldDef.ShowService || bit ||  ||   ||
|| UserFieldDef.ShowTemplate || bit ||  ||   ||
|| UserFieldDef.ShowVendor || bit ||  ||   ||
|| UserFieldDef.SortIndex || float ||  ||   ||
|| UserFieldDef.StoreID || int || Not Used. ||   ||
|| UserFieldDef.UseDefaultColors || bit ||  ||   ||
|| UserFieldDef.UseDropdownBox || bit ||  ||   ||
|| UserFieldDef.UseListFromUDF || bit ||  ||   ||
|| UserFieldDef.UseSelectionList || bit ||  ||   ||
Related Tables 



See Also 
  * Backlinks [[include_pagepage_componentbacklinks]]