ReceivablesRemittanceReferenceRecommendation

The Receivables Remittance Reference Recommendation business object provides the details of how Receivables recommends remittance references for matching and applying customer payments to transactions. This includes the cash receipt, the recommended transaction, the recommendation status, matching score, and applied matching rules.

Expand all

Collapse all

Business Views

** Available for extracting data

• receivablesRemittanceReferenceRecommendationsExtract**

  The Receivables Remittance Reference Recommendation business object provides the details of how Receivables recommends remittance references for matching and applying customer payments to transactions. This includes the cash receipt, the recommended transaction, the recommendation status, matching score, and applied matching rules.

  Label, Plural Label

  Recommendations, Recommendations

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • amountEffectiveScore (big-decimal)

    AutoMatch score that compares the amount match calculated value to the amount weighted threshold value.

    Label

    Amount Effective Score

  • amountWeight (big-decimal)

    Weight that AutoMatch gives to matching the receipt amount to the customer open balance amount.

    Label

    Amount Weight

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • customerEffectiveScore (big-decimal)

    AutoMatch score that compares the customer match calculated value to the customer weighted threshold value.

    Label

    Customer Effective Score

  • customerWeight (big-decimal)

    The relative importance expressed as a percentage of matching the customer information on a transaction within the combined weighted thresholds of an AutoMatch rule set.

    Label

    Customer Weight

  • exactMatchFactor (big-decimal)

    Amount weight exception value that AutoMatch uses to match the receipt amount to the customer open balance amount.

    Label

    Exact Match Factor

  • exactMatchWeight (big-decimal)

    Weight that AutoMatch gives to matching the receipt amount to the customer open balance amount after using the amount weight exception values to find a matching transaction amount.

    Label

    Exact Match Weight

  • matchScore (big-decimal)

    Percentage assigned by the AutoMatch process to indicate how closely a receipt matches a transaction.

    Label

    Match Score

  • netOfFreightFactor (big-decimal)

    Amount weight exception value that AutoMatch gives to the total transaction amount net of freight but including tax.

    Label

    Net of Freight Factor

  • netOfFreightWeight (big-decimal)

    The relative importance of a transaction amount net of freight, expressed as a percentage, within the amount weight threshold of an AutoMatch rule set.

    Label

    Net of Freight Weight

  • netOfTaxAndFreightFactor (big-decimal)

    Amount weight exception value that AutoMatch gives to the total transaction amount net of tax and freight.

    Label

    Net of Tax and Freight Factor

  • netOfTaxAndFreightWeight (big-decimal)

    The relative importance of a transaction amount net of tax and freight, expressed as a percentage, within the amount weight threshold of an AutoMatch rule set.

    Label

    Net of Tax and Freight Weight

  • netOfTaxFactor (big-decimal)

    Amount weight exception value that AutoMatch gives to the total transaction amount net of tax but including freight.

    Label

    Net of Tax Factor

  • netOfTaxWeight (big-decimal)

    The relative importance of a transaction amount net of tax, expressed as a percentage, within the amount weight threshold of an AutoMatch rule set.

    Label

    Net of Tax Weight

  • netUnearnedDiscountFactor (big-decimal)

    Amount weight exception value that AutoMatch gives to transaction amounts that include an unearned discount.

    Label

    Net Unearned Discount Factor

  • recommendationId (int64)

    Identifier of the recommendation generated by the cash reconciliation process.

    Label

    Recommendation ID

    Properties

    • searchable
    • sortable
    • not nullable
  • resolvedTransactionMatch (string)

    Matching number assigned to a cash reconciliation entry once a match between a receipt and a transaction has been resolved during the reconciliation process.

    Label

    Resolved Transaction Match

  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

    • not nullable
  • timeUpdated (date-time)

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • not nullable
  • transactionEffectiveScore (big-decimal)

    AutoMatch score that compares the transaction match calculated value to the transaction weighted threshold value.

    Label

    Transaction Effective Score

  • transactionWeight (big-decimal)

    The relative importance, expressed as a percentage, of matching the open balance amount on a transaction within the combined weighted thresholds of an AutoMatch rule set.

    Label

    Transaction Weight

  • unearnedDiscountWeight (big-decimal)

    The relative importance of the unearned discount on a transaction, expressed as a percentage, within the amount weight threshold of an AutoMatch rule set.

    Label

    Unearned Discount Weight

  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable

  Expand all

  Collapse all

  Reference Object

  • automatchRuleSet (ReceivablesAutomatchRuleSet)

    The AutoMatch rule set provides the details of the AutoMatch rule set. The details include reference set, name, description, start date, end date, customer recommendation threshold, minimum match hold, combined weighted hold, and days of closed invoices hold.

    Business Object

    ReceivablesAutomatchRuleSet

    Expand all

    Collapse all

    Fields

    • automatchRuleId (int64)

      The identifier of the AutoMatch rule set.

      Label

      AutoMatch Rule ID

      Properties

      • searchable
      • sortable
      • not nullable

  • businessUnit (BusinessUnit)

    A business unit represents a unit of an enterprise that performs one or more business functions and may have service provider relationships between the units. It typically focuses on a specific market segment, product line, geographic region, or set of services. The business transactions are recorded, reported, and accounted against the business unit.

    Business Object

    BusinessUnit

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the business unit.

      Label

      Business Unit ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
      • overridable

  • customerAccount (CustomerAccount)

    The Customer Account business object provides the details of the specific business activities that the deploying company engages in with a customer party of type Organization or Person.

    Business Object

    CustomerAccount

    Expand all

    Collapse all

    Fields

    • customerAccountId (int64)

      Identifier of the customer account.

      Label

      Customer Account ID

      Properties

      • searchable
      • sortable
      • not nullable

  • customerAccountSitePurpose (CustomerAccountSitePurpose)

    The Customer Account Site Business Purpose business object provides the details of the business purposes assigned to customer account sites, for example Bill-to, Ship-to, and Statements. Each customer account site can have one or more business purposes.

    Business Object

    CustomerAccountSitePurpose

    Expand all

    Collapse all

    Fields

    • siteUseId (int64)

      Identifier of the customer account site business purpose.

      Label

      Site Use ID

      Properties

      • searchable
      • sortable
      • not nullable

  • matchReason (ERPLookupCode)

    Code that indicates the reason why the receipt wasn't applied to the transaction automatically.

    Business Object

    ERPLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • matchResolvedBy (ERPLookupCode)

    Document reference used to match transactions to receipts. Valid values are: Transaction number, Sales order number, Purchase order number, Balance forward billing number, Shipping reference, Contract number.

    Business Object

    ERPLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • remittanceReference (ReceivablesRemittanceReference)

    The Receivables Receipt Remittance Reference business object provides the number and document reference used to match receipts to transactions.

    Business Object

    ReceivablesRemittanceReference

    Expand all

    Collapse all

    Fields

    • remittanceReferenceId (int64)

      Identifier of the remittance reference.

      Label

      Remittance Reference Identifier

      Properties

      • creatable
      • searchable
      • sortable
      • not nullable
      • updatable

Back to Top