Skip to navigation
DataZuora ReportingData sources and exportsData source reference

Payment data source

View as Markdown

Data source to export Payment data.

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
  • Network Response Code
  • Network Response Code Description
  • 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

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.