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

You could leave a comment if you were logged in.