Select this option to allow the field to be left blank.
- This option appears only if you select Text or Date in the Type field, and you select the Validate option.
- After you click Add to create a field, you can no longer change the Allow Blank option for the field.
- If you do not allow blank entries for a field, you must specify at least one value in the detail table.
Specify the number of digits (from 0 to 9) that appear after the decimal point for values entered in the field.
Note: After you click Add to create a field, you can no longer change the decimals number for the field.
Enter a description for the field.
Enter the maximum number of characters that can be entered in the field (up to 60 characters).
- The Length field appears only if you select Text in the Type field.
- After you click Add to create a field, you can no longer change the field length.
Enter a code for the field.
Specify the type of information to be entered in the field:
- Text. Allows entry of textual (alphabetic) characters with a maximum length specified in the Length field.
- Amount. Allows entry of numeric values to 3 decimal places.
- Number. Allows entry of numeric values to a number of decimal places specified in the Decimals field (from 0 to 9).
- Integer. Allows entry of numeric values up to 2,147,483,647.
- Yes/No. Allows entry of Yes or No.
- Date. Allows entry of a date in month/day/year format.
- Time. Allows entry of a time in hour/minute/second format.
Note: After you click Add to create a field, you can no longer change the field type.
If you select this option, the only values that can be entered in the field are those specified in the detail table. (If you do not select this option, any value can be entered in the field, as long as it is consistent with the field type.)
- For a Text or Date field, you can also select the Allow Blank option to allow the field to be left blank.
-
You cannot change the Validate option after you do one of the following:
- Click Add to create the field.
- Enter a value in the detail table.
- The Validate option does not appear if you select Yes/No in the Type field.
Enter a description for the value.
Enter a value that is consistent with the type of field:
- Text. Enter a text value that does not exceed the number of characters specified in the Length field.
- Amount. Enter a numeric value with up to three characters after the decimal.
- Number. Enter a numeric value with a number of characters after the decimal that does not exceed the number of characters specified in the Decimals field.
- Integer. Enter an integer, up to 2,147,483,647.
- Date. Enter a date in the format of month/day/year.
- Time. Enter a time in the format of hour/minute/second.
Note: You can enter as many values as you want.
Overview
Note: Depending on how your system is set up, this desktop screen may also be available as a web screen. For more information, see the Web Screens Getting Started Guide or the help for Sage 300 web screens.
Use the Optional Fields screen to define system-wide optional fields for your Sage 300 database. Once you have created optional fields for your system, you can add them to each of the applications in which you want to use them.
Optional Fields let you customize your Sage 300 system by letting you store additional information with records and transaction details in any or all of the Sage 300 applications you use.
Note: There is no limit to the number of optional fields you can create. However, an excessive number of optional fields will slow down your system.