Payment Transaction Log Data Source

Overview

Use this data source to export a log of all transactions from Zuora to the Gateway for the Payment. This data source includes the request string, the response string and the related payment, the payment method, and the account.

The credit card number is masked in the request and response strings.

This feature is in Limited Availability. We are actively soliciting feedback from a small set of early adopters before releasing as generally available.

Data Source

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

Data Source Detail

Data Source Diagram

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

Base Object Description

Zuora Object Description

Zuora Object	Description
Payment Transaction Log	This is the base Zuora object for the Payment Transaction Log data source export and includes the following fields: AVS Response Code Batch ID Created Date: If Zuora Fraud Protection is enabled,the data screening date is also contained in this field, in addition to the transaction creation date. Results for fraud protection and gateway services are in separate rows for clarity. CVV Response Code Gateway: If Zuora Fraud Protection is enabled, the value `Zuora_Fraud_Protection_MSDFP` is also contained in this field, in addition to the name of the gateway integration. Results for fraud protection and gateway services are in separate rows for clarity. Gateway Response Code: If Zuora Fraud Protection is enabled, the data screening result from the fraud protection service is also contained in this field, in addition to the response code from the gateway. Results for fraud protection and gateway services are in separate rows for clarity. Gateway Response Code Description: If Zuora Fraud Protection is enabled, the data screening message from the fraud protection service is also contained in this field, in addition to the response message from the gateway. Results for fraud protection and gateway services are in separate rows for clarity. Gateway State Gateway Transaction ID Gateway Transaction Type 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. Request String Response String Service Type: If Zuora Fraud Protection is enabled, the value is `FraudService`. Otherwise, the value is empty. Transaction Date Transaction Log ID

Payment Transaction Log

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

AVS Response Code
Batch ID
Created Date: If Zuora Fraud Protection is enabled,the data screening date is also contained in this field, in addition to the transaction creation date. Results for fraud protection and gateway services are in separate rows for clarity.
CVV Response Code
Gateway: If Zuora Fraud Protection is enabled, the value Zuora_Fraud_Protection_MSDFP is also contained in this field, in addition to the name of the gateway integration. Results for fraud protection and gateway services are in separate rows for clarity.
Gateway Response Code: If Zuora Fraud Protection is enabled, the data screening result from the fraud protection service is also contained in this field, in addition to the response code from the gateway. Results for fraud protection and gateway services are in separate rows for clarity.
Gateway Response Code Description: If Zuora Fraud Protection is enabled, the data screening message from the fraud protection service is also contained in this field, in addition to the response message from the gateway. Results for fraud protection and gateway services are in separate rows for clarity.
Gateway State
Gateway Transaction ID
Gateway Transaction Type
- 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.
Request String
Response String
Service Type: If Zuora Fraud Protection is enabled, the value is FraudService. Otherwise, the value is empty.
Transaction Date
Transaction Log ID

Related Object Descriptions

Descriptions for related Zuora objects are listed in alphabetical order.

Object	Description
Account	The customer account information. Note this is the Invoice Owner account. This object includes the following fields: Account Balance Account Number Additional Email Addresses Allow Invoice Editing Auto Pay Bill Cycle Day Bill Cycle Day Setting Option Billing Batch CMRR CRM Account ID CSR CommunicationProfile ID Created By ID Created Date Credit Balance Currency ID Invoice Delivery Preferences Email Invoice Delivery Preferences Print Invoice Template ID Last Invoice Date Name Notes PO Number Parent ID Payment Gateway Name Payment Term Sales Rep Status Tax Exempt Certificate ID Tax Exempt Certificate Type Tax Exempt Description Tax Exempt Effective Date Tax Exempt Expiration Date Tax Exempt Issuing Jurisdiction Tax Exempt Status Total Invoice Balance Updated By ID Updated Date
Bill To	The contact associated with the account to whom your product or service is billed. This object includes the following fields: Account ID Address 1 Address 2 City Country County Created By ID Created Date Description Fax First Name Home Phone ID Last Name Mobile Phone Nick Name Other Phone Other Phone Type Personal Email Postal Code State/Province Tax Region Updated By ID Updated Date Work Email Work Phone
Default Payment Method	The default payment method used to make payments. This object includes the following fields: ACH ABA Code ACH Account Name ACH Account Number Mask ACH Account Type ACH Bank Name Account ID Active 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 Created By ID Created Date 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 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 Updated By ID Updated Date Use Default Retry Rule
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
Parent Account	Refers to the parent account associated with the customer account, if applicable. This object includes the following fields: Account Balance Account Number Additional Email Addresses Allow Invoice Editing Auto Pay Bill Cycle Day Bill Cycle Day Setting Option Billing Batch CMRR CRM Account ID CSR CommunicationProfile ID Created By ID Created Date Credit Balance Currency ID Invoice Delivery Preferences Email Invoice Delivery Preferences Print Invoice Template ID Last Invoice Date Name Notes PO Number Parent ID Payment Gateway Name Payment Term Sales Rep Status Tax Exempt Certificate ID Tax Exempt Certificate Type Tax Exempt Description Tax Exempt Effective Date Tax Exempt Expiration Date Tax Exempt Issuing Jurisdiction Tax Exempt Status Total Invoice Balance Updated By ID Updated Date
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
Payment Method	Stores information about payment method, such as a credit card, ACH or PayPal. ACH ABA Code ACH Account Name ACH Account Number Mask ACH Account Type ACH Bank Name Account ID Active 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> Created By ID Created Date 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 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 Updated By ID Updated Date Use Default Retry Rule
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
Sold To	The contact associated with the account to whom your product or service is sold. This object includes the following fields: Account ID Address 1 Address 2 City Country County Created By ID Created Date Description Fax First Name Home Phone ID Last Name Mobile Phone Nick Name Other Phone Other Phone Type Personal Email Postal Code State/Province Tax Region Updated By ID Updated Date Work Email Work Phone