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 Supported By

Stitch

Stitch Plan

Standard

DATA SELECTION
Table Selection

Supported

Column Selection

Unsupported

REPLICATION SETTINGS
Anchor Scheduling

Unsupported

Advanced Scheduling

Unsupported

Table-level Reset

Unsupported

Configurable Replication Methods

Unsupported

TRANSPARENCY
Extraction Logs

Unsupported

Loading Reports

Supported

Connecting Zuora

Zuora setup requirements

To set up Zuora in Stitch, you need:

  • A Standard or higher Stitch plan. While those currently in the Free Trial will also be able to set up Zuora, replication will be paused until a Standard plan or higher is selected after the trial ends.
  • Administrator permissions in Zuora. These permissions are required to create a Zuora user for Stitch.

Step 1: Create a Stitch Zuora user

In this step, you’ll create a Zuora user for Stitch. Creating a Stitch-specific user will ensure that Stitch is distinguishable in any logs or audits.

Create the Zuora user

Zuora user permissions

  1. Sign into your Zuora account, if you haven’t already.
  2. Click your username in the top-right corner.
  3. Click Administration, then Manage Users.
  4. Click Add Single User.
  5. Enter a first and last name for the user.
  6. Enter an email address in the Work Email field.
  7. Enter an email address in the Login Field.
  8. In the Zuora Platform Role field, select Standard User.
  9. For the remaining Role fields, select the Standard User option.
  10. There aren’t any requirements for the Locale and Language fields - leave them as the defaults.
  11. Click Save to create the user.

After the user is created, Zuora will send a verification email to the email address in the Work Email field. Complete the verification and set a password for the Stitch user before moving on to the next step.

Step 2: Add Zuora as a Stitch data source

  1. Sign into your Stitch account.
  2. On the Stitch Dashboard page, click the Add Integration button.

  3. Click the Zuora icon.

  4. Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.

    For example, the name “Stitch Zuora” would create a schema called stitch_zuora in the destination. Note: Schema names cannot be changed after you save the integration.

  5. Enter the username and password of the Stitch user. Note that Stitch needs the username and password - entering a token and secret will result in an unsuccessful connection.
  6. If the instance you want to connect to Stitch is a sandbox, check the Connect to a Sandbox Environment box.

Initial and historical replication jobs

After you finish setting up Zuora, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.

For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.

Free historical data loads

The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.


Zuora table schemas

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


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.