Knowledge Center

Knowledge Center > Reporting > Data Sources and Exports > Data Source Reference > Payment Part Data Source

Payment Part Data Source

This feature is only available if you have the Advanced AR Settlement feature enabled. The Advanced AR Settlement feature is in Limited Availability. If you wish to have access to the feature, submit a request at Zuora Global Support

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.

Data Source

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

Data Source Detail

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
  • Created By ID
  • Created Date
  • ID
  • Updated By ID
  • Updated Date

Related Object Descriptions

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 owned 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
  • Debit 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 information. This object is only used for Zuora Multi-entity.

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 Advanced AR 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 Response
  • Gateway Response Code
  • Gateway State
  • ID
  • Marked For Submission On
  • Payment Number
  • Reference ID
  • Referenced Payment ID
  • Refund Amount
  • Second Payment Reference ID
  • Settled On
  • Soft Descriptor
  • Soft Descriptor Phone
  • Source
  • Source Name
  • Status
  • Submitted On
  • Transferred to Accounting
  • Type
  • Unapplied Amount
  • Updated By ID
  • Updated Date

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.
Last modified
19:13, 10 May 2017

Tags

Classifications

(not set)