Revenova PayIQ Log Dictionary

The end of the start method of the Match Loads to PayIQ Participants job.

All pay programs/periods were loaded and aggregates reset in {elapsed ms}ms

The end of each iteration of the Match Loads to PayIQ Participants job (1 created).

1 participant match was created in {elapsed ms}ms

The end of each iteration of the Match Loads to PayIQ Participants job (N created).

{count} participant matches were created in {elapsed ms}ms

The end of the finish method of the Match Loads to PayIQ Participants job (1 created).

Match Loads To PayIQ Participants completed. 1 participant match was created in {elapsed ms}ms

The end of the finish method of the Match Loads to PayIQ Participants job (N created).

Match Loads to PayIQ Participants completed. {count} participant matches were created in {elapsed ms}ms

The end of the start method of the Match Driver Logs to PayIQ Participants job.

All pay programs/periods were loaded and aggregates reset in {elapsed ms}ms

The end of each iteration of the Match Driver Logs to PayIQ Participants job (1 created).

1 participant match was created in {elapsed ms}ms

The end of each iteration of the Match Driver Logs to PayIQ Participants job (N created).

{count} participant matches were created in {elapsed ms}ms

The end of the finish method of the Match Driver Logs to PayIQ Participants job (1 created).

Match Driver Logs to PayIQ Participants completed. 1 participant match was created in {elapsed ms}ms

The end of the finish method of the Match Driver Logs to PayIQ Participants job (N created).

Match Driver Logs to PayIQ Participants completed. {count} participant matches were created in {elapsed ms}ms

The end of the start method of the Match Trip Plan Legs to PayIQ Participants job.

All pay programs/periods were loaded and aggregates reset in {elapsed ms}ms

The end of each iteration of the Match Trip Plan Legs to PayIQ Participants job (1 created).

1 participant match was created in {elapsed ms}ms

The end of each iteration of the Match Trip Plan Legs to PayIQ Participants job (N created).

{count} participant matches were created in {elapsed ms}ms

The end of the finish method of the Match Trip Plan Legs to PayIQ Participants job.

Match Trip Plan Legs To PayIQ Participants completed. 1 participant match was created in {elapsed ms}ms

The end of the finish method of the Match Trip Plan Legs to PayIQ Participants job (N created).

Match Trip Plan Legs To PayIQ Participants completed. {count} participant matches were created in {elapsed ms}ms

The end of each iteration of the Clear Out Unapproved Pay job (1st Iteration - 1 deleted).

1 pay detail was deleted in {elapsed ms}ms

The end of each iteration of the Clear Out Unapproved Pay job (1st iteration - N deleted).

{count} pay details were deleted in {elapsed ms}ms

The end of the finish method of the Clear Out Unapproved Pay job (1st iteration - 1 deleted).

Clear Out Unapproved Pay completed. 1 pay detail was deleted in {elapsed ms}ms

The end of the finish method of the Clear Out Unapproved Pay job (1st iteration - N deleted).

Clear Out Unapproved Pay completed. {count} pay details were deleted in {elapsed ms}ms

The end of each iteration of the Clear Out Unapproved Pay job (2nd Iteration - 1 deleted).

1 pay adjustment was deleted in {elapsed ms}ms

The end of each iteration of the Clear Out Unapproved Pay job (2nd iteration - N deleted).

{count} pay adjustments were deleted in {elapsed ms}ms

The end of the finish method of the Clear Out Unapproved Pay job (2nd Iteration - 1 deleted).

Clear Out Unapproved Pay completed. 1 pay adjustment was deleted in {elapsed ms}ms

The end of the finish method of the Clear Out Unapproved Pay job (2nd Iteration - N deleted).

Clear Out Unapproved Pay completed. {count} pay adjustments were deleted in {elapsed ms}ms

The end of the start method of the Generate Tier Pay job.

All pay programs/periods were loaded and aggregates reset in {elapsed ms}ms

The end of each iteration of the Generate Tier Pay job (1 created).

1 pay detail was created in {elapsed ms}ms

The end of each iteration of the Generate Tier Pay job (N created).

{count} pay details were created in {elapsed ms}ms

The end of the finish method of the Generate Tier Pay job (1 created).

Generate Tier Pay completed. 1 pay detail was created in {elapsed ms}ms

The end of the finish method of the Generate Tier Pay job (N created).

Generate Tier Pay completed. {count} pay details were created in {elapsed ms}ms

The end of the start method of the Generate Accessorial Pay job.

All pay programs/periods were loaded in {elapsed ms}ms

The end of each iteration of the Generate Accessorial Pay job (1 created).

1 pay detail was created in {elapsed ms}ms

The end of each iteration of the Generate Accessorial Pay job (N created).

{count} pay details were created in {elapsed ms}ms

The end of the finish method of the Generate Accessorial Pay job (1 created).

Generate Accessorial Pay completed. 1 pay detail was created in {elapsed ms}ms

The end of the finish method of the Generate Accessorial Pay job (N created).

Generate Accessorial Pay completed. {count} pay details were created in {elapsed ms}ms

The end of each iteration of the Copy Over Pay Estimate Adjustments job (1 created).

1 adjustment was created in {elapsed ms}ms

The end of each iteration of the Copy Over Pay Estimate Adjustments job (N created).

{count} adjustments were created in {elapsed ms}ms

The end of the finish method of the Copy Over Pay Estimate Adjustments job (1 created).

Copy Over Pay Estimate Adjustments completed. 1 adjustment was created in {elapsed ms}ms

The end of the finish method of the Copy Over Pay Estimate Adjustments job (N created).

Copy Over Pay Estimate Adjustments completed. {count} adjustments were created in {elapsed ms}ms

The end of each iteration of the Generate Adjustments job (1 created).

1 create/update for adjustments was processed in {elapsed ms}ms

