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.