Payment Data Source

Last updated
Save as PDF

Overview

Use this data source to export Payment data, including amount, dates, and status. Each row represents a single payment. This data source also includes data on the account and payment methods associated with the payment.

Objects Available in the Data Source

See Zuora Business Object Model for more information.

Base Object Description

Descriptions for the base Zuora object.

Zuora Object	Description
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

Zuora Object

Description

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

Related Object Descriptions

Descriptions for related Zuora objects are listed in alphabetical order.

Object	Description
Account	The account that made the payment.
Bill To Contact	The bill to contact of the Customer 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
Sold To Contact	The sold to contact of the Customer Account that made the payment.
Payment FX Data	Contains Home Currency and Reporting Currency information. To enable this option, submit a request at Zuora Global Support.
Payment Method	Details of the payment method, such as credit card or PayPal.
Payment Method Snapshot	A copy of the particular Payment Method used in a transaction.
Payment Option	Payment option rule data for ACH payment transactions through the Citi payment gateway integration.