Updated: 2009-09-09



Version: Control 4.4



Table Purpose, Usage, and Notes 



This table is ...



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



Table Structure 



||~ Table.FieldName ||~ Data Type ||~ Description ||~ Links To ||
|| AccountUserField.ClassTypeID || int || Identifier for the Type of Object ||   ||
|| AccountUserField.ID || int || Primary Key for the Table || Account.ID  ||
|| AccountUserField.IsActive || bit || Not Used for This Table ||   ||
|| AccountUserField.IsSystem || bit || Used to Mark Required Records ||   ||
|| AccountUserField.ModifiedByComputer || nvarchar(25) || HostName of computer that last modified this record ||   ||
|| AccountUserField.ModifiedByUser || nvarchar(25) || Windows User who last modified this record ||   ||
|| AccountUserField.ModifiedDate || datetime || DateTime this Record was last modified ||   ||
|| AccountUserField.SeqID || int ||  ||   ||
|| AccountUserField.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