Payment Application Item Data Source

Last updated
Save as PDF

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

Use this data source to export data about payment application items. Each row represents a payment application on one line item of the invoice or debit memo.

Data Source

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

Data Source Detail

The Payment Application Item object represents a business event that happened to a Payment at the item level.

Base Object Description

Descriptions for the base Zuora object.

Zuora Object	Description
Payment Application Item	Payment applications on invoice items and debit memo items. It includes the following fields: Amount Created By ID Created Date Effective Date ID Updated By ID Updated Date

Zuora Object

Description

Payment Application Item

Payment applications on invoice items and debit memo items. It includes the following fields:

Amount
Created By ID
Created Date
Effective 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.
AccountingPeriod	Periods of time that represents the financial calendar of your company. Used to assist with accounting close activities and financial reporting. Contains the following fields: Created By ID Created Date End Date Fiscal Quarter Fiscal Year ID Name Notes Start Date Status Updated By ID Updated Date
Accounts Receivable Accounting Code	Accounting code for accounts receivable. Contains the following fields: Category Created By ID Created Date GL Account Name GL Account Number ID Name Notes Status Type Updated By ID Updated Date
Application Group	Groups of payment, refund, and credit memo applications. It includes the following fields: Created By ID Created Date ID Operation Date Updated By ID Updated Date
Bill To	The Bill-To Contact of the Account.
Bank Account Accounting Code	Accounting code for your bank account. Contains the following fields: Category Created By ID Created Date GL Account Name GL Account Number ID Name Notes Status Type Updated By ID Updated Date
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.
Journal Entry	Represents a Zuora transaction recorded as a debit and credit. Includes the following fields: Created By ID Created Date Currency ID Journal Entry Date Notes Number [Segment Name]: One or more fields representing the name of each segment created. These fields become available for export on this data source only if they are used by the GL segmentation rule. Status Transaction Count Transaction Type Transfer Date Transferred By Transferred To Accounting Update By ID Updated Date
Journal Run	Automated process for creating journal entries from Zuora transactions. Includes the following fields: Created By ID Created Date ID Number Process End Date Time Process Start Date Time Status Target Date Type Target End Date Target Start Date Total Journal Entry Count Updated By ID Updated Date
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 Application	Information about when and how payments are applied to invoices and debit memos. It includes the following fields: Apply Amount Billing Document Owner ID Created By ID Created Date Effective Date ID Payment Application Status 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.
Payment Application Item FX Data	Contains Home Currency and Reporting Currency information. To enable this option, submit a request at Zuora Global Support.
Taxation Item	Related taxation record.
Unapplied Payment Accounting Code	Accounting code for unapplied payments. Includes the following fields: Category Created By ID Created Date GL Account Name GL Account Number ID Name Notes Status Type Updated By ID Updated Date