Understanding Field-level Prompts and Validation

Some edit box fields are linked to database prompt tables, which store values for information shared across your organization, such as department IDs, country codes, and state codes. These tables are called prompt or lookup tables because you prompt the system to look up and present a list of valid field values that reside in the prompt table. Prompt fields are defined so that the system compares the values that you enter to values that are in a prompt table to ensure that your values are valid.

Many fields validate against prompt tables. For example, currency codes and country codes are each stored in their own tables: the CURRENCY_CD_TBL and COUNTRY_TBL tables. Fields prompting against these kinds of prompt tables appear on the page as edit boxes with a lookup button to the right.

Term	Definition
	Click to open the Look Up page for the current field.
	Click to open a small calendar that displays the current month.

Note:

Alternatively, you can press ALT+5 while in a prompt or calendar field to open the lookup page or the calendar, respectively.