Payment Method Transaction Log Data Source

Payment Method Transaction Log

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

• Gateway
• Gateway Response Code
• Gateway Response Code Description
• Gateway Transaction ID
• Gateway Transaction Type
• Payment Method Type
• Request String
• Response String
• Transaction Date
• Transaction Log ID

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 

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

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

Parent 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

Payment Method

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

Sold To 

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