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 |
Sort Level Options
JB T&M Template Setup
