Overview
Log Dictionary
Below is a listing of all Revenova PayIQ logs that may be created while using the package. Each section refers to options that must be enabled from the PayIQ Admin LWC to generate the logs.
To save storage space in an org, Log records are only created once per Load per Log type. Each Log is unique. This means a Log containing the same message for a Load that doesn’t qualify for all PayIQ Programs is only created once.
Logs are only generated by first enabling them on the PayIQ Admin LWC.
Performance
All Performance logs are independent. They are not specific to a Load, participant match, or pay detail. Performance logs measure the amount of time to run components of PayIQ.
Event | Log Content |
|---|---|
The end of the start method of the Match Loads to PayIQ Participants job. | All pay programs/periods were loaded 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). | Job 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). | Job completed. {count} participant matches were created in {elapsed ms}ms |
The end of the start method of the Generate Pay job. | All pay programs/periods were loaded in {elapsed ms}ms |
The end of each iteration of the Generate Pay job (1 created). | 1 participant match was processed in {elapsed ms}ms |
The end of each iteration of the Generate Pay job (N created). | {count} participant matches were processed in {elapsed ms}ms |
The end of the finish method of the Generate Pay job (1 created). | Job completed. 1 pay detail was created in {elapsed ms}ms |
The end of the finish method of the Generate Pay job (N created). | Job completed. {count} pay details were created in {elapsed ms}ms |
Governor Limits
All Governor Limits logs are independent. They are not specific to a Load, Participant Match, or Pay Detail record. Governor limits are set by Salesforce. See more information on Salesforce governor limits here.
Event | Log Content |
|---|---|
The end of the start method of the Match Loads to PayIQ Participants job. | CPU time: {CPU ms}ms out of 60000 DML statements: {DML Statements} out of 150 DML Rows: {DML Rows} out of 10000 SOQL Queries: {SOQL Queries} out of 200 SOQL Rows: {SOQL Rows} out of 50000 Aggregate Queries: {Aggregate Queries} out of 600 Heap Size: {Heap Size kb}kb out of 12000 |
The end of each iteration of the Match Loads to PayIQ Participants job. | CPU time: {CPU ms}ms out of 60000 DML statements: {DML Statements} out of 150 DML Rows: {DML Rows} out of 10000 SOQL Queries: {SOQL Queries} out of 200 SOQL Rows: {SOQL Rows} out of 50000 Aggregate Queries: {Aggregate Queries} out of 600 Heap Size: {Heap Size kb}kb out of 12000 |
The end of the finish method of the Match Loads to PayIQ Participants job. | CPU time: {CPU ms}ms out of 60000 DML statements: {DML Statements} out of 150 DML Rows: {DML Rows} out of 10000 SOQL Queries: {SOQL Queries} out of 200 SOQL Rows: {SOQL Rows} out of 50000 Aggregate Queries: {Aggregate Queries} out of 600 Heap Size: {Heap Size kb}kb out of 12000 |
The end of the start method of the Generate Pay job. | CPU time: {CPU ms}ms out of 60000 DML statements: {DML Statements} out of 150 DML Rows: {DML Rows} out of 10000 SOQL Queries: {SOQL Queries} out of 200 SOQL Rows: {SOQL Rows} out of 50000 Aggregate Queries: {Aggregate Queries} out of 600 Heap Size: {Heap Size kb}kb out of 12000 |
The end of each iteration of the Generate Pay job. | CPU time: {CPU ms}ms out of 60000 DML statements: {DML Statements} out of 150 DML Rows: {DML Rows} out of 10000 SOQL Queries: {SOQL Queries} out of 200 SOQL Rows: {SOQL Rows} out of 50000 Aggregate Queries: {Aggregate Queries} out of 600 Heap Size: {Heap Size kb}kb out of 12000 |
The end of the finish method of the Generate Pay job. | CPU time: {CPU ms}ms out of 60000 DML statements: {DML Statements} out of 150 DML Rows: {DML Rows} out of 10000 SOQL Queries: {SOQL Queries} out of 200 SOQL Rows: {SOQL Rows} out of 50000 Aggregate Queries: {Aggregate Queries} out of 600 Heap Size: {Heap Size kb}kb out of 12000 |
Qualifications (Met/Did not Meet criteria)
If Freight Plan Load Criteria defined by the PayIQ Program are not met, a Qualification log is generated for every Load. Each Carrier and customer Load within a Freight Plan is considered. Loads that do not qualify generate one log and disqualifying criteria is included in the Detail field of the Log record.
Freight Plan Carrier Loads generate logs on a per Freight Plan, per PayIQ Program basis. If using multiple PayIQ programs (cascading) each Carrier Load generates multiple Qualification log records.
If no Effective or Expiration Date is provided for a Participant, the resulting log displays “(No Effective Date)” or “(No Expiration Date).”
Event | Qualification | Log Detail | Record Tied To |
|---|---|---|---|
During Generate Pay when first processing each participant match. | Load Filter Not Met | Load filter from program "{PayIQ Program}" not met: {Field API Name} {Operator} {Filter Value}, Actual: {Load Value} | Load |
During Generate Pay before checking criteria against the tier range (Aggregated Quote Financials) | Within Tier Calculation when using Aggregated Quote Financials (Informational) | [Within {Tier Name} calculation] = [From] < [Aggregated {Tier Criteria} (Quoted)] <= [To] = {Tier From} < {Criteria from Load} <= {Tier To} | Pay Detail (if created), otherwise Load. |
During Generate Pay before checking criteria against the tier range (Individual Load Quote Financials). | Within Tier Calculation when using Individual Load Quote Financials (Informational) | [Within {Tier Name} calculation] = [From] < [Individual Load {Tier Criteria} (Quoted)] <= [To] = {Tier From} < {Criteria from Load} <= {Tier To} | Pay Detail (if created), otherwise Load. |
During Generate Pay before checking criteria against the tier range (Aggregated Invoice Financials). | Within Tier Calculation when using Aggregate Quote Financials (Informational) | [Within {Tier Name} calculation] = [From] < [Aggregated {Tier Criteria} (Invoiced)] <= [To] = {Tier From} < {Criteria from Load} <= {Tier To} | Pay Detail (if created), otherwise Load. |
During Generate Pay before checking criteria against the tier range (Individual Load Invoice Financials). | Within Tier Calculation when using Individual Load Invoice Financials (Informational) | [Within {Tier Name} calculation] = [From] < [Individual Load {Tier Criteria} (Invoiced)] <= [To] = {Tier From} < {Criteria from Load} <= {Tier To} | Pay Detail (if created), otherwise Load. |
During Generate Pay after identifying participants from Participant matches. | 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 |
During Match Loads to PayIQ Participants while validating Load Roles on the PayIQ Program. | No Eligible Date set on Load | No eligible date set via Load field {Eligible Date} on Load: {Load Name} | Load |
During Match Loads to PayIQ Participants while validating Load Roles on the PayIQ Program. | PayIQ Program not open | PayIQ Program not open: {PayIQ Program Name} | Load |
During Match Loads to PayIQ Participants while validating Load Roles on the PayIQ Program. | Pay Schedule not open | Pay Schedule not open | Load |
During Match Loads to PayIQ Participants while validating Load Roles on the PayIQ Program. | No Pay Periods matched to Eligible Date | No Pay Periods matched to date: {Eligible Date} | Load |
During Match Loads to PayIQ Participants while validating Load Roles on the PayIQ Program. | Pay period matched to date not open | Pay Period matched to date is not open: {Eligible Date} | Load |
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 while validating applicable Pay Periods for Load Roles on the PayIQ Program. | 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 while validating applicable Pay Periods for Load Roles on the PayIQ Program. | 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 while validating applicable Pay Periods for Load Roles on the PayIQ Program. | No matching PayIQ Program Participant found for User | No program participant found for user: {User Name} | Load |
During Match Loads to PayIQ Participants while validating applicable Pay Periods for Load Roles on the PayIQ Program. | No matching PayIQ Program Participant found for Contact | No program participant found for contact: {Contact Name} | Load |
During Match Loads to PayIQ Participants while applying PayIQ Programs to Freight Plan Loads. | 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 Pay after checking criteria against the tier range. | Criteria did not fall within tier | Metric {Criteria from Load} did not fall within {Tier Name} ({Tier From} < {Tier Criteria} <= {Tier To}) | Load |
During Generate Pay after calculating pay and before saving the Pay Detail. | Pay Detail amount is zero | Did not create zero amount Pay Detail. | Load |
Math
Math logs are generated for Loads that are eligible for pay and qualified to calculate a Pay Detail.
Event | Calculation | Log | Record Tied To |
|---|---|---|---|
During Match Loads to PayIQ Participants job creating Freight Plans prior to participant matches. | 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)} {Org Currency} | Participant Match |
During Match Loads to PayIQ Participants job creating Freight Plans prior to participant matches. | 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)} {Org Currency} | Participant Match |
During Match Loads to PayIQ Participants job creating Freight Plans prior to participant matches. | 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)} {Org Currency} | Participant Match |
During Match Loads to PayIQ Participants job creating Freight Plans prior to participant matches. | 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)} {Org Currency} | Participant Match |
During Match Loads to PayIQ Participants job creating Freight Plans prior to participant matches. | 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)} {Org Currency} | Participant Match |
During Match Loads to PayIQ Participants job creating Freight Plans prior to participant matches. | 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)} {Org Currency} | Participant Match |
During Match Loads to PayIQ Participants job creating Freight Plans prior to participant matches. | 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)} {Org Currency} | Participant Match |
During Match Loads to PayIQ Participants job creating Freight Plans prior to participant matches. | 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)} {Org Currency} | Participant Match |
During Match Loads to PayIQ Participants job creating Freight Plans prior to participant matches. | 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)} {Org Currency} | Participant Match |
During Match Loads to PayIQ Participants job creating Freight Plans prior to participant matches. | 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)} {Org Currency} | Participant Match |
During Match Loads to PayIQ Participants job creating Freight Plans prior to participant matches. | 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)} {Org Currency} | Participant Match |
During Match Loads to PayIQ Participants job creating Freight Plans prior to participant matches. | 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)} {Org Currency} | Participant Match |
During Match Loads to PayIQ Participants job creating Freight Plans prior to participant matches. | 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)} {Org Currency} | Participant Match |
During Match Loads to PayIQ Participants job creating Freight Plans prior to participant matches. | Revenue (Invoiced) for Customer Load from Freight Plan. | [{Freight Plan Name} : Revenue (Invoiced)] = [Customer Load Revenue] = {Customer Load Revenue (Invoiced)} {Org Currency} | Participant Match |
During Match Loads to PayIQ Participants job creating Freight Plans prior to participant matches. | 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)} {Org Currency} | Participant Match |
During Match Loads to PayIQ Participants job creating Freight Plans prior to participant matches. | Revenue (Quoted) for Customer Load from Freight Plan. | [{Freight Plan Name} : Revenue (Quoted)] = [Customer Load Revenue] = {Customer Load Revenue (Quoted)} {Org Currency} | Participant Match |
During Generate Pay job after calculating pay amount for the Pay Detail before adjusting for payroll or zero amount check. | Amount Per Load Pay Calculation. Flat rate is paid. | [Pay Amount] = [Flat Rate] = {Tier Amount} {Org Currency} | Pay Detail if the amount is not zero, Load if the final amount is zero. |
During Generate Pay job after calculating the percent of margin pay amount and before min/maxing the pay amount for the Pay Detail, adjusting for payroll, or zero amount check. | Percent of Margin (Quoted) Pay Calculation | [Pay Amount] = [Load Margin (Invoiced)] x [Percent] = {Margin} x {Tier Percent}% = {Pay Amount} {Org Currency} | Pay Detail if the amount is not zero, Load if the final amount is zero. |
During Generate Pay job after calculating the percent of margin pay amount and before min/maxing the pay amount for the Pay Detail, adjusting for payroll, or zero amount check. | Percent of Margin (Invoiced) Pay Calculation | [Pay Amount] = [Load Margin (Quoted)] x [Percent] = {Margin} x {Tier Percent}% = {Pay Amount} {Org Currency} | Pay Detail if the amount is not zero, Load if the final amount is zero. |
During Generate Pay job before setting the minimum pay amount for the Pay Detail and before adjusting for payroll, or zero amount check. | Pay calculated below minimum to indicate the pay is the minimum. | Pay Amount {Pay Amount} is below min of {Tier Amount}. [Pay Amount] = {Tier Amount} | Pay Detail if the amount is not zero, Load if the final amount is zero. |
During Generate Pay job before setting the maximum pay amount for the Pay Detail and before adjusting for payroll, or zero amount check. | Pay calculated above maximum indicating pay is the maximum. | Pay Amount {Pay Amount} is above max of {Tier Amount}. [Pay Amount] = {Tier Amount} | Pay Detail if the amount is not zero, Load if the final amount is zero. |
During Generate Pay job after calculating the percent of margin sliding scale pay amount and before adjusting for payroll, or zero amount check. | 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. | [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} {Org Currency} | Pay Detail if the amount is not zero, Load if the final amount is zero. |
During Generate Pay job after calculating the percent of margin sliding scale pay amount and before adjusting for payroll, or zero amount check. | 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. | [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} {Org Currency} | Pay Detail if the amount is not zero, Load if the final amount is zero. |
During Generate Pay job after calculating the percent of revenue pay amount and before adjusting for payroll, or zero amount check. | Percent of Revenue (Quoted) Pay Calculation | [Pay Amount] = [Load Revenue (Quoted)] x [Percent] = {Revenue} x {Tier Percent}% = {Pay Amount} {Org Currency} | Pay Detail if the amount is not zero, Load if the final amount is zero. |
During Generate Pay job after calculating the percent of revenue pay amount and before adjusting for payroll, or zero amount check. | Percent of Revenue (Invoiced) Pay Calculation | [Pay Amount] = [Load Revenue (Invoiced)] x [Percent] = {Revenue} x {Tier Percent}% = {Pay Amount} {Org Currency} | Pay Detail if the amount is not zero, Load if the final amount is zero. |
During Generate Pay job before adjusting for payroll. | Pay amount is divided among team members 1/N where N is the number of team members. | [Team Pay] = [Pay Amount] x [Team Member Pay Ratio] = [Pay Amount] x (1 / [Team Size]) = {Pay Amount} x (1 / {Team Size}) = {Team-Adjusted Pay Amount} {Org Currency} | Pay Detail if the amount is not zero, Load if the final amount is zero. |
During Generate Pay job before creating the Pay Detail record, converting to the user’s currency. | 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] = [Pay Amount] - [Amount Already Paid] = {Pay Amount} - ({Approved Pay Deatil Amount 1} + {Approved Pay Deatil Amount 2} + … + {Approved Pay Deatil Amount N}) = {Adjusted Amount} {Org Currency} | Pay Detail if the amount is not zero, Load if the final amount is zero. |
Currency Conversions
See Salesforce documentation regarding multiple currencies and dated exchange rates here. Currency conversion logs are only applicable to multi-currency orgs to show how a Pay Detail record was converted using the rate of exchange.
Event | Amount | Log Content | Record Tied To |
|---|---|---|---|
During Match Loads to PayIQ Participants job when creating Freight Plans and before creating Participant Matches. | Customer Load Revenue (Invoiced) | [Customer Load Revenue (Invoiced)] converted from {From Currency} to {To Currency} (using dated exchange rate from XX-XX-XXXX) => {Customer Load Revenue (Invoiced)} {From Currency} = {Converted Customer Load Revenue (Invoiced)} {To Currency} | Participant Match |
During Match Loads to PayIQ Participants job when creating Freight Plans and before creating Participant Matches. | Customer Load Cost (Invoiced) | [Customer Load Cost (Invoiced)] converted from {From Currency} to {To Currency} (using dated exchange rate from XX-XX-XXXX) => {Customer Load Cost (Invoiced)} {From Currency} = {Converted Customer Load Cost (Invoiced)} {To Currency} | Participant Match |
During Match Loads to PayIQ Participants job when creating Freight Plans and before creating Participant Matches. | Customer Load Cost Allocation (Invoiced) | [Customer Load Cost Allocation (Invoiced)] converted from {From Currency} to {To Currency} (using dated exchange rate from XX-XX-XXXX) => {Customer Load Cost Allocation (Invoiced)} {From Currency} = {Converted Customer Load Cost Allocation (Invoiced)} {To Currency} | Participant Match |
During Match Loads to PayIQ Participants job when creating Freight Plans and before creating Participant Matches. | Customer Load Revenue (Quoted) | [Customer Load Revenue (Quoted)] converted from {From Currency} to {To Currency} (using dated exchange rate from XX-XX-XXXX) => {Customer Load Revenue (Quoted)} {From Currency} = {Converted Customer Load Revenue (Quoted)} {To Currency} | Participant Match |
During Match Loads to PayIQ Participants job when creating Freight Plans and before creating Participant Matches. | Customer Load Cost (Quoted) | [Customer Load Cost (Quoted)] converted from {From Currency} to {To Currency} (using dated exchange rate from XX-XX-XXXX) => {Customer Load Cost (Quoted)} {From Currency} = {Converted Customer Load Cost (Quoted)} {To Currency} | Participant Match |
During Match Loads to PayIQ Participants job when creating Freight Plans and before creating Participant Matches. | Customer Load Cost Allocation (Quoted) | [Customer Load Cost Allocation (Quoted)] converted from {From Currency} to {To Currency} (using dated exchange rate from XX-XX-XXXX) => {Customer Load Cost Allocation (Quoted)} {From Currency} = {Converted Customer Load Cost Allocation (Quoted)} {To Currency} | Participant Match |
During Match Loads to PayIQ Participants job when creating a Participant Match for a Carrier Load under cost contribution ratio for each program. | Carrier Load Cost | [Carrier Load Cost] converted from {From Currency} to {To Currency} (using dated exchange rate from XX-XX-XXXX) => {Carrier Load Cost} {From Currency} = {Converted Carrier Load Cost} {To Currency} | Participant Match |
During Match Loads to PayIQ Participants job when creating a Participant Match for a non-Freight Plan Load. | Margin (Quoted) | [Margin (Quoted)] converted from {From Currency} to {To Currency} (using dated exchange rate from XX-XX-XXXX) => {Margin (Quoted)} {From Currency} = {Converted Margin (Quoted)} {To Currency} | Participant Match |
During Match Loads to PayIQ Participants job when creating a Participant Match for a non-Freight Plan Load. | Margin (Invoiced) | [Margin (Invoiced)] converted from {From Currency} to {To Currency} (using dated exchange rate from XX-XX-XXXX) => {Margin (Invoiced)} {From Currency} = {Converted Margin (Invoiced)} {To Currency} | Participant Match |
During Match Loads to PayIQ Participants job creating Participant Match for a non-Freight Plan Load. | Revenue (Quoted) | [Revenue (Quoted)] converted from {From Currency} to {To Currency} (using dated exchange rate from XX-XX-XXXX) => {Revenue (Quoted)} {From Currency} = {Converted Revenue (Quoted)} {To Currency} | Participant Match |
During Match Loads to PayIQ Participants when creating Participant Match for a non-Freight Plan Load. | Revenue (Invoiced) | [Revenue (Invoiced)] converted from {From Currency} to {To Currency} (using dated exchange rate from XX-XX-XXXX) => {Revenue (Invoiced)} {From Currency} = {Converted Revenue (Invoiced)} {To Currency} | Pay Detail |
During Generate Pay after Pay Detail creation. | Pay Amount | [Pay Amount] converted from {From Currency} to {To Currency} (using dated exchange rate from [DATE] => {Pay Amount}{From Currency} = {Converted Pay Amount} {To Currency} |