Creating User Fields

To create a user field:

  1. On the UET User Fields form, select Actions > New.
  2. In the User Field Name field, enter a unique name, prefixed with "uf", to define a user field.

    NOTE: The"uf" prefix is not case sensitive, so you can enter something like Uf_Category , uf_Category, or UF_Category as a user field name.

  3. In the User Data Type field, select a user data type to define the new user field.
  4. In the Data Type field, select a standard SQL Server data type for the user field.
  5. In the Precision field, enter the number of alphanumeric characters that can be entered in the user field.
  6. In the Decimals field, if you selected Decimal in the Data Type field, enter the number of decimal places available in the user field.
  7. In the Initial Value field, enter the initial value you wish to display in the user field.
  8. In the Description field, enter a description of the user field.
  9. Save the user field.

Related Topics

User Extended Tables Overview

User Extended Tables - Steps