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) |