For AI agents: a documentation index is available at the root level at /llms.txt. Append /llms.txt to any URL for a page-level index, or .md for the markdown version of any page.
Data source to export the payment application statistics, including applied payment amount, status, and key dates
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 payment application statistics, including applied payment amount, status, and key dates. Each row represents a single payment application.
Data source
Navigation: Reporting > Data Sources and select Payment Application as the data source.
Data source detail
The Payment Application object represents a business event that happened to a Payment.
Base object description
Descriptions for the base Zuora object.
Zuora Object
Description
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
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 contact associated with the account to whom your product or service is billed.
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
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.
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 Method
Stores information about payment method, such as a credit card, ACH or PayPal.
If the original payment method associated with a payment application has been deleted, PaymentMethod.Type can return null. If you need the payment method type for historical transactions or for conditions based on the Payment Application object, use PaymentMethodSnapshot.Type instead. PaymentMethodSnapshot stores a copy of the payment method used in the transaction and retains that information even after the original payment method is deleted.
Payment Method Snapshot
A copy of the particular Payment Method used in a transaction. If the original payment method is deleted, Payment Method Snapshot retains the payment method information used in the transaction. Use PaymentMethodSnapshot.Type to retrieve the payment method type for historical transactions in this case.
Sold To
The contact associated with the account to whom your product or service is sold.
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
Payment Application FX Data
Contains Home Currency and Reporting Currency information.
