Major Key Values

The system matches the major key information that you set up for a markup table to the information in billable workfile transactions.

This table lists the searches that the system can use for a major key:

Search Level

Key Type

Search Criteria

Table Used for Validation

First

1

Work Orders

Work Order Master File (F4801)

Second

2

Work Order Classes

User Defined Code 00/W7

Third

3

Contract Numbers

Contract Master (F5201)

Fourth

4

Parent Contract Numbers

Contract Master (F5201)

Fifth

5

Customer Numbers

Address Book Master (F0101)

Sixth

6

Job/Business Units

Business Unit Master (F0006)

Seventh

7

Job Classes

User Defined Code 00/11

Eighth

8

Company

Company Constants (F0010)

Ninth

9

System Default

No validation

The system uses key type 9 when it does not find a match in any of the previous levels. The system applies the remaining eligible transactions to tables with this key type. When the system does not find a match for key type 9, it uses the default markup percentage that you specified in the system constants.

Note: The system uses a different search hierarchy for major key values for advanced contracts. For advanced contracts, you can select either the funding-level, invoice-level, or contract-level contract number as the parent contract number key. In addition, the search hierarchy is: work order, work order class, business unit, job class, contract number, customer, company, and then default.