{$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

You could leave a comment if you were logged in.