Stitch Documentation
has moved!

Please update your bookmarks to

If you're not automatically redirected after 5 seconds, click here.

Expected Zuora Data

Now that Zuora is successfully connected to your Stitch account, what comes next? In this article, we'll cover:

Replicating Zuora Data

Historical Sync

By default, a historical sync of Zuora data goes back one year from the Stitch connection date.


Stitch will replicate Zuora data based on the frequency you define. The default setting is every half hour, but you can change it to more or less frequent based on your needs.

Replication Methods

Zuora data is replicated using Incremental Replication. This means that every time Zuora data is queued for replication, only new and updated records will be replicated to your data warehouse.

Zuora Tables in Your Data Warehouse

After Stitch completes an initial sync, you'll have the ability to select individual tables for syncing.

Below is a list of the main and subtables that are available for syncing. Because Zuora uses nested arrays to structure data in some of its API's endpoints, Stitch will de-nest these arrays and create subtables. Refer to the Handling of nested data structures doc for more info.

To see the attributes of each table, refer to Zuora's API documentation - click the table name to go there. If you want to learn more about how the tables in your Zuora integration relate to each other, we recommend checking out Zuora's entity relationship diagram.

account This table includes customer account information, including the account ID, customer's address, payment methods, terms, balance, and so on.
accounting_code This table includes information relevant to the various accounting codes used in Zuora. Attributes include the accounting code category, GL account information, status, and type.
accounting_period The accounting_period table includes attributes such as the period's ID, start and end dates, fiscal year, name, and status.
amendment Amendments are changes to customer subscriptions. This table records information about these changes, such as the amendment's ID, code, effective date, customer acceptance date, renewal setting, and more.
billing_run The billing_run table records information about ad hoc billing runs, including the billing run ID, account ID, batch information, charge type exclusions, execution date, invoice information, status, target date, and creation/update information.
communication_profile A communication profile is a set of policies that determine how to communicate with the contacts associated with an account. This table records the profile ID, name, description, and creation information.
contact The contact table contains information about an account's point of contact, including the account ID, address, name, phone number, and email.
credit_balance_adjustment This table records information about changes to a customer's credit balance and includes the adjustment ID, account ID, accounting code, adjustment date, amount, reason code, source transaction information, and status.
invoice The invoice table includes the invoice ID, customer's account ID, adjustment amounts, invoice amount, pre-tax amount, balance, bill run ID, due date, one-time charge information, recurring charges, invoice date, payment amount, refund amount, posting information, source, status, and tax amount attributes.
invoice_adjustment An invoice adjustment modifies an existing invoice. This table contains information about these adjustments, including the ID, account ID, accounting code, adjustment date, amount, creation information, customer name, impact amount, reason code, status, and type.
invoice_item The invoice_item table records information about individual line items in invoices. Attributes include the ID, accounting code, charge information, invoice ID, processing type, product information, subscription ID, and tax information.
invoice_item_adjustment This table records information about adjustments to line items in invoices such as the adjustment ID, account ID, accounting code, adjustment date, amount, invoice ID, reason code, source, status, and type.
invoice_payment An invoice payment is just that - a payment applied to an invoice. Attributes of this table include the payment ID, amount, invoice ID, refund amount, and creation information.
invoice_split A 'split' invoice is one of several invoices that once formed one original invoices. This table contains information about split invoices, such as the original invoice ID, the split invoice ID, and creation information.
invoice_split_item Split invoice items refer to the individual line items contained in split invoices. Data in this table includes the split invoice item ID, invoice date, new invoice ID, payment term, and the split percentage.
journal_entry_item The journal_entry_item table records information about journal entries, including the journal entry item ID, amount, currency, type, accounting code, accounting period, detailed journal information, and creation/update information.
payment The payment table contains all the information related to customer payments, including the payment ID, account ID, accounting code, amount, application information, auth ID, effective date, gateway data, invoice data, payment method, settlement date, source, status, submission date, and type.
payment_method Payment methods are the ways customers pay for their subscriptions. The payment_method table records the various payment types such as check, PayPal, credit card, and so on. Attributes include the ID, account ID, and information specific to each payment type, depending on how the customer paid. Click the table name to see the full list of fields in this table.
payment_method_snapshot The fields in this table are identical to those in the payment_method table, which the exception of the Active, Created by ID, Created Date, Updated by ID, and Updated Date fields. Check out the PaymentMethod documentation (click the table name) for more information.
payment_transaction_log This payment_transaction_log table contains information about transaction logs sent from Zuora to the gateway for payment. Attributes include the payment transaction log ID, batch ID, gateway information, account, billing information, payment method, and creation/update information.
product The product table contains data about the products your company offers, including the product ID, category, description, effective start and end dates, SKU, and update information.
product_rate_plan A product rate plan is the part of a product that your customers can subscribe to. This table records information about the product rate plans, including ID, active currencies, description, effective start and end dates, name, and product ID.
product_rate_plan_charge Product rate plan charges are a charge model or a set of fees associated with a product rate plan. This table includes the ID, accounting code, discount information, billing and billing cycle information, charge type, end date condition, quantity information, overage information, product rate plan ID, tax information, trigger event, and more.
product_rate_plan_charge_tier The product_rate_plan_charge_tier holds the pricing information for product rate plan charges. Attributes include the ID, currency, discount information, price, product rate plan charge ID, tier, and more.

