Welcome to Zuora Product Documentation

Explore our rich library of product information

Credit Memo Part data source

Data source to export the applied and unapplied portions of credit memos

Note:

This feature is only available if you have Invoice Settlement enabled. The Invoice Settlement feature is generally available as of Zuora Billing Release 296 (March 2021). This feature includes Unapplied Payments, Credit and Debit Memos, and Invoice Item Settlement. If you want to have access to the feature, see Invoice Settlement Enablement and Checklist Guide for more information.

Use this data source to export the applied and unapplied portions of credit memos. Each row represents a single portion of a credit memo. A credit memo can be applied to more than invoices and debit memos. You can export this data source to see how much of the credit memo is applied to invoices and debit memos, and how much is unapplied.

Accessing the data source

​Navigation: Reporting > Data Sources and select Credit Memo Part as the data source.

Data source detail

The following sections provide data source details.

Base object description

Descriptions for the base Zuora object.

Zuora ObjectDescription
Credit Memo Part

The applied and unapplied portions of the credit memo. It includes the following fields:

  • Amount
  • Created By ID
  • Created Date
  • ID
  • Updated By ID
  • Updated Date

Descriptions for related Zuora objects are listed in alphabetical order.

Zuora ObjectDescription
AccountThe account that made the payment.
Bill ToThe Bill-To Contact of the Account.
Credit Memo

Credit memos that you issued to your customers to reduce invoice and account balances. It includes the following fields:

  • Amount Applied By
  • Amount Applied To
  • Balance
  • Cancelled By Id
  • Cancelled On
  • Comments
  • Created By ID
  • Created Date
  • Credit Memo Date
  • Memo Number
  • Discount Amount
  • ID
  • Posted By ID
  • Posted On
  • Reason Code
  • Source
  • Status
  • Target Date
  • Tax Amount
  • Total Amount
  • Total Amount Without Tax
  • Total Tax Exempt Amount
  • Transferred To Accounting
  • Updated By ID
  • Updated Date
Credit Memo Part FX Data

Contains Home Currency and Reporting Currency information.

To enable this option, submit a request at Zuora Global Support.
Debit Memo

Debit memos that you issued to your customers to increase the amount your customers owed you. It includes the following fields:

  • Amount Applied By
  • Amount Applied To
  • Balance
  • Cancelled By Id
  • Cancelled On
  • Comments
  • Created By ID
  • Created Date
  • Debit Memo Date
  • Memo Number
  • Discount Amount
  • Due Date
  • ID
  • Posted By ID
  • Posted On
  • Reason Code
  • Source
  • Status
  • Target Date
  • Tax Amount
  • Total Amount
  • Total Amount Without Tax
  • Total Tax Exempt Amount
  • Transferred To Accounting
  • Updated By ID
  • Updated Date
Default Payment Method

The default payment method used to make payments.

Entity

The entity that the data relates to. Part of the Multi-entity feature. Contains the following fields:

  • Address 1
  • Address 2
  • City
  • Country
  • Created By ID
  • Created Date
  • Display Name
  • Email
  • ID
  • Name
  • Postal Code
  • State
  • Updated By ID
  • Updated Date
InvoiceThe invoice to which the credit memo is applied.
Parent Account

Refers to the parent account associated with the customer account, if applicable.

Sold ToThe Sold-To Contact of the Account.