{$page} 



Updated: 2009-09-09



Version: Control 4.4



Table Purpose, Usage, and Notes 



This table is ...



Information on Table Data 
  * ClassTypeIDs Stores in Table:
    * 3001 - Account Contact UDFs



Table Structure 



||~ Table.FieldName ||~ Data Type ||~ Description ||~ Links To ||
|| AccountContactUserField.ClassTypeID || int || Identifier for the Type of Object ||   ||
|| AccountContactUserField.ID || int || Primary Key for the Table || AccountContact.ID  ||
|| AccountContactUserField.IsActive || bit || Not Used for This Table ||   ||
|| AccountContactUserField.IsSystem || bit || Used to Mark Required Records ||   ||
|| AccountContactUserField.ModifiedByComputer || nvarchar(25) || HostName of computer that last modified this record ||   ||
|| AccountContactUserField.ModifiedByUser || nvarchar(25) || Windows User who last modified this record ||   ||
|| AccountContactUserField.ModifiedDate || datetime || DateTime this Record was last modified ||   ||
|| AccountContactUserField.SeqID || int ||  ||   ||
|| AccountContactUserField.StoreID || int || Not Used. ||   ||
Additional Fields are added at the end of all UDF tables based on the UDFs created by the user.  The basic data types of these UDFs are: \\ ||~ UDF Type ||~ SQL Data Type ||
|| Numeric || float ||
|| String, Editbox, Drop-Down || Text ||
|| Date, Time, DateTime || datetime ||
|| Yes/No || nvarchar(1) ||
Related Tables 



See Also 
  * Backlinks [[include_pagepage_componentbacklinks]]