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
You could leave a comment if you were logged in.