The following fields display when you add a new user field or when you edit an existing user field.
If you are adding a user field, these fields display after you have entered the field name and description and clicked OK. The title at the top of the page contains the text "Creating User Defined Field xxx" where xxx is the new field name.
If you are editing a user field, the title at the top of the page contains the text "Edit User Defined Field xxx" where xxx is the field name that you are changing.
|
Field |
Description |
|
Field Name |
Name of the field that you assigned when you added the field. |
|
Description |
Description for the user field. |
|
Help Text |
Text for mouse-over help for a field. For example, enter mm/dd/yyyy for a date field. When you move the mouse over the field on the form, this text displays as a hint of the data to enter. |
|
Label |
Name of the field that displays on the form. You can change the name by entering a new name in this box. |
|
Data Type |
Determines the type of data you can enter in the field. Click the lookup button to display the choices, such as alpha uppercase or date. Select the data type that applies to your field. |
|
Control Type |
You cannot edit this field. |
|
Max Length |
Enter the maximum length (up to 64 characters) for the field contents. |
|
Min Length |
Enter the minimum length (not less than 1) for the field contents. |
|
Font Name |
Font for the user field. Click the lookup button located next to the font name text box to change the font for the field. |
|
Font Size |
Font size for the user field. Click the lookup button located next to the font size text box to change the font size for the field. |
|
Font Color |
Font color for the user field. Click the lookup button located next to the font color text box to change the font color for the field. |
|
Cell Background |
Color of a text box for the field. Click the lookup button located next to the Cell Background text box to select a new color. |
|
Default Value |
Specific default value for the field. The value that you enter here displays in the field on the form. Using default information on a form can assist in decreasing field data choices, eliminating errors, and standardizing input. |
|
Table Lookup |
Links a user field to data stored in a table on the AddVantage system. Click the lookup button to display the available tables. You can use standard AddVantage tables or user-defined tables. User-defined tables are in the 701-800 range. Use function UTNM (User Table Name Maintenance) in Volume Processing to add a user-defined table. When you use the user field on a form, the screen displays the contents of the selected table as valid entries for the field. This in no way affects the data stored on AddVantage. |
|
OK or Cancel |
Click OK to add the user field or click Cancel to exit the procedure. |
The system assigns a sequence number to each user field. This number is identified in the confirmation message that displays when you click OK.