Menu Path: System Administration Module Setup User Defined Fields Maintenance
Set up valid user-defined fields with optional validation rules for selected types of information.
Use User Defined Fields Maintenance to create user-defined fields for the following:
bank accounts
bills of lading
chargebacks
contacts
containers
credit tasks
customers
direct debit mandates
hazard codes
lots
market segments
orders
order line items
products
purchase orders
purchase order line items
sales contracts
sales representatives
shipments
styles
suppliers
units of measure
work orders
work order line items
You can select to validate the values in these fields if they are used for analytical purposes (such as Business Intelligence Cognos cubes). This window controls the labeling, format, and validation of these fields.
For database information for this window, see User Defined Fields Maintenance Database Information.
To update user-defined fields:
Select the type of fields you want to update. For more information, see User Definition Type below.
Click the Update button in the ribbon.
Enter labels for the fields, select whether to validate data in the fields, and select the type of data to store in the fields.
If you are validating fields, enter a valid value in the Valid Value field and a description of the valid value in the Description field, then click the Add button. Repeat this for all valid values for the field. You can select a valid value, and click the Remove button to delete it. You can also clear the check box in the Active grid column to mark a value as inactive.
Click the OK button in the ribbon. The fields are updated.
Button |
Description |
Exit |
Click this button to close the User Defined Fields Maintenance window. |
Update |
Click this button to update the user-defined fields for the selected user definition type. |
OK |
Click this button to accept an action. This button is only available after you click the Update button in the ribbon. |
Cancel |
Click this button to cancel an action. This button is only available after you click the Update button in the ribbon. |
Show Data |
Click this button to display values associated with a field selected if the Display Where Used radio button is selected. |
Label Maintenance |
Click this button to display Label Maintenance, which allows you to maintain user-defined field labels. |
Field or Button |
Description |
Select the type of user-defined fields.
|
|
Select one of the following options:
Example This is how you could view every Customer that had a value of ABC in user-defined field 7. |
|
Enter values in this field to be validated during entry. Note The User Defined Validation check box must be selected for the user-defined field if you want values to be validated during entry. |
|
Click this button to add more values to the validation list for user-defined fields. |
|
Enter a description of the entered valid value. |
|
Click this button to remove values from the validation list for user-defined fields. Note Values cannot be removed if they are already being used by the type. Example If user-defined field 1 for a product type had a value of 1234, and Product ABC had 1234 stored for its user-defined field 1, then 1234 could not be removed. |
|
Select one of the user-defined fields based on the User Definition Type currently selected. |
|
When the Display Where Used radio button is selected, select the value associated with the field selected. |
|
This grid displays valid values for the selected user-defined field. This grid is only available if you select the Display Valid Value List radio button. You can enter the description associated with each valid value in this grid. You can also use the Active column to mark each value as active or inactive. |
|
This grid displays records where the selected value for the selected user-defined field is used after you click the Show Data button in the ribbon. This grid is only available if you select the Display Where Used radio button. |
|
This grid displays user-defined fields. This grid includes the following columns:
Example You set up a user-defined field with a label Country of Origin, and enter All Countries of Origin for this column. Users will then be able to select the All Countries of Origin check box when filtering data for the user-defined field.
NOTE You cannot change the format of an existing field if it already has user-defined valid values entered in it.
|