home

Zuora Platform

Zuora BillingZuora PaymentsZuora PlatformZuora CPQZephrZuora RevenueAccounts ReceivableRelease NotesBasicsEntitlementsSupport and policies
Zuora BillingZuora PaymentsZuora PlatformZuora CPQZephrZuora RevenueAccounts ReceivableRelease NotesBasicsEntitlementsSupport and policies

Welcome to Zuora Product Documentation

Explore our rich library of product information

Show Contents

thumbnailZuora Platform

Data source reference

Invoice Payment data source

Data source to export invoice payment data

Use this data source to export invoice payment data. Each row represents a payment or partial payment that has been applied to an invoice (a payment applied across several invoices will have several rows). Use this export when trying to reconcile partial payments applied across one or multiple invoices. This data source also includes data on Invoice the payment is applied to, and account information.

Note:

If you have the Invoice Settlement feature enabled, this data source is deprecated and is only available for backward compatibility. Use the Payment Part data source instead to export invoice payment information.

Objects available in the data source

Invoice Payment Data Source Diagram

Base object description

ObjectDescription
Invoice Payment

Contains the following fields:

  • Amount
  • Created By ID
  • Created Date
  • ID
  • Refund Amount
  • Updated By ID
  • Updated Date
ObjectDescription
AccountThe account of the invoice payment.
Accounting Period

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
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
Bill To ContactThe Bill To Contact of the account that made the payment.
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
InvoiceInvoice that the payment was applied to.
Invoice PaymentThe base object for this export, it links a payment to an invoice..
Invoice Payment FX Data

Contains Home Currency and Reporting Currency information.

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

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

This object is available on this data source only when Zuora Finance is enabled on your tenant.

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

This object is available on this data source only when Zuora Finance is enabled on your tenant.

PaymentThe payment that used to apply against the invoice.

While most payments are a applied to a single invoice, a payment can be split among multiple invoices, resulting in multiple Invoice Payment objects.

Payment MethodDetails of the payment method, such as credit card or PayPal used to make the payment against the invoice.
Sold To ContactThe Sold To Contact of the account that made the payment.

Last updated: December 5, 2025