The end of each iteration of the Generate Adjustments job (N created).

{count} creates/updates for adjustments were processed in {elapsed ms}ms

The end of the finish method of the Generate Adjustments job (1 created).

Generate Adjustments completed. 1 create/update for adjustments was processed in {elapsed ms}ms

The end of the finish method of the Generate Adjustments job (N created).

Generate Adjustments completed. {count} creates/updates for adjustments were processed in {elapsed ms}ms

During Match Loads To PayIQ Participants, Match Driver Logs to PayIQ Participants, or Match Trip Plan Legs To PayIQ Participants

Filter Not Met

Filter from program "{PayIQ Program}" not met: {Field Name} {Operator} {Filter Value}, Actual: {Value}

Load, Driver Log, or Trip Plan Leg

During Generate Tier Pay

Within Tier Calculation (Informational)

[Within {Tier Name} calculation] = [From] < [{Tier Criteria}] <= [To] = {Tier From} < {Criteria from Load} <= {Tier To}

Pay Detail

During Match Loads To PayIQ Participants, Match Driver Logs To PayIQ Participants, or Match Trip Plan Legs To PayIQ Participants

Eligible Date did not fall within date range for effective/expiration date for participant

Eligible date {Eligible Date} not within date range for {Participant Name}: {Effective Date} - {Expiration Date}

Load, Driver Log, or Trip Plan Leg

During Match Loads To PayIQ Participants, Match Driver Logs To PayIQ Participants, or Match Trip Plan Legs To PayIQ Participants

No Eligible Date set on Load/Driver Log/Trip Plan Leg

No eligible date set via {Parent Object} field {Eligible Date Field} on {Parent Object}: {Parent Object Name}

Load, Driver Log, or Trip Plan Leg

During Match Loads to PayIQ Participants, Match Driver Logs To PayIQ Participants, or Match Trip Plan Legs To PayIQ Participants

PayIQ Program not open

PayIQ Program not open: {PayIQ Program Name}

Load

During Match Loads to PayIQ Participants, Match Driver Logs To PayIQ Participants, or Match Trip Plan Legs To PayIQ Participants

Pay Schedule not open

Pay Schedule not open

Load, Driver Log, or Trip Plan Leg

During Match Loads to PayIQ Participants, Match Driver Logs To PayIQ Participants, or Match Trip Plan Legs to PayIQ Participants

No Pay Periods matched to Eligible Date

No Pay Periods matched to date: {Eligible Date}

Load, Driver Log, or Trip Plan Leg

During Match Loads to PayIQ Participants, Match Driver Logs To PayIQ Participants, or Match Trip Plan Legs To PayIQ Participants

Pay period matched to date not open

Pay Period matched to date is not open: {Eligible Date}

Load, Driver Log, or Trip Plan Leg

During Match Loads to PayIQ Participants while validating Load Roles on the PayIQ Program

No matching periods found for Eligible Date

No open pay periods matched to date: {Eligible Date}

Load

During Match Loads to PayIQ Participants

No User found assigned on Load Role Field

No user assigned via Load field {Load Role Field} on Load {Load Name}

Load

During Match Loads to PayIQ Participants

No Contact found assigned on Load Role field

No contact assigned via Load field {Load Role Field} on Load {Load Name}

Load

During Match Loads to PayIQ Participants

No matching PayIQ Program Participant found for User

No program participant found for user: {User Name}

Load

During Match Loads to PayIQ Participants

No matching PayIQ Program Participant found for Contact

No program participant found for contact: {Contact Name}

Load

During Match Driver Logs To PayIQ Participants or Match Trip Plan Legs To PayIQ Participants

No matching PayIQ Program Participant found for Driver

No program participant found for driver: {Driver Name}

Driver Log or Trip Plan Leg

During Match Driver Logs To PayIQ Participants or Match Trip Plan Legs To PayIQ Participants

No matching PayIQ Program Participant found for Fleet Asset

No program participant found for fleet asset: {Fleet Asset}

Trip Plan Leg

During Match Loads to PayIQ Participants or Match Trip Plan Legs To PayIQ Participants

Freight Plan Load Criteria defined on PayIQ Program not met

Freight Plan Load Criteria {PayIQ Program Freight Plan Load Criteria} not met for freight plan: {Freight Plan Name}

Load

During Generate Tier Pay

Criteria did not fall within tier

Metric {Criteria} did not fall within {Tier Name} ({Tier From} < {Tier Criteria} <= {Tier To})

Load, Driver Log, or Trip Plan Leg

During Generate Tier Pay

Pay Detail amount is zero

Did not create zero amount pay detail

Load, Driver Log, or Trip Plan Log

During Match Loads to PayIQ Participants and Match Legs To PayIQ Participants (when paying off load)

Margin (Invoiced) for Carrier Load taken from Freight Plan according to Cost Contribution, per PayIQ Program.

[{Freight Plan Name} : Margin (Invoiced)] =

[Customer Load Margin] x [Cost Contribution Ratio] =

([Customer Load Revenue] - [Customer Load Cost] - [Customer Load Cost Allocation]) x ([Carrier Load Cost] / ([Customer Load Cost] + [Customer Load Cost Allocation])) =

({Customer Load Revenue (Invoiced)} - {Customer Load Cost (Invoiced)} - {Customer Load Cost Allocation (Invoiced)}) x ({Carrier Load Cost (Invoiced)} / ({Customer Load Cost (Invoiced)} + {Customer Load Cost Allocation (Invoiced)})) =

{Margin (Invoiced)} {Participant Currency}

Participant Match

During Match Loads to PayIQ Participants and Match Legs to PayIQ Participants (when paying off load)

Revenue (Invoiced) for Carrier Load from Freight Plan according to cost contribution, per PayIQ Program.

