{$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:
    * 22001 - User Field Layout



Table Structure 



||~ Table.FieldName ||~ Data Type ||~ Description ||~ Links To ||
|| UserFieldLayout.AssociatedClassTypeID || int ||  ||   ||
|| UserFieldLayout.ClassTypeID || int || Identifier for the Type of Object ||   ||
|| UserFieldLayout.ID || int || Primary Key for the Table ||   ||
|| UserFieldLayout.IsActive || bit || Indicates if Enabled.  1Record is Active, 0Record is Not Active ||   ||
|| UserFieldLayout.IsSystem || bit || Used to Mark Required Records ||   ||
|| UserFieldLayout.Layout || text ||  ||   ||
|| UserFieldLayout.LayoutName || varchar(40) ||  ||   ||
|| UserFieldLayout.ModifiedByComputer || varchar(25) || HostName of computer that last modified this record ||   ||
|| UserFieldLayout.ModifiedByUser || varchar(25) || Windows User who last modified this record ||   ||
|| UserFieldLayout.ModifiedDate || datetime || DateTime this Record was last modified ||   ||
|| UserFieldLayout.SeqID || int ||  ||   ||
|| UserFieldLayout.ShowClient || bit ||  ||   ||
|| UserFieldLayout.ShowEquipmentPart || bit ||  ||   ||
|| UserFieldLayout.ShowEstimate || bit ||  ||   ||
|| UserFieldLayout.ShowFreightPart || bit ||  ||   ||
|| UserFieldLayout.ShowFullContact || bit ||  ||   ||
|| UserFieldLayout.ShowLaborPart || bit ||  ||   ||
|| UserFieldLayout.ShowLimitedContact || bit ||  ||   ||
|| UserFieldLayout.ShowLocationPart || bit ||  ||   ||
|| UserFieldLayout.ShowMaterialPart || bit ||  ||   ||
|| UserFieldLayout.ShowOrder || bit ||  ||   ||
|| UserFieldLayout.ShowOtherPart || bit ||  ||   ||
|| UserFieldLayout.ShowOutsourcePart || bit ||  ||   ||
|| UserFieldLayout.ShowPersonal || bit ||  ||   ||
|| UserFieldLayout.ShowProspect || bit ||  ||   ||
|| UserFieldLayout.ShowService || bit ||  ||   ||
|| UserFieldLayout.ShowTemplate || bit ||  ||   ||
|| UserFieldLayout.ShowVendor || bit ||  ||   ||
|| UserFieldLayout.SortIndex || int ||  ||   ||
|| UserFieldLayout.StoreID || int || Not Used. ||   ||
Related Tables 



See Also 
  * Backlinks [[http:control.cyriouswiki.cominclude_pagepage_componentbacklinks]]