# Receivables Management measures

## Company Customer

Measure | Source and/or calculation |
---|---|

Credit Limit | CompanyCustomer.CreditLimit |

Credit Review Days | CompanyCustomer.CreditReviewDays |

Current Balance | CompanyCustomer.CurrentBalance |

Disputed Invoice Amount | CompanyCustomer.DisputedInvoiceAmount |

Disputed Invoices | CompanyCustomer.DisputedInvoices |

Last Dunning Letter Number | CompanyCustomer.LastDunningLetterNumber |

Last Payment Amount | CompanyCustomer.LastPaymentAmount |

Open Order Amount | CompanyCustomer.OpenOrderAmount |

Order Limit | CompanyCustomer.OrderLimit |

Search Name | CompanyCustomer.SearchName |

Unapplied Payments Credits | CompanyCustomer.UnappliedPaymentsCredits |

Unreleased Payments | CompanyCustomer.UnreleasedPayments |

Year To Date Cash Paid | CompanyCustomer.YearToDateCashPaid |

Year To Date Earned Discounts | CompanyCustomer.YearToDateEarnedDiscounts |

Year To Date Unearned Discounts | CompanyCustomer.YearToDateUnearnedDiscounts |

## Receivable GL Distribution

Measure | Source and/or calculation |
---|---|

Receivable Distribution Alternate Amount | ReceivableGLDistribution.DistributionAmount.AlternateAmount.EnteredCurrencyAmount |

Receivable Distribution Alternate Amount 2 | ReceivableGLDistribution.DistributionAmount.AlternateAmount2.EnteredCurrencyAmount |

Receivable Distribution Alternate Amount 3 | ReceivableGLDistribution.DistributionAmount.AlternateAmount3.EnteredCurrencyAmount |

Receivable Distribution Alternate Rate | ReceivableGLDistribution.DistributionAmount.AlternateAmount.EnteredCurrencyRate |

Receivable Distribution Alternate Rate 2 | ReceivableGLDistribution.DistributionAmount.AlternateAmount2.EnteredCurrencyRate |

Receivable Distribution Alternate Rate 3 | ReceivableGLDistribution.DistributionAmount.AlternateAmount3.EnteredCurrencyRate |

Receivable Distribution Base Amount | ReceivableGLDistribution.ToCompanyBaseAmount |

Receivable Distribution Base Taxable Amount | ReceivableGLDistribution.BaseTaxableAmount |

Receivable Distribution Blocking Override Percent | ReceivableGLDistribution.BlockingOverridePercent |

Receivable Distribution Currency Rate | ReceivableGLDistribution.CurrencyRate |

Receivable Distribution Distribution Amount | ReceivableGLDistribution.DistributionAmount.CurrencyAmount |

Receivable Distribution Functional Amount | ReceivableGLDistribution.DistributionAmount.FunctionalAmount.EnteredCurrencyAmount |

Receivable Distribution Functional Rate | ReceivableGLDistribution.DistributionAmount.FunctionalAmount.EnteredCurrencyRate |

Receivable Distribution Partial Exempt Recvbl Ovrd Pct | ReceivableGLDistribution.PartialExemptRecvblOvrdPct |

Receivable Distribution Post To Alternate | ReceivableGLDistribution.DistributionAmount.ToAlternateAmount.EnteredCurrencyAmount |

Receivable Distribution Post To Alternate 2 | ReceivableGLDistribution.DistributionAmount.ToAlternateAmount2.EnteredCurrencyAmount |

Receivable Distribution Post To Alternate 3 | ReceivableGLDistribution.DistributionAmount.ToAlternateAmount3.EnteredCurrencyAmount |

Receivable Distribution Post To Functional | ReceivableGLDistribution.DistributionAmount.ToFunctionalAmount.EnteredCurrencyAmount |

Receivable Distribution Project Amount | ReceivableGLDistribution.DistributionAmount.ProjectAmount.EnteredCurrencyAmount |

Receivable Distribution Project Rate | ReceivableGLDistribution.DistributionAmount.ProjectAmount.EnteredCurrencyRate |

Receivable Distribution Recoverable Amount | ReceivableGLDistribution.RecoverableAmount |

