Refund Transaction Log data source

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.

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