Skip to main content

Refund Transaction Log Data Source

Zuora

Refund Transaction Log Data Source

Overview

Use this data source to export a log of all transactions from Zuora to the gateway for the Refund. This datasource includes the request string, response string as well as the related Refund and Account.

Data Source

Navigation: Reporting > Data Sources and select Refund Transaction Log as the data source.

Data Source Detail

Data Source Diagram

This diagram illustrates the hierarchical association between the base Refund Transaction Log object and related (joined) Zuora objects.

graph_data_refund_transaction.jpg

Base Object Description

Zuora Object Description

Payment Transaction Log

This is the base Zuora object for the Refund Transaction Log data source export and includes the following fields:

    • Authorization: Payment method creation and update.
    • Capture: Used for delayed capture.
    • Sale: Payment creation.
    • Void: Void sale (not void authorization).
    • Credit: Not used.
    • Inquiry: Used for the inquiry call in the payment detail page.
    • RefundAuthorize: Not used.
    • Refund: Refund.
    • VoidAuth: Voids payment method authorization for a credit card.
    • Validate: No longer used. Was used for Spectrum when the authorization amount was 0. 
    • Deposit: No longer used. Was used as a batch operation to capture by Spectrum.
    • NonReferenceRefund: Refund credit balance.

Related Object Descriptions

Descriptions for related Zuora objects are listed in alphabetical order.

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

Payment Method Snapshot

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

This object includes the following fields:

  • ACH ABA Code

  • ACH Account Name

  • ACH Account Number Mask

  • ACH Account Type

  • ACH Bank Name

  • Account ID

  • Bank Branch Code

  • Bank Check Digit

  • Bank City

  • Bank Code

  • Bank Identification Number

  • Bank Name

  • Bank Postal Code

  • Bank Street Name

  • Bank Street Number

  • Bank Transfer Account Name

  • Bank Transfer Account Number Mask

  • Bank Transfer Account Type

  • Bank Transfer Type

  • Business Identification Code

  • City

  • Country

  • Credit Card Address 1

  • Credit Card Address 2

  • Credit Card City

  • Credit Card Country

  • Credit Card Expiration Month

  • Credit Card Expiration Year

  • Credit Card Holder Name

  • Credit Card Mask Number

  • Credit Card Postal Code

  • Credit Card State

  • Credit Card Type

  • Device Session ID

  • Email

  • Existing Mandate

  • First Name

  • IBAN

  • ID

  • IP Address

  • Last Failed Sale Transaction Date

  • Last Name

  • Last Transaction Date

  • Last Transaction Status

  • Mandate Creation Date

  • Mandate ID

  • Mandate Received

  • Mandate Update Date

  • Max Consecutive Payment Failures

  • Name

  • Number of Consecutive Failures

  • Payment Method ID

  • Payment Method Status

  • Payment Retry Window

  • Paypal BAID

  • Paypal Email

  • Paypal Preapproval Key

  • Paypal Type

  • Phone

  • Postal Code

  • Second Token ID

  • State

  • Street Name

  • Street Number

  • Token ID

  • Total Number Of Error Payments

  • Total Number Of Processed Payments

  • Type

  • Use Default Retry Rule

Refund 

Represents money that is returned to a customer, or a reversed transaction.

This object includes the following fields:

  • Accounting Code

  • Amount

  • Cancelled On

  • Comment

  • Created By ID

  • Created Date

  • Gateway

  • Gateway Response

  • Gateway Response Code

  • Gateway State

  • ID

  • Marked For Submission On

  • Method Type

  • Payment Method ID

  • Reason Code

  • Reference ID

  • Refund Date

  • Refund Number

  • Refund Transaction Time

  • Second Refund Reference ID

  • Settled On

  • Soft Descriptor

  • Soft Descriptor Phone

  • Source Type

  • Status

  • Submitted On

  • Transferred to Accounting

  • Type

  • Updated By ID

  • Updated Date