Receivable Distribution Recoverable Percent | ReceivableGLDistribution.RecoverablePercent |

Receivable Distribution Report 1 Rate | ReceivableGLDistribution.DistributionAmount.ReportAmount1.EnteredCurrencyRate |

Receivable Distribution Report 2 Rate | ReceivableGLDistribution.DistributionAmount.ReportAmount2.EnteredCurrencyRate |

Receivable Distribution Report 3 Rate | ReceivableGLDistribution.DistributionAmount.ReportAmount3.EnteredCurrencyRate |

Receivable Distribution Report 4 Rate | ReceivableGLDistribution.DistributionAmount.ReportAmount4.EnteredCurrencyRate |

Receivable Distribution Report 5 Rate | ReceivableGLDistribution.DistributionAmount.ReportAmount5.EnteredCurrencyRate |

Receivable Distribution Report Amount 1 | ReceivableGLDistribution.DistributionAmount.ReportAmount1.EnteredCurrencyAmount |

Receivable Distribution Report Amount 2 | ReceivableGLDistribution.DistributionAmount.ReportAmount2.EnteredCurrencyAmount |

Receivable Distribution Report Amount 3 | ReceivableGLDistribution.DistributionAmount.ReportAmount3.EnteredCurrencyAmount |

Receivable Distribution Report Amount 4 | ReceivableGLDistribution.DistributionAmount.ReportAmount4.EnteredCurrencyAmount |

Receivable Distribution Report Amount 5 | ReceivableGLDistribution.DistributionAmount.ReportAmount5.EnteredCurrencyAmount |

Receivable Distribution Stock Weight | ReceivableGLDistribution.StockWeight |

Receivable Distribution Supplementary Quantity | ReceivableGLDistribution.SupplementaryQuantity |

Receivable Distribution To Alternate Rate | ReceivableGLDistribution.DistributionAmount.ToAlternateAmount.EnteredCurrencyRate |

Receivable Distribution To Alternate Rate 2 | ReceivableGLDistribution.DistributionAmount.ToAlternateAmount2.EnteredCurrencyRate |

Receivable Distribution To Alternate Rate 3 | ReceivableGLDistribution.DistributionAmount.ToAlternateAmount3.EnteredCurrencyRate |

Receivable Distribution To Company Base Amount | ReceivableGLDistribution.ToCompanyBaseAmount |

Receivable Distribution To Functional Rate | ReceivableGLDistribution.DistributionAmount.ToFunctionalAmount.EnteredCurrencyRate |

Receivable Distribution Transaction Amount | ReceivableGLDistribution.TransactionAmount |

Receivable Distribution Transaction Taxable Amount | ReceivableGLDistribution.TransactionTaxableAmount |

Receivable Distribution Units | ReceivableGLDistribution.Units |

Receivable Distribution Unrecoverable Amount | ReceivableGLDistribution.UnrecoverableAmount |

Receivable Distribution VAT Input Tax Amount | ReceivableGLDistribution.VATInputTaxAmount |

## Receivables Invoice

Measure | Source and/or calculation |
---|---|

ARH Base Amount | ReceivableInvoice.BaseAmount |

ARH Discount Amount | ReceivableInvoice.DiscountAmount |

ARH Discount Percent | ReceivableInvoice.DiscountPercent |

ARH Invoice Amount Currency Amount | ReceivableInvoice.InvoiceAmountCurrencyAmount |

ARH Invoice Amount Functional Amount | ReceivableInvoice.InvoiceAmountFunctionalAmountEnteredCurrencyAmount |

ARH Invoice Count | ReceivableInvoice.ARHInvoiceCount |

ARH Tax Amount | ReceivableInvoice.TaxAmount |

ARH Transaction Amount | ReceivableInvoice.TransactionAmount |

## Receivables Invoice Detail

Measure | Source and/or calculation |
---|---|

Adjustment Amount Currency Amount | ReceivableInvoiceDetail.AdjustmentAmountCurrencyAmount |

Application Amount Currency Amount | ReceivableInvoiceDetail.ApplicationAmountCurrencyAmount |

Base Adjust Amount | ReceivableInvoiceDetail.BaseAdjustAmount |

