Defining a Summary of Supplier Performance Information

Access the Define Inquiry Columns form.

Review supplier analysis information by the columns selected on this form.

Column Name

Enter an alphanumeric code that identifies a column. A column represents a performance factor, such as the average unit cost for an item and the last cost that you paid for an item. For example, you can review performance factors to compare suppliers' costs and services for a certain item.

The system adds the value that you enter to a list of available column names.

Column Heading 1

Enter a name for the first line in the heading that describes the column on the Job Status Inquiry form. The system automatically centers this line for the column.

Formula

Enter values from the Formula Descriptions (43/FM) UDC table together with the mathematical operators that are required to determine an amount or quantity for this column. You can use a single predefined value or multiple predefined values with mathematical operators to enter a formula.

Note: Select Formula Values from the Form menu to access the 43/FM UDC.

Acceptable mathematical operators are:

+: Add.

-: Subtract.

*: Multiply.

/: Divide.

( ): Left and right parentheses for nesting.

For example, you can enter this formula to have the system calculate on-time percentages:

20/(20+21+22)

The preceding formula equals on-time percentages for these reasons:

20 is the value in UDC 43/FM for on-time amounts.

21 is the value in UDC 43/FM for early amounts.

22 is the value in UDC 43/FM for late amounts.

Decimal Positions

Enter the number of characters that appear to the right of the decimal point. For example, if you enter 2, the amount or quantity in this column would have two characters to the right of the decimal point, such as 7.00.

Edit Code

Enter a value from the Edit Codes (98/EC) UDC that determines the format of numeric data. By entering different codes, you can change the appearance of the values that appear or print.

Multiplier

Enter the factor by which the amounts or unit quantities in a column are multiplied.

The result of the calculation in the Formula field is multiplied by this factor before it appears on the Job Status Inquiry form.

For example, if you want to scale down extremely large numbers to thousands, enter 001. If you want percentages to be displayed as whole numbers, enter 100.

Glossary Item

Enter the item in the F9201 table that describes the information that a column represents. Typically, a column contains information about a supplier's performance to enable you to compare suppliers' costs and services for a certain item.

The related glossary description appears when you access field help for the column.

Sequence

Enter a value from the Sequence/Ascending /Descending (H43/SQ) UDC to specify whether the system displays information in ascending or descending order.