Open Item Prompt Tables

You can add an Open Item Prompt Table to perform an online lookup of valid open item keys.

The prompt table is a SQL view that you create by selecting two fields from the Open Item Edit Record, as defined with the Open Item Account, in PeopleTools Application Designer. The two fields are:

• The Open Item Edit Field that you must rename to OPEN_ITEM_KEY in your new SQL view.

• A description field that is informational only.

Note:

Before performing modifications, complete the PeopleTools classes to learn to use the PeopleTools Application Designer and its associated database tools. Completion of the PeopleCode and SQL/SQR classes is recommended.

PeopleTools Documentation: PeopleSoft Application Designer Developer's Guide