Sort Level

Enter the sort level (1-14) for the source/sequence. This will identify the order in which detail will be sorted. The sort level will differ depending on the source. For a complete list of sort level descriptions by source, click the icon below.

For example, if the Sequence source is PR (Labor/Burden Cost Type) and “4” (Craft/Class) is entered in the Sum Option field, it would not be beneficial to set the Sort Level to “1” (Employee/Craft/Class/Earnings Type). The system would not be able to sort at this level because employees were not included in the detail summarization and would not be found during the sort process. It would be more beneficial instead, to enter “2” (Craft/Class/Employee/Earnings Type) in the Sum Option field. Detail would be sorted at the Craft/Class level, but further sorting at the Employee/Earnings Type level would not occur because the detail would not be available.

The following table lists the sort levels available for each source:

Source

Sort Level

Description

PR - Labor/Burden CT

1

Employee/Craft/Class/Earn Type

2

Craft/Class/Employee/Earn Type

3

Category/Employee/Craft/Class/Earn Type

4

Category/Craft/Class/Employee/Earn Type

5

Employee/Craft/Class/Factor

6

Craft/Class/Employee/Factor

7

Category/Employee/Craft/Class/Factor

8

Category/Craft/Class/Employee/Factor

9

Craft/Class/Liability Type/Employee

10

Category/Craft/Class/Employee/Liability Type

13

Craft/Class/Employee/Factor/EarnType

14

Craft/Class/Employee/Factor/Shift

PR-Equipment CT

11

EMCo/Equip/EMGroup/RevCode/Employee/Craft/Class

12

EMCo/Equip/EMGroup/RevCode/Craft/Class/ Employee

IN/MS - Material CT

1

Material/Location

2

Location/Material

3

Category/Material/Location

4

Location/Category/Material

MaterialCT - AP

1

Material/Vendor/APRef

2

Vendor/APRef/Material

3

Category/Material/Vendor/APRef

4

Vendor/APRef/Category/Material

5

PO/POItem/Vendor/APRef/Material

6

PO/Vendor/APRef/Material

7

Vendor/APRef/PO/POItem/Material

8

Vendor/APRef/PO/Material

AP - Expense

1

Vendor/APRef

(not material or subcontract)

2

PO/POItem/Vendor/APRef

3

PO/Vendor/APRef

4

Vendor/APRef/PO/POItem

5

Vendor/APRef/PO

AP - Subledger CT

1

SL/SLItem/Vendor/APRef

2

SL/Vendor/APRef

3

Vendor/APRef/SL/SLItem

4

Vendor/APRef/SL

EM - Equipment CT

1

EMCo/Equip/EMGroup/RevCode

2

EMGroup/RevCode/EMCo/Equip

3

Category/EMCo/Equip/EMGroup/RevCode

4

EMGroup/RevCode/Category/EMCo/Equip

11

EMCo/Equip/EMGroup/RevCode/Employee/Craft/Class

12

EMCo/Equip/EMGroup/RevCode/Craft/Class/ Employee

Note: Summary levels are not used if the sequence type is “N-No Bill,” “A-Amount,” “T-Total Addon,” or “D-Detail.”.

Sort Level Options

JB T&M Template Setup