Zuora integration summary

Stitch’s Zuora integration replicates data using the Zuora SOAP API. Refer to the Schema section for a list of objects available for replication.

Zuora feature snapshot

A high-level look at Stitch's Zuora (v15-10-2015) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release status

Sunset on September 1, 2018

 Supported by

[Stitch] (https://community.qlik.com/t5/Support/ct-p/qlikSupport)
Stitch plan

Standard

 API availability

Not available
Singer GitHub repository

Not applicable
REPLICATION SETTINGS
Anchor Scheduling

Unsupported

 Advanced Scheduling

Unsupported
Table-level reset

Unsupported

 Configurable Replication Methods

Unsupported
DATA SELECTION
Table selection

Supported

 Column selection

Unsupported
Select all

Supported
TRANSPARENCY
Extraction Logs

Unsupported

 Loading Reports

Supported

Zuora table reference

Zuora object relationships

To get a better understanding of how Zuora objects relate to each other, check out Zuora’s Entity Relationship Diagram.

Understanding the relationships between different data sets will allow you to perform more in-depth and complex analyses.

Don’t see a table listed here? The list of tables shown below is not an exhaustive list of all the tables Stitch can replicate from Zuora.

We’re working on adding documentation for additional Zuora tables. If there’s a specific table you’d like to see here, let us know by opening an issue in the Stitch Docs GitHub repo.


zuora_account

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_account table contains customer account info.

Table Info & Attributes

zuora_account Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Account ID (id)

  • autopay

  • invoicedeliveryprefsemail

  • balance

  • crmid

  • billcycleday

  • defaultpaymentmethodid

  • invoicetemplateid

  • communicationprofileid

  • accountnumber

  • paymentterm

  • purchaseordernumber

  • status

  • createdbyid

  • invoicedeliveryprefsprint

  • bcdsettingoption

  • updatedbyid

  • batch

  • creditbalance

  • billtoid

  • soldtoid

  • allowinvoiceedit

  • createddate

  • updateddate

  • customerservicerepname

  • lastinvoicedate

  • currency

  • name

  • totalinvoicebalance

  • notes

  • salesrepname

  • parentid

zuora_accounting_code

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_accounting_code table contains info relevant to the various accounting codes used in Zuora.

Table Info & Attributes

zuora_accounting_code Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Accounting Code ID (id)

  • category

  • createdbyid

  • createddate

  • glaccountname

  • glaccountnumber

  • name

  • status

  • type

  • updatedbyid

  • updateddate

zuora_accounting_period

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_accounting_period table contains info about accounting periods.

Table Info & Attributes

zuora_accounting_period Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Accounting Period ID (id)

  • createdbyid

  • createddate

  • enddate

  • fiscalquarter

  • fiscalyear

  • name

  • notes

  • startdate

  • status

  • updatedbyid

  • updateddate

zuora_amendment

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_amendment table contains info about amendments, or changes to customer subscriptions.

Table Info & Attributes

zuora_amendment Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Amendment ID (id)

  • autorenew

  • code

  • contracteffectivedate

  • createdbyid

  • createddate

  • currentterm

  • currenttermperiodtype

  • customeracceptancedate

  • description

  • destinationaccountid

  • destinationinvoiceonwerid

  • effectivedate

  • name

  • rateplandata

  • renewalsetting

  • renewalterm

  • renewaltermperiodtype

  • serviceactivationdate

  • specificupdatedate

  • status

  • subscriptionid

  • termstartdate

  • termtype

  • type

  • updatedbyid

  • updateddate

zuora_billing_run

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_billing_run table contains info about ad hoc billing runs.

Table Info & Attributes

zuora_billing_run Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Billing Run ID (id)

  • accountid

  • autoemail

  • autopost

  • autorenewal

  • batch

  • billcycleday

  • billrunnumber

  • chargetypetoexclude

  • errormessage

  • executeddate

  • invoicedate

  • invoicesemailed

  • lastemailsenttime

  • noemailforzeroamountinvoice

  • numberofaccounts

  • numberofinvoices

  • status

  • targetdate

  • createdbyid

  • createddate

  • updatedbyid

  • updateddate

zuora_communication_profile

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_communication_profile table contains info about communication profiles. Communication Profiles are sets of policies that determine how to communicate with the contacts associated with an account.

Table Info & Attributes

zuora_communication_profile Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Communication Profile ID (id)

  • createdbyid

  • createddate

  • description

  • profilename

  • updatedbyid

  • updateddate

zuora_contact

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_contact table contains info about an account's point-of-contact.

Table Info & Attributes

zuora_contact Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Contact ID (id)

  • accountid

  • address1

  • address2

  • city

  • country

  • createdbyid

  • createddate

  • firstname

  • lastname

  • mobiilephone

  • nickname

  • otherphonetype

  • postalcode

  • state

  • workemail

  • workphone

  • updatedbyid

  • updateddate

zuora_credit_balance_adjustment

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_credit_balance_adjustment table contains info about changes to customers' credit balances.

Table Info & Attributes

zuora_credit_balance_adjustment Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Credit Balance Adjustment ID (id)

  • accountid

  • accountingcode

  • adjustmentdate

  • amount

  • comment

  • createdbyid

  • createddate

  • number

  • reasoncode

  • referenceid

  • sourcetransactionid

  • sourcetransactionnumber

  • sourcetransactiontype

  • status

  • type

  • updatedbyid

  • updateddate

zuora_export

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_export table contains info about export items.

Table Info & Attributes

zuora_export Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Export ID (id)

  • createdbyid

  • createddate

  • encrypted

  • fileid

  • format

  • name

  • query

  • size

  • status

  • zip

  • updatedbyid

  • updateddate

zuora_import

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_import table contains info about import functions.

Table Info & Attributes

zuora_import Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Import ID (id)

  • createdbyid

  • createddate

  • importedcount

  • importtype

  • name

  • originalresourceurl

  • resultresourceurl

  • status

  • statusreason

  • totalcount

  • updatedbyid

  • updateddate

zuora_invoice

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_invoice table contains info about invoices.

Table Info & Attributes

zuora_invoice Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Invoice ID (id)

  • accountid

  • adjustmentamount

  • amount

  • balance

  • createdbyid

  • createddate

  • creditbalanceadjustmentamount

  • duedate

  • includesometime

  • includesrecurring

  • includesusage

  • invoicedate

  • invoicenumber

  • lastemailssentdate

  • paymentamount

  • postedby

  • posteddate

  • refundamount

  • status

  • targetdate

  • updatedbyid

  • updateddate

zuora_invoice_adjustment

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_invoice_adjustment table contains info about invoice adjustments, or changes to an existing invoice.

Table Info & Attributes

zuora_invoice_adjustment Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Invoice Adjustment ID (id)

  • accountid

  • accountingperiod

  • accountsreceivableaccountingcode

  • billtocontact

  • createdbyid

  • createddate

  • defaultpaymentmethod

  • deferredrevenueaccountingcode

  • entity

  • invoiceid

  • soldtocontact

  • updatedbyid

  • updateddate

zuora_invoice_file

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_invoice_file table contains info about invoice files. These are the generated PDF versions of invoices, hosted on Zuora.

Table Info & Attributes

zuora_invoice_file Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes.

  • Invoice File ID (id)

  • createdbyid

  • createddate

  • invoiceid

  • pdffileurl

  • versionnumber

  • updatedbyid

  • updateddate

zuora_invoice_item

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_invoice_item table contains info about the line items in invoices.

Table Info & Attributes

zuora_invoice_item Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Invoice Item ID (id)

  • accountid

  • accountingperiod

  • chargedate

  • chargedescription

  • chargeid

  • chargename

  • chargenumber

  • chargetype

  • createdbyid

  • createddate

  • invoiceid

  • processingtype

  • productid

  • productname

  • quantity

  • rateplanchargeid

  • serviceenddate

  • servicestartdate

  • sku

  • subscriptionid

  • subscriptionnumber

  • unitprice

  • uom

  • updatedbyid

  • updateddate

zuora_invoice_item_adjustment

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_invoice_item_adjustment table contains info about adjustments made to invoice items.

Table Info & Attributes

zuora_invoice_item_adjustment Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Invoice Item Adjustment ID (id)

  • accountid

  • accountingperiod

  • accountsreceivableaccountingcode

  • adjustmentdate

  • adjustmentnumber

  • amount

  • amendment

  • cancelleddate

  • comment

  • createdbyid

  • createddate

  • invoiceid

  • invoiceitemname

  • invoicenumber

  • reasoncode

  • referenceid

  • serviceenddate

  • servicestartdtae

  • sourceid

  • sourcetype

  • status

  • type

  • updatedbyid

  • updateddate

zuora_invoice_payment

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_invoice_payment table contains info about payments applied to invoices.

Table Info & Attributes

zuora_invoice_payment Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Invoice Payment ID (id)

  • amount

  • createdbyid

  • createddate

  • invoiceid

  • paymentid

  • refundamount

  • updatedbyid

  • updateddate

zuora_invoice_split

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_invoice_split table contains info about 'split' invoices, or one of several invoices that once made up a single invoice.

Table Info & Attributes

zuora_invoice_split Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Invoice Split ID (id)

  • createdbyid

  • createddate

  • invoiceid

  • updatedbyid

  • updateddate

zuora_invoice_split_item

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_invoice_split_item table contains info about the line items contained in split invoices.

Table Info & Attributes

zuora_invoice_split_item Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Invoice Split Item ID (id)

  • createdbyid

  • createddate

  • invoicedate

  • invoiceid

  • invoicesplititd

  • paymentterm

  • splitpercentage

  • updatedbyid

  • updateddate

zuora_journal_entry_item

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_journal_entry_item table contains info about journal entries.

Table Info & Attributes

zuora_journal_entry_item Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Journal Entry ID (id)

  • amount

  • createdbyid

  • createddate

  • currency

  • type

  • updatedbyid

  • updateddate

zuora_payment

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_payment table contains info about customer payments.

Table Info & Attributes

zuora_payment Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Payment ID (id)

  • accountid

  • accountingcode

  • amount

  • appliedcreditbalanceamount

  • bankidentifcationnumber

  • cancelledon

  • comment

  • createdbyid

  • createddate

  • effectivedate

  • gateway

  • gatewayresponse

  • gatewayresponsecode

  • gatewaystate

  • paymentmethodid

  • paymentmethodsnapshotid

  • paymentnumber

  • referenceid

  • refundamount

  • source

  • sourcename

  • status

  • submittedon

  • type

  • updatedbyid

  • updateddate

zuora_payment_method

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_payment_method table contains info about payment methods, or the ways customers pay for their subscriptions.

Table Info & Attributes

zuora_payment_method Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Payment Method ID (id)

  • accountid

  • achaddress1

  • achadress2

  • active

  • bankidentificationnumber

  • createdbyid

  • createddate

  • creditcardaddress1

  • creditcardaddress2

  • creditcardcity

  • creditcardcountry

  • creditcardexpirationmonth

  • creditcardexpirationyear

  • creditcardholdername

  • creditcardmasknumber

  • creditcardpostalcode

  • creditcardstate

  • creditcardtype

  • email

  • lastfailedsaletransactiondate

  • lasttransactiondatetime

  • lasttransactionstatus

  • name

  • numconsecutivefailures

  • paymentmethodstatus

  • phone

  • totalnumberoferrorpayments

  • totalnumberofprocessedpayments

  • type

  • useddefaultentryrule

  • updatedbyid

  • updateddate

zuora_payment_method_snapshot

Replication Method: Full Table
Primary Key: id
Contains Nested Structures?: No

The zuora_payment_method_snapshot table contains snapshot info about payment methods.

Table Info & Attributes

zuora_payment_method_snapshot Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Payment Method Snapshot ID (id)

  • accountid

  • bankidentificationnumber

  • createdbyid

  • createddate

  • creditcardaddress1

  • creditcardaddress2

  • creditcardcity

  • creditcardcountry

  • creditcardexpirationmonth

  • creditcardexpirationyear

  • creditcardholdername

  • creditcardmasknumber

  • creditcardpostalcode

  • creditcardstate

  • creditcardtype

  • email

  • lastfailedsaletransactiondate

  • lasttransactiondatetime

  • lasttransactionstatus

  • name

  • numconsecutivefailures

  • paymentmethodstatus

  • phone

  • totalnumberoferrorpayments

  • totalnumberofprocessedpayments

  • type

  • useddefaultentryrule

  • updatedbyid

  • updatedon

zuora_payment_transaction_log

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_payment_transaction_log table contains info about transaction logs sent from Zuora to the gateway for payment.

Table Info & Attributes

zuora_payment_transaction_log Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Payment Transaction Log ID (id)

  • gateway

  • gatewayreasoncode

  • gatewayreasoncodedescription

  • gatewaytransactiontype

  • paymentmethodid

  • paymentmethodtype

  • requeststring

  • responsestring

  • transactiondate

  • transactionid

zuora_product

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_product table contains info about your company's product offerings.

Table Info & Attributes

zuora_product Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Product ID (id)

  • allowfeaturechanges

  • category

  • description

  • effectiveenddate

  • effectivestartdate

  • name

  • sku

  • createdbyid

  • createddate

  • updatedbyid

  • updateddate

zuora_product_rate_plan

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_product_rate_plan table contains info about product rate plans, or the part of a product that customers can subscribe to.

Table Info & Attributes

zuora_product_rate_plan Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Product Rate Plan ID (id)

  • activecurrencies

  • createdbyid

  • createddate

  • description

  • effectiveenddate

  • effectivestartdate

  • name

  • productid

  • updatedbyid

  • updateddate

zuora_product_rate_plan_charge

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_product_rate_plan_charge table contains info about product rate plan charges, which are a charge model or set of fees associated with a product rate plan.

Table Info & Attributes

zuora_product_rate_plan_charge Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Product Rate Plan Charge ID (id)

  • accountingcode

  • applydiscountto

  • billcycleday

  • billcycletype

  • billingperiod

  • billingperiodalignment

  • billingtiming

  • chargemodel

  • chargetype

  • createdbyid

  • createddate

  • defaultquantity

  • deferredrevenueaccount

  • description

  • discountlevel

  • enddatecondition

  • includedunits

  • listpricebase

  • maxquantity

  • minquantity

  • model

  • name

  • numberofperiod

  • overagecalculationoption

  • overageunusedunitscreditoption

  • pricechangeoption

  • priceincreaseoption

  • priceincreasepercentage

  • productrateplanid

  • recognizedrevenuerulename

  • revreccode

  • revrectriggercondition

  • smoothingmodel

  • specificbillingperiod

  • taxable

  • taxcode

  • taxmode

  • triggerevent

  • type

  • uom

  • updatedbyid

  • updateddate

  • uptoperiods

  • uptoperiodstype

  • usagerecordratingoption

  • usediscountspecificaccountingcode

  • usetenantdfaultforpricechange

  • weeklybillcycleday

zuora_product_rate_plan_charge_tier

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_product_rate_plan_charge_tier table contains pricing info for product rate plan charges.

Table Info & Attributes

zuora_product_rate_plan_charge_tier Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Product Rate Plan Charge Tier ID (id)

  • active

  • createdbyid

  • createddate

  • currency

  • discountamount

  • discountpercentage

  • endingunit

  • isoverageprice

  • price

  • priceformat

  • productrateplanchargeid

  • startingunit

  • tier

  • updatedbyid

  • updateddate

zuora_rate_plan

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_rate_plan table contains info about rate plans, which is a price or collection of prices for services.

Table Info & Attributes

Custom Fields

In addition to the attributes listed below, our Zuora integration will also replicate any custom fields.

zuora_rate_plan Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Rate Plan ID (id)

  • amendmentid

  • amendmentsubscriptionrateplanid

  • amendmenttype

  • createdbyid

  • createddate

  • name

  • productrateplanid

  • subscriptionid

  • updatedbyid

  • updateddate

zuora_rate_plan_charge

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_rate_plan_charge table contains info about rate plan charges, which are the parts of a subscription or subscription amendment that come from product rate charges.

Table Info & Attributes

Custom Fields

In addition to the attributes listed below, our Zuora integration will also replicate any custom fields.

zuora_rate_plan_charge Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Rate Plan Charge ID (id)

  • accountingcode

  • applydiscountto

  • billcycleday

  • billcycletype

  • billingperiod

  • billingperiodalignment

  • billingtiming

  • chargedthroughdate

  • chargemodel

  • chargenumber

  • chargetype

  • createdbyid

  • createddate

  • description

  • discountamount

  • discountlevel

  • discountpercentage

  • dmrc

  • dtcv

  • effectiveenddate

  • effectivestartdate

  • enddatecondition

  • includedunits

  • islastsegment

  • listpricebase

  • mrr

  • name

  • numberofperiods

  • originalid

  • overagecalculationoption

  • overageprice

  • overageunusedunitscreditoption

  • price

  • pricechangeoption

  • priceincreasepercentage

  • processedthroughdate

  • productrateplanchargeid

  • quantity

  • rateplanid

  • recognizedrevenuerulename

  • revreccode

  • revrectriggercondition

  • rolloverbalance

  • segment

  • specificbillingperiod

  • specificenddate

  • tcv

  • triggerdate

  • triggerevent

  • unusedunitscreditrates

  • uom

  • updatedbyid

  • updateddate

  • uptoperiods

  • uptoperiodstype

  • usagerecordratingoption

  • usediscountspecificaccountingcode

  • version

  • weeklybillcycleday

zuora_rate_plan_charge_tier

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_rate_plan_charge_tier table contains pricing info for rate plan charges.

Table Info & Attributes

zuora_rate_plan_charge_tier Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Rate Plan Charge Tier ID (id)

  • createdbyid

  • createddate

  • endingunit

  • isoverageprice

  • price

  • priceformat

  • rateplanchargeid

  • startingunit

  • tier

  • updatedbyid

  • updateddate

zuora_refund

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_refund table contains info about refunds, or transactions where money is returned to a customer.

Table Info & Attributes

zuora_refund Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Refund ID (id)

  • accountid

  • accountingcode

  • amount

  • cancelledon

  • comment

  • createdbyid

  • createddate

  • effectivedate

  • gateway

  • gatewayoptiondata

  • gatewayresponse

  • gatewayresponsecode

  • gatewaystate

  • markedforsubmissionon

  • methodtype

  • paymentid

  • paymentmethodid

  • paymentmethodsnapshotid

  • reasoncode

  • referenceid

  • refundamount

  • refunddate

  • refundinvoicepaymentdata

  • refundnumber

  • refundtransactiontime

  • secondrefundreferenceid

  • settledon

  • softdescriptor

  • softdescriptionphone

  • sourcetype

  • status

  • submittedon

  • transferredtoaccounting

  • type

  • updatedbyid

  • updateddate

zuora_refund_invoice_payment

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_refund_invoice_payment table contains info about refund invoice payments, or parts of refunds that are being made against payments applied to invoices.

Table Info & Attributes

zuora_refund_invoice_payment Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Refund Invoice Payment ID (id)

  • createdbyid

  • createddate

  • invoiceidid

  • invoicepaymentid

  • refundamount

  • refundid

  • updatedbyid

  • updateddate

zuora_refund_transaction_log

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_refund_transaction_log table contains info about transactions related to refunds.

Table Info & Attributes

zuora_refund_transaction_log Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Refund Transaction Log ID (id)

  • gateway

  • gatewayreasoncode

  • gatewayreasoncodedescription

  • gatewaytransactiontype

  • refundid

  • requeststring

  • responsestring

  • transactiondate

  • transactionid

zuora_revenue_charge_summary_item

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_revenue_charge_summary_item table contains info about revenue charge summary items.

Table Info & Attributes

zuora_revenue_charge_summary_item Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Revenue Charge Summary Item ID (id)

  • amount

  • createdbyid

  • createddate

  • currency

  • updatedbyid

  • updateddate

zuora_revenue_event_item

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_revenue_event_item table contains info about revenue events.

Table Info & Attributes

zuora_revenue_event_item Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Revenue Event Item ID (id)

  • amount

  • createdbyid

  • createddate

  • currency

  • updatedbyid

  • updateddate

zuora_revenue_schedule_item

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_revenue_schedule_item table contains info about revenue schedule items.

Table Info & Attributes

zuora_revenue_schedule_item Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Revenue Schedule Item ID (id)

  • amount

  • createdbyid

  • createddate

  • currency

  • updatedbyid

  • updateddate

zuora_revenue_schedule_item_invoice_item_adjustment

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_revenue_schedule_item_invoice_item_adjustment table contains info about adjustments made to revenue schedule item - invoice items.

Table Info & Attributes

zuora_revenue_schedule_item_invoice_item_adjustment Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Revenue Schedule Item Invoice Item ID (id)

  • amount

  • createdbyid

  • createddate

  • currency

  • updatedbyid

  • updateddate

zuora_revenue_schedule_item_invoice_item

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_revenue_schedule_item_invoice_item table contains info about revenue schedule item - invoice items.

Table Info & Attributes

zuora_revenue_schedule_item_invoice_item Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Revenue Schedule Item Invoice Item ID (id)

  • amount

  • createdbyid

  • createddate

  • currency

  • updatedbyid

  • updateddate

zuora_subscription

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_subscription table contains info about your products and/or services with recurring charges.

Table Info & Attributes

Custom Fields

In addition to the attributes listed below, our Zuora integration will also replicate any custom fields.

zuora_subscription Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Subscription ID (id)

  • accountid

  • ancestoraccountid

  • autorenew

  • cancelleddate

  • contractacceptancedate

  • contracteffectivedate

  • createdbyid

  • createddate

  • creatoraccountid

  • creatorinvoiceownerid

  • currentterm

  • currenttermperiodtype

  • initialterm

  • intitaltermperiodtype

  • invoiceownerid

  • isinvoiceseparate

  • name

  • notes

  • originalcreateddate

  • originalid

  • previoussubscriptionid

  • renewalsetting

  • renewalterm

  • renewaltermperiodtype

  • serviceactivationdate

  • status

  • subscriptionenddate

  • subscriptionstartdate

  • termenddate

  • termstartdate

  • termtype

  • updatedbyid

  • updateddate

  • version

  • versioncreateddate

zuora_taxation_item

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_taxation_item table contains info about taxation items, or items that are used to add a tax amount to an invoice item.

Table Info & Attributes

zuora_taxation_item Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Taxation Item ID (id)

  • accountingcode

  • createdbyid

  • createddate

  • exemptamount

  • invoiceid

  • invoiceitemid

  • jurisdiction

  • locationcode

  • name

  • taxamount

  • taxcode

  • taxcodedescription

  • taxdate

  • taxrate

  • taxratedescription

  • taxratetype

  • updatedbyid

  • updateddate

zuora_unit_of_measure

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_unit_of_measure table contains info about units of measure. These are definable units that you measure when determining charges. For example: if a subscription plan includes 5 licenses, then 5 is the quantity and the license is the unit of measure.

Table Info & Attributes

zuora_unit_of_measure Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Unit of Measure ID (id)

  • active

  • createdbyid

  • createddate

  • decimalplaces

  • displayedas

  • roundingmode

  • uomname

  • updatedbyid

  • updateddate

zuora_usage

Replication Method: Key-based Incremental
Primary Key: id
Contains Nested Structures?: No

The zuora_usage table contains info about the amount of resources a customer uses.

Table Info & Attributes

zuora_usage Attributes

While we try to include everything Zuora has here, this may not be a full list of attributes. Refer to Zuora's documentation for a full list and description of each attribute.

  • Usage ID (id)

  • accountid

  • accountnumber

  • ancestoraccountid

  • chargeid

  • chargenumber

  • createdbyid

  • createddate

  • creatoraccountid

  • description

  • enddatetime

  • importid

  • invoiceid

  • invoicenumber

  • quantity

  • rbestatus

  • sourcename

  • sourcetype

  • startdatetime

  • submissiondatetime

  • subscriptionid

  • subscriptionnumber

  • uom

  • updatedbyid

  • updateddate

Related Troubleshooting
Questions? Feedback?

Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.