Payment Part data source

Data source to export the applied and unapplied portions of the payments

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 see Invoice Settlement Enablement and Checklist Guide for more information.

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

Accessing the data source

Navigation: Reporting > Data Sources and select Payment Part as the data source.

Data source details

The following sections provide data source details.

Base object description

Descriptions for the base Zuora object.

Zuora object	Description
Payment Part	The applied and unapplied portions of the payments. It includes the following fields: Amount Billing Document Owner ID Created By ID Created Date ID Updated By ID Updated Date

Zuora object

Description

Payment Part

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

Amount
Billing Document Owner ID
Created By ID
Created Date
ID
Updated By ID
Updated Date

Descriptions for related Zuora objects are listed in alphabetical order.

Zuora object	Description
Account	The account that made the payment.
Bill To	The Bill-To Contact of the Account.
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
Invoice	The invoice to which the payment is applied.
Parent Account	Refers to the parent account associated with the customer account, if applicable.
Payment	The money sent by a customer to pay for charges related to their subscriptions. Contains the following fields: Accounting Code Amount Applied Amount (Only applicable if you have Invoice Settlement enabled) Applied Credit Balance Amount Authorized Transaction ID Bank Identification Number Cancelled On Comment Created By ID Created Date Currency Effective Date Gateway Gateway Order ID Gateway Reconciliation Status Gateway Reconciliation Reason Gateway Response Gateway Response Code Gateway State ID Marked For Submission On Payment Number Payout Id Prepayment Reference ID Referenced Payment ID Refund Amount Second Payment Reference ID Settled On Soft Descriptor Soft Descriptor Phone Source Source Name Standalone (Only applicable if support for standalone payments is enabled) Status Submitted On Transferred to Accounting Type Unapplied Amount Updated By ID Updated Date
Payment Part FX Data	Contains Home Currency and Reporting Currency information. To enable this option, submit a request at Zuora Global Support.
Payment Method	Stores information about payment method, such as a credit card, ACH or PayPal.
Payment Method Snapshot	A copy of the particular Payment Method used in a transaction.
Sold To	The Sold-To Contact of the Account.

Accessing the data source

Data source details

Base object description

Related object descriptions