Skip to main content

Payment Application Data Source

Zuora

Payment Application Data Source

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.

Payment Method Snapshot

A copy of the particular Payment Method used in a transaction. 

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.

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