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