[{Freight Plan Name} : Revenue (Invoiced)] =

[Customer Load Revenue] x [Cost Contribution Ratio] =

[Customer Load Revenue] x ([Carrier Load Cost] / ([Customer Load Cost] + [Customer Load Cost Allocation])) =

{Customer Load Revenue (Invoiced)} x ({Carrier Load Cost} / ({Customer Load Cost (Invoiced} + {Customer Load Cost Allocation (Invoiced)})) =

{Revenue (Invoiced)} {Participant Currency}

Participant Match

During Match Loads to PayIQ Participants and Match Legs to PayIQ Participants (when paying off load)

Freight (Invoiced) for Carrier Load from Freight Plan according to cost contribution, per PayIQ Program.

[{Freight Plan Name} : Freight (Invoiced)] = [Customer Load Freight ] x [Cost Contribution Ratio] = [Customer Load Freight] x ([Carrier Load Cost] / ([Customer Load Cost] + [Customer Load Cost Allocation])) = {Customer Load Freight (Invoiced)} x ({Carrier Load Cost} / ({Customer Load Cost (Invoiced} + {Customer Load Cost Allocation (Invoiced)})) = {Freight (Invoiced)} {Participant Currency}

Participant Match

During Match Loads to PayIQ Participants and Match Legs to PayIQ Participants (when paying off load)

Fuel (Invoiced) for Carrier Load from Freight Plan according to cost contribution, per PayIQ Program.

[{Freight Plan Name } : Fuel (Invoiced)] = [Customer Load Fuel] x [Cost Contribution Ratio] = [Customer Load Fuel] x ([Carrier Load Cost] / ([Customer Load Cost] + [Customer Load Cost Allocation])) = {Customer Load Fuel (Invoiced)} x ({Carrier Load Cost} / ({Customer Load Cost (Invoiced} + {Customer Load Cost Allocation (Invoiced)})) = {Fuel (Invoiced)} {Participant Currency}

Participant Match

During Match Loads to PayIQ Participants and Match Legs to PayIQ Participants (when paying off load)

Margin (Quoted) for Carrier Load from Freight Plan according to cost contribution, per PayIQ Program.

[{Freight Plan Name} : Margin (Quoted)] =

[Customer Load Margin] x [Cost Contribution Ratio] =

([Customer Load Revenue] - [Customer Load Cost] - [Customer Load Cost Allocation]) x ([Carrier Load Cost] / ([Customer Load Cost] + [Customer Load Cost Allocation])) =

({Customer Load Revenue (Quoted)} - {Customer Load Cost (Quoted)} - {Customer Load Cost Allocation (Quoted)}) x ({Carrier Load Cost (Quoted)} / ({Customer Load Cost (Quoted)} + {Customer Load Cost Allocation (Quoted)})) =

{Margin (Quoted)} {Participant Currency}

Participant Match

During Match Loads to PayIQ Participants and Match Legs to PayIQ Participants (when paying off load)

Revenue (Quoted) for Carrier Load from Freight Plan according to cost contribution, per PayIQ Program.

[{Freight Plan Name} : Revenue (Quoted)] =

[Customer Load Revenue] x [Cost Contribution Ratio] =

[Customer Load Revenue] x ([Carrier Load Cost] / ([Customer Load Cost] + [Customer Load Cost Allocation])) =

{Customer Load Revenue (Quoted)} x ({Carrier Load Cost} / ({Customer Load Cost (Quoted} + {Customer Load Cost Allocation (Quoted)})) =

{Revenue (Quoted)} {Participant Currency}

Participant Match

During Match Loads to PayIQ Participants and Match Legs to PayIQ Participants (when paying off load)

Freight (Quoted) for Carrier Load from Freight Plan according to cost contribution, per PayIQ Program.

[{Freight Plan Name} : Freight (Quoted)] = [Customer Load Freight ] x [Cost Contribution Ratio] =

[Customer Load Freight] x ([Carrier Load Cost] / ([Customer Load Cost] + [Customer Load Cost Allocation])) =

{Customer Load Freight (Quoted)} x ({Carrier Load Cost} / ({Customer Load Cost (Quoted} + {Customer Load Cost Allocation (Quoted)})) = {Freight (Quoted)} {Participant Currency}

Participant Match

During Match Loads to PayIQ Participants and Match Legs to PayIQ Participants (when paying off load)

Fuel (Quoted) for Carrier Load from Freight Plan according to cost contribution, per PayIQ Program.

[{Freight Plan Name} : Fuel (Quoted)] = [Customer Load Fuel] x [Cost Contribution Ratio] =

[Customer Load Fuel] x ([Carrier Load Cost] / ([Customer Load Cost] + [Customer Load Cost Allocation])) =

{Customer Load Fuel (Quoted) } x ({Carrier Load Cost} / ({Customer Load Cost (Quoted} + {Customer Load Cost Allocation(Quoted)})) =

{Fuel (Quoted)} {Participant Currency}

Participant Match

During Match Loads to PayIQ Participants and Match Legs to PayIQ Participants (when paying off load)

Margin (Invoiced) for Carrier Load from Freight Plan according to distance contribution, per PayIQ Program.

[{Freight Plan Name} : Margin (Invoiced)] =

[Customer Load Margin] x [Distance Contribution Ratio] =

([Customer Load Revenue] - [Customer Load Cost] - [Customer Load Cost Allocation]) x ([Carrier Load Distance] / [Customer Load Distance]) =

({Customer Load Revenue (Invoiced)} - {Customer Load Cost (Invoiced)} - {Customer Load Cost Allocation (Invoiced)}) x ({Carrier Load Distance} / {Customer Load Distance}) =

{Margin (Invoiced)} {Participant Currency}

Participant Match

During Match Loads to PayIQ Participants and Match Legs to PayIQ Participants (when paying off load)

Revenue (Invoiced) for Carrier Load from Freight Plan according to distance contribution, per PayIQ Program.

[{Freight Plan Name} : Revenue (Invoiced)] =

[Customer Load Revenue] x [Distance Contribution Ratio] =

[Customer Load Revenue] x ([Carrier Load Distance] / [Customer Load Distance]) =

{Customer Load Revenue (Invoiced)} x ({Carrier Load Distance} / {Customer Load Distance}) =

{Revenue (Invoiced)} {Participant Currency}

Participant Match

During Match Loads to PayIQ Participants and Match Legs to PayIQ Participants (when paying off load)

Freight (Invoiced) for Carrier Load from Freight Plan according to distance distribution, per PayIQ Program.

[{Freight Plan Name} : Freight (Invoiced)] = [Customer Load Freight] x [Distance Contribution Ratio] =

[Customer Load Freight] x ([Carrier Load Distance] / [Customer Load Distance]) =

{Customer Load Freight (Invoiced)} x ({Carrier Load Distance} / {Customer Load Distance}) =

{Freight (Invoiced)} {Participant Currency}

Participant Match

During Match Loads to PayIQ Participants and Match Legs to PayIQ Participants (when paying off load)

Fuel (Invoiced) for Carrier Load from Freight Plan according to distance contribution, per PayIQ Program.

[{Freight Plan Name} : Fuel (Invoiced)] = [Customer Load Fuel] x [Distance Contribution Ratio] =

[Customer Load Fuel] x ([Carrier Load Distance] / [Customer Load Distance]) =

{Customer Load Fuel (Invoiced)} x ({Carrier Load Distance} / {Customer Load Distance}) =

{Fuel (Invoiced)} {Participant Currency}

Participant Match

During Match Loads to PayIQ Participants and Match Legs to PayIQ Participants (when paying off load)

Margin (Quoted) for Carrier Load from Freight Plan according to distance contribution, per PayIQ Program.

[{Freight Plan Name} : Margin (Quoted)] =

[Customer Load Margin] x [Distance Contribution Ratio] =

([Customer Load Revenue] - [Customer Load Cost] - [Customer Load Cost Allocation]) x ([Carrier Load Distance] / [Customer Load Distance]) =

({Customer Load Revenue (Quoted)} - {Customer Load Cost (Quoted)} - {Customer Load Cost Allocation (Quoted)}) x ({Carrier Load Distance} / {Customer Load Distance}) =

{Margin (Quoted)} {Participant Currency}

Participant Match

During Match Loads to PayIQ Participants and Match Legs to PayIQ Participants (when paying off load)

Revenue (Quoted) for Carrier Load from Freight Plan according to distance contribution, per PayIQ Program.

[{Freight Plan Name} : Revenue (Quoted)] =

[Customer Load Revenue] x [Distance Contribution Ratio] =

[Customer Load Revenue] x ([Carrier Load Distance] / [Customer Load Distance]) =

{Customer Load Revenue (Quoted)} x ({Carrier Load Distance} / {Customer Load Distance}) =

{Revenue (Quoted)} {Participant Currency}

Participant Match

During Match Loads to PayIQ Participants and Match Legs to PayIQ Participants (when paying off load)

Freight (Quoted) for Carrier Load from Freight Plan according to distance contribution, per PayIQ Program.

[{Freight Plan Name} : Freight (Quoted)] = [Customer Load Freight] x [Distance Contribution Ratio] =

[Customer Load Freight] x ([Carrier Load Distance] / [Customer Load Distance]) =

{Customer Load Freight (Quoted)} x ({Carrier Load Distance} / {Customer Load Distance}) =

{Freight (Quoted)} {Participant Currency}

Participant Match

During Match Loads to PayIQ Participants and Match Legs to PayIQ Participants (when paying off load)

Fuel (Quoted) for Carrier Load from Freight Plan according to distance contribution, per PayIQ Program.

[{Freight Plan Name} : Fuel (Quoted)] = [Customer Load Fuel] x [Distance Contribution Ratio] =

[Customer Load Fuel] x ([Carrier Load Distance] / [Customer Load Distance]) =

{Customer Load Fuel (Quoted)} x ({Carrier Load Distance} / {Customer Load Distance}) =

{Fuel(Quoted)} {Participant Currency}

Participant Match

During Match Loads to PayIQ Participants and Match Legs to PayIQ Participants (when paying off load)

Margin (Invoiced) for Carrier Load from Freight Plan - full, per PayIQ Program.

[{Freight Plan Name} : Margin (Invoiced)] =

[Customer Load Margin] x [Full Ratio] =

([Customer Load Revenue] - [Customer Load Cost] - [Customer Load Cost Allocation]) x 1.0 =

{Customer Load Revenue (Invoiced)} - {Customer Load Cost (Invoiced)} - {Customer Load Cost Allocation (Invoiced)} =

{Margin (Invoiced)} {Participant Currency}

Participant Match

During Match Loads to PayIQ Participants and Match Legs to PayIQ Participants (when paying off load)

Revenue (Invoiced) for Carrier Load from Freight Plan - full, per PayIQ Program.

[{Freight Plan Name} : Revenue (Invoiced)] =

[Customer Load Revenue] x [Full Ratio] =

[Customer Load Revenue] x 1.0 =

{Revenue (Invoiced)} {Participant Currency}

Participant Match

During Match Loads to PayIQ Participants and Match Legs to PayIQ Participants (when paying off load)

Freight (Invoiced) for Carrier Load from Freight Plan - full, per PayIQ Program.

[{Freight Plan Name} : Freight (Invoiced)] = [Customer Load Freight] x [Full Ratio] = [Customer Load Freight] x 1.0 =

{Freight (Invoiced)} {Participant Currency}

Participant Match

During Match Loads to PayIQ Participants and Match Legs to PayIQ Participants (when paying off load)

Fuel (Invoiced) for Carrier Load from Freight Plan - full, per PayIQ Program.

[{Freight Plan Name } : Fuel (Invoiced)] = [Customer Load Fuel] x [Full Ratio] = [Customer Load Fuel] x 1.0 =

{Fuel (Invoiced)} {Participant Currency}

Participant Match

During Match Loads to PayIQ Participants and Match Legs to PayIQ Participants (when paying off load)

Margin (Quoted) for Carrier Load from Freight Plan - full, per PayIQ Program.

[{Freight Plan Name} : Margin (Quoted)] =

[Customer Load Margin] x [Full Ratio] =

([Customer Load Revenue] - [Customer Load Cost] - [Customer Load Cost Allocation]) x 1.0 =

{Customer Load Revenue (Quoted)} - {Customer Load Cost (Quoted)} - {Customer Load Cost Allocation (Quoted)} =

{Margin (Quoted)} {Participant Currency}

Participant Match

During Match Loads to PayIQ Participants and Match Legs to PayIQ Participants (when paying off load)

Revenue (Quoted) for Carrier Load from Freight Plan - full, per PayIQ Program.

[{Freight Plan Name} : Revenue (Quoted)] =

[Customer Load Revenue] x [Full Ratio] =

[Customer Load Revenue] x 1.0 =

{Revenue (Quoted)} {Participant Currency}

Participant Match

During Match Loads to PayIQ Participants and Match Legs to PayIQ Participants (when paying off load)

Freight (Quoted) for Carrier Load from Freight Plan - full, per PayIQ Program.

[{Freight Plan Name} : Freight (Quoted)] = [Customer Load Freight] x [Full Ratio] = [Customer Load Freight] x 1.0 =

{Freight (Quoted)} {Participant Currency}

Participant Match

During Match Loads to PayIQ Participants and Match Legs to PayIQ Participants (when paying off load)

Fuel (Quoted) for Carrier Load from Freight Plan - full, per PayIQ Program.

[{Freight Plan Name} : Fuel (Quoted)] = [Customer Load Fuel] x [Full Ratio] = [Customer Load Fuel] x 1.0 =

{Fuel (Quoted)} {Participant Currency}

Participant Match

During Match Loads to PayIQ Participants and Match Legs to PayIQ Participants (when paying off load)

Carrier Load matched to program with Carrier Load Allocation set to blank, applies per PayIQ Program.

Carrier Load Allocation is blank, which signifies No Contribution, set all load financials to 0.

Participant Match

During Match Loads to PayIQ Participants and Match Legs to PayIQ Participants (when paying off load)

Margin (Invoiced) for Customer Load from Freight Plan.

[{Freight Plan Name} : Margin (Invoiced)] =

[Customer Load Revenue] - [Customer Load Cost] - [Customer Load Cost Allocation] =

{Customer Load Revenue (Invoiced)} - {Customer Load Cost (Invoiced)} - {Customer Load Cost Allocation (Invoiced)} = {Margin (Invoiced)} {Participant Currency}

Participant Match

During Match Loads to PayIQ Participants and Match Legs to PayIQ Participants (when paying off load)

Revenue (Invoiced) for Customer Load from Freight Plan.

[{Freight Plan Name} : Revenue (Invoiced)] =

[Customer Load Revenue] = {Customer Load Revenue (Invoiced)} {Participant Currency}

Participant Match

During Match Loads to PayIQ Participants and Match Legs to PayIQ Participants (when paying off load)

Freight (Invoiced) for Customer Load from Freight Plan.

[{Freight Plan Name} : Freight (Invoiced)] = [Customer Load Freight] = {Customer Load Freight (Invoiced)} {Participant Currency}

Participant Match

During Match Loads to PayIQ Participants and Match Legs to PayIQ Participants (when paying off load)

Fuel (Invoiced) for Customer Load from Freight Plan.

[{Freight Plan Name} : Fuel (Invoiced)] = [Customer Load Fuel] = {Customer Load Fuel (Invoiced)} {Participant Currency}

Participant Match

During Match Loads to PayIQ Participants and Match Legs to PayIQ Participants (when paying off load)

Margin (Quoted) for Customer Load from Freight Plan.

[{Freight Plan Name} : Margin (Quoted)] =

[Customer Load Revenue] - [Customer Load Cost] - [Customer Load Cost Allocation] =

{Customer Load Revenue (Quoted)} - {Customer Load Cost (Quoted)} - {Customer Load Cost Allocation (Quoted)} = {Margin (Quoted)} {Participant Currency}

Participant Match

During Match Loads to PayIQ Participants and Match Legs to PayIQ Participants (when paying off load)

Revenue (Quoted) for Customer Load from Freight Plan.

[{Freight Plan Name} : Revenue (Quoted)] =

[Customer Load Revenue] = {Customer Load Revenue (Quoted)} {Participant Currency}

Participant Match

During Match Loads to PayIQ Participants and Match Legs to PayIQ Participants (when paying off load)

Freight (Quoted) for Customer Load from Freight Plan.

[{Freight Plan Name} : Freight (Quoted)] = [Customer Load Freight] = {Customer Load Freight (Quoted)} {Participant Currency}

Participant Match

During Match Loads to PayIQ Participants and Match Legs to PayIQ Participants (when paying off load)

Fuel (Quoted) for Customer Load from Freight Plan.

[{Freight Plan Name} : Fuel (Quoted)] = [Customer Load Fuel] = {Customer Load Fuel (Quoted)} {Participant Currency}

Participant Match

During Generate Tier Pay and Generate Accessorial Pay

Amount Per Load Pay Calculation or Flat Rate Accessorial Rule Pay Calculation Flat Rate is paid in both cases.

[{Tier Name} Pay Amount] = [Flat Rate] = {Tier Amount} {Participant Currency}

Pay Detail if the amount is not zero, Load if the final amount is zero.

During Generate Tier Pay job

Percent of Margin (Invoiced) Pay Calculation

[{Tier Name} Pay Amount] = [Load Margin (Invoiced)] x [Percent] = {Margin} x {Tier Percent}% = {Pay Amount} {Participant Currency}

Pay Detail if the amount is not zero, Load if the final amount is zero.

During Generate Tier Pay job

Percent of Margin (Quoted) Pay Calculation

[{Tier Name} Pay Amount] = [Load Margin (Quoted)] x [Percent] = {Margin} x {Tier Percent}% = {Pay Amount} {Participant Currency}

Pay Detail if the amount is not zero, Load if the final amount is zero.

During Generate Tier Pay job

Pay calculated below minimum to indicate the pay is the minimum.

{Tier Name} Pay Amount {Pay Amount} is below min of {Tier Amount}. [Pay Amount] = {Tier Amount} {Participant Currency}

Pay Detail if the amount is not zero, Load if the final amount is zero.

During Generate Tier Pay job

Pay calculated above maximum indicating pay is the maximum.

{Tier Name} Pay Amount {Pay Amount} is above max of {Tier Amount}. [Pay Amount] = {Tier Amount} {Participant Currency}

Pay Detail if the amount is not zero, Load if the final amount is zero.

During Generate Tier Pay job

Percent of Margin (Quoted) Sliding Scale Pay Calculation. This is the amount to slide up to by applying a ratio of margin/amount, capped at 1.0.

[{Tier Name} Pay Amount] = [Load Margin (Quoted)] x [Percent] x MIN([Load Margin (Quoted)]/[Amount], 1.0) = {Margin} x {Tier Percent}% x MIN({Margin}/{Tier Amount}, 1.0) = {Pay Amount} {Participant Currency}

Pay Detail if the amount is not zero, Load if the final amount is zero.

During Generate Tier Pay job

Percent of Margin (Invoiced) Sliding Scale Pay Calculation. This is the amount to slide up to by applying a ratio of margin/amount, capped at 1.0.

[{Tier Name} Pay Amount] = [Load Margin (Invoiced)] x [Percent] x MIN([Load Margin (Invoiced)]/[Amount], 1.0) = {Margin} x {Tier Percent}% x MIN({Margin}/{Tier Amount}, 1.0) = {Pay Amount} {Participant Currency}

Pay Detail if the amount is not zero, Load if the final amount is zero.

During Generate Tier Pay job

Percent of Revenue (Quoted) Pay Calculation

[{Tier Name} Pay Amount] = [Load Full Revenue (Quoted)] x [Percent] = {Revenue} x {Tier Percent}% = {Pay Amount} {Participant Currency}

Pay Detail if the amount is not zero, Load if the final amount is zero.

During Generate Tier Pay job

Percent of Revenue (Invoiced) Pay Calculation

[{Tier Name} Pay Amount] = [Load Full Revenue (Invoiced)] x [Percent] = {Revenue} x {Tier Percent}% = {Pay Amount} {Participant Currency}

Pay Detail if the amount is not zero, Load if the final amount is zero.

During Generate Tier Pay job

Percent of Freight (Quoted) Pay Calculation

[{Tier Name} Pay Amount] = [Load Freight Only (Quoted)] x [Percent] = {Freight} x {Tier Percent}% = {Pay Amount} {Participant Currency}

Pay Detail if the amount is not zero, Load if the final amount is zero.

During Generate Tier Pay job

Percent of Freight (Invoiced) Pay Calculation

[{Tier Name} Pay Amount] = [Load Freight Only (Invoiced)] x [Percent] = {Freight} x {Tier Percent}% = {Pay Amount} {Participant Currency}

Pay Detail if the amount is not zero, Load if the final amount is zero.

During Generate Tier Pay job

Percent of Fuel (Quoted) Pay Calculation

[{Tier Name} Pay Amount] = [Load Fuel Only (Quoted)] x [Percent] = {Fuel} x {Tier Percent}% = {Pay Amount} {Participant Currency}

Pay Detail if the amount is not zero, Load if the final amount is zero.

During Generate Tier Pay job

Percent of Fuel (Invoiced) Pay Calculation

[{Tier Name} Pay Amount] = [Load Fuel Only (Invoiced)] x [Percent] = {Fuel} x {Tier Percent}% = {Pay Amount} {Participant Currency}

Pay Detail if the amount is not zero, Load if the final amount is zero.

During Generate Tier Pay job

Percent of Freight & Fuel (Quoted) Pay Calculation

[{Tier Name} Pay Amount] = [Load Freight + Fuel (Quoted)] x [Percent] = {Freight + Fuel} x {Tier Percent}% = {Pay Amount} {Participant Currency}

Pay Detail if the amount is not zero, Load if the final amount is zero.

During Generate Tier Pay job

Percent of Freight & Fuel (Invoiced) Pay Calculation

[{Tier Name} Pay Amount] = [Load Freight + Fuel (Invoiced)] x [Percent] = {Freight + Fuel} x {Tier Percent}% = {Pay Amount} {Participant Currency}

Pay Detail if the amount is not zero, Load if the final amount is zero.

During Generate Tier Pay job

Percent of Custom Amount Pay Calculation

[{Tier Name} Pay Amount] = [Calculation Custom Currency Field(Field Name)] x [Percent] = {Custom Amount} x {Percent}% = {Pay Amount} {Participant Currency}

Pay Detail if the amount is not zero, Load if the final amount is zero.

During Generate Tier Pay job

Rate per Hour Pay Calculation (Trip Plan Leg)

[{Tier Name} Pay Amount] = [Trip Plan Leg Start To End (Hours)] x [Amount] = {Hours} x {Rate} {Participant Currency} = {Pay Amount} {Participant Currency}

Pay Detail if the amount is not zero, Trip Plan Leg if the final amount is zero.

During Generate Tier Pay job

Rate per Mile Pay Calculation (Trip Plan Leg)

[{Tier Name} Pay Amount] = [Trip Plan Leg Distance Miles] x [Amount] = {Distance Miles} x {Rate} {Participant Currency} = {Pay Amount} {Participant Currency}

Pay Detail if the amount is not zero, Trip Plan Leg if the final amount is zero.

During Generate Tier Pay job

Rate per Kilometer Pay Calculation (Trip Plan Leg)

[{Tier Name} Pay Amount] = [Trip Plan Leg Distance Kilometers] x [Amount] = {Distance Km} x {Rate} {Participant Currency} = {Pay Amount} {Participant Currency}

Pay Detail if the amount is not zero, Trip Plan Leg if the final amount is zero.

During Generate Tier Pay job

Rate per Hour Pay Calculation (Driver Log, single field)

[{Tier Name} Pay Amount] = [Driver Log {field} (Hours)] x [Amount] = {Hours} x {Rate} {Participant Currency} = {Pay Amount} {Participant Currency}

Pay Detail if the amount is not zero, Driver Log if the final amount is zero.

During Generate Tier Pay job

Rate per Mile Pay Calculation (Driver Log, single field)

[{Tier Name} Pay Amount] = [Driver Log {field} Miles] x [Amount] = {Distance Miles} x {Rate} {Participant Currency} = {Pay Amount} {Participant Currency}

Pay Detail if the amount is not zero, Driver Log if the final amount is zero.

During Generate Tier Pay job

Rate per Kilometer Pay Calculation (Driver Log, single field)

[{Tier Name} Pay Amount] = [Driver Log {field} Kilometers] x [Amount] = {Distance Km} x {Rate} {Participant Currency} = {Pay Amount} {Participant Currency}

Pay Detail if the amount is not zero, Driver Log if the final amount is zero.

During Generate Tier Pay job

Rate per Hour Pay Calculation (Driver Log, multiple fields)

[{Tier Name} Pay Amount] = [Driver Log ({field 1} + {field 2} + … + {field N}) (Hours)] x [Amount] = {Hours} x {Rate} {Participant Currency} = {Pay Amount} {Participant Currency}

Pay Detail if the amount is not zero, Driver Log if the final amount is zero.

During Generate Tier Pay job

Rate per Mile Pay Calculation (Driver Log, multiple fields)

[{Tier Name} Pay Amount] = [Driver Log ({field 1} + {field 2} + … + {field N}) Miles] x [Amount] = {Distance Miles} x {Rate} {Participant Currency} = {Pay Amount} {Participant Currency}

Pay Detail if the amount is not zero, Driver Log if the final amount is zero.

During Generate Tier Pay job

Rate per Kilometer Pay Calculation (Driver Log, multiple fields)

[{Tier Name} Pay Amount] = [Driver Log ({field 1} + {field 2} + … + {field N}) Kilometers] x [Amount] = {Distance Km} x {Rate} {Participant Currency} = {Pay Amount} {Participant Currency}

Pay Detail if the amount is not zero, Driver Log if the final amount is zero.

During Generate Accessorial Pay job

Amount per Unit/Qty Accessorial Rule Pay Calculation

[{Tier Name} Pay Amount] = [Quantity] x [Amount] = {Accessorial Quantity} x {Amount} = {Pay Amount} {Participant Currency}

Pay Detail if the amount is not zero, Load or Trip Plan Leg if the final amount is zero.

During Generate Accessorial Pay job

Percent of Accessorial Accessorial Rule Pay Calculation

[{Tier Name} Pay Amount] = [Accessorial Amount] x [Percent] = {Accessorial Item Total} x {Percent}% = {Pay Amount} {Participant Currency}

Pay Detail if the amount is not zero, Load or Trip Plan Leg if the final amount is zero.

During Generate Accessorial Pay job

When paying full accessorial amount to Trip Plan Leg accessorials

[{Tier Name} Pay Amount] = [Quantity] x [Unit Price] = {Accessorial Quantity} x {Accessorial Unit Price} = {Pay Amount} {Participant Currency}

Pay Detail if the amount is not zero, Load or Trip Plan Leg if the final amount is zero.

During Generate Tier Pay job

Pay amount is divided among team members 1/N where N is the number of team members.

[Team Pay] = [{Tier Name} Pay Amount] x [Team Member Pay Ratio] = [Pay Amount] x (1 / [Team Size]) = {Pay Amount} x (1 / {Team Size}) = {Team-Adjusted Pay Amount} {Participant Currency}

Pay Detail if the amount is not zero, Load, Driver Log, or Trip Plan Leg if the final amount is zero.

During Generate Tier Pay and Generate Accessorial Pay

Pay amount is adjusted down by the sum of pre-existing approved Pay Details that are treated as the “Amount Already Paid” per-Load, per-tier, per-user/contact.

[Adjusted Pay] = [{Tier Name} Pay Amount] - [Amount Already Paid] = {Pay Amount} - ({Approved Pay Detail Amount 1} + {Approved Pay Detail Amount 2} + … + {Approved Pay Detail Amount N}) = {Adjusted Amount} {Participant Currency}

Pay Detail if the amount is not zero, Load, Driver Log, or Trip Plan Leg if the final amount is zero.

During Match Loads to PayIQ Participants & Match Trip Plan Legs to PayIQ Participants jobs when assembling Freight Plans.

Customer Load Revenue (Invoiced)

Participant Match

During Match Loads to PayIQ Participants & Match Trip Plan Legs to PayIQ Participants jobs when assembling Freight Plans.

Customer Load Freight (Invoiced)

Participant Match

During Match Loads to PayIQ Participants & Match Trip Plan Legs to PayIQ Participants jobs when assembling Freight Plans.

Customer Load Fuel (Invoiced)

Participant Match

During Match Loads to PayIQ Participants & Match Trip Plan Legs to PayIQ Participants jobs when assembling Freight Plans.

Customer Load Cost (Invoiced)

Participant Match

During Match Loads to PayIQ Participants & Match Trip Plan Legs to PayIQ Participants jobs when assembling Freight Plans.

Customer Load Cost Allocation (Invoiced)

Participant Match

During Match Loads to PayIQ Participants & Match Trip Plan Legs to PayIQ Participants jobs when assembling Freight Plans.

Customer Load Revenue (Quoted)

Participant Match

During Match Loads to PayIQ Participants & Match Trip Plan Legs to PayIQ Participants jobs when assembling Freight Plans.

Customer Load Freight (Quoted)

Participant Match

During Match Loads to PayIQ Participants & Match Trip Plan Legs to PayIQ Participants jobs when assembling Freight Plans.

Customer Load Fuel (Quoted)

Participant Match

During Match Loads to PayIQ Participants & Match Trip Plan Legs to PayIQ Participants jobs when assembling Freight Plans.

Customer Load Cost (Quoted)

Participant Match

During Match Loads to PayIQ Participants & Match Trip Plan Legs to PayIQ Participants jobs when assembling Freight Plans.

Customer Load Cost Allocation (Quoted)

Participant Match

During Match Loads to PayIQ Participants & Match Trip Plan Legs to PayIQ Participants jobs when creating a Participant Match for a Carrier Load under cost contribution ratio for each program.

Carrier Load Cost

Participant Match

During Match Loads to PayIQ Participants & Match Trip Plan Legs to PayIQ Participants jobs when creating a Participant Match for a non-Freight Plan Load.

Margin (Quoted)

Participant Match

During Match Loads to PayIQ Participants & Match Trip Plan Legs to PayIQ Participants jobs when creating a Participant Match for a non-Freight Plan Load.

Margin (Invoiced)

Participant Match

During Match Loads to PayIQ Participants & Match Trip Plan Legs to PayIQ Participants jobs creating Participant Match for a non-Freight Plan Load.

Revenue (Quoted)

Participant Match

During Match Loads to PayIQ Participants & Match Trip Plan Legs to PayIQ Participants jobs when creating a Participant Match for a non-Freight Plan Load.

Revenue (Invoiced)

Participant Match

During Match Loads to PayIQ Participants & Match Trip Plan Legs to PayIQ Participants jobs when creating a Participant Match for a non-Freight Plan Load.

Freight (Invoiced)

Participant Match

During Match Loads to PayIQ Participants & Match Trip Plan Legs to PayIQ Participants jobs when creating a Participant Match for a non-Freight Plan Load.

Fuel (Invoiced)

Participant Match

During Match Loads to PayIQ Participants & Match Trip Plan Legs to PayIQ Participants jobs when creating a Participant Match for a non-Freight Plan Load.

Freight (Quoted)

Participant Match

During Match Loads to PayIQ Participants & Match Trip Plan Legs to PayIQ Participants jobs when creating a Participant Match for a non-Freight Plan Load.

Fuel (Quoted)

Participant Match

During Generate Tier Pay when checking a Load Custom Amount against criteria.

Criteria Custom Currency Field

Pay Detail if matched; Load, Driver Log, or Trip Plan Leg if not matched

During Generate Tier Pay when checking against a currency-based criteria (margin, revenue, or Load Custom Amount).

Criterial From

Pay Detail if matched; Load, Driver Log, or Trip Plan Leg if not matched

During Generate Tier Pay when checking against currency-based criteria (margin, revenue, or Load Custom Amount).

Criteria To

Pay Detail if matched; Load, Driver Log, or Trip Plan Leg if not matched

During Generate Tier Pay when generating pay from an amount-based calculation (amount per Load, percent of margin with min, percent of margin with max, percent of margin (sliding), rate per hour, rate per mile, or rate per km).

Calculation Amount

Pay Detail

During Generate Tier Pay when generating pay for a custom currency calculation.

Calculation Custom Currency Field

Pay Detail

During Generate Tier Pay if the current participant currency does not match the existing pay header currency (can occur if a participant switched currencies).

Margin (Quoted)

Pay Detail

During Generate Tier Pay if the current participant currency does not match the existing Pay Header currency (can occur if a participant switched currencies).

Margin (Invoiced)

Pay Detail

During Generate Tier Pay if the current participant currency does not match the existing Pay Header currency (can occur if a participant switched currencies).

Revenue (Quoted)

Pay Detail

During Generate Tier Pay if the current participant currency does not match the existing Pay Header currency (can occur if a participant switched currencies).

Revenue (Invoiced)

Pay Detail

During Generate Tier Pay if the current participant currency does not match the existing Pay Header currency (can occur if a participant switched currencies).

Freight (Quoted)

Pay Detail

During Generate Tier Pay if the current participant currency does not match the existing Pay Header currency (can occur if a participant switched currencies).

Freight (Invoiced)

Pay Detail

During Generate Tier Pay if the current participant currency does not match the existing Pay Header currency (can occur if a participant switched currencies).

Fuel (Quoted)

Pay Detail

During Generate Tier Pay if the current participant currency does not match the existing Pay Header currency (can occur if a participant switched currencies).

Fuel (Invoiced)

Pay Detail

During Generate Accessorial Pay

Accessorial Amount

Pay Detail

During Generate Accessorial Pay if generating from a flat rate or amount per unit/qty rule.

Accessorial Rule Amount

Pay Detail