Base Amount | ReceivableInvoiceDetail.BaseAmount |

Base Open Amount | [AR Receivable Invoice Detail.Invoice Amount Currency Amount] - ([AR Receivable Invoice Detail.Application Amount Currency Amount] + [AR Receivable Invoice Detail.Adjustment Amount Currency Amount]) |

Discount Amount 1 | ReceivableInvoiceDetail.DiscountAmountOrigDiscAmt1 |

Discount Amount 2 | ReceivableInvoiceDetail.DiscountAmountOrigDiscAmt2 |

Discount Amount 3 | ReceivableInvoiceDetail.DiscountAmountOrigDiscAmt3 |

Gain Loss Amount | ReceivableInvoiceDetail.GainLossAmount |

Invoice Amount Currency Amount | ReceivableInvoiceDetail.InvoiceAmountCurrencyAmount |

ReceivableInvoiceDetailKey | ReceivableInvoiceDetail.ReceivableInvoiceDetailKey |

Signed Applied Amount |
IF ([AR Receivable Invoice Detail.Receivable Invoice Detail Type Code] = 'C') THEN [Signed Applied Amount] = [AR Receivable Invoice Detail.Application Amount Currency Amount] * -1 ELSE [Signed Applied Amount] = [AR Receivable Invoice Detail.Application Amount Currency Amount] END IF |

Signed Base Amount |
IF ([AR Receivable Invoice Detail.Receivable Invoice Detail Type Code] = 'C') THEN [Signed Base Amount] = [AR Receivable Invoice Detail.Invoice Amount Currency Amount] * -1 ELSE [Signed Base Amount] = [AR Receivable Invoice Detail.Invoice Amount Currency Amount] END IF |

Signed Base Open Amount |
IF ([AR Receivable Invoice Detail.Receivable Invoice Detail Type Code] = 'C') THEN [Signed Base Open Amount] = ([AR Receivable Invoice Detail.Invoice Amount Currency Amount] - ([AR Receivable Invoice Detail.Application Amount Currency Amount] + [AR Receivable Invoice Detail.Adjustment Amount Currency Amount])) * -1 ELSE [Signed Base Open Amount] = [AR Receivable Invoice Detail.Invoice Amount Currency Amount] - ([AR Receivable Invoice Detail.Application Amount Currency Amount] + [AR Receivable Invoice Detail.Adjustment Amount Currency Amount]) END IF |

## Receivable Payment

Measure | Source and/or calculation |
---|---|

Advance Amount |
IF [AR Receivable Payment.Prepayment Code] = 1 THEN [Advance Amount] = [AR Receivable Payment.Base Amount] ELSE [Advance Amount] = 0.00 END IF |

Applied Amount |
IF [AR Receivable Payment.Status Code] = 2 THEN [Total Unapplied Amount] = IFNULL([AR Receivable Payment.Base Amount],0.0) - IFNULL([AR Receivable Payment.Applied Amount],0.0) ELSE [Total Unapplied Amount] = 0.0 END IF |

Base Adjust Amount | IFNULL([FSM_ReceivablePayment.BaseAdjustAmount],0.0) |

Base Applied Amount | IFNULL([FSM_ReceivablePayment.BaseAppliedAmount],0.0) |

Base Credit Applied Amount | IFNULL([FSM_ReceivablePayment.BaseCreditAppliedAmount],0.0) |

Currency Rate | IFNULL([FSM_ReceivablePayment.CurrencyRate],0.0) |

Receivable Payment Amount | IFNULL([FSM_ReceivablePayment.BaseAmount],0.0) |

ReceivablePaymentKey | ReceivablePayment.ReceivablePaymentKey |

Total Unapplied Amount |
IF [AR Receivable Payment.Status Code] = 2 THEN [Total Unapplied Amount] = IFNULL([AR Receivable Payment.Base Amount],0.0) - IFNULL([AR Receivable Payment.Applied Amount],0.0) ELSE [Total Unapplied Amount] = 0.0 END IF |

Transaction Amount | ReceivablePayment.TransactionAmount |

Transfer Amount | IFNULL([FSM_ReceivablePayment.TransferAmount],0.0) |