Our Zuora integration is currently in Open Beta. As such, the info in this article may change.
| Release Status | Open Beta | Availability | Premium |
| Status Page | Zuora Status Page | Default Historical Sync | 1 year |
| Whitelist Tables/Columns | Supported/Unsupported | Default Replication Frequency | 30 minutes |
| Full Table Endpoints | 0 | Incremental Endpoints | 42 |
| Destination Incompatibilities | None | ||
Connecting Zuora
Connecting your Zuora data to Stitch is a five-step process:
- Create a Stitch Zuora user
- Add Zuora as a Stitch data source
- Define the Historical Sync
- Define the Replication Frequency
- Select tables to sync
Prerequisites
- Verify that your Zuora account is a Production account. At this time, Stitch can’t connect to Sandbox accounts.
- Verify that you have Administrator permissions in Zuora. This is required to create a Zuora user for Stitch.
Creating a Stitch Zuora User
To connect your Zuora account, we recommend that you create a user for Stitch. Note that you must have Administrator permissions in your Zuora account to create a new user.
To read and replicate your Zuora data, Stitch requires a user that:
- Has Standard user permissions. Note that we will only ever read your data.
-
Has two-factor authentication disabled. If this type of authentication is enabled for the Stitch user, you’ll encounter connection and replication issues after the Zuora setup is complete.
Need some help disabling this setting? Check out the Disable or Reset Two-Factor Authentication section in this Zuora documentation.
- Has credentials that don’t expire. This is only applicable if your company enforces Password Expiration rules. If Stitch’s Zuora credentials expire in the future, you may encounter connection issues. For a workaround, refer to this Zuora support article.
When entering the user credentials in the next step, be sure to use the username and password associated with the user. Entering anything else, such as an API token or secret, will result in an unsuccessful connection.
Add Zuora as a Stitch Data Source
- On the Stitch Dashboard page, click the Add an Integration button.
-
Click the Zuora icon.
-
Enter a name for the integration. This is the name that will display on the for the integration; it’ll also be used to create the schema in your data warehouse.
For example, the name “Stitch Zuora” would create a schema called
stitch_zuorain the data warehouse. This schema is where all the tables for this integration will be stored. - 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.
Defining the Historical Sync
The Sync Historical Data setting will define the starting date for your Zuora integration. This means that data equal to or newer than this date will be replicated to your data warehouse.
Change this setting if you want to sync data beyond Zuora’s default setting of 1 year. For a detailed look at historical syncs, check out the Syncing Historical SaaS Data article.
Define the Replication Frequency
The Replication Frequency controls how often Stitch will attempt to replicate data from your Zuora integration. By default the frequency is set to 30 minutes, but you can change it to better suit your needs.
Before setting the Replication Frequency, note that:
- The more often Zuora is set to replicate, the higher the number of replicated rows.
-
The number of rows in the source may not equal the number of rows replicated by Stitch. Tables that use Full Table Replication will result in a higher number of replicated rows.
- If you’re using a data warehouses that doesn’t natively support nested structures, you’ll see a higher number of replicated rows due to the de-nesting Stitch performs.
To help prevent overages, we recommend setting the Replication Frequency to something less frequent - like 6 hours instead of 30 minutes. For tips on reducing your row count, check out the Reducing Your Row Count section of our Billing Guide.
After selecting a Replication Frequency, click Save Integration.
Selecting Tables to Sync
To complete the setup, you’ll need to select tables you want to sync to your data warehouse.
Check out the Schema section to learn more about the available tables in Zuora.
- In the Integration Details page, click the Tables to Replicate tab.
- Locate a table you want to replicate.
-
To sync a table, click the checkbox next to the table’s name. A green checkmark means the table is set to sync.
- Repeat this process for all the tables you want to replicate.
Zuora’s Intial Sync
After you finish setting up Zuora, you might see its Sync Status 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 sync for the integration. This may take some time to complete.
Zuora Schema
To get a better understanding of how Zuora objects relate to each other, check out Zuora’s Entity Relationship Diagram. It’s incredibly handy for figuring out how to combine different data sets, which will allow you to perform more in-depth and complex analyses.
Included Tables
Note that these tables won't automatically be created in your data warehouse. You must set them to sync in the Integration Details page first.
Stitch's Zuora integration includes these tables:
- zuora_account
- zuora_accounting_code
- zuora_accounting_period
- zuora_amendment
- zuora_billing_run
- zuora_communication_profile
- zuora_contact
- zuora_credit_balance_adjustment
- zuora_export
- zuora_import
- zuora_invoice
- zuora_invoice_adjustment
- zuora_invoice_file
- zuora_invoice_item
- zuora_invoice_item_adjustment
- zuora_invoice_payment
- zuora_invoice_split
- zuora_invoice_split_item
- zuora_journal_entry_item
- zuora_payment
- zuora_payment_method
- zuora_payment_method_snapshot
- zuora_payment_transaction_log
- zuora_product
- zuora_product_rate_plan
- zuora_product_rate_plan_charge
- zuora_product_rate_plan_charge_tier
- zuora_rate_plan
- zuora_rate_plan_charge
- zuora_rate_plan_charge_tier
- zuora_refund
- zuora_refund_invoice_payment
- zuora_refund_transaction_log
- zuora_revenue_charge_summary_item
- zuora_revenue_event_item
- zuora_revenue_schedule_item
- zuora_revenue_schedule_item_invoice_item_adjustment
- zuora_revenue_schedule_item_invoice_item
- zuora_subscription
- zuora_taxation_item
- zuora_unit_of_measure
- zuora_usage
zuora_account
Replication Method: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_account table contains customer account info.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_accounting_code table contains info relevant to the various accounting codes used in Zuora.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_accounting_period table contains info about accounting periods.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_amendment table contains info about amendments, or changes to customer subscriptions.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_billing_run table contains info about ad hoc billing runs.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
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.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_contact table contains info about an account's point-of-contact.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_credit_balance_adjustment table contains info about changes to customers' credit balances.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_export table contains info about export items.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_import table contains info about import functions.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_invoice table contains info about invoices.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_invoice_adjustment table contains info about invoice adjustments, or changes to an existing invoice.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_invoice_file table contains info about invoice files. These are the generated PDF versions of invoices, hosted on Zuora.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_invoice_item table contains info about the line items in invoices.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_invoice_item_adjustment table contains info about adjustments made to invoice items.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_invoice_payment table contains info about payments applied to invoices.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_invoice_split table contains info about 'split' invoices, or one of several invoices that once made up a single invoice.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_invoice_split_item table contains info about the line items contained in split invoices.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_journal_entry_item table contains info about journal entries.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_payment table contains info about customer payments.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_payment_method table contains info about payment methods, or the ways customers pay for their subscriptions.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_payment_method_snapshot table contains 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
updateddate
zuora_payment_transaction_log
Replication Method: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_payment_transaction_log table contains info about transaction logs sent from Zuora to the gateway for payment.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_product table contains info about your company's product offerings.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_product_rate_plan table contains info about product rate plans, or the part of a product that customers can subscribe to.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
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.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_product_rate_plan_charge_tier table contains pricing info for product rate plan charges.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_rate_plan table contains info about rate plans, which is a price or collection of prices for services.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
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.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_rate_plan_charge_tier table contains pricing info for rate plan charges.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_refund table contains info about refunds, or transactions where money is returned to a customer.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_refund_invoice_payment table contains info about refund invoice payments, or parts of refunds that are being made against payments applied to invoices.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_refund_transaction_log table contains info about transactions related to refunds.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_revenue_charge_summary_item table contains info about revenue charge summary items.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_revenue_event_item table contains info about revenue events.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_revenue_schedule_item table contains info about revenue schedule items.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_revenue_schedule_item_invoice_item_adjustment table contains info about adjustments made to revenue schedule item - invoice items.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_revenue_schedule_item_invoice_item table contains info about revenue schedule item - invoice items.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_subscription table contains info about your products and/or services with recurring charges.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_taxation_item table contains info about taxation items, or items that are used to add a tax amount to an invoice item.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
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.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: Incremental
Primary Key: id
Contains Nested Structures?:
No
zuora_usage table contains info about the amount of resources a customer uses.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, please reach out to us.