Setting Up a Supplemental Database Code

Access the Supplemental Database Setup form.

Supplemental Database Code

Enter a code from UDC table 00/SD, or a user-specified code from the UDC tables for systems 55 through 59.

Business Unit and Company

Specify whether the system uses the business unit and company as key fields for supplemental data.

If you select one or both of these check boxes, the Business Unit or Document Company field, or both appear as a key field on the Work With Supplemental Data form.

Generic Alphanumeric Key 1 and Generic Alphanumeric Key 2

Specify whether the system uses these as key fields for supplemental data.

If you select one or both of these check boxes, you must enter a valid data dictionary alias in the corresponding DD Alias fields. The Generic Alphanumeric Key 1 or Generic Alphanumeric Key 2 field, or both appear with the data dictionary name as a key field on the Work With Supplemental Data form.

Generic Numeric Key 1 and Generic Numeric Key 2

Specify whether the system uses these as a key field for supplemental data.

If you select one or both of these check boxes, you must enter a valid data dictionary alias in the corresponding DD Alias fields. The Generic Numeric Key 1 or Generic Numeric Key 2 field, or both appear with the data dictionary name as a key field on the Work With Supplemental Data form.

DD Alias (data dictionary alias)

Enter a valid data dictionary alias for each key field that you select. The data dictionary alias must exist in the UDC table 00/S1 (for generic numeric keys) and UDC table 00/S2 (for generic alphanumeric keys).

Row Description

To override the data dictionary name for a data dictionary alias, enter a value. The description that you enter in this field appears as the key field name on the Work With Supplemental Data form.