Skip to navigation
DataZuora ReportingData sources and exportsData source reference

Payment Part Item data source

View as Markdown

Data source to export data about payment part items

This feature is only available if you have Invoice Item Settlement enabled. Invoice Item Settlement must be used together with other Invoice Settlement features (Unapplied Payments, and Credit and Debit memos). If you want to enable Invoice Settlement, see see Invoice Settlement Enablement and Checklist Guide for more information.

Use this data source to export data about payment part items. Each row represents a portion of a payment that is associated with one line item on an invoice or debit memo.

Accessing the data source

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

Data source detail

The following sections provide data source details.

Base object description

Descriptions for the base Zuora object.

Zuora Object

Description

Payment Part Item

The payment part items that are associated with invoice items and debit memo items. 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 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

Debit Memo Item

Line items on debit memos. It includes the following fields:

  • Amount Without Tax
  • Applied To Others Amount
  • Be Applied By Others Amount
  • Charge Date
  • Created By ID
  • Created Date
  • Description
  • ID
  • Processing Type
  • Quantity
  • SKU
  • Service End Date
  • Service Start Date
  • Tax Amount
  • Tax Code Name
  • Tax Exempt Amount
  • Tax Mode
  • Unit Of Measure
  • Unit Price
  • Updated By ID
  • Updated Date

Debit Taxation Item

Taxation records on debit memos. It includes the following fields:

  • Accounting Code
  • Created By ID
  • Created Date
  • ExemptAmount
  • ID
  • Jurisdiction
  • Location Code
  • Name
  • Tax Amount
  • Tax Code
  • Tax Code Description
  • Tax Date
  • Tax Mode
  • Tax Rate
  • Tax Rate Description
  • Tax Rate Type
  • 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.

Invoice Item

Represents one line item on the invoice.

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 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.

Payment Part

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

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

Payment Part Item FX Data

Contains Home Currency and Reporting Currency information.

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

Sold To

The Sold-To Contact of the Account.

Taxation Item

Related taxation record.