Knowledge Center

Knowledge Center > Reporting > Data Sources and Exports > Data Source Reference > Payment Data Source

Payment Data Source

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

payment_datasource.png

Base Object Description

Descriptions for related Zuora objects are listed in alphabetical order.

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
  • 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 Response
  • Gateway Response Code
  • Gateway State
  • ID
  • Marked For Submission On
  • Payment Number
  • Reference ID
  • Referenced Payment ID
  • Refund Amount
  • Second Payment Reference ID
  • Settled On
  • Soft Descriptor
  • Soft Descriptor Phone
  • Source
  • Source Name
  • 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 information. This object is only used for Zuora Multi-entity.

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 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.
Last modified
23:15, 8 Jan 2017

Tags

Classifications

(not set)