Advanced Field Settings - Add/Edit Field

Advanced Field Settings - Add/Edit Field - Fields

Show/Hide All

Field

If you are creating a new setting, select the standard field or user-defined field (UDF) to create or maintain an advanced setting for. This field displays all fields in the selected table except for the primary key field and read-only fields. If you are editing an existing advanced setting, this field displays the field being modified and can only be viewed.

Note For UDFs, you can create advanced settings in this window only for a specific user and/or company. Access User-Defined Fields to modify UDF settings for all users and all companies. For more information, see User-Defined Fields.

Field Description

This field displays the description, data type, and maximum length for the field selected in the Field field, and can only be viewed. It also displays any values that are defined for the field, such as whether it is required, uses uppercase characters, and/or has existing validation.

User

If you are creating a new setting, select the user code that the advanced setting will apply to, or select the All check box to apply the advanced setting to all user codes. If you are editing an existing advanced setting, this field displays the user code the advanced setting is currently applied to, and can only be viewed.

Company

If you are creating a new setting, select the company code that the advanced setting will apply to, or select the All check box to apply the advanced setting to all company codes. If you are editing an existing advanced setting, this field displays the company code the advanced setting is currently applied to, and can only be viewed.

Uppercase

Select this check box to automatically change all entries in the selected field to uppercase. Clear this check box to allow mixed case and lowercase entries as well as uppercase entries. This field is available only if the All check box is selected in the User and Company fields, and if this attribute is not selected for the field by default. This field is not available for numeric fields or UDFs. You can set this attribute for UDFs in User-Defined Fields. For more information, see User-Defined Fields.

If a lock button appears next to this field, this field is not available due to one or more restrictions based on the field, user, or company selected. Click the button or hover your cursor over the button to view details regarding the restriction. For more information, see Customizing Advanced Field Settings.

Required

Select this check box to require an entry at the selected field. Clear this check box if you do not want to require an entry in the selected field. This field is available only if the All check box is selected in the User field, and if this attribute is not selected for the field by default. This field is not available for numeric fields.

If a lock button appears next to this field, this field is not available due to one or more restrictions based on the field, user, or company selected. Click the button or hover your cursor over the button to view details regarding the restriction. For more information, see Customizing Advanced Field Settings.

Default Value

Enter a default value to appear in the selected field. If the field has values that are predefined for the field by default, this field displays the predefined values. If values are entered in the List of values field that conform to the field data type and maximum length, this field displays the list of values entered.

If a lock button appears next to this field, this field is not available due to one or more restrictions based on the field, user, or company selected. Click the button or hover your cursor over the button to view details regarding the restriction. For more information, see Customizing Advanced Field Settings.

Note In some situations, the program design may override the default value entered in this field.

NOTEDefault values are not checked by business object validation; therefore, it is important to ensure that the value entered in this field is valid.

Examples of pre-defined default values for different field data types

Select

To

<CompanyCode>

display the three-character company code as the default value for a string field.

<UserCode>

display the three-character user code as the default value for a string field.

<ModuleDate>

display the module date as the default value for a date field.

<SystemDate>

display the system date as the default value for a date field.

Validation

Select the type of validation to perform for entries in this field. Validation options are available only if the All check box is selected in the User field, and if validation is not predefined for the field by default.

If a lock button appears next to this field, this field is not available due to one or more restrictions based on the field, user, or company selected. Click the button or hover your cursor over the button to view details regarding the restriction. For more information, see Customizing Advanced Field Settings.

Select None if you do not want to perform entry validation for this field.

Select Range of Values to enter a range of acceptable entry values for the field. Then enter the beginning value and ending value. Entries must be valid for the data type and maximum length. For numeric fields, enter only numeric digits. For date fields, enter dates in YYYYMMDD format, where YYYY is the four-digit year, MM is the two-digit month, and DD is the two-digit day. For string fields, you can enter any combination of alphanumeric characters up to the maximum length of the field.

Select List of Values to enter a list of acceptable entry values for the field. Press Enter after each value to enter another value. Entries must be valid for the data type and maximum length of the field. For numeric fields, enter only numbers. For date fields, enter dates in YYYYMMDD format, where YYYY is the four-digit year, MM is the two-digit month, and DD is the two-digit day. For string fields, you can enter any combination of alphanumeric characters up to the maximum length of the field.

Select User-Defined Table to validate entries in the field against a user-defined table (UDT). Then select the UDT to validate against. This field displays only UDTs whose key field length is the same as the length of the field being validated. This field is available only if the All check box is selected in the User and Company fields, UDTs with valid key field lengths exist, and the field is not predefined to validate against another table by default. For UDFs, UDT validation can be set up only in User-Defined Fields. For more information, see Validate a Standard Field Against a User-Defined Table.

Examples of valid entries for the range of values and list of values

Enter

If

20100531

20100630

20100731

the valid date entries for a date field are May 31, 2010, June 30, 2010, and July 31, 2010.

949

714

the valid entries for a numeric field with a length of three digits are 949 and 714.

East

West

South

the valid entries for a string field are East, West, and South.

Select	To
<CompanyCode>	display the three-character company code as the default value for a string field.
<UserCode>	display the three-character user code as the default value for a string field.
<ModuleDate>	display the module date as the default value for a date field.
<SystemDate>	display the system date as the default value for a date field.

Enter	If
20100531 20100630 20100731	the valid date entries for a date field are May 31, 2010, June 30, 2010, and July 31, 2010.
949 714	the valid entries for a numeric field with a length of three digits are 949 and 714.
East West South	the valid entries for a string field are East, West, and South.