{$page} 



Updated: 2010-04-30



Version: Control 4.4



Table Purpose, Usage, and Notes 



This table stores user defined fields for Products.

**//Note://** This table is no longer used in Control versions **04.40.1004.0301** and later. The data is stored in the UDFXML field of the CustomerGoodsItem table and this table is renamed to Old_ProductUserField.



Information on Table Data 
  * ClassTypeIDs Stores in Table: 
    * 12001 - Product UDFs



Table Structure 



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



[[sql_structure_-_customergoodsitem_table]]



See Also 
  * Backlinks [[include_pagepage_componentbacklinks]]