Important: Version 15-10-2015 deprecation
This version of the Zuora integration will be deprecated on September 1, 2018 and no longer be formally supported by the Stitch Support Team.
Connections created from October 15, 2015 to April 16, 2018 use this version. Upgrade to the latest version (1.0) to take advantage of the new enhancements.
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 |
Deprecated |
Supported By | |
| Stitch Plan |
Paid |
||
| 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 paid Stitch plan. While those currently in the Free Trial will also be able to set up Zuora, replication will be paused until a paid plan 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.
Important: Zuora user requirements
To replicate your Zuora data, Stitch requires a user that:
- Has Standard user permissions. While Stitch will only ever read your data, these permissions are required to access certain objects in Zuora.
- Has two-factor authentication disabled. If this is enabled, connection and replication issues will occur after setup. Refer to the Disable or Reset Two-Factor Authentication section in this Zuora documentation for help disabling this setting.
- Has credentials that don’t expire. This is applicable only if your company enforces Password Expiration rules. If Stitch’s Zuora credentials expire, connection issues may arise. Refer to this Zuora support article for a workaround.
Create the Zuora user
- Sign into your Zuora account, if you haven’t already.
- Click your username in the top-right corner.
- Click Administration, then Manage Users.
- Click Add Single User.
- Enter a first and last name for the user.
- Enter an email address in the Work Email field.
- Enter an email address in the Login Field.
- In the Zuora Platform Role field, select Standard User.
- For the remaining Role fields, select the Standard User option.
- There aren’t any requirements for the Locale and Language fields - leave them as the defaults.
- 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
- Sign into your Stitch account.
-
On the Stitch Dashboard page, click the Add Integration button.
-
Click the Zuora icon.
-
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_zuorain the destination. Note: Schema names cannot be changed after you save the integration. - 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.
- 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.
Initial replication jobs with Anchor Scheduling
If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the Anchor Scheduling documentation for more information.
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
Schemas and versioning
Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.
The schema and info displayed below is for version 15-10-2015 of this integration.
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
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: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Full Table
Primary Key: id
Contains Nested Structures?:
No
zuora_payment_method_snapshot table contains snapshot info about payment methods.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
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: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Key-based 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: Key-based 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, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.