Advanced Field Settings - Add/Edit Field

Window Details		How Do I...
	Navigation		Create or Maintain Advanced Field Settings
	Overview		Validate a Standard Field Against a User-Defined Table
	Fields

Related Topics
	Advanced Field Settings	Customizing Advanced Field Settings
	User-Defined Fields	Customizer FAQs

Navigation

Select Custom Office Main menu > User-Defined Field and Table Maintenance. Select the table to edit advanced field settings for, and then click the Advanced Field Settings button. In the Advanced Field Settings window, click the Add button or the Edit button.

This task is available only for tables in modules other than Material Requirements Planning and Work Order. This task is not available for work tables.

Overview

Use Advanced Field Settings - Add/Edit Field to create or edit advanced settings for a standard Sage 100 field, including the uppercase attribute, required attribute, and validation criteria. When setting entry validation, you can define a list of acceptable values, specify a default value, or validate the field against a user-defined table (UDT). You can create multiple settings for a field. Advanced field settings can be defined by user and company, allowing you to create settings for all users, all companies, specific users and/or specific companies.

For user-defined fields (UDFs), this window allows you to define advanced settings only for individual users and/or companies. You can define UDF settings for all users and all companies in User-Defined Fields.

You can edit advanced settings for all fields except primary key fields and read-only fields. In addition, some Sage 100 fields are shipped with pre-defined default settings, default field entry values, and/or existing validations against another table that cannot be modified. A lock button appearing next to a field indicates that the setting cannot be modified based on the restrictions of the field, user, or company selected. Clicking this button allows you to view information about the restrictions for that field attribute.

Fields

Field	User
Field Description	Company

1. Attributes
Uppercase	Required

2. Validation
Default Value	Validation