CustomerPromiseApplicationReference

A Customer Promise Application Reference in Oracle Fusion provides details about payments and adjustments made to promised invoices. It tracks the applied amount, payment date, whether a payment was reversed, and the reversal date. This reference links promise details, receivable applications, and adjustments, helping to manage and reconcile payments against customer promises.

Expand all

Collapse all

Business Views

** Available for extracting data

• customerPromiseApplicationReferencesExtract**

  A Customer Promise Application Reference in Oracle Fusion provides details about payments and adjustments made to promised invoices. It tracks the applied amount, payment date, whether a payment was reversed, and the reversal date. This reference links promise details, receivable applications, and adjustments, helping to manage and reconcile payments against customer promises.

  Label, Plural Label

  Customer Promise Application References, Customer Promise Application References

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • appliedAmount (big-decimal)

    Amount applied to the promise.

    Label

    Applied Amount

    Properties

    • not nullable
  • appliedDate (date)

    Date when the payment is applied to the promise.

    Label

    Applied Date

    Properties

    • not nullable
  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • promiseApplicationReferenceId (int64)

    Identifier of the customer promise application reference

    Label

    Promise Application Reference Id

    Properties

    • searchable
    • sortable
    • not nullable
  • reversedDate (date)

    Date when the payment is reversed.

    Label

    Reversed Date

  • reversedFlag (boolean)

    Indicates if the payment is reversed.

    Label

    Reversed

  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

    • searchable
    • not nullable
  • timeUpdated (date-time)

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • searchable
    • not nullable
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable

  Expand all

  Collapse all

  Reference Object

  • adjustment (ReceivablesAdjustment)

    An adjustment refers to any modification made to the accounts receivable balance of an organization. It provides information related to adjustments such as adjustment number, adjustment date, receivables activity, accounting date, installment number, installment balance, and adjustment status. The adjustment information is used to update the AMOUNT_ADJUSTED and AMOUNT_DUE_REMAINING columns in the AR_PAYMENT_SCHEDULES_ALL table. If an adjustment is created with a receipt, the ASSOCIATED_CASH_RECEIPT_ID column in the AR_PAYMENT_SCHEDULES_ALL table stores the receipt ID when the adjustment is created against the invoice, debit memo, or chargeback.

    Business Object

    ReceivablesAdjustment

    Expand all

    Collapse all

    Fields

    • adjustmentId (int64)

      The identifier of the adjustment.

      Label

      Adjustment ID

      Properties

      • searchable
      • sortable
      • not nullable

  • promiseDetail (CustomerPromiseDetail)

    The customer promise detail provides the detail of a promise to pay on delinquent invoices.

    Business Object

    CustomerPromiseDetail

    Expand all

    Collapse all

    Fields

    • promiseDetailId (int64)

      The identifier of the promise.

      Label

      Promise Detail ID

      Properties

      • searchable
      • sortable
      • not nullable

  • receiptActivity (ReceivablesReceiptActivity)

    The Receivables Receipt Activity provides the details of the accounting entries for both the cash and credit memo applications, which includes the amount applied, status and related details. Cash applications represent cash receipt applications. If the cash receipt isn't confirmed, applications of that receipt aren't reflected in the payment schedule of the transaction the receipt is applied against.

    Business Object

    ReceivablesReceiptActivity

    Expand all

    Collapse all

    Fields

    • receivableApplicationId (int64)

      The identifier of the receipt application to the transaction.

      Label

      Receivable Application ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

Back to Top