A rate plan is a price or collection of prices for services. The rate_plan table contains the rate plan ID, name, amendment information, and product rate plan ID.

Note that rate plans that were removed by an amendment with the type "Remove Product Amendment" are not returned.

rate_plan_charge Rate plan charges are parts of a subscription or subscription amendment, which come from product rate plan charges. Attributes of this table include the rate plan charge ID, accounting code, billing cycle and period information, charge information, discount information, effective start and end dates,
rate_plan_charge_tier Rate plan charge tiers are part of a subscription or amendment; it comes from a product rate plan charge tier. A rate plan charge tier contains the prices for a rate plan charge. This table includes the rate plan charge tier ID, pricing and overage information, rate plan charge ID, tier information, and creation/update information.
refund Refunds are transactions where money is returned to the customer. The refund table records information about these transactions such as the refund ID, account ID, accounting code, amount, cancellation information, processing and settlement information, refund method, reason code, refund date, status, type, and update information.
refund_invoice_payment A refund invoice payment is a part of a refund that's being made against a payment that was applied to an invoice. Attributes in this table includes the refund invoice payment ID, refund amount, refund ID, and creation/update information.
refund_transaction_log A refund transaction log is a record of all transactions related to refunds. The refund_transaction_log table includes the transaction log ID, batch ID, gateway information, and request and response strings.
revenue_charge_summary_item The revenue_charge_summary_item table includes the ID, amount, currency, and creation/update information.
revenue_event_item The revenue_event_item table records information about revenue events. Attributes include the revenue event item ID, amount, currency, and creation/update information.
revenue_schedule_item The revenue_schedule_item table contains information about revenue schedule items, including the revenue schedule item ID, amount, currency, ID, and creation/update information.
revenue_schedule_item_invoice_item_adjustment The revenue_schedule_item_invoice_item_adjustment table records information pertaining to revenue schedule item - invoice item adjustments. Attributes include the ID, amount, currency, and creation/update information.
revenue_schedule_item_invoice_item The revenue_schedule_item_invoice_item table includes the ID, amount, currency, and creation/update information. Click the table name for a full list of related data points.
subscription Subscriptions are products or services with recurring charges - your Stitch plan is a good example of this. The subscriptions table includes the subscription ID, account ID, renewal information, cancellation information, contract information, current term, term type, name, creation information, status, and version information.
taxation_item A Taxation Item is used to add a tax amount to an invoice item. The taxation_item table includes the Taxation Item ID, accounting code, exempt amount, invoice ID, invoice item ID, jurisdiction, location code, name, tax information, and creation/update information.
unit_of_measure Unit of measures are definable units that you measure when determining charges. If a subscription plan includes 5 licenses, then 5 is the quantity and the license is the unit that the quantity measures. The unit_of_measure records the Unit of Measure ID, name, status, decimal places, display value, rounding value, and creation/update information.
updater_detail The updater_detail table contains information about the Payment Method Updater, including the payment method, new payment method, and batch information.
usage Usage is the amount of resources a customer uses. Attributes of this table include the usage ID, account ID, account number, charge information, description, invoice information, quantity, RBE (rating and billing engine) status, soucre information, start and end dates, subscription information, units of measure, and creation/update information.



Was this article helpful?
0 out of 0 found this helpful


Questions or suggestions? If something in our documentation is unclear, let us know in the comments!