Zuora integration summary

Stitch’s Zuora integration can use one of two APIs: REST API and AQuA API. When setting up the integration in Stitch, you can choose which API to use.

Additionally, Stitch supports replicating custom fields for any object that supports custom fields in Zuora. Custom fields are supported for both the REST API and AQuA API.

Note: Each API has its benefits and limitations. For example: With the AQuA API, you can replicate large data sets and deleted records for objects that support it. Once an integration is saved, the API selected can’t be changed. Learn more about the APIs.

Refer to the Schema section for a list of objects available for replication.

Zuora feature snapshot

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

STITCH
Release status

Released on April 17, 2018

Supported by

Stitch

Stitch plan

Standard

API availability

Available

Singer GitHub repository

singer-io/tap-zuora

REPLICATION SETTINGS
Anchor Scheduling

Supported

Advanced Scheduling

Supported

Table-level reset

Unsupported

Configurable Replication Methods

Unsupported

DATA SELECTION
Table selection

Supported

Column selection

Supported

Select all

Supported

TRANSPARENCY
Extraction Logs

Supported

Loading Reports

Supported

Connecting Zuora

Zuora setup requirements

To set up Zuora in Stitch, you need:

  • 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. If the Zuora instance you want to connect to Stitch is a sandbox, check the Connect to a Sandbox Environment checkbox.
  6. In the Username field, enter the Stitch Zuora user’s username. This is the email address that was in the Login Name field when you created the user.
  7. In the Password field, enter the password associated with the Stitch Zuora user.
  8. If the Zuora instance you want to connect to Stitch is a sandbox, check the Connect to a Sandbox Environment box.
  9. If the Zuora instance you want to connect to Stitch is based in Europe, check the Connect to a European endpoint box. If you aren’t sure if this is applicable to you, refer to Zuora’s documentation.

Step 3: Select a Zuora extraction API

Stitch’s Zuora integration gives you the ability to select the API that you want Stitch to use to extract data. If you aren’t sure which API you should use, take a look at the brief comparison below.

Note: This setting can be changed at any time, but will only affect extractions that take place after the change.

Once you’ve decided, click the radio button next to the API you want to use.

REST API AQuA API
Good for replicating

Small data sets, more frequently

Large data sets, less frequently

Deleted records

Unsupported

Supported. An additional column (deleted) will be added to objects that support deletions, which indicates the record’s deletion status.

Deleted data extraction is unsupported by the AQuA API for the following objects:

  • accountingPeriod

  • contactSnapshot

  • discountAppliedMetrics

  • paymentGaterwayReconciliationEventLog

  • paymentTransactionLog

  • paymentMethodTransactionLog

  • paymentReconciliationJob

  • paymentReconciliationLog

  • processedUsage

  • refundTransactionLog

  • updaterBatch

  • updaterDetail

Refer to Zuora’s documentation for more info.

Requires additional Zuora credentials

Not required

Required. Using the AQuA API requires a Partner ID - to obtain one, reach out to Zuora Global Support.

Step 4: Define the historical replication start date

The Sync Historical Data setting defines 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 replicate data beyond Zuora’s default setting of 1 year. For a detailed look at historical replication jobs, check out the Syncing Historical SaaS Data guide.

Step 5: Create a replication schedule

In the Replication Frequency section, you’ll create the integration’s replication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.

Zuora integrations support the following replication scheduling methods:

To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.

Step 6: Set objects to replicate

The last step is to select the tables and columns you want to replicate. Learn about the available tables for this integration.

Note: If a replication job is currently in progress, new selections won’t be used until the next job starts.

For Zuora integrations, you can select:

  1. Individual tables and columns

  2. All tables and columns

Click the tabs to view instructions for each selection method.

  1. In the integration’s Tables to Replicate tab, locate a table you want to replicate.
  2. To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.

  3. To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.

  4. Repeat this process for all the tables and columns you want to replicate.
  5. When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.
  1. Click into the integration from the Stitch Dashboard page.
  2. Click the Tables to Replicate tab.

  3. In the list of tables, click the box next to the Table Names column.
  4. In the menu that displays, click Track all Tables and Fields:

    The Track all Tables and Fields menu in the Tables to Replicate tab

  5. Click the Finalize Your Selections button at the bottom of the page to save your data selections.

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 replication

Replicate deleted data

If using the AQuA API for data extraction, deleted data will be replicated for objects that support it. Supported objects will contain a boolean column named deleted that indicates a record’s deletion status.

Note: This column won’t be automatically included for replication - it must be set to replicate.

Deleted data is supported for all objects with the exception of the following:

  • accountingPeriod

  • contactSnapshot

  • discountAppliedMetrics

  • paymentGaterwayReconciliationEventLog

  • paymentTransactionLog

  • paymentMethodTransactionLog

  • paymentReconciliationJob

  • paymentReconciliationLog

  • processedUsage

  • refundTransactionLog

  • updaterBatch

  • updaterDetail

Custom field replication

Custom object properties, or attributes, are supported by Stitch’s Zuora integration. If custom fields are available through Zuora’s API, Stitch will replicate them to your destination.

This is applicable to any object that supports custom fields in Zuora. Refer to Zuora’s documentation for info on which objects support custom fields.

Unsupported objects

Stitch’s Zuora integration doesn’t currently support replication for the following objects:

  • discountApplyDetail

  • invoiceFile

  • paymentMethodSnapshot

  • productDiscountApplyDetail

  • unitOfMeasure


Zuora table reference

Zuora object relationships

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

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

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

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


Account

The Account table contains information about the customer accounts in your Zuora instance.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

Join Account with on
ContactSnapshot
Account.id = ContactSnapshot.accountId
Account.billToContactId = ContactSnapshot.contactId
Account.soldToContactId = ContactSnapshot.contactId
Invoice
Account.id = Invoice.accountId
Account.billToContactId = Invoice.billToContactId
Account.soldToContactId = Invoice.billToContactId
Account.billToContactId = Invoice.soldToContactId
Account.soldToContactId = Invoice.soldToContactId
Account.defaultPaymentMethodId = Invoice.defaultPaymentMethodId
Account.parentAccountId = Invoice.parentAccountId
Payment
Account.id = Payment.accountId
Refund
Account.id = Refund.accountId
Account.billToContactId = Refund.billToContactId
Account.soldToContactId = Refund.billToContactId
Account.billToContactId = Refund.soldToContactId
Account.soldToContactId = Refund.soldToContactId
Account.parentAccountId = Refund.parentAccountId
Subscription
Account.id = Subscription.accountId
Contact
Account.billToContactId = Contact.id
Account.soldToContactId = Contact.id
CreditBalanceAdjustment
Account.billToContactId = CreditBalanceAdjustment.billToContactId
Account.soldToContactId = CreditBalanceAdjustment.billToContactId
Account.billToContactId = CreditBalanceAdjustment.soldToContactId
Account.soldToContactId = CreditBalanceAdjustment.soldToContactId
Account.parentAccountId = CreditBalanceAdjustment.parentAccountId
DiscountAppliedMetrics
Account.billToContactId = DiscountAppliedMetrics.billToContactId
Account.soldToContactId = DiscountAppliedMetrics.billToContactId
Account.billToContactId = DiscountAppliedMetrics.soldToContactId
Account.soldToContactId = DiscountAppliedMetrics.soldToContactId
Account.parentAccountId = DiscountAppliedMetrics.parentAccountId
InvoiceItemAdjustment
Account.billToContactId = InvoiceItemAdjustment.billToContactId
Account.soldToContactId = InvoiceItemAdjustment.billToContactId
Account.billToContactId = InvoiceItemAdjustment.soldToContactId
Account.soldToContactId = InvoiceItemAdjustment.soldToContactId
Account.parentAccountId = InvoiceItemAdjustment.parentAccountId
ProcessedUsage
Account.billToContactId = ProcessedUsage.billToContactId
Account.soldToContactId = ProcessedUsage.billToContactId
Account.billToContactId = ProcessedUsage.soldToContactId
Account.soldToContactId = ProcessedUsage.soldToContactId
Account.parentAccountId = ProcessedUsage.parentAccountId
RatePlan
Account.billToContactId = RatePlan.billToContactId
Account.soldToContactId = RatePlan.billToContactId
RevenueChargeSummaryItem
Account.billToContactId = RevenueChargeSummaryItem.billToContactId
Account.soldToContactId = RevenueChargeSummaryItem.billToContactId
Account.billToContactId = RevenueChargeSummaryItem.soldToContactId
Account.soldToContactId = RevenueChargeSummaryItem.soldToContactId
Account.parentAccountId = RevenueChargeSummaryItem.parentAccountId
RevenueEventItem
Account.billToContactId = RevenueEventItem.billToContactId
Account.soldToContactId = RevenueEventItem.billToContactId
Account.billToContactId = RevenueEventItem.soldToContactId
Account.soldToContactId = RevenueEventItem.soldToContactId
Account.id = RevenueEventItem.deferredRevenueAccountingCodeId
Account.parentAccountId = RevenueEventItem.parentAccountId
RevenueEventItemInvoiceItem
Account.billToContactId = RevenueEventItemInvoiceItem.billToContactId
Account.soldToContactId = RevenueEventItemInvoiceItem.billToContactId
Account.billToContactId = RevenueEventItemInvoiceItem.soldToContactId
Account.soldToContactId = RevenueEventItemInvoiceItem.soldToContactId
Account.id = RevenueEventItemInvoiceItem.deferredRevenueAccountingCodeId
Account.parentAccountId = RevenueEventItemInvoiceItem.parentAccountId
RevenueEventItemInvoiceItemAdjustment
Account.billToContactId = RevenueEventItemInvoiceItemAdjustment.billToContactId
Account.soldToContactId = RevenueEventItemInvoiceItemAdjustment.billToContactId
Account.billToContactId = RevenueEventItemInvoiceItemAdjustment.soldToContactId
Account.soldToContactId = RevenueEventItemInvoiceItemAdjustment.soldToContactId
Account.id = RevenueEventItemInvoiceItemAdjustment.deferredRevenueAccountingCodeId
Account.parentAccountId = RevenueEventItemInvoiceItemAdjustment.parentAccountId
RevenueScheduleItem
Account.billToContactId = RevenueScheduleItem.billToContactId
Account.soldToContactId = RevenueScheduleItem.billToContactId
Account.billToContactId = RevenueScheduleItem.soldToContactId
Account.soldToContactId = RevenueScheduleItem.soldToContactId
Account.id = RevenueScheduleItem.deferredRevenueAccountingCodeId
Account.parentAccountId = RevenueScheduleItem.parentAccountId
RevenueScheduleItemInvoiceItem
Account.billToContactId = RevenueScheduleItemInvoiceItem.billToContactId
Account.soldToContactId = RevenueScheduleItemInvoiceItem.billToContactId
Account.billToContactId = RevenueScheduleItemInvoiceItem.soldToContactId
Account.soldToContactId = RevenueScheduleItemInvoiceItem.soldToContactId
Account.id = RevenueScheduleItemInvoiceItem.deferredRevenueAccountingCodeId
Account.parentAccountId = RevenueScheduleItemInvoiceItem.parentAccountId
RevenueScheduleItemInvoiceItemAdjustment
Account.billToContactId = RevenueScheduleItemInvoiceItemAdjustment.billToContactId
Account.soldToContactId = RevenueScheduleItemInvoiceItemAdjustment.billToContactId
Account.billToContactId = RevenueScheduleItemInvoiceItemAdjustment.soldToContactId
Account.soldToContactId = RevenueScheduleItemInvoiceItemAdjustment.soldToContactId
Account.id = RevenueScheduleItemInvoiceItemAdjustment.deferredRevenueAccountingCodeId
Account.parentAccountId = RevenueScheduleItemInvoiceItemAdjustment.parentAccountId
CommunicationProfile
Account.communicationProfileId = CommunicationProfile.id
PaymentMethod
Account.defaultPaymentMethodId = PaymentMethod.id

accountNumber

STRING

additionalEmailAddresses

STRING

allowInvoiceEdit

BOOLEAN

autoPay

BOOLEAN

balance

DECIMAL

batch

STRING

bcdSettingOption

STRING

billCycleDay

INTEGER

billToContactId

STRING

communicationProfileId

STRING

createdById

STRING

createdDate

DATE-TIME

creditBalance

DECIMAL

crmId

STRING

currency

STRING

customerServiceRepName

STRING

defaultPaymentMethodId

STRING

deleted

BOOLEAN

id

STRING

invoiceDeliveryPrefsEmail

BOOLEAN

invoiceDeliveryPrefsPrint

BOOLEAN

invoiceTemplateId

STRING

lastInvoiceDate

DATE-TIME

name

STRING

notes

STRING

parentAccountId

STRING

paymentGateway

STRING

paymentTerm

STRING

purchaseOrderNumber

STRING

salesRepName

STRING

soldToContactId

STRING

status

STRING

taxExemptCertificateId

STRING

taxExemptCertificateType

STRING

taxExemptDescription

STRING

taxExemptEffectiveDate

DATE-TIME

taxExemptExpirationDate

DATE-TIME

taxExemptIssuingJurisdiction

STRING

taxExemptStatus

STRING

totalInvoiceBalance

DECIMAL

updatedById

STRING

updatedDate

DATE-TIME

AccountingCode

The AccountingCode table contains information about the accounting codes in your Zuora instance. Accounting codes are used to categorize transactions for accounting purposes.

Note: To replicate this table, you must have Zuora Finance enabled.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

Join AccountingCode with on
CreditBalanceAdjustment
AccountingCode.id = CreditBalanceAdjustment.accountingCode
AccountingCode.id = CreditBalanceAdjustment.accountReceivableAccountingCodeId
AccountingCode.id = CreditBalanceAdjustment.cashOnAccountAccountingCodeId
InvoiceItem
AccountingCode.id = InvoiceItem.accountingCode
InvoiceItemAdjustment
AccountingCode.id = InvoiceItemAdjustment.accountingCode
AccountingCode.id = InvoiceItemAdjustment.accountReceivableAccountingCodeId
AccountingCode.id = InvoiceItemAdjustment.recognizedRevenueAccountingCodeId
AccountingCode.id = InvoiceItemAdjustment.salesTaxPayableAccountingCodeId
ProductRatePlanCharge
AccountingCode.id = ProductRatePlanCharge.accountingCode
RevenueEventItem
AccountingCode.id = RevenueEventItem.recognizedRevenueAccountingCodeId
RevenueEventItemInvoiceItem
AccountingCode.id = RevenueEventItemInvoiceItem.recognizedRevenueAccountingCodeId
RevenueEventItemInvoiceItemAdjustment
AccountingCode.id = RevenueEventItemInvoiceItemAdjustment.recognizedRevenueAccountingCodeId
RevenueScheduleItem
AccountingCode.id = RevenueScheduleItem.recognizedRevenueAccountingCodeId
RevenueScheduleItemInvoiceItem
AccountingCode.id = RevenueScheduleItemInvoiceItem.recognizedRevenueAccountingCodeId
RevenueScheduleItemInvoiceItemAdjustment
AccountingCode.id = RevenueScheduleItemInvoiceItemAdjustment.recognizedRevenueAccountingCodeId

category

STRING

createdById

STRING

createdDate

DATE-TIME

deleted

BOOLEAN

glAccountName

STRING

glAccountNumber

STRING

id

STRING

name

STRING

notes

STRING

status

STRING

type

STRING

updatedById

STRING

updatedDate

DATE-TIME

AccountingPeriod

The AccountingPeriod table contains information about the accounting periods in your Zuora account.

Note: To replicate this table, you must have Zuora Finance enabled.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

Join AccountingPeriod with on
CreditBalanceAdjustment
AccountingPeriod.id = CreditBalanceAdjustment.accountingPeriodId
InvoiceItemAdjustment
AccountingPeriod.id = InvoiceItemAdjustment.accountingPeriodId
JournalEntry
AccountingPeriod.id = JournalEntry.accountingPeriodId
RevenueChargeSummaryItem
AccountingPeriod.id = RevenueChargeSummaryItem.accountingPeriodId
RevenueEventItemInvoiceItem
AccountingPeriod.id = RevenueEventItemInvoiceItem.accountingPeriodId
RevenueEventItemInvoiceItemAdjustment
AccountingPeriod.id = RevenueEventItemInvoiceItemAdjustment.accountingPeriodId
RevenueScheduleItem
AccountingPeriod.id = RevenueScheduleItem.accountingPeriodId
RevenueScheduleItemInvoiceItem
AccountingPeriod.id = RevenueScheduleItemInvoiceItem.accountingPeriodId
RevenueScheduleItemInvoiceItemAdjustment
AccountingPeriod.id = RevenueScheduleItemInvoiceItemAdjustment.accountingPeriodId

createdById

STRING

createdDate

DATE-TIME

endDate

DATE-TIME

fiscalQuarter

STRING

fiscalYear

STRING

id

STRING

name

STRING

notes

STRING

runTrialBalanceEnd

DATE-TIME

runTrialBalanceErrorMessage

STRING

runTrialBalanceStart

DATE-TIME

runTrialBalanceStatus

STRING

startDate

DATE-TIME

status

STRING

updatedById

STRING

updatedDate

DATE-TIME

Amendment

The Amendment table contains information about subscription amendments, which are changes to customer subscriptions. For example: Changing the terms of a contract, adding/removing a product, canceling a subscription, etc.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

Join Amendment with on
DiscountAppliedMetrics
Amendment.id = DiscountAppliedMetrics.amendmentId
Amendment.subscriptionId = DiscountAppliedMetrics.subscriptionId
InvoiceItemAdjustment
Amendment.id = InvoiceItemAdjustment.amendmentId
Amendment.subscriptionId = InvoiceItemAdjustment.subscriptionId
ProcessedUsage
Amendment.id = ProcessedUsage.amendmentId
RatePlan
Amendment.id = RatePlan.amendmentId
Amendment.subscriptionId = RatePlan.subscriptionId
RatePlanChargeTier
Amendment.id = RatePlanChargeTier.amendmentId
Amendment.subscriptionId = RatePlanChargeTier.subscriptionId
RevenueChargeSummaryItem
Amendment.id = RevenueChargeSummaryItem.amendmentId
Amendment.subscriptionId = RevenueChargeSummaryItem.subscriptionId
RevenueEventItem
Amendment.id = RevenueEventItem.amendmentId
Amendment.subscriptionId = RevenueEventItem.subscriptionId
RevenueEventItemInvoiceItem
Amendment.id = RevenueEventItemInvoiceItem.amendmentId
Amendment.subscriptionId = RevenueEventItemInvoiceItem.subscriptionId
RevenueEventItemInvoiceItemAdjustment
Amendment.id = RevenueEventItemInvoiceItemAdjustment.amendmentId
Amendment.subscriptionId = RevenueEventItemInvoiceItemAdjustment.subscriptionId
RevenueScheduleItem
Amendment.id = RevenueScheduleItem.amendmentId
RevenueScheduleItemInvoiceItem
Amendment.id = RevenueScheduleItemInvoiceItem.amendmentId
RevenueScheduleItemInvoiceItemAdjustment
Amendment.id = RevenueScheduleItemInvoiceItemAdjustment.amendmentId
Amendment.subscriptionId = RevenueScheduleItemInvoiceItemAdjustment.subscriptionId
Subscription
Amendment.subscriptionId = Subscription.id
InvoiceItem
Amendment.subscriptionId = InvoiceItem.subscriptionId

autoRenew

BOOLEAN

code

STRING

contractEffectiveDate

DATE-TIME

createdById

STRING

createdDate

DATE-TIME

currentTerm

INTEGER

currentTermPeriodType

STRING

customerAcceptanceDate

DATE-TIME

deleted

BOOLEAN

description

STRING

effectiveDate

DATE-TIME

id

STRING

name

STRING

renewalSetting

STRING

renewalTerm

STRING

renewalTermPeriodType

STRING

serviceActivationDate

DATE-TIME

specificUpdateDate

DATE-TIME

status

STRING

subscriptionId

STRING

termStartDate

STRING

type

STRING

updatedById

STRING

updatedDate

DATE-TIME

BillingRun

The BillingRun table contains information about billing runs.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

Join BillingRun with on
PaymentRun
BillingRun.id = PaymentRun.billingRunId

autoEmail

BOOLEAN

autoPost

BOOLEAN

autoRenewal

BOOLEAN

batch

STRING

billCycleDay

STRING

billRunNumber

STRING

chargeTypeToExclude

STRING

createdById

STRING

createdDate

DATE-TIME

deleted

BOOLEAN

errorMessage

STRING

executedDate

DATE-TIME

id

STRING

invoiceDate

DATE-TIME

invoicesEmailed

BOOLEAN

lastEmailSentTime

DATE-TIME

noEmailForZeroAmountInvoice

BOOLEAN

numberOfAccounts

INTEGER

numberOfInvoices

INTEGER

status

STRING

targetDate

DATE-TIME

updatedById

STRING

updatedDate

DATE-TIME

CommunicationProfile

The CommunicationProfile table contains information about communication profiles, which are sets of policies that determine how to communicate with the contacts associated with a specific customer account.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

Join CommunicationProfile with on
Account
CommunicationProfile.id = Account.communicationProfileId

createdById

STRING

createdDate

DATE-TIME

deleted

BOOLEAN

description

STRING

id

STRING

profileName

STRING

updatedById

STRING

updatedDate

DATE-TIME

Contact

The Contact table contains info about an account’s point-of-contact.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

Join Contact with on
Account
Contact.id = Account.billToContactId
Contact.id = Account.soldToContactId
ContactSnapshot
Contact.id = ContactSnapshot.contactId
CreditBalanceAdjustment
Contact.id = CreditBalanceAdjustment.billToContactId
Contact.id = CreditBalanceAdjustment.soldToContactId
DiscountAppliedMetrics
Contact.id = DiscountAppliedMetrics.billToContactId
Contact.id = DiscountAppliedMetrics.soldToContactId
Invoice
Contact.id = Invoice.billToContactId
Contact.id = Invoice.soldToContactId
InvoiceItemAdjustment
Contact.id = InvoiceItemAdjustment.billToContactId
Contact.id = InvoiceItemAdjustment.soldToContactId
ProcessedUsage
Contact.id = ProcessedUsage.billToContactId
Contact.id = ProcessedUsage.soldToContactId
RatePlan
Contact.id = RatePlan.billToContactId
Refund
Contact.id = Refund.billToContactId
Contact.id = Refund.soldToContactId
RevenueChargeSummaryItem
Contact.id = RevenueChargeSummaryItem.billToContactId
Contact.id = RevenueChargeSummaryItem.soldToContactId
RevenueEventItem
Contact.id = RevenueEventItem.billToContactId
Contact.id = RevenueEventItem.soldToContactId
RevenueEventItemInvoiceItem
Contact.id = RevenueEventItemInvoiceItem.billToContactId
Contact.id = RevenueEventItemInvoiceItem.soldToContactId
RevenueEventItemInvoiceItemAdjustment
Contact.id = RevenueEventItemInvoiceItemAdjustment.billToContactId
Contact.id = RevenueEventItemInvoiceItemAdjustment.soldToContactId
RevenueScheduleItem
Contact.id = RevenueScheduleItem.billToContactId
Contact.id = RevenueScheduleItem.soldToContactId
RevenueScheduleItemInvoiceItem
Contact.id = RevenueScheduleItemInvoiceItem.billToContactId
Contact.id = RevenueScheduleItemInvoiceItem.soldToContactId
RevenueScheduleItemInvoiceItemAdjustment
Contact.id = RevenueScheduleItemInvoiceItemAdjustment.billToContactId
Contact.id = RevenueScheduleItemInvoiceItemAdjustment.soldToContactId

accountId

STRING

address1

STRING

address2

STRING

city

STRING

country

STRING

createdById

STRING

createdDate

DATE-TIME

deleted

BOOLEAN

description

STRING

fax

STRING

firstName

STRING

homePhone

STRING

id

STRING

lastName

STRING

mobilePhone

STRING

nickName

STRING

otherPhone

STRING

otherPhoneType

STRING

personalEmail

STRING

postalCode

STRING

state

STRING

taxRegion

STRING

updatedById

STRING

updatedDate

DATE-TIME

workEmail

STRING

workPhone

STRING

ContactSnapshot

The ContactSnapshot table contains ‘snapshot’ records of Bill-To or Sold-To contacts on customer accounts. Snapshots are record preservations at specific points in time. When invoices are posted, Zuora will preserve the data for the Bill-To and Sold-To contacts at that point in time.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

Join ContactSnapshot with on
Account
ContactSnapshot.accountId = Account.id
ContactSnapshot.contactId = Account.billToContactId
ContactSnapshot.contactId = Account.soldToContactId
Invoice
ContactSnapshot.accountId = Invoice.accountId
ContactSnapshot.contactId = Invoice.billToContactId
ContactSnapshot.contactId = Invoice.billToContactSnapshotId
ContactSnapshot.contactId = Invoice.soldToContactId
ContactSnapshot.contactId = Invoice.soldToContactSnapshotId
Payment
ContactSnapshot.accountId = Payment.accountId
Refund
ContactSnapshot.accountId = Refund.accountId
ContactSnapshot.contactId = Refund.billToContactId
ContactSnapshot.contactId = Refund.soldToContactId
Subscription
ContactSnapshot.accountId = Subscription.accountId
Contact
ContactSnapshot.contactId = Contact.id
CreditBalanceAdjustment
ContactSnapshot.contactId = CreditBalanceAdjustment.billToContactId
ContactSnapshot.contactId = CreditBalanceAdjustment.soldToContactId
DiscountAppliedMetrics
ContactSnapshot.contactId = DiscountAppliedMetrics.billToContactId
ContactSnapshot.contactId = DiscountAppliedMetrics.soldToContactId
InvoiceItemAdjustment
ContactSnapshot.contactId = InvoiceItemAdjustment.billToContactId
ContactSnapshot.contactId = InvoiceItemAdjustment.soldToContactId
ProcessedUsage
ContactSnapshot.contactId = ProcessedUsage.billToContactId
ContactSnapshot.contactId = ProcessedUsage.soldToContactId
RatePlan
ContactSnapshot.contactId = RatePlan.billToContactId
RevenueChargeSummaryItem
ContactSnapshot.contactId = RevenueChargeSummaryItem.billToContactId
ContactSnapshot.contactId = RevenueChargeSummaryItem.soldToContactId
RevenueEventItem
ContactSnapshot.contactId = RevenueEventItem.billToContactId
ContactSnapshot.contactId = RevenueEventItem.soldToContactId
RevenueEventItemInvoiceItem
ContactSnapshot.contactId = RevenueEventItemInvoiceItem.billToContactId
ContactSnapshot.contactId = RevenueEventItemInvoiceItem.soldToContactId
RevenueEventItemInvoiceItemAdjustment
ContactSnapshot.contactId = RevenueEventItemInvoiceItemAdjustment.billToContactId
ContactSnapshot.contactId = RevenueEventItemInvoiceItemAdjustment.soldToContactId
RevenueScheduleItem
ContactSnapshot.contactId = RevenueScheduleItem.billToContactId
ContactSnapshot.contactId = RevenueScheduleItem.soldToContactId
RevenueScheduleItemInvoiceItem
ContactSnapshot.contactId = RevenueScheduleItemInvoiceItem.billToContactId
ContactSnapshot.contactId = RevenueScheduleItemInvoiceItem.soldToContactId
RevenueScheduleItemInvoiceItemAdjustment
ContactSnapshot.contactId = RevenueScheduleItemInvoiceItemAdjustment.billToContactId
ContactSnapshot.contactId = RevenueScheduleItemInvoiceItemAdjustment.soldToContactId

accountId

STRING

address1

STRING

address2

STRING

city

STRING

contactId

STRING

country

STRING

createdById

STRING

createdDate

DATE-TIME

description

STRING

fax

STRING

firstName

STRING

homePhone

STRING

id

STRING

lastName

STRING

mobilePhone

STRING

nickName

STRING

otherPhone

STRING

otherPhoneType

STRING

personalEmail

STRING

postalCode

STRING

state

STRING

taxRegion

STRING

updatedById

STRING

updatedDate

DATE-TIME

workEmail

STRING

workPhone

STRING

CreditBalanceAdjustment

The CreditBalanceAdjustment table contains information about credit balance adjustments, or the application of credit balances to invoices, payments, and refunds.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

Join CreditBalanceAdjustment with on
AccountingCode
CreditBalanceAdjustment.accountingCode = AccountingCode.id
CreditBalanceAdjustment.accountReceivableAccountingCodeId = AccountingCode.id
CreditBalanceAdjustment.cashOnAccountAccountingCodeId = AccountingCode.id
InvoiceItem
CreditBalanceAdjustment.accountingCode = InvoiceItem.accountingCode
InvoiceItemAdjustment
CreditBalanceAdjustment.accountingCode = InvoiceItemAdjustment.accountingCode
CreditBalanceAdjustment.accountingPeriodId = InvoiceItemAdjustment.accountingPeriodId
CreditBalanceAdjustment.accountReceivableAccountingCodeId = InvoiceItemAdjustment.accountReceivableAccountingCodeId
CreditBalanceAdjustment.billToContactId = InvoiceItemAdjustment.billToContactId
CreditBalanceAdjustment.soldToContactId = InvoiceItemAdjustment.billToContactId
CreditBalanceAdjustment.billToContactId = InvoiceItemAdjustment.soldToContactId
CreditBalanceAdjustment.soldToContactId = InvoiceItemAdjustment.soldToContactId
CreditBalanceAdjustment.journalEntryId = InvoiceItemAdjustment.journalEntryId
CreditBalanceAdjustment.journalRunId = InvoiceItemAdjustment.journalRunId
CreditBalanceAdjustment.parentAccountId = InvoiceItemAdjustment.parentAccountId
ProductRatePlanCharge
CreditBalanceAdjustment.accountingCode = ProductRatePlanCharge.accountingCode
AccountingPeriod
CreditBalanceAdjustment.accountingPeriodId = AccountingPeriod.id
JournalEntry
CreditBalanceAdjustment.accountingPeriodId = JournalEntry.accountingPeriodId
CreditBalanceAdjustment.journalEntryId = JournalEntry.id
RevenueChargeSummaryItem
CreditBalanceAdjustment.accountingPeriodId = RevenueChargeSummaryItem.accountingPeriodId
CreditBalanceAdjustment.billToContactId = RevenueChargeSummaryItem.billToContactId
CreditBalanceAdjustment.soldToContactId = RevenueChargeSummaryItem.billToContactId
CreditBalanceAdjustment.billToContactId = RevenueChargeSummaryItem.soldToContactId
CreditBalanceAdjustment.soldToContactId = RevenueChargeSummaryItem.soldToContactId
CreditBalanceAdjustment.parentAccountId = RevenueChargeSummaryItem.parentAccountId
RevenueEventItemInvoiceItem
CreditBalanceAdjustment.accountingPeriodId = RevenueEventItemInvoiceItem.accountingPeriodId
CreditBalanceAdjustment.billToContactId = RevenueEventItemInvoiceItem.billToContactId
CreditBalanceAdjustment.soldToContactId = RevenueEventItemInvoiceItem.billToContactId
CreditBalanceAdjustment.billToContactId = RevenueEventItemInvoiceItem.soldToContactId
CreditBalanceAdjustment.soldToContactId = RevenueEventItemInvoiceItem.soldToContactId
CreditBalanceAdjustment.journalEntryId = RevenueEventItemInvoiceItem.journalEntryId
CreditBalanceAdjustment.journalRunId = RevenueEventItemInvoiceItem.journalRunId
CreditBalanceAdjustment.parentAccountId = RevenueEventItemInvoiceItem.parentAccountId
RevenueEventItemInvoiceItemAdjustment
CreditBalanceAdjustment.accountingPeriodId = RevenueEventItemInvoiceItemAdjustment.accountingPeriodId
CreditBalanceAdjustment.billToContactId = RevenueEventItemInvoiceItemAdjustment.billToContactId
CreditBalanceAdjustment.soldToContactId = RevenueEventItemInvoiceItemAdjustment.billToContactId
CreditBalanceAdjustment.billToContactId = RevenueEventItemInvoiceItemAdjustment.soldToContactId
CreditBalanceAdjustment.soldToContactId = RevenueEventItemInvoiceItemAdjustment.soldToContactId
CreditBalanceAdjustment.journalEntryId = RevenueEventItemInvoiceItemAdjustment.journalEntryId
CreditBalanceAdjustment.journalRunId = RevenueEventItemInvoiceItemAdjustment.journalRunId
CreditBalanceAdjustment.parentAccountId = RevenueEventItemInvoiceItemAdjustment.parentAccountId
RevenueScheduleItem
CreditBalanceAdjustment.accountingPeriodId = RevenueScheduleItem.accountingPeriodId
CreditBalanceAdjustment.billToContactId = RevenueScheduleItem.billToContactId
CreditBalanceAdjustment.soldToContactId = RevenueScheduleItem.billToContactId
CreditBalanceAdjustment.billToContactId = RevenueScheduleItem.soldToContactId
CreditBalanceAdjustment.soldToContactId = RevenueScheduleItem.soldToContactId
CreditBalanceAdjustment.parentAccountId = RevenueScheduleItem.parentAccountId
RevenueScheduleItemInvoiceItem
CreditBalanceAdjustment.accountingPeriodId = RevenueScheduleItemInvoiceItem.accountingPeriodId
CreditBalanceAdjustment.billToContactId = RevenueScheduleItemInvoiceItem.billToContactId
CreditBalanceAdjustment.soldToContactId = RevenueScheduleItemInvoiceItem.billToContactId
CreditBalanceAdjustment.billToContactId = RevenueScheduleItemInvoiceItem.soldToContactId
CreditBalanceAdjustment.soldToContactId = RevenueScheduleItemInvoiceItem.soldToContactId
CreditBalanceAdjustment.parentAccountId = RevenueScheduleItemInvoiceItem.parentAccountId
RevenueScheduleItemInvoiceItemAdjustment
CreditBalanceAdjustment.accountingPeriodId = RevenueScheduleItemInvoiceItemAdjustment.accountingPeriodId
CreditBalanceAdjustment.billToContactId = RevenueScheduleItemInvoiceItemAdjustment.billToContactId
CreditBalanceAdjustment.soldToContactId = RevenueScheduleItemInvoiceItemAdjustment.billToContactId
CreditBalanceAdjustment.billToContactId = RevenueScheduleItemInvoiceItemAdjustment.soldToContactId
CreditBalanceAdjustment.soldToContactId = RevenueScheduleItemInvoiceItemAdjustment.soldToContactId
CreditBalanceAdjustment.parentAccountId = RevenueScheduleItemInvoiceItemAdjustment.parentAccountId
Account
CreditBalanceAdjustment.billToContactId = Account.billToContactId
CreditBalanceAdjustment.soldToContactId = Account.billToContactId
CreditBalanceAdjustment.billToContactId = Account.soldToContactId
CreditBalanceAdjustment.soldToContactId = Account.soldToContactId
CreditBalanceAdjustment.parentAccountId = Account.parentAccountId
Contact
CreditBalanceAdjustment.billToContactId = Contact.id
CreditBalanceAdjustment.soldToContactId = Contact.id
ContactSnapshot
CreditBalanceAdjustment.billToContactId = ContactSnapshot.contactId
CreditBalanceAdjustment.soldToContactId = ContactSnapshot.contactId
DiscountAppliedMetrics
CreditBalanceAdjustment.billToContactId = DiscountAppliedMetrics.billToContactId
CreditBalanceAdjustment.soldToContactId = DiscountAppliedMetrics.billToContactId
CreditBalanceAdjustment.billToContactId = DiscountAppliedMetrics.soldToContactId
CreditBalanceAdjustment.soldToContactId = DiscountAppliedMetrics.soldToContactId
CreditBalanceAdjustment.parentAccountId = DiscountAppliedMetrics.parentAccountId
Invoice
CreditBalanceAdjustment.billToContactId = Invoice.billToContactId
CreditBalanceAdjustment.soldToContactId = Invoice.billToContactId
CreditBalanceAdjustment.billToContactId = Invoice.soldToContactId
CreditBalanceAdjustment.soldToContactId = Invoice.soldToContactId
CreditBalanceAdjustment.invoiceId = Invoice.id
CreditBalanceAdjustment.sourceTransactionId = Invoice.id
CreditBalanceAdjustment.sourceTransactionNumber = Invoice.invoiceNumber
CreditBalanceAdjustment.parentAccountId = Invoice.parentAccountId
ProcessedUsage
CreditBalanceAdjustment.billToContactId = ProcessedUsage.billToContactId
CreditBalanceAdjustment.soldToContactId = ProcessedUsage.billToContactId
CreditBalanceAdjustment.billToContactId = ProcessedUsage.soldToContactId
CreditBalanceAdjustment.soldToContactId = ProcessedUsage.soldToContactId
CreditBalanceAdjustment.parentAccountId = ProcessedUsage.parentAccountId
RatePlan
CreditBalanceAdjustment.billToContactId = RatePlan.billToContactId
CreditBalanceAdjustment.soldToContactId = RatePlan.billToContactId
Refund
CreditBalanceAdjustment.billToContactId = Refund.billToContactId
CreditBalanceAdjustment.soldToContactId = Refund.billToContactId
CreditBalanceAdjustment.billToContactId = Refund.soldToContactId
CreditBalanceAdjustment.soldToContactId = Refund.soldToContactId
CreditBalanceAdjustment.parentAccountId = Refund.parentAccountId
CreditBalanceAdjustment.paymentMethodId = Refund.paymentMethodId
CreditBalanceAdjustment.paymentMethodSnapshotId = Refund.paymentMethodSnapshotId
CreditBalanceAdjustment.refundId = Refund.id
CreditBalanceAdjustment.sourceTransactionId = Refund.id
RevenueEventItem
CreditBalanceAdjustment.billToContactId = RevenueEventItem.billToContactId
CreditBalanceAdjustment.soldToContactId = RevenueEventItem.billToContactId
CreditBalanceAdjustment.billToContactId = RevenueEventItem.soldToContactId
CreditBalanceAdjustment.soldToContactId = RevenueEventItem.soldToContactId
CreditBalanceAdjustment.journalEntryId = RevenueEventItem.journalEntryId
CreditBalanceAdjustment.journalRunId = RevenueEventItem.journalRunId
CreditBalanceAdjustment.parentAccountId = RevenueEventItem.parentAccountId
JournalEntryItem
CreditBalanceAdjustment.journalEntryId = JournalEntryItem.journalEntryId
CreditBalanceAdjustment.journalRunId = JournalEntryItem.journalRunId
JournalRun
CreditBalanceAdjustment.journalRunId = JournalRun.id
Payment
CreditBalanceAdjustment.paymentId = Payment.id
CreditBalanceAdjustment.sourceTransactionId = Payment.id
CreditBalanceAdjustment.paymentMethodId = Payment.paymentMethodId
CreditBalanceAdjustment.paymentMethodSnapshotId = Payment.paymentMethodSnapshotId
PaymentMethod
CreditBalanceAdjustment.paymentMethodId = PaymentMethod.id
PaymentMethodSnapshot
CreditBalanceAdjustment.paymentMethodSnapshotId = PaymentMethodSnapshot.id

accountId

STRING

accountReceivableAccountingCodeId

STRING

accountingCode

STRING

accountingPeriodId

STRING

adjustmentDate

DATE-TIME

amount

DOUBLE

billToContactId

STRING

cancelledOn

DATE-TIME

cashOnAccountAccountingCodeId

STRING

comment

STRING

createdById

STRING

createdDate

DATE-TIME

defaultPaymentMethodId

STRING

deleted

BOOLEAN

id

STRING

invoiceId

STRING

journalEntryId

STRING

journalRunId

STRING

number

STRING

parentAccountId

STRING

paymentId

STRING

paymentMethodId

STRING

paymentMethodSnapshotId

STRING

reasonCode

STRING

referenceId

STRING

refundId

STRING

soldToContactId

STRING

sourceTransactionId

STRING

sourceTransactionNumber

STRING

sourceTransactionType

STRING

status

STRING

transferredToAccounting

STRING

updatedById

STRING

updatedDate

DATE-TIME

DiscountAppliedMetrics

The DiscountAppliedMetrics table contains information about rate plan charges that use either a discount-fixed amount or discount-percentage charge model.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

Join DiscountAppliedMetrics with on
Amendment
DiscountAppliedMetrics.amendmentId = Amendment.id
DiscountAppliedMetrics.subscriptionId = Amendment.subscriptionId
InvoiceItemAdjustment
DiscountAppliedMetrics.amendmentId = InvoiceItemAdjustment.amendmentId
DiscountAppliedMetrics.billToContactId = InvoiceItemAdjustment.billToContactId
DiscountAppliedMetrics.soldToContactId = InvoiceItemAdjustment.billToContactId
DiscountAppliedMetrics.billToContactId = InvoiceItemAdjustment.soldToContactId
DiscountAppliedMetrics.soldToContactId = InvoiceItemAdjustment.soldToContactId
DiscountAppliedMetrics.parentAccountId = InvoiceItemAdjustment.parentAccountId
DiscountAppliedMetrics.productId = InvoiceItemAdjustment.productId
DiscountAppliedMetrics.productRatePlanChargeId = InvoiceItemAdjustment.productRatePlanChargeId
DiscountAppliedMetrics.ratePlanChargeId = InvoiceItemAdjustment.ratePlanChargeId
DiscountAppliedMetrics.ratePlanId = InvoiceItemAdjustment.ratePlanId
DiscountAppliedMetrics.subscriptionId = InvoiceItemAdjustment.subscriptionId
ProcessedUsage
DiscountAppliedMetrics.amendmentId = ProcessedUsage.amendmentId
DiscountAppliedMetrics.billToContactId = ProcessedUsage.billToContactId
DiscountAppliedMetrics.soldToContactId = ProcessedUsage.billToContactId
DiscountAppliedMetrics.billToContactId = ProcessedUsage.soldToContactId
DiscountAppliedMetrics.soldToContactId = ProcessedUsage.soldToContactId
DiscountAppliedMetrics.parentAccountId = ProcessedUsage.parentAccountId
DiscountAppliedMetrics.productId = ProcessedUsage.productId
DiscountAppliedMetrics.productRatePlanChargeId = ProcessedUsage.productRatePlanChargeId
DiscountAppliedMetrics.productRatePlanId = ProcessedUsage.productRatePlanId
DiscountAppliedMetrics.ratePlanChargeId = ProcessedUsage.ratePlanChargeId
DiscountAppliedMetrics.ratePlanId = ProcessedUsage.ratePlanId
RatePlan
DiscountAppliedMetrics.amendmentId = RatePlan.amendmentId
DiscountAppliedMetrics.billToContactId = RatePlan.billToContactId
DiscountAppliedMetrics.soldToContactId = RatePlan.billToContactId
DiscountAppliedMetrics.productRatePlanId = RatePlan.productRatePlanId
DiscountAppliedMetrics.ratePlanId = RatePlan.id
DiscountAppliedMetrics.subscriptionId = RatePlan.subscriptionId
RatePlanChargeTier
DiscountAppliedMetrics.amendmentId = RatePlanChargeTier.amendmentId
DiscountAppliedMetrics.productRatePlanId = RatePlanChargeTier.productRatePlanId
DiscountAppliedMetrics.ratePlanChargeId = RatePlanChargeTier.ratePlanChargeId
DiscountAppliedMetrics.ratePlanId = RatePlanChargeTier.ratePlanId
DiscountAppliedMetrics.subscriptionId = RatePlanChargeTier.subscriptionId
RevenueChargeSummaryItem
DiscountAppliedMetrics.amendmentId = RevenueChargeSummaryItem.amendmentId
DiscountAppliedMetrics.billToContactId = RevenueChargeSummaryItem.billToContactId
DiscountAppliedMetrics.soldToContactId = RevenueChargeSummaryItem.billToContactId
DiscountAppliedMetrics.billToContactId = RevenueChargeSummaryItem.soldToContactId
DiscountAppliedMetrics.soldToContactId = RevenueChargeSummaryItem.soldToContactId
DiscountAppliedMetrics.parentAccountId = RevenueChargeSummaryItem.parentAccountId
DiscountAppliedMetrics.productId = RevenueChargeSummaryItem.productId
DiscountAppliedMetrics.productRatePlanChargeId = RevenueChargeSummaryItem.productRatePlanChargeId
DiscountAppliedMetrics.productRatePlanId = RevenueChargeSummaryItem.productRatePlanId
DiscountAppliedMetrics.ratePlanChargeId = RevenueChargeSummaryItem.ratePlanChargeId
DiscountAppliedMetrics.ratePlanId = RevenueChargeSummaryItem.ratePlanId
DiscountAppliedMetrics.subscriptionId = RevenueChargeSummaryItem.subscriptionId
RevenueEventItem
DiscountAppliedMetrics.amendmentId = RevenueEventItem.amendmentId
DiscountAppliedMetrics.billToContactId = RevenueEventItem.billToContactId
DiscountAppliedMetrics.soldToContactId = RevenueEventItem.billToContactId
DiscountAppliedMetrics.billToContactId = RevenueEventItem.soldToContactId
DiscountAppliedMetrics.soldToContactId = RevenueEventItem.soldToContactId
DiscountAppliedMetrics.parentAccountId = RevenueEventItem.parentAccountId
DiscountAppliedMetrics.productId = RevenueEventItem.productId
DiscountAppliedMetrics.productRatePlanChargeId = RevenueEventItem.productRatePlanChargeId
DiscountAppliedMetrics.productRatePlanId = RevenueEventItem.productRatePlanId
DiscountAppliedMetrics.ratePlanChargeId = RevenueEventItem.ratePlanChargeId
DiscountAppliedMetrics.ratePlanId = RevenueEventItem.ratePlanId
DiscountAppliedMetrics.subscriptionId = RevenueEventItem.subscriptionId
RevenueEventItemInvoiceItem
DiscountAppliedMetrics.amendmentId = RevenueEventItemInvoiceItem.amendmentId
DiscountAppliedMetrics.billToContactId = RevenueEventItemInvoiceItem.billToContactId
DiscountAppliedMetrics.soldToContactId = RevenueEventItemInvoiceItem.billToContactId
DiscountAppliedMetrics.billToContactId = RevenueEventItemInvoiceItem.soldToContactId
DiscountAppliedMetrics.soldToContactId = RevenueEventItemInvoiceItem.soldToContactId
DiscountAppliedMetrics.parentAccountId = RevenueEventItemInvoiceItem.parentAccountId
DiscountAppliedMetrics.productId = RevenueEventItemInvoiceItem.productId
DiscountAppliedMetrics.productRatePlanChargeId = RevenueEventItemInvoiceItem.productRatePlanChargeId
DiscountAppliedMetrics.productRatePlanId = RevenueEventItemInvoiceItem.productRatePlanId
DiscountAppliedMetrics.ratePlanChargeId = RevenueEventItemInvoiceItem.ratePlanChargeId
DiscountAppliedMetrics.ratePlanId = RevenueEventItemInvoiceItem.ratePlanId
DiscountAppliedMetrics.subscriptionId = RevenueEventItemInvoiceItem.subscriptionId
RevenueEventItemInvoiceItemAdjustment
DiscountAppliedMetrics.amendmentId = RevenueEventItemInvoiceItemAdjustment.amendmentId
DiscountAppliedMetrics.billToContactId = RevenueEventItemInvoiceItemAdjustment.billToContactId
DiscountAppliedMetrics.soldToContactId = RevenueEventItemInvoiceItemAdjustment.billToContactId
DiscountAppliedMetrics.billToContactId = RevenueEventItemInvoiceItemAdjustment.soldToContactId
DiscountAppliedMetrics.soldToContactId = RevenueEventItemInvoiceItemAdjustment.soldToContactId
DiscountAppliedMetrics.parentAccountId = RevenueEventItemInvoiceItemAdjustment.parentAccountId
DiscountAppliedMetrics.productId = RevenueEventItemInvoiceItemAdjustment.productId
DiscountAppliedMetrics.productRatePlanChargeId = RevenueEventItemInvoiceItemAdjustment.productRatePlanChargeId
DiscountAppliedMetrics.productRatePlanId = RevenueEventItemInvoiceItemAdjustment.productRatePlanId
DiscountAppliedMetrics.ratePlanChargeId = RevenueEventItemInvoiceItemAdjustment.ratePlanChargeId
DiscountAppliedMetrics.ratePlanId = RevenueEventItemInvoiceItemAdjustment.ratePlanId
DiscountAppliedMetrics.subscriptionId = RevenueEventItemInvoiceItemAdjustment.subscriptionId
RevenueScheduleItem
DiscountAppliedMetrics.amendmentId = RevenueScheduleItem.amendmentId
DiscountAppliedMetrics.billToContactId = RevenueScheduleItem.billToContactId
DiscountAppliedMetrics.soldToContactId = RevenueScheduleItem.billToContactId
DiscountAppliedMetrics.billToContactId = RevenueScheduleItem.soldToContactId
DiscountAppliedMetrics.soldToContactId = RevenueScheduleItem.soldToContactId
DiscountAppliedMetrics.parentAccountId = RevenueScheduleItem.parentAccountId
DiscountAppliedMetrics.productId = RevenueScheduleItem.productId
DiscountAppliedMetrics.productRatePlanChargeId = RevenueScheduleItem.productRatePlanChargeId
DiscountAppliedMetrics.productRatePlanId = RevenueScheduleItem.productRatePlanId
DiscountAppliedMetrics.ratePlanChargeId = RevenueScheduleItem.ratePlanChargeId
DiscountAppliedMetrics.ratePlanId = RevenueScheduleItem.ratePlanId
RevenueScheduleItemInvoiceItem
DiscountAppliedMetrics.amendmentId = RevenueScheduleItemInvoiceItem.amendmentId
DiscountAppliedMetrics.billToContactId = RevenueScheduleItemInvoiceItem.billToContactId
DiscountAppliedMetrics.soldToContactId = RevenueScheduleItemInvoiceItem.billToContactId
DiscountAppliedMetrics.billToContactId = RevenueScheduleItemInvoiceItem.soldToContactId
DiscountAppliedMetrics.soldToContactId = RevenueScheduleItemInvoiceItem.soldToContactId
DiscountAppliedMetrics.parentAccountId = RevenueScheduleItemInvoiceItem.parentAccountId
DiscountAppliedMetrics.productId = RevenueScheduleItemInvoiceItem.productId
DiscountAppliedMetrics.productRatePlanChargeId = RevenueScheduleItemInvoiceItem.productRatePlanChargeId
DiscountAppliedMetrics.productRatePlanId = RevenueScheduleItemInvoiceItem.productRatePlanId
DiscountAppliedMetrics.ratePlanChargeId = RevenueScheduleItemInvoiceItem.ratePlanChargeId
DiscountAppliedMetrics.ratePlanId = RevenueScheduleItemInvoiceItem.ratePlanId
RevenueScheduleItemInvoiceItemAdjustment
DiscountAppliedMetrics.amendmentId = RevenueScheduleItemInvoiceItemAdjustment.amendmentId
DiscountAppliedMetrics.billToContactId = RevenueScheduleItemInvoiceItemAdjustment.billToContactId
DiscountAppliedMetrics.soldToContactId = RevenueScheduleItemInvoiceItemAdjustment.billToContactId
DiscountAppliedMetrics.billToContactId = RevenueScheduleItemInvoiceItemAdjustment.soldToContactId
DiscountAppliedMetrics.soldToContactId = RevenueScheduleItemInvoiceItemAdjustment.soldToContactId
DiscountAppliedMetrics.parentAccountId = RevenueScheduleItemInvoiceItemAdjustment.parentAccountId
DiscountAppliedMetrics.productId = RevenueScheduleItemInvoiceItemAdjustment.productId
DiscountAppliedMetrics.productRatePlanChargeId = RevenueScheduleItemInvoiceItemAdjustment.productRatePlanChargeId
DiscountAppliedMetrics.productRatePlanId = RevenueScheduleItemInvoiceItemAdjustment.productRatePlanId
DiscountAppliedMetrics.ratePlanChargeId = RevenueScheduleItemInvoiceItemAdjustment.ratePlanChargeId
DiscountAppliedMetrics.ratePlanId = RevenueScheduleItemInvoiceItemAdjustment.ratePlanId
DiscountAppliedMetrics.subscriptionId = RevenueScheduleItemInvoiceItemAdjustment.subscriptionId
Account
DiscountAppliedMetrics.billToContactId = Account.billToContactId
DiscountAppliedMetrics.soldToContactId = Account.billToContactId
DiscountAppliedMetrics.billToContactId = Account.soldToContactId
DiscountAppliedMetrics.soldToContactId = Account.soldToContactId
DiscountAppliedMetrics.parentAccountId = Account.parentAccountId
Contact
DiscountAppliedMetrics.billToContactId = Contact.id
DiscountAppliedMetrics.soldToContactId = Contact.id
ContactSnapshot
DiscountAppliedMetrics.billToContactId = ContactSnapshot.contactId
DiscountAppliedMetrics.soldToContactId = ContactSnapshot.contactId
CreditBalanceAdjustment
DiscountAppliedMetrics.billToContactId = CreditBalanceAdjustment.billToContactId
DiscountAppliedMetrics.soldToContactId = CreditBalanceAdjustment.billToContactId
DiscountAppliedMetrics.billToContactId = CreditBalanceAdjustment.soldToContactId
DiscountAppliedMetrics.soldToContactId = CreditBalanceAdjustment.soldToContactId
DiscountAppliedMetrics.parentAccountId = CreditBalanceAdjustment.parentAccountId
Invoice
DiscountAppliedMetrics.billToContactId = Invoice.billToContactId
DiscountAppliedMetrics.soldToContactId = Invoice.billToContactId
DiscountAppliedMetrics.billToContactId = Invoice.soldToContactId
DiscountAppliedMetrics.soldToContactId = Invoice.soldToContactId
DiscountAppliedMetrics.parentAccountId = Invoice.parentAccountId
Refund
DiscountAppliedMetrics.billToContactId = Refund.billToContactId
DiscountAppliedMetrics.soldToContactId = Refund.billToContactId
DiscountAppliedMetrics.billToContactId = Refund.soldToContactId
DiscountAppliedMetrics.soldToContactId = Refund.soldToContactId
DiscountAppliedMetrics.parentAccountId = Refund.parentAccountId
RatePlanCharge
DiscountAppliedMetrics.discountRatePlanChargeId = RatePlanCharge.id
DiscountAppliedMetrics.ratePlanChargeId = RatePlanCharge.id
Product
DiscountAppliedMetrics.productId = Product.id
InvoiceItem
DiscountAppliedMetrics.productId = InvoiceItem.productId
DiscountAppliedMetrics.productRatePlanChargeId = InvoiceItem.productRatePlanChargeId
DiscountAppliedMetrics.ratePlanChargeId = InvoiceItem.ratePlanChargeId
DiscountAppliedMetrics.subscriptionId = InvoiceItem.subscriptionId
ProductRatePlan
DiscountAppliedMetrics.productId = ProductRatePlan.productId
DiscountAppliedMetrics.productRatePlanId = ProductRatePlan.id
ProductRatePlanCharge
DiscountAppliedMetrics.productRatePlanChargeId = ProductRatePlanCharge.id
DiscountAppliedMetrics.productRatePlanId = ProductRatePlanCharge.productRatePlanId
ProductRatePlanChargeTier
DiscountAppliedMetrics.productRatePlanChargeId = ProductRatePlanChargeTier.productRatePlanChargeId
DiscountAppliedMetrics.productRatePlanId = ProductRatePlanChargeTier.productRatePlanId
DiscountAppliedMetrics.ratePlanChargeId = ProductRatePlanChargeTier.ratePlanChargeId
DiscountAppliedMetrics.ratePlanId = ProductRatePlanChargeTier.ratePlanId
Subscription
DiscountAppliedMetrics.subscriptionId = Subscription.id

accountId

STRING

amendmentId

STRING

billToContactId

STRING

createdById

STRING

createdDate

DATE-TIME

defaultPaymentMethodId

STRING

discountRatePlanChargeId

STRING

id

STRING

mrr

STRING

parentAccountId

STRING

productId

STRING

productRatePlanChargeId

STRING

productRatePlanId

STRING

ratePlanChargeId

STRING

ratePlanId

STRING

soldToContactId

STRING

startDate

DATE-TIME

subscriptionId

STRING

tcv

STRING

updatedById

STRING

updatedDate

DATE-TIME

Export

The Export table contains information about export jobs and files.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

convertToCurrencies

STRING

createdById

STRING

createdDate

DATE-TIME

deleted

BOOLEAN

encrypted

BOOLEAN

fileId

STRING

format

STRING

id

STRING

name

STRING

query

STRING

size

INTEGER

status

STRING

statusReason

STRING

updatedById

STRING

updatedDate

DATE-TIME

zip

BOOLEAN

Import

The Import table contains information about content uploads.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

createdById

STRING

createdDate

DATE-TIME

deleted

BOOLEAN

id

STRING

importType

STRING

importedCount

INTEGER

md5

STRING

name

STRING

originalResourceUrl

STRING

resultResourceUrl

STRING

status

STRING

statusReason

STRING

totalCount

INTEGER

updatedById

STRING

updatedDate

DATE-TIME

Invoice

The Invoice table contains info about invoices, which are bills to customers.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

Join Invoice with on
Account
Invoice.accountId = Account.id
Invoice.billToContactId = Account.billToContactId
Invoice.soldToContactId = Account.billToContactId
Invoice.billToContactId = Account.soldToContactId
Invoice.soldToContactId = Account.soldToContactId
Invoice.defaultPaymentMethodId = Account.defaultPaymentMethodId
Invoice.parentAccountId = Account.parentAccountId
ContactSnapshot
Invoice.accountId = ContactSnapshot.accountId
Invoice.billToContactId = ContactSnapshot.contactId
Invoice.billToContactSnapshotId = ContactSnapshot.contactId
Invoice.soldToContactId = ContactSnapshot.contactId
Invoice.soldToContactSnapshotId = ContactSnapshot.contactId
Payment
Invoice.accountId = Payment.accountId
Invoice.id = Payment.id
Invoice.invoiceNumber = Payment.number
Refund
Invoice.accountId = Refund.accountId
Invoice.billToContactId = Refund.billToContactId
Invoice.soldToContactId = Refund.billToContactId
Invoice.billToContactId = Refund.soldToContactId
Invoice.soldToContactId = Refund.soldToContactId
Invoice.parentAccountId = Refund.parentAccountId
Invoice.id = Refund.id
Invoice.invoiceNumber = Refund.number
Subscription
Invoice.accountId = Subscription.accountId
Contact
Invoice.billToContactId = Contact.id
Invoice.soldToContactId = Contact.id
CreditBalanceAdjustment
Invoice.billToContactId = CreditBalanceAdjustment.billToContactId
Invoice.soldToContactId = CreditBalanceAdjustment.billToContactId
Invoice.billToContactId = CreditBalanceAdjustment.soldToContactId
Invoice.soldToContactId = CreditBalanceAdjustment.soldToContactId
Invoice.id = CreditBalanceAdjustment.invoiceId
Invoice.id = CreditBalanceAdjustment.sourceTransactionId
Invoice.invoiceNumber = CreditBalanceAdjustment.sourceTransactionNumber
Invoice.parentAccountId = CreditBalanceAdjustment.parentAccountId
DiscountAppliedMetrics
Invoice.billToContactId = DiscountAppliedMetrics.billToContactId
Invoice.soldToContactId = DiscountAppliedMetrics.billToContactId
Invoice.billToContactId = DiscountAppliedMetrics.soldToContactId
Invoice.soldToContactId = DiscountAppliedMetrics.soldToContactId
Invoice.parentAccountId = DiscountAppliedMetrics.parentAccountId
InvoiceItemAdjustment
Invoice.billToContactId = InvoiceItemAdjustment.billToContactId
Invoice.soldToContactId = InvoiceItemAdjustment.billToContactId
Invoice.billToContactId = InvoiceItemAdjustment.soldToContactId
Invoice.soldToContactId = InvoiceItemAdjustment.soldToContactId
Invoice.parentAccountId = InvoiceItemAdjustment.parentAccountId
ProcessedUsage
Invoice.billToContactId = ProcessedUsage.billToContactId
Invoice.soldToContactId = ProcessedUsage.billToContactId
Invoice.billToContactId = ProcessedUsage.soldToContactId
Invoice.soldToContactId = ProcessedUsage.soldToContactId
Invoice.parentAccountId = ProcessedUsage.parentAccountId
RatePlan
Invoice.billToContactId = RatePlan.billToContactId
Invoice.soldToContactId = RatePlan.billToContactId
RevenueChargeSummaryItem
Invoice.billToContactId = RevenueChargeSummaryItem.billToContactId
Invoice.soldToContactId = RevenueChargeSummaryItem.billToContactId
Invoice.billToContactId = RevenueChargeSummaryItem.soldToContactId
Invoice.soldToContactId = RevenueChargeSummaryItem.soldToContactId
Invoice.parentAccountId = RevenueChargeSummaryItem.parentAccountId
RevenueEventItem
Invoice.billToContactId = RevenueEventItem.billToContactId
Invoice.soldToContactId = RevenueEventItem.billToContactId
Invoice.billToContactId = RevenueEventItem.soldToContactId
Invoice.soldToContactId = RevenueEventItem.soldToContactId
Invoice.parentAccountId = RevenueEventItem.parentAccountId
RevenueEventItemInvoiceItem
Invoice.billToContactId = RevenueEventItemInvoiceItem.billToContactId
Invoice.soldToContactId = RevenueEventItemInvoiceItem.billToContactId
Invoice.billToContactId = RevenueEventItemInvoiceItem.soldToContactId
Invoice.soldToContactId = RevenueEventItemInvoiceItem.soldToContactId
Invoice.parentAccountId = RevenueEventItemInvoiceItem.parentAccountId
RevenueEventItemInvoiceItemAdjustment
Invoice.billToContactId = RevenueEventItemInvoiceItemAdjustment.billToContactId
Invoice.soldToContactId = RevenueEventItemInvoiceItemAdjustment.billToContactId
Invoice.billToContactId = RevenueEventItemInvoiceItemAdjustment.soldToContactId
Invoice.soldToContactId = RevenueEventItemInvoiceItemAdjustment.soldToContactId
Invoice.parentAccountId = RevenueEventItemInvoiceItemAdjustment.parentAccountId
RevenueScheduleItem
Invoice.billToContactId = RevenueScheduleItem.billToContactId
Invoice.soldToContactId = RevenueScheduleItem.billToContactId
Invoice.billToContactId = RevenueScheduleItem.soldToContactId
Invoice.soldToContactId = RevenueScheduleItem.soldToContactId
Invoice.parentAccountId = RevenueScheduleItem.parentAccountId
RevenueScheduleItemInvoiceItem
Invoice.billToContactId = RevenueScheduleItemInvoiceItem.billToContactId
Invoice.soldToContactId = RevenueScheduleItemInvoiceItem.billToContactId
Invoice.billToContactId = RevenueScheduleItemInvoiceItem.soldToContactId
Invoice.soldToContactId = RevenueScheduleItemInvoiceItem.soldToContactId
Invoice.parentAccountId = RevenueScheduleItemInvoiceItem.parentAccountId
RevenueScheduleItemInvoiceItemAdjustment
Invoice.billToContactId = RevenueScheduleItemInvoiceItemAdjustment.billToContactId
Invoice.soldToContactId = RevenueScheduleItemInvoiceItemAdjustment.billToContactId
Invoice.billToContactId = RevenueScheduleItemInvoiceItemAdjustment.soldToContactId
Invoice.soldToContactId = RevenueScheduleItemInvoiceItemAdjustment.soldToContactId
Invoice.parentAccountId = RevenueScheduleItemInvoiceItemAdjustment.parentAccountId
PaymentMethod
Invoice.defaultPaymentMethodId = PaymentMethod.id

accountId

STRING

adjustmentAccount

DOUBLE

amount

DOUBLE

amountWithoutTax

DOUBLE

autoPay

BOOLEAN

balance

DOUBLE

billRunId

STRING

billToContactId

STRING

billToContactSnapshotId

STRING

comments

STRING

createdById

STRING

createdDate

DATE-TIME

creditBalanceAdjustmentAmount

DOUBLE

defaultPaymentMethodId

STRING

deleted

BOOLEAN

dueDate

DATE-TIME

id

STRING

includesOneTime

BOOLEAN

includesRecurring

BOOLEAN

includesUsage

BOOLEAN

invoiceDate

DATE-TIME

invoiceNumber

STRING

lastEmailSentDate

DATE-TIME

parentAccountId

STRING

paymentAmount

DOUBLE

postedBy

STRING

postedDate

DATE-TIME

refundAmount

DOUBLE

soldToContactId

STRING

soldToContactSnapshotId

STRING

source

STRING

sourceId

STRING

status

STRING

targetDate

DATE-TIME

taxAmount

DOUBLE

taxExemptAmount

DOUBLE

transferredToAccounting

STRING

updatedById

STRING

updatedDate

DATE-TIME

InvoiceItem

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

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

Join InvoiceItem with on
AccountingCode
InvoiceItem.accountingCode = AccountingCode.id
CreditBalanceAdjustment
InvoiceItem.accountingCode = CreditBalanceAdjustment.accountingCode
InvoiceItemAdjustment
InvoiceItem.accountingCode = InvoiceItemAdjustment.accountingCode
InvoiceItem.productId = InvoiceItemAdjustment.productId
InvoiceItem.productRatePlanChargeId = InvoiceItemAdjustment.productRatePlanChargeId
InvoiceItem.ratePlanChargeId = InvoiceItemAdjustment.ratePlanChargeId
InvoiceItem.subscriptionId = InvoiceItemAdjustment.subscriptionId
ProductRatePlanCharge
InvoiceItem.accountingCode = ProductRatePlanCharge.accountingCode
InvoiceItem.productRatePlanChargeId = ProductRatePlanCharge.id
ProcessedUsage
InvoiceItem.id = ProcessedUsage.invoiceItemId
InvoiceItem.productId = ProcessedUsage.productId
InvoiceItem.productRatePlanChargeId = ProcessedUsage.productRatePlanChargeId
InvoiceItem.ratePlanChargeId = ProcessedUsage.ratePlanChargeId
RevenueEventItemInvoiceItem
InvoiceItem.id = RevenueEventItemInvoiceItem.invoiceItemId
InvoiceItem.productId = RevenueEventItemInvoiceItem.productId
InvoiceItem.productRatePlanChargeId = RevenueEventItemInvoiceItem.productRatePlanChargeId
InvoiceItem.ratePlanChargeId = RevenueEventItemInvoiceItem.ratePlanChargeId
InvoiceItem.subscriptionId = RevenueEventItemInvoiceItem.subscriptionId
RevenueEventItemInvoiceItemAdjustment
InvoiceItem.id = RevenueEventItemInvoiceItemAdjustment.invoiceItemId
InvoiceItem.productId = RevenueEventItemInvoiceItemAdjustment.productId
InvoiceItem.productRatePlanChargeId = RevenueEventItemInvoiceItemAdjustment.productRatePlanChargeId
InvoiceItem.ratePlanChargeId = RevenueEventItemInvoiceItemAdjustment.ratePlanChargeId
InvoiceItem.subscriptionId = RevenueEventItemInvoiceItemAdjustment.subscriptionId
RevenueScheduleItemInvoiceItem
InvoiceItem.id = RevenueScheduleItemInvoiceItem.invoiceItemId
InvoiceItem.productId = RevenueScheduleItemInvoiceItem.productId
InvoiceItem.productRatePlanChargeId = RevenueScheduleItemInvoiceItem.productRatePlanChargeId
InvoiceItem.ratePlanChargeId = RevenueScheduleItemInvoiceItem.ratePlanChargeId
RevenueScheduleItemInvoiceItemAdjustment
InvoiceItem.id = RevenueScheduleItemInvoiceItemAdjustment.invoiceItemId
InvoiceItem.productId = RevenueScheduleItemInvoiceItemAdjustment.productId
InvoiceItem.productRatePlanChargeId = RevenueScheduleItemInvoiceItemAdjustment.productRatePlanChargeId
InvoiceItem.ratePlanChargeId = RevenueScheduleItemInvoiceItemAdjustment.ratePlanChargeId
InvoiceItem.subscriptionId = RevenueScheduleItemInvoiceItemAdjustment.subscriptionId
Product
InvoiceItem.productId = Product.id
DiscountAppliedMetrics
InvoiceItem.productId = DiscountAppliedMetrics.productId
InvoiceItem.productRatePlanChargeId = DiscountAppliedMetrics.productRatePlanChargeId
InvoiceItem.ratePlanChargeId = DiscountAppliedMetrics.ratePlanChargeId
InvoiceItem.subscriptionId = DiscountAppliedMetrics.subscriptionId
ProductRatePlan
InvoiceItem.productId = ProductRatePlan.productId
RevenueChargeSummaryItem
InvoiceItem.productId = RevenueChargeSummaryItem.productId
InvoiceItem.productRatePlanChargeId = RevenueChargeSummaryItem.productRatePlanChargeId
InvoiceItem.ratePlanChargeId = RevenueChargeSummaryItem.ratePlanChargeId
InvoiceItem.subscriptionId = RevenueChargeSummaryItem.subscriptionId
RevenueEventItem
InvoiceItem.productId = RevenueEventItem.productId
InvoiceItem.productRatePlanChargeId = RevenueEventItem.productRatePlanChargeId
InvoiceItem.ratePlanChargeId = RevenueEventItem.ratePlanChargeId
InvoiceItem.subscriptionId = RevenueEventItem.subscriptionId
RevenueScheduleItem
InvoiceItem.productId = RevenueScheduleItem.productId
InvoiceItem.productRatePlanChargeId = RevenueScheduleItem.productRatePlanChargeId
InvoiceItem.ratePlanChargeId = RevenueScheduleItem.ratePlanChargeId
ProductRatePlanChargeTier
InvoiceItem.productRatePlanChargeId = ProductRatePlanChargeTier.productRatePlanChargeId
InvoiceItem.ratePlanChargeId = ProductRatePlanChargeTier.ratePlanChargeId
RatePlanCharge
InvoiceItem.ratePlanChargeId = RatePlanCharge.id
RatePlanChargeTier
InvoiceItem.ratePlanChargeId = RatePlanChargeTier.ratePlanChargeId
InvoiceItem.subscriptionId = RatePlanChargeTier.subscriptionId
Subscription
InvoiceItem.subscriptionId = Subscription.id
Amendment
InvoiceItem.subscriptionId = Amendment.subscriptionId
RatePlan
InvoiceItem.subscriptionId = RatePlan.subscriptionId

accountingCode

STRING

appliedToChargeNumber

STRING

appliedToInvoiceItemId

STRING

chargeAmount

DECIMAL

chargeDate

DATE-TIME

chargeName

STRING

createdById

STRING

createdDate

DATE-TIME

deleted

BOOLEAN

id

STRING

invoiceId

STRING

processingType

DECIMAL

productDescription

STRING

productId

STRING

productRatePlanChargeId

STRING

quantity

DECIMAL

ratePlanChargeId

STRING

revRecCode

STRING

revRecStartDate

DATE-TIME

revRecTriggerCondition

STRING

serviceEndDate

DATE-TIME

serviceStartDate

DATE-TIME

sku

STRING

subscriptionId

STRING

taxAmaount

DOUBLE

taxCode

STRING

taxExemptAmount

DOUBLE

taxMode

STRING

unitPrice

DOUBLE

uom

STRING

updatedById

STRING

updatedDate

DATE-TIME

InvoiceItemAdjustment

The InvoiceItemAdjustment table contains info about adjustments applied to invoice line items.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

Join InvoiceItemAdjustment with on
AccountingCode
InvoiceItemAdjustment.accountingCode = AccountingCode.id
InvoiceItemAdjustment.accountReceivableAccountingCodeId = AccountingCode.id
InvoiceItemAdjustment.recognizedRevenueAccountingCodeId = AccountingCode.id
InvoiceItemAdjustment.salesTaxPayableAccountingCodeId = AccountingCode.id
CreditBalanceAdjustment
InvoiceItemAdjustment.accountingCode = CreditBalanceAdjustment.accountingCode
InvoiceItemAdjustment.accountingPeriodId = CreditBalanceAdjustment.accountingPeriodId
InvoiceItemAdjustment.accountReceivableAccountingCodeId = CreditBalanceAdjustment.accountReceivableAccountingCodeId
InvoiceItemAdjustment.billToContactId = CreditBalanceAdjustment.billToContactId
InvoiceItemAdjustment.soldToContactId = CreditBalanceAdjustment.billToContactId
InvoiceItemAdjustment.billToContactId = CreditBalanceAdjustment.soldToContactId
InvoiceItemAdjustment.soldToContactId = CreditBalanceAdjustment.soldToContactId
InvoiceItemAdjustment.journalEntryId = CreditBalanceAdjustment.journalEntryId
InvoiceItemAdjustment.journalRunId = CreditBalanceAdjustment.journalRunId
InvoiceItemAdjustment.parentAccountId = CreditBalanceAdjustment.parentAccountId
InvoiceItem
InvoiceItemAdjustment.accountingCode = InvoiceItem.accountingCode
InvoiceItemAdjustment.productId = InvoiceItem.productId
InvoiceItemAdjustment.productRatePlanChargeId = InvoiceItem.productRatePlanChargeId
InvoiceItemAdjustment.ratePlanChargeId = InvoiceItem.ratePlanChargeId
InvoiceItemAdjustment.subscriptionId = InvoiceItem.subscriptionId
ProductRatePlanCharge
InvoiceItemAdjustment.accountingCode = ProductRatePlanCharge.accountingCode
InvoiceItemAdjustment.productRatePlanChargeId = ProductRatePlanCharge.id
AccountingPeriod
InvoiceItemAdjustment.accountingPeriodId = AccountingPeriod.id
JournalEntry
InvoiceItemAdjustment.accountingPeriodId = JournalEntry.accountingPeriodId
InvoiceItemAdjustment.journalEntryId = JournalEntry.id
RevenueChargeSummaryItem
InvoiceItemAdjustment.accountingPeriodId = RevenueChargeSummaryItem.accountingPeriodId
InvoiceItemAdjustment.amendmentId = RevenueChargeSummaryItem.amendmentId
InvoiceItemAdjustment.billToContactId = RevenueChargeSummaryItem.billToContactId
InvoiceItemAdjustment.soldToContactId = RevenueChargeSummaryItem.billToContactId
InvoiceItemAdjustment.billToContactId = RevenueChargeSummaryItem.soldToContactId
InvoiceItemAdjustment.soldToContactId = RevenueChargeSummaryItem.soldToContactId
InvoiceItemAdjustment.parentAccountId = RevenueChargeSummaryItem.parentAccountId
InvoiceItemAdjustment.productId = RevenueChargeSummaryItem.productId
InvoiceItemAdjustment.productRatePlanChargeId = RevenueChargeSummaryItem.productRatePlanChargeId
InvoiceItemAdjustment.ratePlanChargeId = RevenueChargeSummaryItem.ratePlanChargeId
InvoiceItemAdjustment.ratePlanId = RevenueChargeSummaryItem.ratePlanId
InvoiceItemAdjustment.subscriptionId = RevenueChargeSummaryItem.subscriptionId
RevenueEventItemInvoiceItem
InvoiceItemAdjustment.accountingPeriodId = RevenueEventItemInvoiceItem.accountingPeriodId
InvoiceItemAdjustment.amendmentId = RevenueEventItemInvoiceItem.amendmentId
InvoiceItemAdjustment.billToContactId = RevenueEventItemInvoiceItem.billToContactId
InvoiceItemAdjustment.soldToContactId = RevenueEventItemInvoiceItem.billToContactId
InvoiceItemAdjustment.billToContactId = RevenueEventItemInvoiceItem.soldToContactId
InvoiceItemAdjustment.soldToContactId = RevenueEventItemInvoiceItem.soldToContactId
InvoiceItemAdjustment.journalEntryId = RevenueEventItemInvoiceItem.journalEntryId
InvoiceItemAdjustment.journalRunId = RevenueEventItemInvoiceItem.journalRunId
InvoiceItemAdjustment.parentAccountId = RevenueEventItemInvoiceItem.parentAccountId
InvoiceItemAdjustment.productId = RevenueEventItemInvoiceItem.productId
InvoiceItemAdjustment.productRatePlanChargeId = RevenueEventItemInvoiceItem.productRatePlanChargeId
InvoiceItemAdjustment.ratePlanChargeId = RevenueEventItemInvoiceItem.ratePlanChargeId
InvoiceItemAdjustment.ratePlanId = RevenueEventItemInvoiceItem.ratePlanId
InvoiceItemAdjustment.recognizedRevenueAccountingCodeId = RevenueEventItemInvoiceItem.recognizedRevenueAccountingCodeId
InvoiceItemAdjustment.subscriptionId = RevenueEventItemInvoiceItem.subscriptionId
RevenueEventItemInvoiceItemAdjustment
InvoiceItemAdjustment.accountingPeriodId = RevenueEventItemInvoiceItemAdjustment.accountingPeriodId
InvoiceItemAdjustment.amendmentId = RevenueEventItemInvoiceItemAdjustment.amendmentId
InvoiceItemAdjustment.billToContactId = RevenueEventItemInvoiceItemAdjustment.billToContactId
InvoiceItemAdjustment.soldToContactId = RevenueEventItemInvoiceItemAdjustment.billToContactId
InvoiceItemAdjustment.billToContactId = RevenueEventItemInvoiceItemAdjustment.soldToContactId
InvoiceItemAdjustment.soldToContactId = RevenueEventItemInvoiceItemAdjustment.soldToContactId
InvoiceItemAdjustment.id = RevenueEventItemInvoiceItemAdjustment.invoiceItemAdjustmentId
InvoiceItemAdjustment.journalEntryId = RevenueEventItemInvoiceItemAdjustment.journalEntryId
InvoiceItemAdjustment.journalRunId = RevenueEventItemInvoiceItemAdjustment.journalRunId
InvoiceItemAdjustment.parentAccountId = RevenueEventItemInvoiceItemAdjustment.parentAccountId
InvoiceItemAdjustment.productId = RevenueEventItemInvoiceItemAdjustment.productId
InvoiceItemAdjustment.productRatePlanChargeId = RevenueEventItemInvoiceItemAdjustment.productRatePlanChargeId
InvoiceItemAdjustment.ratePlanChargeId = RevenueEventItemInvoiceItemAdjustment.ratePlanChargeId
InvoiceItemAdjustment.ratePlanId = RevenueEventItemInvoiceItemAdjustment.ratePlanId
InvoiceItemAdjustment.recognizedRevenueAccountingCodeId = RevenueEventItemInvoiceItemAdjustment.recognizedRevenueAccountingCodeId
InvoiceItemAdjustment.subscriptionId = RevenueEventItemInvoiceItemAdjustment.subscriptionId
RevenueScheduleItem
InvoiceItemAdjustment.accountingPeriodId = RevenueScheduleItem.accountingPeriodId
InvoiceItemAdjustment.amendmentId = RevenueScheduleItem.amendmentId
InvoiceItemAdjustment.billToContactId = RevenueScheduleItem.billToContactId
InvoiceItemAdjustment.soldToContactId = RevenueScheduleItem.billToContactId
InvoiceItemAdjustment.billToContactId = RevenueScheduleItem.soldToContactId
InvoiceItemAdjustment.soldToContactId = RevenueScheduleItem.soldToContactId
InvoiceItemAdjustment.parentAccountId = RevenueScheduleItem.parentAccountId
InvoiceItemAdjustment.productId = RevenueScheduleItem.productId
InvoiceItemAdjustment.productRatePlanChargeId = RevenueScheduleItem.productRatePlanChargeId
InvoiceItemAdjustment.ratePlanChargeId = RevenueScheduleItem.ratePlanChargeId
InvoiceItemAdjustment.ratePlanId = RevenueScheduleItem.ratePlanId
InvoiceItemAdjustment.recognizedRevenueAccountingCodeId = RevenueScheduleItem.recognizedRevenueAccountingCodeId
RevenueScheduleItemInvoiceItem
InvoiceItemAdjustment.accountingPeriodId = RevenueScheduleItemInvoiceItem.accountingPeriodId
InvoiceItemAdjustment.amendmentId = RevenueScheduleItemInvoiceItem.amendmentId
InvoiceItemAdjustment.billToContactId = RevenueScheduleItemInvoiceItem.billToContactId
InvoiceItemAdjustment.soldToContactId = RevenueScheduleItemInvoiceItem.billToContactId
InvoiceItemAdjustment.billToContactId = RevenueScheduleItemInvoiceItem.soldToContactId
InvoiceItemAdjustment.soldToContactId = RevenueScheduleItemInvoiceItem.soldToContactId
InvoiceItemAdjustment.parentAccountId = RevenueScheduleItemInvoiceItem.parentAccountId
InvoiceItemAdjustment.productId = RevenueScheduleItemInvoiceItem.productId
InvoiceItemAdjustment.productRatePlanChargeId = RevenueScheduleItemInvoiceItem.productRatePlanChargeId
InvoiceItemAdjustment.ratePlanChargeId = RevenueScheduleItemInvoiceItem.ratePlanChargeId
InvoiceItemAdjustment.ratePlanId = RevenueScheduleItemInvoiceItem.ratePlanId
InvoiceItemAdjustment.recognizedRevenueAccountingCodeId = RevenueScheduleItemInvoiceItem.recognizedRevenueAccountingCodeId
RevenueScheduleItemInvoiceItemAdjustment
InvoiceItemAdjustment.accountingPeriodId = RevenueScheduleItemInvoiceItemAdjustment.accountingPeriodId
InvoiceItemAdjustment.amendmentId = RevenueScheduleItemInvoiceItemAdjustment.amendmentId
InvoiceItemAdjustment.billToContactId = RevenueScheduleItemInvoiceItemAdjustment.billToContactId
InvoiceItemAdjustment.soldToContactId = RevenueScheduleItemInvoiceItemAdjustment.billToContactId
InvoiceItemAdjustment.billToContactId = RevenueScheduleItemInvoiceItemAdjustment.soldToContactId
InvoiceItemAdjustment.soldToContactId = RevenueScheduleItemInvoiceItemAdjustment.soldToContactId
InvoiceItemAdjustment.id = RevenueScheduleItemInvoiceItemAdjustment.invoiceItemAdjustmentId
InvoiceItemAdjustment.parentAccountId = RevenueScheduleItemInvoiceItemAdjustment.parentAccountId
InvoiceItemAdjustment.productId = RevenueScheduleItemInvoiceItemAdjustment.productId
InvoiceItemAdjustment.productRatePlanChargeId = RevenueScheduleItemInvoiceItemAdjustment.productRatePlanChargeId
InvoiceItemAdjustment.ratePlanChargeId = RevenueScheduleItemInvoiceItemAdjustment.ratePlanChargeId
InvoiceItemAdjustment.ratePlanId = RevenueScheduleItemInvoiceItemAdjustment.ratePlanId
InvoiceItemAdjustment.recognizedRevenueAccountingCodeId = RevenueScheduleItemInvoiceItemAdjustment.recognizedRevenueAccountingCodeId
InvoiceItemAdjustment.subscriptionId = RevenueScheduleItemInvoiceItemAdjustment.subscriptionId
Amendment
InvoiceItemAdjustment.amendmentId = Amendment.id
InvoiceItemAdjustment.subscriptionId = Amendment.subscriptionId
DiscountAppliedMetrics
InvoiceItemAdjustment.amendmentId = DiscountAppliedMetrics.amendmentId
InvoiceItemAdjustment.billToContactId = DiscountAppliedMetrics.billToContactId
InvoiceItemAdjustment.soldToContactId = DiscountAppliedMetrics.billToContactId
InvoiceItemAdjustment.billToContactId = DiscountAppliedMetrics.soldToContactId
InvoiceItemAdjustment.soldToContactId = DiscountAppliedMetrics.soldToContactId
InvoiceItemAdjustment.parentAccountId = DiscountAppliedMetrics.parentAccountId
InvoiceItemAdjustment.productId = DiscountAppliedMetrics.productId
InvoiceItemAdjustment.productRatePlanChargeId = DiscountAppliedMetrics.productRatePlanChargeId
InvoiceItemAdjustment.ratePlanChargeId = DiscountAppliedMetrics.ratePlanChargeId
InvoiceItemAdjustment.ratePlanId = DiscountAppliedMetrics.ratePlanId
InvoiceItemAdjustment.subscriptionId = DiscountAppliedMetrics.subscriptionId
ProcessedUsage
InvoiceItemAdjustment.amendmentId = ProcessedUsage.amendmentId
InvoiceItemAdjustment.billToContactId = ProcessedUsage.billToContactId
InvoiceItemAdjustment.soldToContactId = ProcessedUsage.billToContactId
InvoiceItemAdjustment.billToContactId = ProcessedUsage.soldToContactId
InvoiceItemAdjustment.soldToContactId = ProcessedUsage.soldToContactId
InvoiceItemAdjustment.parentAccountId = ProcessedUsage.parentAccountId
InvoiceItemAdjustment.productId = ProcessedUsage.productId
InvoiceItemAdjustment.productRatePlanChargeId = ProcessedUsage.productRatePlanChargeId
InvoiceItemAdjustment.ratePlanChargeId = ProcessedUsage.ratePlanChargeId
InvoiceItemAdjustment.ratePlanId = ProcessedUsage.ratePlanId
RatePlan
InvoiceItemAdjustment.amendmentId = RatePlan.amendmentId
InvoiceItemAdjustment.billToContactId = RatePlan.billToContactId
InvoiceItemAdjustment.soldToContactId = RatePlan.billToContactId
InvoiceItemAdjustment.ratePlanId = RatePlan.id
InvoiceItemAdjustment.subscriptionId = RatePlan.subscriptionId
RatePlanChargeTier
InvoiceItemAdjustment.amendmentId = RatePlanChargeTier.amendmentId
InvoiceItemAdjustment.ratePlanChargeId = RatePlanChargeTier.ratePlanChargeId
InvoiceItemAdjustment.ratePlanId = RatePlanChargeTier.ratePlanId
InvoiceItemAdjustment.subscriptionId = RatePlanChargeTier.subscriptionId
RevenueEventItem
InvoiceItemAdjustment.amendmentId = RevenueEventItem.amendmentId
InvoiceItemAdjustment.billToContactId = RevenueEventItem.billToContactId
InvoiceItemAdjustment.soldToContactId = RevenueEventItem.billToContactId
InvoiceItemAdjustment.billToContactId = RevenueEventItem.soldToContactId
InvoiceItemAdjustment.soldToContactId = RevenueEventItem.soldToContactId
InvoiceItemAdjustment.journalEntryId = RevenueEventItem.journalEntryId
InvoiceItemAdjustment.journalRunId = RevenueEventItem.journalRunId
InvoiceItemAdjustment.parentAccountId = RevenueEventItem.parentAccountId
InvoiceItemAdjustment.productId = RevenueEventItem.productId
InvoiceItemAdjustment.productRatePlanChargeId = RevenueEventItem.productRatePlanChargeId
InvoiceItemAdjustment.ratePlanChargeId = RevenueEventItem.ratePlanChargeId
InvoiceItemAdjustment.ratePlanId = RevenueEventItem.ratePlanId
InvoiceItemAdjustment.recognizedRevenueAccountingCodeId = RevenueEventItem.recognizedRevenueAccountingCodeId
InvoiceItemAdjustment.subscriptionId = RevenueEventItem.subscriptionId
Account
InvoiceItemAdjustment.billToContactId = Account.billToContactId
InvoiceItemAdjustment.soldToContactId = Account.billToContactId
InvoiceItemAdjustment.billToContactId = Account.soldToContactId
InvoiceItemAdjustment.soldToContactId = Account.soldToContactId
InvoiceItemAdjustment.parentAccountId = Account.parentAccountId
Contact
InvoiceItemAdjustment.billToContactId = Contact.id
InvoiceItemAdjustment.soldToContactId = Contact.id
ContactSnapshot
InvoiceItemAdjustment.billToContactId = ContactSnapshot.contactId
InvoiceItemAdjustment.soldToContactId = ContactSnapshot.contactId
Invoice
InvoiceItemAdjustment.billToContactId = Invoice.billToContactId
InvoiceItemAdjustment.soldToContactId = Invoice.billToContactId
InvoiceItemAdjustment.billToContactId = Invoice.soldToContactId
InvoiceItemAdjustment.soldToContactId = Invoice.soldToContactId
InvoiceItemAdjustment.parentAccountId = Invoice.parentAccountId
Refund
InvoiceItemAdjustment.billToContactId = Refund.billToContactId
InvoiceItemAdjustment.soldToContactId = Refund.billToContactId
InvoiceItemAdjustment.billToContactId = Refund.soldToContactId
InvoiceItemAdjustment.soldToContactId = Refund.soldToContactId
InvoiceItemAdjustment.parentAccountId = Refund.parentAccountId
JournalEntryItem
InvoiceItemAdjustment.journalEntryId = JournalEntryItem.journalEntryId
InvoiceItemAdjustment.journalRunId = JournalEntryItem.journalRunId
JournalRun
InvoiceItemAdjustment.journalRunId = JournalRun.id
Product
InvoiceItemAdjustment.productId = Product.id
ProductRatePlan
InvoiceItemAdjustment.productId = ProductRatePlan.productId
ProductRatePlanChargeTier
InvoiceItemAdjustment.productRatePlanChargeId = ProductRatePlanChargeTier.productRatePlanChargeId
InvoiceItemAdjustment.ratePlanChargeId = ProductRatePlanChargeTier.ratePlanChargeId
InvoiceItemAdjustment.ratePlanId = ProductRatePlanChargeTier.ratePlanId
RatePlanCharge
InvoiceItemAdjustment.ratePlanChargeId = RatePlanCharge.id
Subscription
InvoiceItemAdjustment.subscriptionId = Subscription.id

accountId

STRING

accountReceivableAccountingCodeId

STRING

accountingCode

STRING

accountingPeriodId

STRING

adjustmentDate

DATE-TIME

adjustmentNumber

STRING

amendmentId

STRING

amount

DOUBLE

billToContactId

STRING

cancelledById

STRING

cancelledDate

DATE-TIME

comment

STRING

createdById

STRING

createdDate

DATE-TIME

customerName

STRING

customerNumber

STRING

deleted

BOOLEAN

id

STRING

invoiceId

STRING

invoiceItemName

STRING

invoiceNumber

STRING

journalEntryId

STRING

journalRunId

STRING

parentAccountId

STRING

productId

STRING

productRatePlanChargeId

STRING

ratePlanChargeId

STRING

ratePlanId

STRING

reasonCode

STRING

recognizedRevenueAccountingCodeId

DATE-TIME

referenceId

STRING

salesTaxPayableAccountingCodeId

STRING

serviceEndDate

DATE-TIME

serviceStartDate

DATE-TIME

soldToContactId

STRING

sourceId

STRING

sourceType

STRING

status

STRING

subscriptionId

STRING

taxationItemId

STRING

transferredToAccounting

STRING

updatedById

STRING

updatedDate

DATE-TIME

JournalEntry

The JournalEntry table contains information about

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

Join JournalEntry with on
AccountingPeriod
JournalEntry.accountingPeriodId = AccountingPeriod.id
CreditBalanceAdjustment
JournalEntry.accountingPeriodId = CreditBalanceAdjustment.accountingPeriodId
JournalEntry.id = CreditBalanceAdjustment.journalEntryId
InvoiceItemAdjustment
JournalEntry.accountingPeriodId = InvoiceItemAdjustment.accountingPeriodId
JournalEntry.id = InvoiceItemAdjustment.journalEntryId
RevenueChargeSummaryItem
JournalEntry.accountingPeriodId = RevenueChargeSummaryItem.accountingPeriodId
RevenueEventItemInvoiceItem
JournalEntry.accountingPeriodId = RevenueEventItemInvoiceItem.accountingPeriodId
JournalEntry.id = RevenueEventItemInvoiceItem.journalEntryId
RevenueEventItemInvoiceItemAdjustment
JournalEntry.accountingPeriodId = RevenueEventItemInvoiceItemAdjustment.accountingPeriodId
JournalEntry.id = RevenueEventItemInvoiceItemAdjustment.journalEntryId
RevenueScheduleItem
JournalEntry.accountingPeriodId = RevenueScheduleItem.accountingPeriodId
RevenueScheduleItemInvoiceItem
JournalEntry.accountingPeriodId = RevenueScheduleItemInvoiceItem.accountingPeriodId
RevenueScheduleItemInvoiceItemAdjustment
JournalEntry.accountingPeriodId = RevenueScheduleItemInvoiceItemAdjustment.accountingPeriodId
JournalEntryItem
JournalEntry.id = JournalEntryItem.journalEntryId
RevenueEventItem
JournalEntry.id = RevenueEventItem.journalEntryId

accountingPeriodId

STRING

createdById

STRING

createdDate

DATE-TIME

currency

STRING

deleted

BOOLEAN

id

STRING

journalEntryDate

DATE-TIME

journalRunId

STRING

notes

STRING

number

STRING

status

STRING

transferDate

DATE-TIME

transferredBy

STRING

updatedDate

DATE-TIME

JournalEntryItem

The JournalEntryItem table contains information about journal entry items.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

Join JournalEntryItem with on
JournalEntry
JournalEntryItem.journalEntryId = JournalEntry.id
CreditBalanceAdjustment
JournalEntryItem.journalEntryId = CreditBalanceAdjustment.journalEntryId
JournalEntryItem.journalRunId = CreditBalanceAdjustment.journalRunId
InvoiceItemAdjustment
JournalEntryItem.journalEntryId = InvoiceItemAdjustment.journalEntryId
JournalEntryItem.journalRunId = InvoiceItemAdjustment.journalRunId
RevenueEventItem
JournalEntryItem.journalEntryId = RevenueEventItem.journalEntryId
JournalEntryItem.journalRunId = RevenueEventItem.journalRunId
RevenueEventItemInvoiceItem
JournalEntryItem.journalEntryId = RevenueEventItemInvoiceItem.journalEntryId
JournalEntryItem.journalRunId = RevenueEventItemInvoiceItem.journalRunId
RevenueEventItemInvoiceItemAdjustment
JournalEntryItem.journalEntryId = RevenueEventItemInvoiceItemAdjustment.journalEntryId
JournalEntryItem.journalRunId = RevenueEventItemInvoiceItemAdjustment.journalRunId
JournalRun
JournalEntryItem.journalRunId = JournalRun.id

accountingCodeId

STRING

accountingCodeType

STRING

amount

DOUBLE

createdById

STRING

createdDate

DATE-TIME

deleted

BOOLEAN

id

STRING

journalEntryId

STRING

journalRunId

STRING

type

STRING

updatedById

STRING

updatedDate

DATE-TIME

JournalRun

The JournalRun table contains information about journal runs.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

Join JournalRun with on
CreditBalanceAdjustment
JournalRun.id = CreditBalanceAdjustment.journalRunId
InvoiceItemAdjustment
JournalRun.id = InvoiceItemAdjustment.journalRunId
JournalEntryItem
JournalRun.id = JournalEntryItem.journalRunId
RevenueEventItem
JournalRun.id = RevenueEventItem.journalRunId
RevenueEventItemInvoiceItem
JournalRun.id = RevenueEventItemInvoiceItem.journalRunId
RevenueEventItemInvoiceItemAdjustment
JournalRun.id = RevenueEventItemInvoiceItemAdjustment.journalRunId

createdById

STRING

createdDate

DATE-TIME

deleted

BOOLEAN

executedOn

DATE-TIME

id

STRING

number

STRING

segmentationRuleName

STRING

status

STRING

targetEndDate

DATE-TIME

targetStartDate

DATE-TIME

totalJournalEntryCount

INTEGER

updatedById

STRING

updatedDate

DATE-TIME

Payment

The payment table contains info about customer payments.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

Join Payment with on
Account
Payment.accountId = Account.id
ContactSnapshot
Payment.accountId = ContactSnapshot.accountId
Invoice
Payment.accountId = Invoice.accountId
Payment.id = Invoice.id
Payment.number = Invoice.invoiceNumber
Refund
Payment.accountId = Refund.accountId
Payment.paymentMethodId = Refund.paymentMethodId
Payment.paymentMethodSnapshotId = Refund.paymentMethodSnapshotId
Payment.id = Refund.id
Payment.number = Refund.number
Subscription
Payment.accountId = Subscription.accountId
CreditBalanceAdjustment
Payment.id = CreditBalanceAdjustment.paymentId
Payment.id = CreditBalanceAdjustment.sourceTransactionId
Payment.paymentMethodId = CreditBalanceAdjustment.paymentMethodId
Payment.paymentMethodSnapshotId = CreditBalanceAdjustment.paymentMethodSnapshotId
PaymentMethod
Payment.paymentMethodId = PaymentMethod.id
PaymentMethodSnapshot
Payment.paymentMethodSnapshotId = PaymentMethodSnapshot.id

accountId

STRING

amount

NUMBER

appliedAmount

STRING

authTransactionId

STRING

bankIdentificationNumber

STRING

cancelledOn

DATE-TIME

comment

STRING

createdById

STRING

createdDate

DATE-TIME

creditBalanceAmount

NUMBER

currency

STRING

deleted

BOOLEAN

effectiveDate

DATE-TIME

gatewayId

STRING

gatewayResponse

STRING

gatewayResponseCode

STRING

gatewayState

STRING

id

STRING

markedForSubmissionOn

DATE-TIME

number

STRING

paymentDate

DATE-TIME

paymentId

STRING

paymentMethodId

STRING

paymentMethodSnapshotId

STRING

paymentTransactionTime

DATE-TIME

referenceId

STRING

refundAmount

NUMBER

secondPaymentReferenceId

STRING

settledOn

DATE-TIME

softDescriptor

STRING

softDescriptorPhone

STRING

status

STRING

submittedOn

DATE-TIME

success

BOOLEAN

type

STRING

unappliedAmount

NUMBER

updatedById

STRING

updatedDate

DATE-TIME

PaymentRun

The PaymentRun table contains information about payment runs.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

Join PaymentRun with on
BillingRun
PaymentRun.billingRunId = BillingRun.id

batch

STRING

billCycleDay

STRING

billingRunId

STRING

completedOn

DATE-TIME

consolidatedPayment

BOOLEAN

createdById

STRING

createdDate

DATE-TIME

currency

STRING

deleted

BOOLEAN

executedOn

DATE-TIME

id

STRING

number

STRING

numberOfErrors

INTEGER

numberOfInvoices

INTEGER

numberOfPayments

INTEGER

status

STRING

targetDate

DATE-TIME

updatedById

STRING

updatedDate

DATE-TIME

ProcessedUsage

The ProcessedUsage table contains information about usage.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

Join ProcessedUsage with on
Amendment
ProcessedUsage.amendmentId = Amendment.id
DiscountAppliedMetrics
ProcessedUsage.amendmentId = DiscountAppliedMetrics.amendmentId
ProcessedUsage.billToContactId = DiscountAppliedMetrics.billToContactId
ProcessedUsage.soldToContactId = DiscountAppliedMetrics.billToContactId
ProcessedUsage.billToContactId = DiscountAppliedMetrics.soldToContactId
ProcessedUsage.soldToContactId = DiscountAppliedMetrics.soldToContactId
ProcessedUsage.parentAccountId = DiscountAppliedMetrics.parentAccountId
ProcessedUsage.productId = DiscountAppliedMetrics.productId
ProcessedUsage.productRatePlanChargeId = DiscountAppliedMetrics.productRatePlanChargeId
ProcessedUsage.productRatePlanId = DiscountAppliedMetrics.productRatePlanId
ProcessedUsage.ratePlanChargeId = DiscountAppliedMetrics.ratePlanChargeId
ProcessedUsage.ratePlanId = DiscountAppliedMetrics.ratePlanId
InvoiceItemAdjustment
ProcessedUsage.amendmentId = InvoiceItemAdjustment.amendmentId
ProcessedUsage.billToContactId = InvoiceItemAdjustment.billToContactId
ProcessedUsage.soldToContactId = InvoiceItemAdjustment.billToContactId
ProcessedUsage.billToContactId = InvoiceItemAdjustment.soldToContactId
ProcessedUsage.soldToContactId = InvoiceItemAdjustment.soldToContactId
ProcessedUsage.parentAccountId = InvoiceItemAdjustment.parentAccountId
ProcessedUsage.productId = InvoiceItemAdjustment.productId
ProcessedUsage.productRatePlanChargeId = InvoiceItemAdjustment.productRatePlanChargeId
ProcessedUsage.ratePlanChargeId = InvoiceItemAdjustment.ratePlanChargeId
ProcessedUsage.ratePlanId = InvoiceItemAdjustment.ratePlanId
RatePlan
ProcessedUsage.amendmentId = RatePlan.amendmentId
ProcessedUsage.billToContactId = RatePlan.billToContactId
ProcessedUsage.soldToContactId = RatePlan.billToContactId
ProcessedUsage.productRatePlanId = RatePlan.productRatePlanId
ProcessedUsage.ratePlanId = RatePlan.id
RatePlanChargeTier
ProcessedUsage.amendmentId = RatePlanChargeTier.amendmentId
ProcessedUsage.productRatePlanId = RatePlanChargeTier.productRatePlanId
ProcessedUsage.ratePlanChargeId = RatePlanChargeTier.ratePlanChargeId
ProcessedUsage.ratePlanId = RatePlanChargeTier.ratePlanId
RevenueChargeSummaryItem
ProcessedUsage.amendmentId = RevenueChargeSummaryItem.amendmentId
ProcessedUsage.billToContactId = RevenueChargeSummaryItem.billToContactId
ProcessedUsage.soldToContactId = RevenueChargeSummaryItem.billToContactId
ProcessedUsage.billToContactId = RevenueChargeSummaryItem.soldToContactId
ProcessedUsage.soldToContactId = RevenueChargeSummaryItem.soldToContactId
ProcessedUsage.parentAccountId = RevenueChargeSummaryItem.parentAccountId
ProcessedUsage.productId = RevenueChargeSummaryItem.productId
ProcessedUsage.productRatePlanChargeId = RevenueChargeSummaryItem.productRatePlanChargeId
ProcessedUsage.productRatePlanId = RevenueChargeSummaryItem.productRatePlanId
ProcessedUsage.ratePlanChargeId = RevenueChargeSummaryItem.ratePlanChargeId
ProcessedUsage.ratePlanId = RevenueChargeSummaryItem.ratePlanId
RevenueEventItem
ProcessedUsage.amendmentId = RevenueEventItem.amendmentId
ProcessedUsage.billToContactId = RevenueEventItem.billToContactId
ProcessedUsage.soldToContactId = RevenueEventItem.billToContactId
ProcessedUsage.billToContactId = RevenueEventItem.soldToContactId
ProcessedUsage.soldToContactId = RevenueEventItem.soldToContactId
ProcessedUsage.parentAccountId = RevenueEventItem.parentAccountId
ProcessedUsage.productId = RevenueEventItem.productId
ProcessedUsage.productRatePlanChargeId = RevenueEventItem.productRatePlanChargeId
ProcessedUsage.productRatePlanId = RevenueEventItem.productRatePlanId
ProcessedUsage.ratePlanChargeId = RevenueEventItem.ratePlanChargeId
ProcessedUsage.ratePlanId = RevenueEventItem.ratePlanId
RevenueEventItemInvoiceItem
ProcessedUsage.amendmentId = RevenueEventItemInvoiceItem.amendmentId
ProcessedUsage.billToContactId = RevenueEventItemInvoiceItem.billToContactId
ProcessedUsage.soldToContactId = RevenueEventItemInvoiceItem.billToContactId
ProcessedUsage.billToContactId = RevenueEventItemInvoiceItem.soldToContactId
ProcessedUsage.soldToContactId = RevenueEventItemInvoiceItem.soldToContactId
ProcessedUsage.invoiceItemId = RevenueEventItemInvoiceItem.invoiceItemId
ProcessedUsage.parentAccountId = RevenueEventItemInvoiceItem.parentAccountId
ProcessedUsage.productId = RevenueEventItemInvoiceItem.productId
ProcessedUsage.productRatePlanChargeId = RevenueEventItemInvoiceItem.productRatePlanChargeId
ProcessedUsage.productRatePlanId = RevenueEventItemInvoiceItem.productRatePlanId
ProcessedUsage.ratePlanChargeId = RevenueEventItemInvoiceItem.ratePlanChargeId
ProcessedUsage.ratePlanId = RevenueEventItemInvoiceItem.ratePlanId
RevenueEventItemInvoiceItemAdjustment
ProcessedUsage.amendmentId = RevenueEventItemInvoiceItemAdjustment.amendmentId
ProcessedUsage.billToContactId = RevenueEventItemInvoiceItemAdjustment.billToContactId
ProcessedUsage.soldToContactId = RevenueEventItemInvoiceItemAdjustment.billToContactId
ProcessedUsage.billToContactId = RevenueEventItemInvoiceItemAdjustment.soldToContactId
ProcessedUsage.soldToContactId = RevenueEventItemInvoiceItemAdjustment.soldToContactId
ProcessedUsage.invoiceItemId = RevenueEventItemInvoiceItemAdjustment.invoiceItemId
ProcessedUsage.parentAccountId = RevenueEventItemInvoiceItemAdjustment.parentAccountId
ProcessedUsage.productId = RevenueEventItemInvoiceItemAdjustment.productId
ProcessedUsage.productRatePlanChargeId = RevenueEventItemInvoiceItemAdjustment.productRatePlanChargeId
ProcessedUsage.productRatePlanId = RevenueEventItemInvoiceItemAdjustment.productRatePlanId
ProcessedUsage.ratePlanChargeId = RevenueEventItemInvoiceItemAdjustment.ratePlanChargeId
ProcessedUsage.ratePlanId = RevenueEventItemInvoiceItemAdjustment.ratePlanId
RevenueScheduleItem
ProcessedUsage.amendmentId = RevenueScheduleItem.amendmentId
ProcessedUsage.billToContactId = RevenueScheduleItem.billToContactId
ProcessedUsage.soldToContactId = RevenueScheduleItem.billToContactId
ProcessedUsage.billToContactId = RevenueScheduleItem.soldToContactId
ProcessedUsage.soldToContactId = RevenueScheduleItem.soldToContactId
ProcessedUsage.parentAccountId = RevenueScheduleItem.parentAccountId
ProcessedUsage.productId = RevenueScheduleItem.productId
ProcessedUsage.productRatePlanChargeId = RevenueScheduleItem.productRatePlanChargeId
ProcessedUsage.productRatePlanId = RevenueScheduleItem.productRatePlanId
ProcessedUsage.ratePlanChargeId = RevenueScheduleItem.ratePlanChargeId
ProcessedUsage.ratePlanId = RevenueScheduleItem.ratePlanId
RevenueScheduleItemInvoiceItem
ProcessedUsage.amendmentId = RevenueScheduleItemInvoiceItem.amendmentId
ProcessedUsage.billToContactId = RevenueScheduleItemInvoiceItem.billToContactId
ProcessedUsage.soldToContactId = RevenueScheduleItemInvoiceItem.billToContactId
ProcessedUsage.billToContactId = RevenueScheduleItemInvoiceItem.soldToContactId
ProcessedUsage.soldToContactId = RevenueScheduleItemInvoiceItem.soldToContactId
ProcessedUsage.invoiceItemId = RevenueScheduleItemInvoiceItem.invoiceItemId
ProcessedUsage.parentAccountId = RevenueScheduleItemInvoiceItem.parentAccountId
ProcessedUsage.productId = RevenueScheduleItemInvoiceItem.productId
ProcessedUsage.productRatePlanChargeId = RevenueScheduleItemInvoiceItem.productRatePlanChargeId
ProcessedUsage.productRatePlanId = RevenueScheduleItemInvoiceItem.productRatePlanId
ProcessedUsage.ratePlanChargeId = RevenueScheduleItemInvoiceItem.ratePlanChargeId
ProcessedUsage.ratePlanId = RevenueScheduleItemInvoiceItem.ratePlanId
RevenueScheduleItemInvoiceItemAdjustment
ProcessedUsage.amendmentId = RevenueScheduleItemInvoiceItemAdjustment.amendmentId
ProcessedUsage.billToContactId = RevenueScheduleItemInvoiceItemAdjustment.billToContactId
ProcessedUsage.soldToContactId = RevenueScheduleItemInvoiceItemAdjustment.billToContactId
ProcessedUsage.billToContactId = RevenueScheduleItemInvoiceItemAdjustment.soldToContactId
ProcessedUsage.soldToContactId = RevenueScheduleItemInvoiceItemAdjustment.soldToContactId
ProcessedUsage.invoiceItemId = RevenueScheduleItemInvoiceItemAdjustment.invoiceItemId
ProcessedUsage.parentAccountId = RevenueScheduleItemInvoiceItemAdjustment.parentAccountId
ProcessedUsage.productId = RevenueScheduleItemInvoiceItemAdjustment.productId
ProcessedUsage.productRatePlanChargeId = RevenueScheduleItemInvoiceItemAdjustment.productRatePlanChargeId
ProcessedUsage.productRatePlanId = RevenueScheduleItemInvoiceItemAdjustment.productRatePlanId
ProcessedUsage.ratePlanChargeId = RevenueScheduleItemInvoiceItemAdjustment.ratePlanChargeId
ProcessedUsage.ratePlanId = RevenueScheduleItemInvoiceItemAdjustment.ratePlanId
Account
ProcessedUsage.billToContactId = Account.billToContactId
ProcessedUsage.soldToContactId = Account.billToContactId
ProcessedUsage.billToContactId = Account.soldToContactId
ProcessedUsage.soldToContactId = Account.soldToContactId
ProcessedUsage.parentAccountId = Account.parentAccountId
Contact
ProcessedUsage.billToContactId = Contact.id
ProcessedUsage.soldToContactId = Contact.id
ContactSnapshot
ProcessedUsage.billToContactId = ContactSnapshot.contactId
ProcessedUsage.soldToContactId = ContactSnapshot.contactId
CreditBalanceAdjustment
ProcessedUsage.billToContactId = CreditBalanceAdjustment.billToContactId
ProcessedUsage.soldToContactId = CreditBalanceAdjustment.billToContactId
ProcessedUsage.billToContactId = CreditBalanceAdjustment.soldToContactId
ProcessedUsage.soldToContactId = CreditBalanceAdjustment.soldToContactId
ProcessedUsage.parentAccountId = CreditBalanceAdjustment.parentAccountId
Invoice
ProcessedUsage.billToContactId = Invoice.billToContactId
ProcessedUsage.soldToContactId = Invoice.billToContactId
ProcessedUsage.billToContactId = Invoice.soldToContactId
ProcessedUsage.soldToContactId = Invoice.soldToContactId
ProcessedUsage.parentAccountId = Invoice.parentAccountId
Refund
ProcessedUsage.billToContactId = Refund.billToContactId
ProcessedUsage.soldToContactId = Refund.billToContactId
ProcessedUsage.billToContactId = Refund.soldToContactId
ProcessedUsage.soldToContactId = Refund.soldToContactId
ProcessedUsage.parentAccountId = Refund.parentAccountId
InvoiceItem
ProcessedUsage.invoiceItemId = InvoiceItem.id
ProcessedUsage.productId = InvoiceItem.productId
ProcessedUsage.productRatePlanChargeId = InvoiceItem.productRatePlanChargeId
ProcessedUsage.ratePlanChargeId = InvoiceItem.ratePlanChargeId
Product
ProcessedUsage.productId = Product.id
ProductRatePlan
ProcessedUsage.productId = ProductRatePlan.productId
ProcessedUsage.productRatePlanId = ProductRatePlan.id
ProductRatePlanCharge
ProcessedUsage.productRatePlanChargeId = ProductRatePlanCharge.id
ProcessedUsage.productRatePlanId = ProductRatePlanCharge.productRatePlanId
ProductRatePlanChargeTier
ProcessedUsage.productRatePlanChargeId = ProductRatePlanChargeTier.productRatePlanChargeId
ProcessedUsage.productRatePlanId = ProductRatePlanChargeTier.productRatePlanId
ProcessedUsage.ratePlanChargeId = ProductRatePlanChargeTier.ratePlanChargeId
ProcessedUsage.ratePlanId = ProductRatePlanChargeTier.ratePlanId
RatePlanCharge
ProcessedUsage.ratePlanChargeId = RatePlanCharge.id

accountId

STRING

amendmentId

STRING

amount

DOUBLE

billToContactId

STRING

billingPeriodEndDate

DATE-TIME

billingPeriodStartDate

DATE-TIME

createdById

STRING

createdDate

DATE-TIME

defaultPaymentMethodId

STRING

id

STRING

invoiceId

STRING

invoiceItemId

STRING

parentAccountId

STRING

productId

STRING

productRatePlanChargeId

STRING

productRatePlanId

STRING

ratePlanChargeId

STRING

ratePlanId

STRING

soldToContactId

STRING

updatedById

STRING

updatedDate

DATE-TIME

usageId

STRING

Product

The Product table contains info about your company’s product offerings.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

Join Product with on
DiscountAppliedMetrics
Product.id = DiscountAppliedMetrics.productId
InvoiceItem
Product.id = InvoiceItem.productId
InvoiceItemAdjustment
Product.id = InvoiceItemAdjustment.productId
ProcessedUsage
Product.id = ProcessedUsage.productId
ProductRatePlan
Product.id = ProductRatePlan.productId
RevenueChargeSummaryItem
Product.id = RevenueChargeSummaryItem.productId
RevenueEventItem
Product.id = RevenueEventItem.productId
RevenueEventItemInvoiceItem
Product.id = RevenueEventItemInvoiceItem.productId
RevenueEventItemInvoiceItemAdjustment
Product.id = RevenueEventItemInvoiceItemAdjustment.productId
RevenueScheduleItem
Product.id = RevenueScheduleItem.productId
RevenueScheduleItemInvoiceItem
Product.id = RevenueScheduleItemInvoiceItem.productId
RevenueScheduleItemInvoiceItemAdjustment
Product.id = RevenueScheduleItemInvoiceItemAdjustment.productId

allowFeatureChanges

BOOLEAN

category

STRING

createdById

STRING

createdDate

DATE-TIME

deleted

BOOLEAN

description

STRING

effectiveEndDate

DATE-TIME

effectiveStartDate

DATE-TIME

id

STRING

name

STRING

sku

STRING

updatedById

STRING

updatedDate

DATE-TIME

ProductRatePlan

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

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

Join ProductRatePlan with on
Product
ProductRatePlan.productId = Product.id
DiscountAppliedMetrics
ProductRatePlan.productId = DiscountAppliedMetrics.productId
ProductRatePlan.id = DiscountAppliedMetrics.productRatePlanId
InvoiceItem
ProductRatePlan.productId = InvoiceItem.productId
InvoiceItemAdjustment
ProductRatePlan.productId = InvoiceItemAdjustment.productId
ProcessedUsage
ProductRatePlan.productId = ProcessedUsage.productId
ProductRatePlan.id = ProcessedUsage.productRatePlanId
RevenueChargeSummaryItem
ProductRatePlan.productId = RevenueChargeSummaryItem.productId
ProductRatePlan.id = RevenueChargeSummaryItem.productRatePlanId
RevenueEventItem
ProductRatePlan.productId = RevenueEventItem.productId
ProductRatePlan.id = RevenueEventItem.productRatePlanId
RevenueEventItemInvoiceItem
ProductRatePlan.productId = RevenueEventItemInvoiceItem.productId
ProductRatePlan.id = RevenueEventItemInvoiceItem.productRatePlanId
RevenueEventItemInvoiceItemAdjustment
ProductRatePlan.productId = RevenueEventItemInvoiceItemAdjustment.productId
ProductRatePlan.id = RevenueEventItemInvoiceItemAdjustment.productRatePlanId
RevenueScheduleItem
ProductRatePlan.productId = RevenueScheduleItem.productId
ProductRatePlan.id = RevenueScheduleItem.productRatePlanId
RevenueScheduleItemInvoiceItem
ProductRatePlan.productId = RevenueScheduleItemInvoiceItem.productId
ProductRatePlan.id = RevenueScheduleItemInvoiceItem.productRatePlanId
RevenueScheduleItemInvoiceItemAdjustment
ProductRatePlan.productId = RevenueScheduleItemInvoiceItemAdjustment.productId
ProductRatePlan.id = RevenueScheduleItemInvoiceItemAdjustment.productRatePlanId
ProductRatePlanCharge
ProductRatePlan.id = ProductRatePlanCharge.productRatePlanId
ProductRatePlanChargeTier
ProductRatePlan.id = ProductRatePlanChargeTier.productRatePlanId
RatePlan
ProductRatePlan.id = RatePlan.productRatePlanId
RatePlanChargeTier
ProductRatePlan.id = RatePlanChargeTier.productRatePlanId

createdById

STRING

createdDate

DATE-TIME

defaultPaymentMethodId

STRING

deleted

BOOLEAN

description

STRING

effectiveEndDate

DATE-TIME

effectiveStartDate

DATE-TIME

id

STRING

name

STRING

productId

STRING

updatedById

STRING

updatedDate

DATE-TIME

ProductRatePlanCharge

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

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

Join ProductRatePlanCharge with on
AccountingCode
ProductRatePlanCharge.accountingCode = AccountingCode.id
CreditBalanceAdjustment
ProductRatePlanCharge.accountingCode = CreditBalanceAdjustment.accountingCode
InvoiceItem
ProductRatePlanCharge.accountingCode = InvoiceItem.accountingCode
ProductRatePlanCharge.id = InvoiceItem.productRatePlanChargeId
InvoiceItemAdjustment
ProductRatePlanCharge.accountingCode = InvoiceItemAdjustment.accountingCode
ProductRatePlanCharge.id = InvoiceItemAdjustment.productRatePlanChargeId
DiscountAppliedMetrics
ProductRatePlanCharge.id = DiscountAppliedMetrics.productRatePlanChargeId
ProductRatePlanCharge.productRatePlanId = DiscountAppliedMetrics.productRatePlanId
ProcessedUsage
ProductRatePlanCharge.id = ProcessedUsage.productRatePlanChargeId
ProductRatePlanCharge.productRatePlanId = ProcessedUsage.productRatePlanId
ProductRatePlanChargeTier
ProductRatePlanCharge.id = ProductRatePlanChargeTier.productRatePlanChargeId
ProductRatePlanCharge.productRatePlanId = ProductRatePlanChargeTier.productRatePlanId
RevenueChargeSummaryItem
ProductRatePlanCharge.id = RevenueChargeSummaryItem.productRatePlanChargeId
ProductRatePlanCharge.productRatePlanId = RevenueChargeSummaryItem.productRatePlanId
RevenueEventItem
ProductRatePlanCharge.id = RevenueEventItem.productRatePlanChargeId
ProductRatePlanCharge.productRatePlanId = RevenueEventItem.productRatePlanId
RevenueEventItemInvoiceItem
ProductRatePlanCharge.id = RevenueEventItemInvoiceItem.productRatePlanChargeId
ProductRatePlanCharge.productRatePlanId = RevenueEventItemInvoiceItem.productRatePlanId
RevenueEventItemInvoiceItemAdjustment
ProductRatePlanCharge.id = RevenueEventItemInvoiceItemAdjustment.productRatePlanChargeId
ProductRatePlanCharge.productRatePlanId = RevenueEventItemInvoiceItemAdjustment.productRatePlanId
RevenueScheduleItem
ProductRatePlanCharge.id = RevenueScheduleItem.productRatePlanChargeId
ProductRatePlanCharge.productRatePlanId = RevenueScheduleItem.productRatePlanId
RevenueScheduleItemInvoiceItem
ProductRatePlanCharge.id = RevenueScheduleItemInvoiceItem.productRatePlanChargeId
ProductRatePlanCharge.productRatePlanId = RevenueScheduleItemInvoiceItem.productRatePlanId
RevenueScheduleItemInvoiceItemAdjustment
ProductRatePlanCharge.id = RevenueScheduleItemInvoiceItemAdjustment.productRatePlanChargeId
ProductRatePlanCharge.productRatePlanId = RevenueScheduleItemInvoiceItemAdjustment.productRatePlanId
ProductRatePlan
ProductRatePlanCharge.productRatePlanId = ProductRatePlan.id
RatePlan
ProductRatePlanCharge.productRatePlanId = RatePlan.productRatePlanId
RatePlanChargeTier
ProductRatePlanCharge.productRatePlanId = RatePlanChargeTier.productRatePlanId

accountingCode

STRING

applyDiscountTo

STRING

billCycleDay

INTEGER

billCycleType

STRING

billingPeriod

STRING

billingPeriodAlignment

STRING

billingTiming

STRING

chargeModel

STRING

chargeType

STRING

createdById

STRING

createdDate

DATE-TIME

defaultQuantity

DECIMAL

deferredRevenueAccount

STRING

deleted

BOOLEAN

description

STRING

discountClass

STRING

discountLevel

STRING

endDateCondition

STRING

id

STRING

includedUnits

DECIMAL

listPriceBase

STRING

maxQuantity

DECIMAL

minQuantity

DECIMAL

name

STRING

numberOfPeriod

INTEGER

overCalculationOption

STRING

overageUnusedUnitsCreditOption

STRING

priceChangeOption

STRING

priceIncreaseOption

STRING

productRatePlanId

STRING

recognizedRevenueAccount

STRING

revRecCode

STRING

revRecTriggerCondition

STRING

revenueRecognitionRuleName

STRING

smoothingModel

STRING

specificBillingPeriod

INTEGER

taxCode

STRING

taxMode

STRING

taxable

BOOLEAN

triggerEvent

STRING

uom

STRING

upToPeriods

INTEGER

upToPeriodsType

STRING

updatedById

STRING

updatedDate

DATE-TIME

useDiscountSpecificAccountingCode

BOOLEAN

useTenantDefaultForPriceChange

BOOLEAN

weeklyBillCycleDay

STRING

ProductRatePlanChargeTier

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

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

Join ProductRatePlanChargeTier with on
ProductRatePlanCharge
ProductRatePlanChargeTier.productRatePlanChargeId = ProductRatePlanCharge.id
ProductRatePlanChargeTier.productRatePlanId = ProductRatePlanCharge.productRatePlanId
DiscountAppliedMetrics
ProductRatePlanChargeTier.productRatePlanChargeId = DiscountAppliedMetrics.productRatePlanChargeId
ProductRatePlanChargeTier.productRatePlanId = DiscountAppliedMetrics.productRatePlanId
ProductRatePlanChargeTier.ratePlanChargeId = DiscountAppliedMetrics.ratePlanChargeId
ProductRatePlanChargeTier.ratePlanId = DiscountAppliedMetrics.ratePlanId
InvoiceItem
ProductRatePlanChargeTier.productRatePlanChargeId = InvoiceItem.productRatePlanChargeId
ProductRatePlanChargeTier.ratePlanChargeId = InvoiceItem.ratePlanChargeId
InvoiceItemAdjustment
ProductRatePlanChargeTier.productRatePlanChargeId = InvoiceItemAdjustment.productRatePlanChargeId
ProductRatePlanChargeTier.ratePlanChargeId = InvoiceItemAdjustment.ratePlanChargeId
ProductRatePlanChargeTier.ratePlanId = InvoiceItemAdjustment.ratePlanId
ProcessedUsage
ProductRatePlanChargeTier.productRatePlanChargeId = ProcessedUsage.productRatePlanChargeId
ProductRatePlanChargeTier.productRatePlanId = ProcessedUsage.productRatePlanId
ProductRatePlanChargeTier.ratePlanChargeId = ProcessedUsage.ratePlanChargeId
ProductRatePlanChargeTier.ratePlanId = ProcessedUsage.ratePlanId
RevenueChargeSummaryItem
ProductRatePlanChargeTier.productRatePlanChargeId = RevenueChargeSummaryItem.productRatePlanChargeId
ProductRatePlanChargeTier.productRatePlanId = RevenueChargeSummaryItem.productRatePlanId
ProductRatePlanChargeTier.ratePlanChargeId = RevenueChargeSummaryItem.ratePlanChargeId
ProductRatePlanChargeTier.ratePlanId = RevenueChargeSummaryItem.ratePlanId
RevenueEventItem
ProductRatePlanChargeTier.productRatePlanChargeId = RevenueEventItem.productRatePlanChargeId
ProductRatePlanChargeTier.productRatePlanId = RevenueEventItem.productRatePlanId
ProductRatePlanChargeTier.ratePlanChargeId = RevenueEventItem.ratePlanChargeId
ProductRatePlanChargeTier.ratePlanId = RevenueEventItem.ratePlanId
RevenueEventItemInvoiceItem
ProductRatePlanChargeTier.productRatePlanChargeId = RevenueEventItemInvoiceItem.productRatePlanChargeId
ProductRatePlanChargeTier.productRatePlanId = RevenueEventItemInvoiceItem.productRatePlanId
ProductRatePlanChargeTier.ratePlanChargeId = RevenueEventItemInvoiceItem.ratePlanChargeId
ProductRatePlanChargeTier.ratePlanId = RevenueEventItemInvoiceItem.ratePlanId
RevenueEventItemInvoiceItemAdjustment
ProductRatePlanChargeTier.productRatePlanChargeId = RevenueEventItemInvoiceItemAdjustment.productRatePlanChargeId
ProductRatePlanChargeTier.productRatePlanId = RevenueEventItemInvoiceItemAdjustment.productRatePlanId
ProductRatePlanChargeTier.ratePlanChargeId = RevenueEventItemInvoiceItemAdjustment.ratePlanChargeId
ProductRatePlanChargeTier.ratePlanId = RevenueEventItemInvoiceItemAdjustment.ratePlanId
RevenueScheduleItem
ProductRatePlanChargeTier.productRatePlanChargeId = RevenueScheduleItem.productRatePlanChargeId
ProductRatePlanChargeTier.productRatePlanId = RevenueScheduleItem.productRatePlanId
ProductRatePlanChargeTier.ratePlanChargeId = RevenueScheduleItem.ratePlanChargeId
ProductRatePlanChargeTier.ratePlanId = RevenueScheduleItem.ratePlanId
RevenueScheduleItemInvoiceItem
ProductRatePlanChargeTier.productRatePlanChargeId = RevenueScheduleItemInvoiceItem.productRatePlanChargeId
ProductRatePlanChargeTier.productRatePlanId = RevenueScheduleItemInvoiceItem.productRatePlanId
ProductRatePlanChargeTier.ratePlanChargeId = RevenueScheduleItemInvoiceItem.ratePlanChargeId
ProductRatePlanChargeTier.ratePlanId = RevenueScheduleItemInvoiceItem.ratePlanId
RevenueScheduleItemInvoiceItemAdjustment
ProductRatePlanChargeTier.productRatePlanChargeId = RevenueScheduleItemInvoiceItemAdjustment.productRatePlanChargeId
ProductRatePlanChargeTier.productRatePlanId = RevenueScheduleItemInvoiceItemAdjustment.productRatePlanId
ProductRatePlanChargeTier.ratePlanChargeId = RevenueScheduleItemInvoiceItemAdjustment.ratePlanChargeId
ProductRatePlanChargeTier.ratePlanId = RevenueScheduleItemInvoiceItemAdjustment.ratePlanId
ProductRatePlan
ProductRatePlanChargeTier.productRatePlanId = ProductRatePlan.id
RatePlan
ProductRatePlanChargeTier.productRatePlanId = RatePlan.productRatePlanId
ProductRatePlanChargeTier.ratePlanId = RatePlan.id
RatePlanChargeTier
ProductRatePlanChargeTier.productRatePlanId = RatePlanChargeTier.productRatePlanId
ProductRatePlanChargeTier.ratePlanChargeId = RatePlanChargeTier.ratePlanChargeId
ProductRatePlanChargeTier.ratePlanId = RatePlanChargeTier.ratePlanId
RatePlanCharge
ProductRatePlanChargeTier.ratePlanChargeId = RatePlanCharge.id

createdById

STRING

createdDate

DATE-TIME

currency

STRING

deleted

BOOLEAN

endingUnit

NUMBER

id

STRING

price

NUMBER

priceFormat

STRING

productRatePlanChargeId

STRING

productRatePlanId

STRING

ratePlanChargeId

STRING

ratePlanId

STRING

startingUnit

NUMBER

tier

INTEGER

updatedById

STRING

updatedDate

DATE-TIME

RatePlan

The RatePlan 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.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

Join RatePlan with on
Amendment
RatePlan.amendmentId = Amendment.id
RatePlan.subscriptionId = Amendment.subscriptionId
DiscountAppliedMetrics
RatePlan.amendmentId = DiscountAppliedMetrics.amendmentId
RatePlan.billToContactId = DiscountAppliedMetrics.billToContactId
RatePlan.billToContactId = DiscountAppliedMetrics.soldToContactId
RatePlan.productRatePlanId = DiscountAppliedMetrics.productRatePlanId
RatePlan.id = DiscountAppliedMetrics.ratePlanId
RatePlan.subscriptionId = DiscountAppliedMetrics.subscriptionId
InvoiceItemAdjustment
RatePlan.amendmentId = InvoiceItemAdjustment.amendmentId
RatePlan.billToContactId = InvoiceItemAdjustment.billToContactId
RatePlan.billToContactId = InvoiceItemAdjustment.soldToContactId
RatePlan.id = InvoiceItemAdjustment.ratePlanId
RatePlan.subscriptionId = InvoiceItemAdjustment.subscriptionId
ProcessedUsage
RatePlan.amendmentId = ProcessedUsage.amendmentId
RatePlan.billToContactId = ProcessedUsage.billToContactId
RatePlan.billToContactId = ProcessedUsage.soldToContactId
RatePlan.productRatePlanId = ProcessedUsage.productRatePlanId
RatePlan.id = ProcessedUsage.ratePlanId
RatePlanChargeTier
RatePlan.amendmentId = RatePlanChargeTier.amendmentId
RatePlan.productRatePlanId = RatePlanChargeTier.productRatePlanId
RatePlan.id = RatePlanChargeTier.ratePlanId
RatePlan.subscriptionId = RatePlanChargeTier.subscriptionId
RevenueChargeSummaryItem
RatePlan.amendmentId = RevenueChargeSummaryItem.amendmentId
RatePlan.billToContactId = RevenueChargeSummaryItem.billToContactId
RatePlan.billToContactId = RevenueChargeSummaryItem.soldToContactId
RatePlan.productRatePlanId = RevenueChargeSummaryItem.productRatePlanId
RatePlan.id = RevenueChargeSummaryItem.ratePlanId
RatePlan.subscriptionId = RevenueChargeSummaryItem.subscriptionId
RevenueEventItem
RatePlan.amendmentId = RevenueEventItem.amendmentId
RatePlan.billToContactId = RevenueEventItem.billToContactId
RatePlan.billToContactId = RevenueEventItem.soldToContactId
RatePlan.productRatePlanId = RevenueEventItem.productRatePlanId
RatePlan.id = RevenueEventItem.ratePlanId
RatePlan.subscriptionId = RevenueEventItem.subscriptionId
RevenueEventItemInvoiceItem
RatePlan.amendmentId = RevenueEventItemInvoiceItem.amendmentId
RatePlan.billToContactId = RevenueEventItemInvoiceItem.billToContactId
RatePlan.billToContactId = RevenueEventItemInvoiceItem.soldToContactId
RatePlan.productRatePlanId = RevenueEventItemInvoiceItem.productRatePlanId
RatePlan.id = RevenueEventItemInvoiceItem.ratePlanId
RatePlan.subscriptionId = RevenueEventItemInvoiceItem.subscriptionId
RevenueEventItemInvoiceItemAdjustment
RatePlan.amendmentId = RevenueEventItemInvoiceItemAdjustment.amendmentId
RatePlan.billToContactId = RevenueEventItemInvoiceItemAdjustment.billToContactId
RatePlan.billToContactId = RevenueEventItemInvoiceItemAdjustment.soldToContactId
RatePlan.productRatePlanId = RevenueEventItemInvoiceItemAdjustment.productRatePlanId
RatePlan.id = RevenueEventItemInvoiceItemAdjustment.ratePlanId
RatePlan.subscriptionId = RevenueEventItemInvoiceItemAdjustment.subscriptionId
RevenueScheduleItem
RatePlan.amendmentId = RevenueScheduleItem.amendmentId
RatePlan.billToContactId = RevenueScheduleItem.billToContactId
RatePlan.billToContactId = RevenueScheduleItem.soldToContactId
RatePlan.productRatePlanId = RevenueScheduleItem.productRatePlanId
RatePlan.id = RevenueScheduleItem.ratePlanId
RevenueScheduleItemInvoiceItem
RatePlan.amendmentId = RevenueScheduleItemInvoiceItem.amendmentId
RatePlan.billToContactId = RevenueScheduleItemInvoiceItem.billToContactId
RatePlan.billToContactId = RevenueScheduleItemInvoiceItem.soldToContactId
RatePlan.productRatePlanId = RevenueScheduleItemInvoiceItem.productRatePlanId
RatePlan.id = RevenueScheduleItemInvoiceItem.ratePlanId
RevenueScheduleItemInvoiceItemAdjustment
RatePlan.amendmentId = RevenueScheduleItemInvoiceItemAdjustment.amendmentId
RatePlan.billToContactId = RevenueScheduleItemInvoiceItemAdjustment.billToContactId
RatePlan.billToContactId = RevenueScheduleItemInvoiceItemAdjustment.soldToContactId
RatePlan.productRatePlanId = RevenueScheduleItemInvoiceItemAdjustment.productRatePlanId
RatePlan.id = RevenueScheduleItemInvoiceItemAdjustment.ratePlanId
RatePlan.subscriptionId = RevenueScheduleItemInvoiceItemAdjustment.subscriptionId
Account
RatePlan.billToContactId = Account.billToContactId
RatePlan.billToContactId = Account.soldToContactId
Contact
RatePlan.billToContactId = Contact.id
ContactSnapshot
RatePlan.billToContactId = ContactSnapshot.contactId
CreditBalanceAdjustment
RatePlan.billToContactId = CreditBalanceAdjustment.billToContactId
RatePlan.billToContactId = CreditBalanceAdjustment.soldToContactId
Invoice
RatePlan.billToContactId = Invoice.billToContactId
RatePlan.billToContactId = Invoice.soldToContactId
Refund
RatePlan.billToContactId = Refund.billToContactId
RatePlan.billToContactId = Refund.soldToContactId
ProductRatePlan
RatePlan.productRatePlanId = ProductRatePlan.id
ProductRatePlanCharge
RatePlan.productRatePlanId = ProductRatePlanCharge.productRatePlanId
ProductRatePlanChargeTier
RatePlan.productRatePlanId = ProductRatePlanChargeTier.productRatePlanId
RatePlan.id = ProductRatePlanChargeTier.ratePlanId
Subscription
RatePlan.subscriptionId = Subscription.id
InvoiceItem
RatePlan.subscriptionId = InvoiceItem.subscriptionId

amendmentId

STRING

amendmentType

STRING

billToContactId

STRING

createdById

STRING

createdDate

DATE-TIME

deleted

BOOLEAN

id

STRING

name

STRING

productRatePlanId

STRING

subscriptionId

STRING

updatedById

STRING

updatedDate

DATE-TIME

RatePlanChargeTier

The RatePlanChargeTier table contains pricing info for rate plan charges.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

Join RatePlanChargeTier with on
Amendment
RatePlanChargeTier.amendmentId = Amendment.id
RatePlanChargeTier.subscriptionId = Amendment.subscriptionId
DiscountAppliedMetrics
RatePlanChargeTier.amendmentId = DiscountAppliedMetrics.amendmentId
RatePlanChargeTier.productRatePlanId = DiscountAppliedMetrics.productRatePlanId
RatePlanChargeTier.ratePlanChargeId = DiscountAppliedMetrics.ratePlanChargeId
RatePlanChargeTier.ratePlanId = DiscountAppliedMetrics.ratePlanId
RatePlanChargeTier.subscriptionId = DiscountAppliedMetrics.subscriptionId
InvoiceItemAdjustment
RatePlanChargeTier.amendmentId = InvoiceItemAdjustment.amendmentId
RatePlanChargeTier.ratePlanChargeId = InvoiceItemAdjustment.ratePlanChargeId
RatePlanChargeTier.ratePlanId = InvoiceItemAdjustment.ratePlanId
RatePlanChargeTier.subscriptionId = InvoiceItemAdjustment.subscriptionId
ProcessedUsage
RatePlanChargeTier.amendmentId = ProcessedUsage.amendmentId
RatePlanChargeTier.productRatePlanId = ProcessedUsage.productRatePlanId
RatePlanChargeTier.ratePlanChargeId = ProcessedUsage.ratePlanChargeId
RatePlanChargeTier.ratePlanId = ProcessedUsage.ratePlanId
RatePlan
RatePlanChargeTier.amendmentId = RatePlan.amendmentId
RatePlanChargeTier.productRatePlanId = RatePlan.productRatePlanId
RatePlanChargeTier.ratePlanId = RatePlan.id
RatePlanChargeTier.subscriptionId = RatePlan.subscriptionId
RevenueChargeSummaryItem
RatePlanChargeTier.amendmentId = RevenueChargeSummaryItem.amendmentId
RatePlanChargeTier.productRatePlanId = RevenueChargeSummaryItem.productRatePlanId
RatePlanChargeTier.ratePlanChargeId = RevenueChargeSummaryItem.ratePlanChargeId
RatePlanChargeTier.ratePlanId = RevenueChargeSummaryItem.ratePlanId
RatePlanChargeTier.subscriptionId = RevenueChargeSummaryItem.subscriptionId
RevenueEventItem
RatePlanChargeTier.amendmentId = RevenueEventItem.amendmentId
RatePlanChargeTier.productRatePlanId = RevenueEventItem.productRatePlanId
RatePlanChargeTier.ratePlanChargeId = RevenueEventItem.ratePlanChargeId
RatePlanChargeTier.ratePlanId = RevenueEventItem.ratePlanId
RatePlanChargeTier.subscriptionId = RevenueEventItem.subscriptionId
RevenueEventItemInvoiceItem
RatePlanChargeTier.amendmentId = RevenueEventItemInvoiceItem.amendmentId
RatePlanChargeTier.productRatePlanId = RevenueEventItemInvoiceItem.productRatePlanId
RatePlanChargeTier.ratePlanChargeId = RevenueEventItemInvoiceItem.ratePlanChargeId
RatePlanChargeTier.ratePlanId = RevenueEventItemInvoiceItem.ratePlanId
RatePlanChargeTier.subscriptionId = RevenueEventItemInvoiceItem.subscriptionId
RevenueEventItemInvoiceItemAdjustment
RatePlanChargeTier.amendmentId = RevenueEventItemInvoiceItemAdjustment.amendmentId
RatePlanChargeTier.productRatePlanId = RevenueEventItemInvoiceItemAdjustment.productRatePlanId
RatePlanChargeTier.ratePlanChargeId = RevenueEventItemInvoiceItemAdjustment.ratePlanChargeId
RatePlanChargeTier.ratePlanId = RevenueEventItemInvoiceItemAdjustment.ratePlanId
RatePlanChargeTier.subscriptionId = RevenueEventItemInvoiceItemAdjustment.subscriptionId
RevenueScheduleItem
RatePlanChargeTier.amendmentId = RevenueScheduleItem.amendmentId
RatePlanChargeTier.productRatePlanId = RevenueScheduleItem.productRatePlanId
RatePlanChargeTier.ratePlanChargeId = RevenueScheduleItem.ratePlanChargeId
RatePlanChargeTier.ratePlanId = RevenueScheduleItem.ratePlanId
RevenueScheduleItemInvoiceItem
RatePlanChargeTier.amendmentId = RevenueScheduleItemInvoiceItem.amendmentId
RatePlanChargeTier.productRatePlanId = RevenueScheduleItemInvoiceItem.productRatePlanId
RatePlanChargeTier.ratePlanChargeId = RevenueScheduleItemInvoiceItem.ratePlanChargeId
RatePlanChargeTier.ratePlanId = RevenueScheduleItemInvoiceItem.ratePlanId
RevenueScheduleItemInvoiceItemAdjustment
RatePlanChargeTier.amendmentId = RevenueScheduleItemInvoiceItemAdjustment.amendmentId
RatePlanChargeTier.productRatePlanId = RevenueScheduleItemInvoiceItemAdjustment.productRatePlanId
RatePlanChargeTier.ratePlanChargeId = RevenueScheduleItemInvoiceItemAdjustment.ratePlanChargeId
RatePlanChargeTier.ratePlanId = RevenueScheduleItemInvoiceItemAdjustment.ratePlanId
RatePlanChargeTier.subscriptionId = RevenueScheduleItemInvoiceItemAdjustment.subscriptionId
ProductRatePlan
RatePlanChargeTier.productRatePlanId = ProductRatePlan.id
ProductRatePlanCharge
RatePlanChargeTier.productRatePlanId = ProductRatePlanCharge.productRatePlanId
ProductRatePlanChargeTier
RatePlanChargeTier.productRatePlanId = ProductRatePlanChargeTier.productRatePlanId
RatePlanChargeTier.ratePlanChargeId = ProductRatePlanChargeTier.ratePlanChargeId
RatePlanChargeTier.ratePlanId = ProductRatePlanChargeTier.ratePlanId
RatePlanCharge
RatePlanChargeTier.ratePlanChargeId = RatePlanCharge.id
InvoiceItem
RatePlanChargeTier.ratePlanChargeId = InvoiceItem.ratePlanChargeId
RatePlanChargeTier.subscriptionId = InvoiceItem.subscriptionId
Subscription
RatePlanChargeTier.subscriptionId = Subscription.id

amendmentId

STRING

createdById

STRING

createdDate

DATE-TIME

deleted

BOOLEAN

id

STRING

price

NUMBER

priceFormat

STRING

productRatePlanChargeId

STRING

productRatePlanId

STRING

ratePlanChargeId

STRING

ratePlanId

STRING

startingUnit

NUMBER

subscriptionId

STRING

tier

INTEGER

updatedById

STRING

updatedDate

DATE-TIME

Refund

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

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

Join Refund with on
Account
Refund.accountId = Account.id
Refund.billToContactId = Account.billToContactId
Refund.soldToContactId = Account.billToContactId
Refund.billToContactId = Account.soldToContactId
Refund.soldToContactId = Account.soldToContactId
Refund.parentAccountId = Account.parentAccountId
ContactSnapshot
Refund.accountId = ContactSnapshot.accountId
Refund.billToContactId = ContactSnapshot.contactId
Refund.soldToContactId = ContactSnapshot.contactId
Invoice
Refund.accountId = Invoice.accountId
Refund.billToContactId = Invoice.billToContactId
Refund.soldToContactId = Invoice.billToContactId
Refund.billToContactId = Invoice.soldToContactId
Refund.soldToContactId = Invoice.soldToContactId
Refund.parentAccountId = Invoice.parentAccountId
Refund.id = Invoice.id
Refund.number = Invoice.invoiceNumber
Payment
Refund.accountId = Payment.accountId
Refund.paymentMethodId = Payment.paymentMethodId
Refund.paymentMethodSnapshotId = Payment.paymentMethodSnapshotId
Refund.id = Payment.id
Refund.number = Payment.number
Subscription
Refund.accountId = Subscription.accountId
Contact
Refund.billToContactId = Contact.id
Refund.soldToContactId = Contact.id
CreditBalanceAdjustment
Refund.billToContactId = CreditBalanceAdjustment.billToContactId
Refund.soldToContactId = CreditBalanceAdjustment.billToContactId
Refund.billToContactId = CreditBalanceAdjustment.soldToContactId
Refund.soldToContactId = CreditBalanceAdjustment.soldToContactId
Refund.parentAccountId = CreditBalanceAdjustment.parentAccountId
Refund.paymentMethodId = CreditBalanceAdjustment.paymentMethodId
Refund.paymentMethodSnapshotId = CreditBalanceAdjustment.paymentMethodSnapshotId
Refund.id = CreditBalanceAdjustment.refundId
Refund.id = CreditBalanceAdjustment.sourceTransactionId
DiscountAppliedMetrics
Refund.billToContactId = DiscountAppliedMetrics.billToContactId
Refund.soldToContactId = DiscountAppliedMetrics.billToContactId
Refund.billToContactId = DiscountAppliedMetrics.soldToContactId
Refund.soldToContactId = DiscountAppliedMetrics.soldToContactId
Refund.parentAccountId = DiscountAppliedMetrics.parentAccountId
InvoiceItemAdjustment
Refund.billToContactId = InvoiceItemAdjustment.billToContactId
Refund.soldToContactId = InvoiceItemAdjustment.billToContactId
Refund.billToContactId = InvoiceItemAdjustment.soldToContactId
Refund.soldToContactId = InvoiceItemAdjustment.soldToContactId
Refund.parentAccountId = InvoiceItemAdjustment.parentAccountId
ProcessedUsage
Refund.billToContactId = ProcessedUsage.billToContactId
Refund.soldToContactId = ProcessedUsage.billToContactId
Refund.billToContactId = ProcessedUsage.soldToContactId
Refund.soldToContactId = ProcessedUsage.soldToContactId
Refund.parentAccountId = ProcessedUsage.parentAccountId
RatePlan
Refund.billToContactId = RatePlan.billToContactId
Refund.soldToContactId = RatePlan.billToContactId
RevenueChargeSummaryItem
Refund.billToContactId = RevenueChargeSummaryItem.billToContactId
Refund.soldToContactId = RevenueChargeSummaryItem.billToContactId
Refund.billToContactId = RevenueChargeSummaryItem.soldToContactId
Refund.soldToContactId = RevenueChargeSummaryItem.soldToContactId
Refund.parentAccountId = RevenueChargeSummaryItem.parentAccountId
RevenueEventItem
Refund.billToContactId = RevenueEventItem.billToContactId
Refund.soldToContactId = RevenueEventItem.billToContactId
Refund.billToContactId = RevenueEventItem.soldToContactId
Refund.soldToContactId = RevenueEventItem.soldToContactId
Refund.parentAccountId = RevenueEventItem.parentAccountId
RevenueEventItemInvoiceItem
Refund.billToContactId = RevenueEventItemInvoiceItem.billToContactId
Refund.soldToContactId = RevenueEventItemInvoiceItem.billToContactId
Refund.billToContactId = RevenueEventItemInvoiceItem.soldToContactId
Refund.soldToContactId = RevenueEventItemInvoiceItem.soldToContactId
Refund.parentAccountId = RevenueEventItemInvoiceItem.parentAccountId
RevenueEventItemInvoiceItemAdjustment
Refund.billToContactId = RevenueEventItemInvoiceItemAdjustment.billToContactId
Refund.soldToContactId = RevenueEventItemInvoiceItemAdjustment.billToContactId
Refund.billToContactId = RevenueEventItemInvoiceItemAdjustment.soldToContactId
Refund.soldToContactId = RevenueEventItemInvoiceItemAdjustment.soldToContactId
Refund.parentAccountId = RevenueEventItemInvoiceItemAdjustment.parentAccountId
RevenueScheduleItem
Refund.billToContactId = RevenueScheduleItem.billToContactId
Refund.soldToContactId = RevenueScheduleItem.billToContactId
Refund.billToContactId = RevenueScheduleItem.soldToContactId
Refund.soldToContactId = RevenueScheduleItem.soldToContactId
Refund.parentAccountId = RevenueScheduleItem.parentAccountId
RevenueScheduleItemInvoiceItem
Refund.billToContactId = RevenueScheduleItemInvoiceItem.billToContactId
Refund.soldToContactId = RevenueScheduleItemInvoiceItem.billToContactId
Refund.billToContactId = RevenueScheduleItemInvoiceItem.soldToContactId
Refund.soldToContactId = RevenueScheduleItemInvoiceItem.soldToContactId
Refund.parentAccountId = RevenueScheduleItemInvoiceItem.parentAccountId
RevenueScheduleItemInvoiceItemAdjustment
Refund.billToContactId = RevenueScheduleItemInvoiceItemAdjustment.billToContactId
Refund.soldToContactId = RevenueScheduleItemInvoiceItemAdjustment.billToContactId
Refund.billToContactId = RevenueScheduleItemInvoiceItemAdjustment.soldToContactId
Refund.soldToContactId = RevenueScheduleItemInvoiceItemAdjustment.soldToContactId
Refund.parentAccountId = RevenueScheduleItemInvoiceItemAdjustment.parentAccountId
PaymentMethod
Refund.paymentMethodId = PaymentMethod.id
PaymentMethodSnapshot
Refund.paymentMethodSnapshotId = PaymentMethodSnapshot.id

accountId

STRING

amount

NUMBER

billToContactId

STRING

cancelledOn

DATE-TIME

comment

STRING

createdById

STRING

createdDate

DATE-TIME

creditMemoId

STRING

defaultPaymentMethodId

STRING

deleted

BOOLEAN

gatewayId

STRING

gatewayResponse

STRING

gatewayResponseCode

STRING

gatewayState

STRING

id

STRING

markedForSubmissionOn

DATE-TIME

methodType

STRING

number

STRING

parentAccountId

STRING

paymentId

STRING

paymentMethodId

STRING

paymentMethodSnapshotId

STRING

reasonCode

STRING

referenceId

STRING

refundDate

DATE-TIME

refundTransactionTime

DATE-TIME

secondRefundReferenceId

STRING

settledOn

DATE-TIME

softDescriptor

STRING

softDescriptorPhone

STRING

soldToContactId

STRING

status

STRING

submittedOn

DATE-TIME

success

BOOLEAN

type

STRING

updatedById

STRING

updatedDate

DATE-TIME

RevenueChargeSummaryItem

The RevenueChargeSummaryItem table contains information about charge revenue summaries, which are summaries of all revenue distributions associated with a subscription charge.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

Join RevenueChargeSummaryItem with on
AccountingPeriod
RevenueChargeSummaryItem.accountingPeriodId = AccountingPeriod.id
CreditBalanceAdjustment
RevenueChargeSummaryItem.accountingPeriodId = CreditBalanceAdjustment.accountingPeriodId
RevenueChargeSummaryItem.billToContactId = CreditBalanceAdjustment.billToContactId
RevenueChargeSummaryItem.soldToContactId = CreditBalanceAdjustment.billToContactId
RevenueChargeSummaryItem.billToContactId = CreditBalanceAdjustment.soldToContactId
RevenueChargeSummaryItem.soldToContactId = CreditBalanceAdjustment.soldToContactId
RevenueChargeSummaryItem.parentAccountId = CreditBalanceAdjustment.parentAccountId
InvoiceItemAdjustment
RevenueChargeSummaryItem.accountingPeriodId = InvoiceItemAdjustment.accountingPeriodId
RevenueChargeSummaryItem.amendmentId = InvoiceItemAdjustment.amendmentId
RevenueChargeSummaryItem.billToContactId = InvoiceItemAdjustment.billToContactId
RevenueChargeSummaryItem.soldToContactId = InvoiceItemAdjustment.billToContactId
RevenueChargeSummaryItem.billToContactId = InvoiceItemAdjustment.soldToContactId
RevenueChargeSummaryItem.soldToContactId = InvoiceItemAdjustment.soldToContactId
RevenueChargeSummaryItem.parentAccountId = InvoiceItemAdjustment.parentAccountId
RevenueChargeSummaryItem.productId = InvoiceItemAdjustment.productId
RevenueChargeSummaryItem.productRatePlanChargeId = InvoiceItemAdjustment.productRatePlanChargeId
RevenueChargeSummaryItem.ratePlanChargeId = InvoiceItemAdjustment.ratePlanChargeId
RevenueChargeSummaryItem.ratePlanId = InvoiceItemAdjustment.ratePlanId
RevenueChargeSummaryItem.subscriptionId = InvoiceItemAdjustment.subscriptionId
JournalEntry
RevenueChargeSummaryItem.accountingPeriodId = JournalEntry.accountingPeriodId
RevenueEventItemInvoiceItem
RevenueChargeSummaryItem.accountingPeriodId = RevenueEventItemInvoiceItem.accountingPeriodId
RevenueChargeSummaryItem.amendmentId = RevenueEventItemInvoiceItem.amendmentId
RevenueChargeSummaryItem.billToContactId = RevenueEventItemInvoiceItem.billToContactId
RevenueChargeSummaryItem.soldToContactId = RevenueEventItemInvoiceItem.billToContactId
RevenueChargeSummaryItem.billToContactId = RevenueEventItemInvoiceItem.soldToContactId
RevenueChargeSummaryItem.soldToContactId = RevenueEventItemInvoiceItem.soldToContactId
RevenueChargeSummaryItem.parentAccountId = RevenueEventItemInvoiceItem.parentAccountId
RevenueChargeSummaryItem.productId = RevenueEventItemInvoiceItem.productId
RevenueChargeSummaryItem.productRatePlanChargeId = RevenueEventItemInvoiceItem.productRatePlanChargeId
RevenueChargeSummaryItem.productRatePlanId = RevenueEventItemInvoiceItem.productRatePlanId
RevenueChargeSummaryItem.ratePlanChargeId = RevenueEventItemInvoiceItem.ratePlanChargeId
RevenueChargeSummaryItem.ratePlanId = RevenueEventItemInvoiceItem.ratePlanId
RevenueChargeSummaryItem.revenueChargeSummaryId = RevenueEventItemInvoiceItem.revenueChargeSummaryId
RevenueChargeSummaryItem.subscriptionId = RevenueEventItemInvoiceItem.subscriptionId
RevenueEventItemInvoiceItemAdjustment
RevenueChargeSummaryItem.accountingPeriodId = RevenueEventItemInvoiceItemAdjustment.accountingPeriodId
RevenueChargeSummaryItem.amendmentId = RevenueEventItemInvoiceItemAdjustment.amendmentId
RevenueChargeSummaryItem.billToContactId = RevenueEventItemInvoiceItemAdjustment.billToContactId
RevenueChargeSummaryItem.soldToContactId = RevenueEventItemInvoiceItemAdjustment.billToContactId
RevenueChargeSummaryItem.billToContactId = RevenueEventItemInvoiceItemAdjustment.soldToContactId
RevenueChargeSummaryItem.soldToContactId = RevenueEventItemInvoiceItemAdjustment.soldToContactId
RevenueChargeSummaryItem.parentAccountId = RevenueEventItemInvoiceItemAdjustment.parentAccountId
RevenueChargeSummaryItem.productId = RevenueEventItemInvoiceItemAdjustment.productId
RevenueChargeSummaryItem.productRatePlanChargeId = RevenueEventItemInvoiceItemAdjustment.productRatePlanChargeId
RevenueChargeSummaryItem.productRatePlanId = RevenueEventItemInvoiceItemAdjustment.productRatePlanId
RevenueChargeSummaryItem.ratePlanChargeId = RevenueEventItemInvoiceItemAdjustment.ratePlanChargeId
RevenueChargeSummaryItem.ratePlanId = RevenueEventItemInvoiceItemAdjustment.ratePlanId
RevenueChargeSummaryItem.revenueChargeSummaryId = RevenueEventItemInvoiceItemAdjustment.revenueChargeSummaryId
RevenueChargeSummaryItem.subscriptionId = RevenueEventItemInvoiceItemAdjustment.subscriptionId
RevenueScheduleItem
RevenueChargeSummaryItem.accountingPeriodId = RevenueScheduleItem.accountingPeriodId
RevenueChargeSummaryItem.amendmentId = RevenueScheduleItem.amendmentId
RevenueChargeSummaryItem.billToContactId = RevenueScheduleItem.billToContactId
RevenueChargeSummaryItem.soldToContactId = RevenueScheduleItem.billToContactId
RevenueChargeSummaryItem.billToContactId = RevenueScheduleItem.soldToContactId
RevenueChargeSummaryItem.soldToContactId = RevenueScheduleItem.soldToContactId
RevenueChargeSummaryItem.parentAccountId = RevenueScheduleItem.parentAccountId
RevenueChargeSummaryItem.productId = RevenueScheduleItem.productId
RevenueChargeSummaryItem.productRatePlanChargeId = RevenueScheduleItem.productRatePlanChargeId
RevenueChargeSummaryItem.productRatePlanId = RevenueScheduleItem.productRatePlanId
RevenueChargeSummaryItem.ratePlanChargeId = RevenueScheduleItem.ratePlanChargeId
RevenueChargeSummaryItem.ratePlanId = RevenueScheduleItem.ratePlanId
RevenueChargeSummaryItem.revenueChargeSummaryId = RevenueScheduleItem.revenueChargeSummaryId
RevenueScheduleItemInvoiceItem
RevenueChargeSummaryItem.accountingPeriodId = RevenueScheduleItemInvoiceItem.accountingPeriodId
RevenueChargeSummaryItem.amendmentId = RevenueScheduleItemInvoiceItem.amendmentId
RevenueChargeSummaryItem.billToContactId = RevenueScheduleItemInvoiceItem.billToContactId
RevenueChargeSummaryItem.soldToContactId = RevenueScheduleItemInvoiceItem.billToContactId
RevenueChargeSummaryItem.billToContactId = RevenueScheduleItemInvoiceItem.soldToContactId
RevenueChargeSummaryItem.soldToContactId = RevenueScheduleItemInvoiceItem.soldToContactId
RevenueChargeSummaryItem.parentAccountId = RevenueScheduleItemInvoiceItem.parentAccountId
RevenueChargeSummaryItem.productId = RevenueScheduleItemInvoiceItem.productId
RevenueChargeSummaryItem.productRatePlanChargeId = RevenueScheduleItemInvoiceItem.productRatePlanChargeId
RevenueChargeSummaryItem.productRatePlanId = RevenueScheduleItemInvoiceItem.productRatePlanId
RevenueChargeSummaryItem.ratePlanChargeId = RevenueScheduleItemInvoiceItem.ratePlanChargeId
RevenueChargeSummaryItem.ratePlanId = RevenueScheduleItemInvoiceItem.ratePlanId
RevenueChargeSummaryItem.revenueChargeSummaryId = RevenueScheduleItemInvoiceItem.revenueChargeSummaryId
RevenueScheduleItemInvoiceItemAdjustment
RevenueChargeSummaryItem.accountingPeriodId = RevenueScheduleItemInvoiceItemAdjustment.accountingPeriodId
RevenueChargeSummaryItem.amendmentId = RevenueScheduleItemInvoiceItemAdjustment.amendmentId
RevenueChargeSummaryItem.billToContactId = RevenueScheduleItemInvoiceItemAdjustment.billToContactId
RevenueChargeSummaryItem.soldToContactId = RevenueScheduleItemInvoiceItemAdjustment.billToContactId
RevenueChargeSummaryItem.billToContactId = RevenueScheduleItemInvoiceItemAdjustment.soldToContactId
RevenueChargeSummaryItem.soldToContactId = RevenueScheduleItemInvoiceItemAdjustment.soldToContactId
RevenueChargeSummaryItem.parentAccountId = RevenueScheduleItemInvoiceItemAdjustment.parentAccountId
RevenueChargeSummaryItem.productId = RevenueScheduleItemInvoiceItemAdjustment.productId
RevenueChargeSummaryItem.productRatePlanChargeId = RevenueScheduleItemInvoiceItemAdjustment.productRatePlanChargeId
RevenueChargeSummaryItem.productRatePlanId = RevenueScheduleItemInvoiceItemAdjustment.productRatePlanId
RevenueChargeSummaryItem.ratePlanChargeId = RevenueScheduleItemInvoiceItemAdjustment.ratePlanChargeId
RevenueChargeSummaryItem.ratePlanId = RevenueScheduleItemInvoiceItemAdjustment.ratePlanId
RevenueChargeSummaryItem.revenueChargeSummaryId = RevenueScheduleItemInvoiceItemAdjustment.revenueChargeSummaryId
RevenueChargeSummaryItem.subscriptionId = RevenueScheduleItemInvoiceItemAdjustment.subscriptionId
Amendment
RevenueChargeSummaryItem.amendmentId = Amendment.id
RevenueChargeSummaryItem.subscriptionId = Amendment.subscriptionId
DiscountAppliedMetrics
RevenueChargeSummaryItem.amendmentId = DiscountAppliedMetrics.amendmentId
RevenueChargeSummaryItem.billToContactId = DiscountAppliedMetrics.billToContactId
RevenueChargeSummaryItem.soldToContactId = DiscountAppliedMetrics.billToContactId
RevenueChargeSummaryItem.billToContactId = DiscountAppliedMetrics.soldToContactId
RevenueChargeSummaryItem.soldToContactId = DiscountAppliedMetrics.soldToContactId
RevenueChargeSummaryItem.parentAccountId = DiscountAppliedMetrics.parentAccountId
RevenueChargeSummaryItem.productId = DiscountAppliedMetrics.productId
RevenueChargeSummaryItem.productRatePlanChargeId = DiscountAppliedMetrics.productRatePlanChargeId
RevenueChargeSummaryItem.productRatePlanId = DiscountAppliedMetrics.productRatePlanId
RevenueChargeSummaryItem.ratePlanChargeId = DiscountAppliedMetrics.ratePlanChargeId
RevenueChargeSummaryItem.ratePlanId = DiscountAppliedMetrics.ratePlanId
RevenueChargeSummaryItem.subscriptionId = DiscountAppliedMetrics.subscriptionId
ProcessedUsage
RevenueChargeSummaryItem.amendmentId = ProcessedUsage.amendmentId
RevenueChargeSummaryItem.billToContactId = ProcessedUsage.billToContactId
RevenueChargeSummaryItem.soldToContactId = ProcessedUsage.billToContactId
RevenueChargeSummaryItem.billToContactId = ProcessedUsage.soldToContactId
RevenueChargeSummaryItem.soldToContactId = ProcessedUsage.soldToContactId
RevenueChargeSummaryItem.parentAccountId = ProcessedUsage.parentAccountId
RevenueChargeSummaryItem.productId = ProcessedUsage.productId
RevenueChargeSummaryItem.productRatePlanChargeId = ProcessedUsage.productRatePlanChargeId
RevenueChargeSummaryItem.productRatePlanId = ProcessedUsage.productRatePlanId
RevenueChargeSummaryItem.ratePlanChargeId = ProcessedUsage.ratePlanChargeId
RevenueChargeSummaryItem.ratePlanId = ProcessedUsage.ratePlanId
RatePlan
RevenueChargeSummaryItem.amendmentId = RatePlan.amendmentId
RevenueChargeSummaryItem.billToContactId = RatePlan.billToContactId
RevenueChargeSummaryItem.soldToContactId = RatePlan.billToContactId
RevenueChargeSummaryItem.productRatePlanId = RatePlan.productRatePlanId
RevenueChargeSummaryItem.ratePlanId = RatePlan.id
RevenueChargeSummaryItem.subscriptionId = RatePlan.subscriptionId
RatePlanChargeTier
RevenueChargeSummaryItem.amendmentId = RatePlanChargeTier.amendmentId
RevenueChargeSummaryItem.productRatePlanId = RatePlanChargeTier.productRatePlanId
RevenueChargeSummaryItem.ratePlanChargeId = RatePlanChargeTier.ratePlanChargeId
RevenueChargeSummaryItem.ratePlanId = RatePlanChargeTier.ratePlanId
RevenueChargeSummaryItem.subscriptionId = RatePlanChargeTier.subscriptionId
RevenueEventItem
RevenueChargeSummaryItem.amendmentId = RevenueEventItem.amendmentId
RevenueChargeSummaryItem.billToContactId = RevenueEventItem.billToContactId
RevenueChargeSummaryItem.soldToContactId = RevenueEventItem.billToContactId
RevenueChargeSummaryItem.billToContactId = RevenueEventItem.soldToContactId
RevenueChargeSummaryItem.soldToContactId = RevenueEventItem.soldToContactId
RevenueChargeSummaryItem.parentAccountId = RevenueEventItem.parentAccountId
RevenueChargeSummaryItem.productId = RevenueEventItem.productId
RevenueChargeSummaryItem.productRatePlanChargeId = RevenueEventItem.productRatePlanChargeId
RevenueChargeSummaryItem.productRatePlanId = RevenueEventItem.productRatePlanId
RevenueChargeSummaryItem.ratePlanChargeId = RevenueEventItem.ratePlanChargeId
RevenueChargeSummaryItem.ratePlanId = RevenueEventItem.ratePlanId
RevenueChargeSummaryItem.revenueChargeSummaryId = RevenueEventItem.revenueChargeSummaryId
RevenueChargeSummaryItem.subscriptionId = RevenueEventItem.subscriptionId
Account
RevenueChargeSummaryItem.billToContactId = Account.billToContactId
RevenueChargeSummaryItem.soldToContactId = Account.billToContactId
RevenueChargeSummaryItem.billToContactId = Account.soldToContactId
RevenueChargeSummaryItem.soldToContactId = Account.soldToContactId
RevenueChargeSummaryItem.parentAccountId = Account.parentAccountId
Contact
RevenueChargeSummaryItem.billToContactId = Contact.id
RevenueChargeSummaryItem.soldToContactId = Contact.id
ContactSnapshot
RevenueChargeSummaryItem.billToContactId = ContactSnapshot.contactId
RevenueChargeSummaryItem.soldToContactId = ContactSnapshot.contactId
Invoice
RevenueChargeSummaryItem.billToContactId = Invoice.billToContactId
RevenueChargeSummaryItem.soldToContactId = Invoice.billToContactId
RevenueChargeSummaryItem.billToContactId = Invoice.soldToContactId
RevenueChargeSummaryItem.soldToContactId = Invoice.soldToContactId
RevenueChargeSummaryItem.parentAccountId = Invoice.parentAccountId
Refund
RevenueChargeSummaryItem.billToContactId = Refund.billToContactId
RevenueChargeSummaryItem.soldToContactId = Refund.billToContactId
RevenueChargeSummaryItem.billToContactId = Refund.soldToContactId
RevenueChargeSummaryItem.soldToContactId = Refund.soldToContactId
RevenueChargeSummaryItem.parentAccountId = Refund.parentAccountId
Product
RevenueChargeSummaryItem.productId = Product.id
InvoiceItem
RevenueChargeSummaryItem.productId = InvoiceItem.productId
RevenueChargeSummaryItem.productRatePlanChargeId = InvoiceItem.productRatePlanChargeId
RevenueChargeSummaryItem.ratePlanChargeId = InvoiceItem.ratePlanChargeId
RevenueChargeSummaryItem.subscriptionId = InvoiceItem.subscriptionId
ProductRatePlan
RevenueChargeSummaryItem.productId = ProductRatePlan.productId
RevenueChargeSummaryItem.productRatePlanId = ProductRatePlan.id
ProductRatePlanCharge
RevenueChargeSummaryItem.productRatePlanChargeId = ProductRatePlanCharge.id
RevenueChargeSummaryItem.productRatePlanId = ProductRatePlanCharge.productRatePlanId
ProductRatePlanChargeTier
RevenueChargeSummaryItem.productRatePlanChargeId = ProductRatePlanChargeTier.productRatePlanChargeId
RevenueChargeSummaryItem.productRatePlanId = ProductRatePlanChargeTier.productRatePlanId
RevenueChargeSummaryItem.ratePlanChargeId = ProductRatePlanChargeTier.ratePlanChargeId
RevenueChargeSummaryItem.ratePlanId = ProductRatePlanChargeTier.ratePlanId
RatePlanCharge
RevenueChargeSummaryItem.ratePlanChargeId = RatePlanCharge.id
Subscription
RevenueChargeSummaryItem.subscriptionId = Subscription.id

accountId

STRING

accountingPeriodId

STRING

amendmentId

STRING

amount

DOUBLE

billToContactId

STRING

createdById

STRING

createdDate

DATE-TIME

currency

STRING

defaultPaymentMethodId

STRING

deleted

BOOLEAN

id

STRING

parentAccountId

STRING

productId

STRING

productRatePlanChargeId

STRING

productRatePlanId

STRING

ratePlanChargeId

STRING

ratePlanId

STRING

revenueChargeSummaryId

STRING

soldToContactId

STRING

subscriptionId

STRING

updatedById

STRING

updatedDate

DATE-TIME

RevenueEventItem

The RevenueEventItem table contains information about revenue events. A revenue event is a change to a revenue schedule, such as creating the initial schedule, canceling an invoice, or recognizing an undistributed amount.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

Join RevenueEventItem with on
Amendment
RevenueEventItem.amendmentId = Amendment.id
RevenueEventItem.subscriptionId = Amendment.subscriptionId
DiscountAppliedMetrics
RevenueEventItem.amendmentId = DiscountAppliedMetrics.amendmentId
RevenueEventItem.billToContactId = DiscountAppliedMetrics.billToContactId
RevenueEventItem.soldToContactId = DiscountAppliedMetrics.billToContactId
RevenueEventItem.billToContactId = DiscountAppliedMetrics.soldToContactId
RevenueEventItem.soldToContactId = DiscountAppliedMetrics.soldToContactId
RevenueEventItem.parentAccountId = DiscountAppliedMetrics.parentAccountId
RevenueEventItem.productId = DiscountAppliedMetrics.productId
RevenueEventItem.productRatePlanChargeId = DiscountAppliedMetrics.productRatePlanChargeId
RevenueEventItem.productRatePlanId = DiscountAppliedMetrics.productRatePlanId
RevenueEventItem.ratePlanChargeId = DiscountAppliedMetrics.ratePlanChargeId
RevenueEventItem.ratePlanId = DiscountAppliedMetrics.ratePlanId
RevenueEventItem.subscriptionId = DiscountAppliedMetrics.subscriptionId
InvoiceItemAdjustment
RevenueEventItem.amendmentId = InvoiceItemAdjustment.amendmentId
RevenueEventItem.billToContactId = InvoiceItemAdjustment.billToContactId
RevenueEventItem.soldToContactId = InvoiceItemAdjustment.billToContactId
RevenueEventItem.billToContactId = InvoiceItemAdjustment.soldToContactId
RevenueEventItem.soldToContactId = InvoiceItemAdjustment.soldToContactId
RevenueEventItem.journalEntryId = InvoiceItemAdjustment.journalEntryId
RevenueEventItem.journalRunId = InvoiceItemAdjustment.journalRunId
RevenueEventItem.parentAccountId = InvoiceItemAdjustment.parentAccountId
RevenueEventItem.productId = InvoiceItemAdjustment.productId
RevenueEventItem.productRatePlanChargeId = InvoiceItemAdjustment.productRatePlanChargeId
RevenueEventItem.ratePlanChargeId = InvoiceItemAdjustment.ratePlanChargeId
RevenueEventItem.ratePlanId = InvoiceItemAdjustment.ratePlanId
RevenueEventItem.recognizedRevenueAccountingCodeId = InvoiceItemAdjustment.recognizedRevenueAccountingCodeId
RevenueEventItem.subscriptionId = InvoiceItemAdjustment.subscriptionId
ProcessedUsage
RevenueEventItem.amendmentId = ProcessedUsage.amendmentId
RevenueEventItem.billToContactId = ProcessedUsage.billToContactId
RevenueEventItem.soldToContactId = ProcessedUsage.billToContactId
RevenueEventItem.billToContactId = ProcessedUsage.soldToContactId
RevenueEventItem.soldToContactId = ProcessedUsage.soldToContactId
RevenueEventItem.parentAccountId = ProcessedUsage.parentAccountId
RevenueEventItem.productId = ProcessedUsage.productId
RevenueEventItem.productRatePlanChargeId = ProcessedUsage.productRatePlanChargeId
RevenueEventItem.productRatePlanId = ProcessedUsage.productRatePlanId
RevenueEventItem.ratePlanChargeId = ProcessedUsage.ratePlanChargeId
RevenueEventItem.ratePlanId = ProcessedUsage.ratePlanId
RatePlan
RevenueEventItem.amendmentId = RatePlan.amendmentId
RevenueEventItem.billToContactId = RatePlan.billToContactId
RevenueEventItem.soldToContactId = RatePlan.billToContactId
RevenueEventItem.productRatePlanId = RatePlan.productRatePlanId
RevenueEventItem.ratePlanId = RatePlan.id
RevenueEventItem.subscriptionId = RatePlan.subscriptionId
RatePlanChargeTier
RevenueEventItem.amendmentId = RatePlanChargeTier.amendmentId
RevenueEventItem.productRatePlanId = RatePlanChargeTier.productRatePlanId
RevenueEventItem.ratePlanChargeId = RatePlanChargeTier.ratePlanChargeId
RevenueEventItem.ratePlanId = RatePlanChargeTier.ratePlanId
RevenueEventItem.subscriptionId = RatePlanChargeTier.subscriptionId
RevenueChargeSummaryItem
RevenueEventItem.amendmentId = RevenueChargeSummaryItem.amendmentId
RevenueEventItem.billToContactId = RevenueChargeSummaryItem.billToContactId
RevenueEventItem.soldToContactId = RevenueChargeSummaryItem.billToContactId
RevenueEventItem.billToContactId = RevenueChargeSummaryItem.soldToContactId
RevenueEventItem.soldToContactId = RevenueChargeSummaryItem.soldToContactId
RevenueEventItem.parentAccountId = RevenueChargeSummaryItem.parentAccountId
RevenueEventItem.productId = RevenueChargeSummaryItem.productId
RevenueEventItem.productRatePlanChargeId = RevenueChargeSummaryItem.productRatePlanChargeId
RevenueEventItem.productRatePlanId = RevenueChargeSummaryItem.productRatePlanId
RevenueEventItem.ratePlanChargeId = RevenueChargeSummaryItem.ratePlanChargeId
RevenueEventItem.ratePlanId = RevenueChargeSummaryItem.ratePlanId
RevenueEventItem.revenueChargeSummaryId = RevenueChargeSummaryItem.revenueChargeSummaryId
RevenueEventItem.subscriptionId = RevenueChargeSummaryItem.subscriptionId
RevenueEventItemInvoiceItem
RevenueEventItem.amendmentId = RevenueEventItemInvoiceItem.amendmentId
RevenueEventItem.billToContactId = RevenueEventItemInvoiceItem.billToContactId
RevenueEventItem.soldToContactId = RevenueEventItemInvoiceItem.billToContactId
RevenueEventItem.billToContactId = RevenueEventItemInvoiceItem.soldToContactId
RevenueEventItem.soldToContactId = RevenueEventItemInvoiceItem.soldToContactId
RevenueEventItem.deferredRevenueAccountingCodeId = RevenueEventItemInvoiceItem.deferredRevenueAccountingCodeId
RevenueEventItem.journalEntryId = RevenueEventItemInvoiceItem.journalEntryId
RevenueEventItem.journalRunId = RevenueEventItemInvoiceItem.journalRunId
RevenueEventItem.parentAccountId = RevenueEventItemInvoiceItem.parentAccountId
RevenueEventItem.productId = RevenueEventItemInvoiceItem.productId
RevenueEventItem.productRatePlanChargeId = RevenueEventItemInvoiceItem.productRatePlanChargeId
RevenueEventItem.productRatePlanId = RevenueEventItemInvoiceItem.productRatePlanId
RevenueEventItem.ratePlanChargeId = RevenueEventItemInvoiceItem.ratePlanChargeId
RevenueEventItem.ratePlanId = RevenueEventItemInvoiceItem.ratePlanId
RevenueEventItem.recognizedRevenueAccountingCodeId = RevenueEventItemInvoiceItem.recognizedRevenueAccountingCodeId
RevenueEventItem.revenueChargeSummaryId = RevenueEventItemInvoiceItem.revenueChargeSummaryId
RevenueEventItem.subscriptionId = RevenueEventItemInvoiceItem.subscriptionId
RevenueEventItemInvoiceItemAdjustment
RevenueEventItem.amendmentId = RevenueEventItemInvoiceItemAdjustment.amendmentId
RevenueEventItem.billToContactId = RevenueEventItemInvoiceItemAdjustment.billToContactId
RevenueEventItem.soldToContactId = RevenueEventItemInvoiceItemAdjustment.billToContactId
RevenueEventItem.billToContactId = RevenueEventItemInvoiceItemAdjustment.soldToContactId
RevenueEventItem.soldToContactId = RevenueEventItemInvoiceItemAdjustment.soldToContactId
RevenueEventItem.deferredRevenueAccountingCodeId = RevenueEventItemInvoiceItemAdjustment.deferredRevenueAccountingCodeId
RevenueEventItem.journalEntryId = RevenueEventItemInvoiceItemAdjustment.journalEntryId
RevenueEventItem.journalRunId = RevenueEventItemInvoiceItemAdjustment.journalRunId
RevenueEventItem.parentAccountId = RevenueEventItemInvoiceItemAdjustment.parentAccountId
RevenueEventItem.productId = RevenueEventItemInvoiceItemAdjustment.productId
RevenueEventItem.productRatePlanChargeId = RevenueEventItemInvoiceItemAdjustment.productRatePlanChargeId
RevenueEventItem.productRatePlanId = RevenueEventItemInvoiceItemAdjustment.productRatePlanId
RevenueEventItem.ratePlanChargeId = RevenueEventItemInvoiceItemAdjustment.ratePlanChargeId
RevenueEventItem.ratePlanId = RevenueEventItemInvoiceItemAdjustment.ratePlanId
RevenueEventItem.recognizedRevenueAccountingCodeId = RevenueEventItemInvoiceItemAdjustment.recognizedRevenueAccountingCodeId
RevenueEventItem.revenueChargeSummaryId = RevenueEventItemInvoiceItemAdjustment.revenueChargeSummaryId
RevenueEventItem.subscriptionId = RevenueEventItemInvoiceItemAdjustment.subscriptionId
RevenueScheduleItem
RevenueEventItem.amendmentId = RevenueScheduleItem.amendmentId
RevenueEventItem.billToContactId = RevenueScheduleItem.billToContactId
RevenueEventItem.soldToContactId = RevenueScheduleItem.billToContactId
RevenueEventItem.billToContactId = RevenueScheduleItem.soldToContactId
RevenueEventItem.soldToContactId = RevenueScheduleItem.soldToContactId
RevenueEventItem.deferredRevenueAccountingCodeId = RevenueScheduleItem.deferredRevenueAccountingCodeId
RevenueEventItem.parentAccountId = RevenueScheduleItem.parentAccountId
RevenueEventItem.productId = RevenueScheduleItem.productId
RevenueEventItem.productRatePlanChargeId = RevenueScheduleItem.productRatePlanChargeId
RevenueEventItem.productRatePlanId = RevenueScheduleItem.productRatePlanId
RevenueEventItem.ratePlanChargeId = RevenueScheduleItem.ratePlanChargeId
RevenueEventItem.ratePlanId = RevenueScheduleItem.ratePlanId
RevenueEventItem.recognizedRevenueAccountingCodeId = RevenueScheduleItem.recognizedRevenueAccountingCodeId
RevenueEventItem.revenueChargeSummaryId = RevenueScheduleItem.revenueChargeSummaryId
RevenueScheduleItemInvoiceItem
RevenueEventItem.amendmentId = RevenueScheduleItemInvoiceItem.amendmentId
RevenueEventItem.billToContactId = RevenueScheduleItemInvoiceItem.billToContactId
RevenueEventItem.soldToContactId = RevenueScheduleItemInvoiceItem.billToContactId
RevenueEventItem.billToContactId = RevenueScheduleItemInvoiceItem.soldToContactId
RevenueEventItem.soldToContactId = RevenueScheduleItemInvoiceItem.soldToContactId
RevenueEventItem.deferredRevenueAccountingCodeId = RevenueScheduleItemInvoiceItem.deferredRevenueAccountingCodeId
RevenueEventItem.parentAccountId = RevenueScheduleItemInvoiceItem.parentAccountId
RevenueEventItem.productId = RevenueScheduleItemInvoiceItem.productId
RevenueEventItem.productRatePlanChargeId = RevenueScheduleItemInvoiceItem.productRatePlanChargeId
RevenueEventItem.productRatePlanId = RevenueScheduleItemInvoiceItem.productRatePlanId
RevenueEventItem.ratePlanChargeId = RevenueScheduleItemInvoiceItem.ratePlanChargeId
RevenueEventItem.ratePlanId = RevenueScheduleItemInvoiceItem.ratePlanId
RevenueEventItem.recognizedRevenueAccountingCodeId = RevenueScheduleItemInvoiceItem.recognizedRevenueAccountingCodeId
RevenueEventItem.revenueChargeSummaryId = RevenueScheduleItemInvoiceItem.revenueChargeSummaryId
RevenueScheduleItemInvoiceItemAdjustment
RevenueEventItem.amendmentId = RevenueScheduleItemInvoiceItemAdjustment.amendmentId
RevenueEventItem.billToContactId = RevenueScheduleItemInvoiceItemAdjustment.billToContactId
RevenueEventItem.soldToContactId = RevenueScheduleItemInvoiceItemAdjustment.billToContactId
RevenueEventItem.billToContactId = RevenueScheduleItemInvoiceItemAdjustment.soldToContactId
RevenueEventItem.soldToContactId = RevenueScheduleItemInvoiceItemAdjustment.soldToContactId
RevenueEventItem.deferredRevenueAccountingCodeId = RevenueScheduleItemInvoiceItemAdjustment.deferredRevenueAccountingCodeId
RevenueEventItem.parentAccountId = RevenueScheduleItemInvoiceItemAdjustment.parentAccountId
RevenueEventItem.productId = RevenueScheduleItemInvoiceItemAdjustment.productId
RevenueEventItem.productRatePlanChargeId = RevenueScheduleItemInvoiceItemAdjustment.productRatePlanChargeId
RevenueEventItem.productRatePlanId = RevenueScheduleItemInvoiceItemAdjustment.productRatePlanId
RevenueEventItem.ratePlanChargeId = RevenueScheduleItemInvoiceItemAdjustment.ratePlanChargeId
RevenueEventItem.ratePlanId = RevenueScheduleItemInvoiceItemAdjustment.ratePlanId
RevenueEventItem.recognizedRevenueAccountingCodeId = RevenueScheduleItemInvoiceItemAdjustment.recognizedRevenueAccountingCodeId
RevenueEventItem.revenueChargeSummaryId = RevenueScheduleItemInvoiceItemAdjustment.revenueChargeSummaryId
RevenueEventItem.subscriptionId = RevenueScheduleItemInvoiceItemAdjustment.subscriptionId
Account
RevenueEventItem.billToContactId = Account.billToContactId
RevenueEventItem.soldToContactId = Account.billToContactId
RevenueEventItem.billToContactId = Account.soldToContactId
RevenueEventItem.soldToContactId = Account.soldToContactId
RevenueEventItem.deferredRevenueAccountingCodeId = Account.id
RevenueEventItem.parentAccountId = Account.parentAccountId
Contact
RevenueEventItem.billToContactId = Contact.id
RevenueEventItem.soldToContactId = Contact.id
ContactSnapshot
RevenueEventItem.billToContactId = ContactSnapshot.contactId
RevenueEventItem.soldToContactId = ContactSnapshot.contactId
CreditBalanceAdjustment
RevenueEventItem.billToContactId = CreditBalanceAdjustment.billToContactId
RevenueEventItem.soldToContactId = CreditBalanceAdjustment.billToContactId
RevenueEventItem.billToContactId = CreditBalanceAdjustment.soldToContactId
RevenueEventItem.soldToContactId = CreditBalanceAdjustment.soldToContactId
RevenueEventItem.journalEntryId = CreditBalanceAdjustment.journalEntryId
RevenueEventItem.journalRunId = CreditBalanceAdjustment.journalRunId
RevenueEventItem.parentAccountId = CreditBalanceAdjustment.parentAccountId
Invoice
RevenueEventItem.billToContactId = Invoice.billToContactId
RevenueEventItem.soldToContactId = Invoice.billToContactId
RevenueEventItem.billToContactId = Invoice.soldToContactId
RevenueEventItem.soldToContactId = Invoice.soldToContactId
RevenueEventItem.parentAccountId = Invoice.parentAccountId
Refund
RevenueEventItem.billToContactId = Refund.billToContactId
RevenueEventItem.soldToContactId = Refund.billToContactId
RevenueEventItem.billToContactId = Refund.soldToContactId
RevenueEventItem.soldToContactId = Refund.soldToContactId
RevenueEventItem.parentAccountId = Refund.parentAccountId
JournalEntry
RevenueEventItem.journalEntryId = JournalEntry.id
JournalEntryItem
RevenueEventItem.journalEntryId = JournalEntryItem.journalEntryId
RevenueEventItem.journalRunId = JournalEntryItem.journalRunId
JournalRun
RevenueEventItem.journalRunId = JournalRun.id
Product
RevenueEventItem.productId = Product.id
InvoiceItem
RevenueEventItem.productId = InvoiceItem.productId
RevenueEventItem.productRatePlanChargeId = InvoiceItem.productRatePlanChargeId
RevenueEventItem.ratePlanChargeId = InvoiceItem.ratePlanChargeId
RevenueEventItem.subscriptionId = InvoiceItem.subscriptionId
ProductRatePlan
RevenueEventItem.productId = ProductRatePlan.productId
RevenueEventItem.productRatePlanId = ProductRatePlan.id
ProductRatePlanCharge
RevenueEventItem.productRatePlanChargeId = ProductRatePlanCharge.id
RevenueEventItem.productRatePlanId = ProductRatePlanCharge.productRatePlanId
ProductRatePlanChargeTier
RevenueEventItem.productRatePlanChargeId = ProductRatePlanChargeTier.productRatePlanChargeId
RevenueEventItem.productRatePlanId = ProductRatePlanChargeTier.productRatePlanId
RevenueEventItem.ratePlanChargeId = ProductRatePlanChargeTier.ratePlanChargeId
RevenueEventItem.ratePlanId = ProductRatePlanChargeTier.ratePlanId
RatePlanCharge
RevenueEventItem.ratePlanChargeId = RatePlanCharge.id
AccountingCode
RevenueEventItem.recognizedRevenueAccountingCodeId = AccountingCode.id
Subscription
RevenueEventItem.subscriptionId = Subscription.id

accountId

STRING

amendmentId

STRING

amount

DOUBLE

billToContactId

STRING

createdById

STRING

createdDate

DATE-TIME

defaultPaymentMethodId

STRING

deferredRevenueAccountingCodeId

STRING

deleted

BOOLEAN

id

STRING

journalEntryId

STRING

journalRunId

STRING

parentAccountId

STRING

productId

STRING

productRatePlanChargeId

STRING

productRatePlanId

STRING

ratePlanChargeId

STRING

ratePlanId

STRING

recognizedRevenueAccountingCodeId

STRING

revenueChargeSummaryId

STRING

revenueEventId

STRING

revenueEventTypeId

STRING

revenueScheduleId

STRING

soldToContactId

STRING

subscriptionId

STRING

updatedById

STRING

updatedDate

DATE-TIME

RevenueEventItemInvoiceItem

The RevenueEventItemInvoiceItem table contains information about revenue event items that are associated with invoice items.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

Join RevenueEventItemInvoiceItem with on
AccountingPeriod
RevenueEventItemInvoiceItem.accountingPeriodId = AccountingPeriod.id
CreditBalanceAdjustment
RevenueEventItemInvoiceItem.accountingPeriodId = CreditBalanceAdjustment.accountingPeriodId
RevenueEventItemInvoiceItem.billToContactId = CreditBalanceAdjustment.billToContactId
RevenueEventItemInvoiceItem.soldToContactId = CreditBalanceAdjustment.billToContactId
RevenueEventItemInvoiceItem.billToContactId = CreditBalanceAdjustment.soldToContactId
RevenueEventItemInvoiceItem.soldToContactId = CreditBalanceAdjustment.soldToContactId
RevenueEventItemInvoiceItem.journalEntryId = CreditBalanceAdjustment.journalEntryId
RevenueEventItemInvoiceItem.journalRunId = CreditBalanceAdjustment.journalRunId
RevenueEventItemInvoiceItem.parentAccountId = CreditBalanceAdjustment.parentAccountId
InvoiceItemAdjustment
RevenueEventItemInvoiceItem.accountingPeriodId = InvoiceItemAdjustment.accountingPeriodId
RevenueEventItemInvoiceItem.amendmentId = InvoiceItemAdjustment.amendmentId
RevenueEventItemInvoiceItem.billToContactId = InvoiceItemAdjustment.billToContactId
RevenueEventItemInvoiceItem.soldToContactId = InvoiceItemAdjustment.billToContactId
RevenueEventItemInvoiceItem.billToContactId = InvoiceItemAdjustment.soldToContactId
RevenueEventItemInvoiceItem.soldToContactId = InvoiceItemAdjustment.soldToContactId
RevenueEventItemInvoiceItem.journalEntryId = InvoiceItemAdjustment.journalEntryId
RevenueEventItemInvoiceItem.journalRunId = InvoiceItemAdjustment.journalRunId
RevenueEventItemInvoiceItem.parentAccountId = InvoiceItemAdjustment.parentAccountId
RevenueEventItemInvoiceItem.productId = InvoiceItemAdjustment.productId
RevenueEventItemInvoiceItem.productRatePlanChargeId = InvoiceItemAdjustment.productRatePlanChargeId
RevenueEventItemInvoiceItem.ratePlanChargeId = InvoiceItemAdjustment.ratePlanChargeId
RevenueEventItemInvoiceItem.ratePlanId = InvoiceItemAdjustment.ratePlanId
RevenueEventItemInvoiceItem.recognizedRevenueAccountingCodeId = InvoiceItemAdjustment.recognizedRevenueAccountingCodeId
RevenueEventItemInvoiceItem.subscriptionId = InvoiceItemAdjustment.subscriptionId
JournalEntry
RevenueEventItemInvoiceItem.accountingPeriodId = JournalEntry.accountingPeriodId
RevenueEventItemInvoiceItem.journalEntryId = JournalEntry.id
RevenueChargeSummaryItem
RevenueEventItemInvoiceItem.accountingPeriodId = RevenueChargeSummaryItem.accountingPeriodId
RevenueEventItemInvoiceItem.amendmentId = RevenueChargeSummaryItem.amendmentId
RevenueEventItemInvoiceItem.billToContactId = RevenueChargeSummaryItem.billToContactId
RevenueEventItemInvoiceItem.soldToContactId = RevenueChargeSummaryItem.billToContactId
RevenueEventItemInvoiceItem.billToContactId = RevenueChargeSummaryItem.soldToContactId
RevenueEventItemInvoiceItem.soldToContactId = RevenueChargeSummaryItem.soldToContactId
RevenueEventItemInvoiceItem.parentAccountId = RevenueChargeSummaryItem.parentAccountId
RevenueEventItemInvoiceItem.productId = RevenueChargeSummaryItem.productId
RevenueEventItemInvoiceItem.productRatePlanChargeId = RevenueChargeSummaryItem.productRatePlanChargeId
RevenueEventItemInvoiceItem.productRatePlanId = RevenueChargeSummaryItem.productRatePlanId
RevenueEventItemInvoiceItem.ratePlanChargeId = RevenueChargeSummaryItem.ratePlanChargeId
RevenueEventItemInvoiceItem.ratePlanId = RevenueChargeSummaryItem.ratePlanId
RevenueEventItemInvoiceItem.revenueChargeSummaryId = RevenueChargeSummaryItem.revenueChargeSummaryId
RevenueEventItemInvoiceItem.subscriptionId = RevenueChargeSummaryItem.subscriptionId
RevenueEventItemInvoiceItemAdjustment
RevenueEventItemInvoiceItem.accountingPeriodId = RevenueEventItemInvoiceItemAdjustment.accountingPeriodId
RevenueEventItemInvoiceItem.amendmentId = RevenueEventItemInvoiceItemAdjustment.amendmentId
RevenueEventItemInvoiceItem.billToContactId = RevenueEventItemInvoiceItemAdjustment.billToContactId
RevenueEventItemInvoiceItem.soldToContactId = RevenueEventItemInvoiceItemAdjustment.billToContactId
RevenueEventItemInvoiceItem.billToContactId = RevenueEventItemInvoiceItemAdjustment.soldToContactId
RevenueEventItemInvoiceItem.soldToContactId = RevenueEventItemInvoiceItemAdjustment.soldToContactId
RevenueEventItemInvoiceItem.deferredRevenueAccountingCodeId = RevenueEventItemInvoiceItemAdjustment.deferredRevenueAccountingCodeId
RevenueEventItemInvoiceItem.invoiceItemId = RevenueEventItemInvoiceItemAdjustment.invoiceItemId
RevenueEventItemInvoiceItem.journalEntryId = RevenueEventItemInvoiceItemAdjustment.journalEntryId
RevenueEventItemInvoiceItem.journalRunId = RevenueEventItemInvoiceItemAdjustment.journalRunId
RevenueEventItemInvoiceItem.parentAccountId = RevenueEventItemInvoiceItemAdjustment.parentAccountId
RevenueEventItemInvoiceItem.productId = RevenueEventItemInvoiceItemAdjustment.productId
RevenueEventItemInvoiceItem.productRatePlanChargeId = RevenueEventItemInvoiceItemAdjustment.productRatePlanChargeId
RevenueEventItemInvoiceItem.productRatePlanId = RevenueEventItemInvoiceItemAdjustment.productRatePlanId
RevenueEventItemInvoiceItem.ratePlanChargeId = RevenueEventItemInvoiceItemAdjustment.ratePlanChargeId
RevenueEventItemInvoiceItem.ratePlanId = RevenueEventItemInvoiceItemAdjustment.ratePlanId
RevenueEventItemInvoiceItem.recognizedRevenueAccountingCodeId = RevenueEventItemInvoiceItemAdjustment.recognizedRevenueAccountingCodeId
RevenueEventItemInvoiceItem.revenueChargeSummaryId = RevenueEventItemInvoiceItemAdjustment.revenueChargeSummaryId
RevenueEventItemInvoiceItem.subscriptionId = RevenueEventItemInvoiceItemAdjustment.subscriptionId
RevenueScheduleItem
RevenueEventItemInvoiceItem.accountingPeriodId = RevenueScheduleItem.accountingPeriodId
RevenueEventItemInvoiceItem.amendmentId = RevenueScheduleItem.amendmentId
RevenueEventItemInvoiceItem.billToContactId = RevenueScheduleItem.billToContactId
RevenueEventItemInvoiceItem.soldToContactId = RevenueScheduleItem.billToContactId
RevenueEventItemInvoiceItem.billToContactId = RevenueScheduleItem.soldToContactId
RevenueEventItemInvoiceItem.soldToContactId = RevenueScheduleItem.soldToContactId
RevenueEventItemInvoiceItem.deferredRevenueAccountingCodeId = RevenueScheduleItem.deferredRevenueAccountingCodeId
RevenueEventItemInvoiceItem.parentAccountId = RevenueScheduleItem.parentAccountId
RevenueEventItemInvoiceItem.productId = RevenueScheduleItem.productId
RevenueEventItemInvoiceItem.productRatePlanChargeId = RevenueScheduleItem.productRatePlanChargeId
RevenueEventItemInvoiceItem.productRatePlanId = RevenueScheduleItem.productRatePlanId
RevenueEventItemInvoiceItem.ratePlanChargeId = RevenueScheduleItem.ratePlanChargeId
RevenueEventItemInvoiceItem.ratePlanId = RevenueScheduleItem.ratePlanId
RevenueEventItemInvoiceItem.recognizedRevenueAccountingCodeId = RevenueScheduleItem.recognizedRevenueAccountingCodeId
RevenueEventItemInvoiceItem.revenueChargeSummaryId = RevenueScheduleItem.revenueChargeSummaryId
RevenueScheduleItemInvoiceItem
RevenueEventItemInvoiceItem.accountingPeriodId = RevenueScheduleItemInvoiceItem.accountingPeriodId
RevenueEventItemInvoiceItem.amendmentId = RevenueScheduleItemInvoiceItem.amendmentId
RevenueEventItemInvoiceItem.billToContactId = RevenueScheduleItemInvoiceItem.billToContactId
RevenueEventItemInvoiceItem.soldToContactId = RevenueScheduleItemInvoiceItem.billToContactId
RevenueEventItemInvoiceItem.billToContactId = RevenueScheduleItemInvoiceItem.soldToContactId
RevenueEventItemInvoiceItem.soldToContactId = RevenueScheduleItemInvoiceItem.soldToContactId
RevenueEventItemInvoiceItem.deferredRevenueAccountingCodeId = RevenueScheduleItemInvoiceItem.deferredRevenueAccountingCodeId
RevenueEventItemInvoiceItem.invoiceItemId = RevenueScheduleItemInvoiceItem.invoiceItemId
RevenueEventItemInvoiceItem.parentAccountId = RevenueScheduleItemInvoiceItem.parentAccountId
RevenueEventItemInvoiceItem.productId = RevenueScheduleItemInvoiceItem.productId
RevenueEventItemInvoiceItem.productRatePlanChargeId = RevenueScheduleItemInvoiceItem.productRatePlanChargeId
RevenueEventItemInvoiceItem.productRatePlanId = RevenueScheduleItemInvoiceItem.productRatePlanId
RevenueEventItemInvoiceItem.ratePlanChargeId = RevenueScheduleItemInvoiceItem.ratePlanChargeId
RevenueEventItemInvoiceItem.ratePlanId = RevenueScheduleItemInvoiceItem.ratePlanId
RevenueEventItemInvoiceItem.recognizedRevenueAccountingCodeId = RevenueScheduleItemInvoiceItem.recognizedRevenueAccountingCodeId
RevenueEventItemInvoiceItem.revenueChargeSummaryId = RevenueScheduleItemInvoiceItem.revenueChargeSummaryId
RevenueScheduleItemInvoiceItemAdjustment
RevenueEventItemInvoiceItem.accountingPeriodId = RevenueScheduleItemInvoiceItemAdjustment.accountingPeriodId
RevenueEventItemInvoiceItem.amendmentId = RevenueScheduleItemInvoiceItemAdjustment.amendmentId
RevenueEventItemInvoiceItem.billToContactId = RevenueScheduleItemInvoiceItemAdjustment.billToContactId
RevenueEventItemInvoiceItem.soldToContactId = RevenueScheduleItemInvoiceItemAdjustment.billToContactId
RevenueEventItemInvoiceItem.billToContactId = RevenueScheduleItemInvoiceItemAdjustment.soldToContactId
RevenueEventItemInvoiceItem.soldToContactId = RevenueScheduleItemInvoiceItemAdjustment.soldToContactId
RevenueEventItemInvoiceItem.deferredRevenueAccountingCodeId = RevenueScheduleItemInvoiceItemAdjustment.deferredRevenueAccountingCodeId
RevenueEventItemInvoiceItem.invoiceItemId = RevenueScheduleItemInvoiceItemAdjustment.invoiceItemId
RevenueEventItemInvoiceItem.parentAccountId = RevenueScheduleItemInvoiceItemAdjustment.parentAccountId
RevenueEventItemInvoiceItem.productId = RevenueScheduleItemInvoiceItemAdjustment.productId
RevenueEventItemInvoiceItem.productRatePlanChargeId = RevenueScheduleItemInvoiceItemAdjustment.productRatePlanChargeId
RevenueEventItemInvoiceItem.productRatePlanId = RevenueScheduleItemInvoiceItemAdjustment.productRatePlanId
RevenueEventItemInvoiceItem.ratePlanChargeId = RevenueScheduleItemInvoiceItemAdjustment.ratePlanChargeId
RevenueEventItemInvoiceItem.ratePlanId = RevenueScheduleItemInvoiceItemAdjustment.ratePlanId
RevenueEventItemInvoiceItem.recognizedRevenueAccountingCodeId = RevenueScheduleItemInvoiceItemAdjustment.recognizedRevenueAccountingCodeId
RevenueEventItemInvoiceItem.revenueChargeSummaryId = RevenueScheduleItemInvoiceItemAdjustment.revenueChargeSummaryId
RevenueEventItemInvoiceItem.subscriptionId = RevenueScheduleItemInvoiceItemAdjustment.subscriptionId
Amendment
RevenueEventItemInvoiceItem.amendmentId = Amendment.id
RevenueEventItemInvoiceItem.subscriptionId = Amendment.subscriptionId
DiscountAppliedMetrics
RevenueEventItemInvoiceItem.amendmentId = DiscountAppliedMetrics.amendmentId
RevenueEventItemInvoiceItem.billToContactId = DiscountAppliedMetrics.billToContactId
RevenueEventItemInvoiceItem.soldToContactId = DiscountAppliedMetrics.billToContactId
RevenueEventItemInvoiceItem.billToContactId = DiscountAppliedMetrics.soldToContactId
RevenueEventItemInvoiceItem.soldToContactId = DiscountAppliedMetrics.soldToContactId
RevenueEventItemInvoiceItem.parentAccountId = DiscountAppliedMetrics.parentAccountId
RevenueEventItemInvoiceItem.productId = DiscountAppliedMetrics.productId
RevenueEventItemInvoiceItem.productRatePlanChargeId = DiscountAppliedMetrics.productRatePlanChargeId
RevenueEventItemInvoiceItem.productRatePlanId = DiscountAppliedMetrics.productRatePlanId
RevenueEventItemInvoiceItem.ratePlanChargeId = DiscountAppliedMetrics.ratePlanChargeId
RevenueEventItemInvoiceItem.ratePlanId = DiscountAppliedMetrics.ratePlanId
RevenueEventItemInvoiceItem.subscriptionId = DiscountAppliedMetrics.subscriptionId
ProcessedUsage
RevenueEventItemInvoiceItem.amendmentId = ProcessedUsage.amendmentId
RevenueEventItemInvoiceItem.billToContactId = ProcessedUsage.billToContactId
RevenueEventItemInvoiceItem.soldToContactId = ProcessedUsage.billToContactId
RevenueEventItemInvoiceItem.billToContactId = ProcessedUsage.soldToContactId
RevenueEventItemInvoiceItem.soldToContactId = ProcessedUsage.soldToContactId
RevenueEventItemInvoiceItem.invoiceItemId = ProcessedUsage.invoiceItemId
RevenueEventItemInvoiceItem.parentAccountId = ProcessedUsage.parentAccountId
RevenueEventItemInvoiceItem.productId = ProcessedUsage.productId
RevenueEventItemInvoiceItem.productRatePlanChargeId = ProcessedUsage.productRatePlanChargeId
RevenueEventItemInvoiceItem.productRatePlanId = ProcessedUsage.productRatePlanId
RevenueEventItemInvoiceItem.ratePlanChargeId = ProcessedUsage.ratePlanChargeId
RevenueEventItemInvoiceItem.ratePlanId = ProcessedUsage.ratePlanId
RatePlan
RevenueEventItemInvoiceItem.amendmentId = RatePlan.amendmentId
RevenueEventItemInvoiceItem.billToContactId = RatePlan.billToContactId
RevenueEventItemInvoiceItem.soldToContactId = RatePlan.billToContactId
RevenueEventItemInvoiceItem.productRatePlanId = RatePlan.productRatePlanId
RevenueEventItemInvoiceItem.ratePlanId = RatePlan.id
RevenueEventItemInvoiceItem.subscriptionId = RatePlan.subscriptionId
RatePlanChargeTier
RevenueEventItemInvoiceItem.amendmentId = RatePlanChargeTier.amendmentId
RevenueEventItemInvoiceItem.productRatePlanId = RatePlanChargeTier.productRatePlanId
RevenueEventItemInvoiceItem.ratePlanChargeId = RatePlanChargeTier.ratePlanChargeId
RevenueEventItemInvoiceItem.ratePlanId = RatePlanChargeTier.ratePlanId
RevenueEventItemInvoiceItem.subscriptionId = RatePlanChargeTier.subscriptionId
RevenueEventItem
RevenueEventItemInvoiceItem.amendmentId = RevenueEventItem.amendmentId
RevenueEventItemInvoiceItem.billToContactId = RevenueEventItem.billToContactId
RevenueEventItemInvoiceItem.soldToContactId = RevenueEventItem.billToContactId
RevenueEventItemInvoiceItem.billToContactId = RevenueEventItem.soldToContactId
RevenueEventItemInvoiceItem.soldToContactId = RevenueEventItem.soldToContactId
RevenueEventItemInvoiceItem.deferredRevenueAccountingCodeId = RevenueEventItem.deferredRevenueAccountingCodeId
RevenueEventItemInvoiceItem.journalEntryId = RevenueEventItem.journalEntryId
RevenueEventItemInvoiceItem.journalRunId = RevenueEventItem.journalRunId
RevenueEventItemInvoiceItem.parentAccountId = RevenueEventItem.parentAccountId
RevenueEventItemInvoiceItem.productId = RevenueEventItem.productId
RevenueEventItemInvoiceItem.productRatePlanChargeId = RevenueEventItem.productRatePlanChargeId
RevenueEventItemInvoiceItem.productRatePlanId = RevenueEventItem.productRatePlanId
RevenueEventItemInvoiceItem.ratePlanChargeId = RevenueEventItem.ratePlanChargeId
RevenueEventItemInvoiceItem.ratePlanId = RevenueEventItem.ratePlanId
RevenueEventItemInvoiceItem.recognizedRevenueAccountingCodeId = RevenueEventItem.recognizedRevenueAccountingCodeId
RevenueEventItemInvoiceItem.revenueChargeSummaryId = RevenueEventItem.revenueChargeSummaryId
RevenueEventItemInvoiceItem.subscriptionId = RevenueEventItem.subscriptionId
Account
RevenueEventItemInvoiceItem.billToContactId = Account.billToContactId
RevenueEventItemInvoiceItem.soldToContactId = Account.billToContactId
RevenueEventItemInvoiceItem.billToContactId = Account.soldToContactId
RevenueEventItemInvoiceItem.soldToContactId = Account.soldToContactId
RevenueEventItemInvoiceItem.deferredRevenueAccountingCodeId = Account.id
RevenueEventItemInvoiceItem.parentAccountId = Account.parentAccountId
Contact
RevenueEventItemInvoiceItem.billToContactId = Contact.id
RevenueEventItemInvoiceItem.soldToContactId = Contact.id
ContactSnapshot
RevenueEventItemInvoiceItem.billToContactId = ContactSnapshot.contactId
RevenueEventItemInvoiceItem.soldToContactId = ContactSnapshot.contactId
Invoice
RevenueEventItemInvoiceItem.billToContactId = Invoice.billToContactId
RevenueEventItemInvoiceItem.soldToContactId = Invoice.billToContactId
RevenueEventItemInvoiceItem.billToContactId = Invoice.soldToContactId
RevenueEventItemInvoiceItem.soldToContactId = Invoice.soldToContactId
RevenueEventItemInvoiceItem.parentAccountId = Invoice.parentAccountId
Refund
RevenueEventItemInvoiceItem.billToContactId = Refund.billToContactId
RevenueEventItemInvoiceItem.soldToContactId = Refund.billToContactId
RevenueEventItemInvoiceItem.billToContactId = Refund.soldToContactId
RevenueEventItemInvoiceItem.soldToContactId = Refund.soldToContactId
RevenueEventItemInvoiceItem.parentAccountId = Refund.parentAccountId
InvoiceItem
RevenueEventItemInvoiceItem.invoiceItemId = InvoiceItem.id
RevenueEventItemInvoiceItem.productId = InvoiceItem.productId
RevenueEventItemInvoiceItem.productRatePlanChargeId = InvoiceItem.productRatePlanChargeId
RevenueEventItemInvoiceItem.ratePlanChargeId = InvoiceItem.ratePlanChargeId
RevenueEventItemInvoiceItem.subscriptionId = InvoiceItem.subscriptionId
JournalEntryItem
RevenueEventItemInvoiceItem.journalEntryId = JournalEntryItem.journalEntryId
RevenueEventItemInvoiceItem.journalRunId = JournalEntryItem.journalRunId
JournalRun
RevenueEventItemInvoiceItem.journalRunId = JournalRun.id
Product
RevenueEventItemInvoiceItem.productId = Product.id
ProductRatePlan
RevenueEventItemInvoiceItem.productId = ProductRatePlan.productId
RevenueEventItemInvoiceItem.productRatePlanId = ProductRatePlan.id
ProductRatePlanCharge
RevenueEventItemInvoiceItem.productRatePlanChargeId = ProductRatePlanCharge.id
RevenueEventItemInvoiceItem.productRatePlanId = ProductRatePlanCharge.productRatePlanId
ProductRatePlanChargeTier
RevenueEventItemInvoiceItem.productRatePlanChargeId = ProductRatePlanChargeTier.productRatePlanChargeId
RevenueEventItemInvoiceItem.productRatePlanId = ProductRatePlanChargeTier.productRatePlanId
RevenueEventItemInvoiceItem.ratePlanChargeId = ProductRatePlanChargeTier.ratePlanChargeId
RevenueEventItemInvoiceItem.ratePlanId = ProductRatePlanChargeTier.ratePlanId
RatePlanCharge
RevenueEventItemInvoiceItem.ratePlanChargeId = RatePlanCharge.id
AccountingCode
RevenueEventItemInvoiceItem.recognizedRevenueAccountingCodeId = AccountingCode.id
Subscription
RevenueEventItemInvoiceItem.subscriptionId = Subscription.id

accountId

STRING

accountingPeriodId

STRING

amendmentId

STRING

amount

DOUBLE

billToContactId

STRING

createdById

STRING

createdDate

DATE-TIME

currency

STRING

defaultPaymentMethodId

STRING

deferredRevenueAccountingCodeId

STRING

deleted

BOOLEAN

id

STRING

invoiceId

STRING

invoiceItemId

STRING

journalEntryId

STRING

journalRunId

STRING

parentAccountId

STRING

productId

STRING

productRatePlanChargeId

STRING

productRatePlanId

STRING

ratePlanChargeId

STRING

ratePlanId

STRING

recognizedRevenueAccountingCodeId

STRING

revenueChargeSummaryId

STRING

revenueEventId

STRING

revenueEventInvoiceId

STRING

revenueEventTypeId

STRING

revenueScheduleId

STRING

soldToContactId

STRING

subscriptionId

STRING

updatedById

STRING

updatedDate

DATE-TIME

RevenueEventItemInvoiceItemAdjustment

The RevenueEventItemInvoiceItemAdjustment table contains information about revenue event items that are associated with invoice item adjustments.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

Join RevenueEventItemInvoiceItemAdjustment with on
AccountingPeriod
RevenueEventItemInvoiceItemAdjustment.accountingPeriodId = AccountingPeriod.id
CreditBalanceAdjustment
RevenueEventItemInvoiceItemAdjustment.accountingPeriodId = CreditBalanceAdjustment.accountingPeriodId
RevenueEventItemInvoiceItemAdjustment.billToContactId = CreditBalanceAdjustment.billToContactId
RevenueEventItemInvoiceItemAdjustment.soldToContactId = CreditBalanceAdjustment.billToContactId
RevenueEventItemInvoiceItemAdjustment.billToContactId = CreditBalanceAdjustment.soldToContactId
RevenueEventItemInvoiceItemAdjustment.soldToContactId = CreditBalanceAdjustment.soldToContactId
RevenueEventItemInvoiceItemAdjustment.journalEntryId = CreditBalanceAdjustment.journalEntryId
RevenueEventItemInvoiceItemAdjustment.journalRunId = CreditBalanceAdjustment.journalRunId
RevenueEventItemInvoiceItemAdjustment.parentAccountId = CreditBalanceAdjustment.parentAccountId
InvoiceItemAdjustment
RevenueEventItemInvoiceItemAdjustment.accountingPeriodId = InvoiceItemAdjustment.accountingPeriodId
RevenueEventItemInvoiceItemAdjustment.amendmentId = InvoiceItemAdjustment.amendmentId
RevenueEventItemInvoiceItemAdjustment.billToContactId = InvoiceItemAdjustment.billToContactId
RevenueEventItemInvoiceItemAdjustment.soldToContactId = InvoiceItemAdjustment.billToContactId
RevenueEventItemInvoiceItemAdjustment.billToContactId = InvoiceItemAdjustment.soldToContactId
RevenueEventItemInvoiceItemAdjustment.soldToContactId = InvoiceItemAdjustment.soldToContactId
RevenueEventItemInvoiceItemAdjustment.invoiceItemAdjustmentId = InvoiceItemAdjustment.id
RevenueEventItemInvoiceItemAdjustment.journalEntryId = InvoiceItemAdjustment.journalEntryId
RevenueEventItemInvoiceItemAdjustment.journalRunId = InvoiceItemAdjustment.journalRunId
RevenueEventItemInvoiceItemAdjustment.parentAccountId = InvoiceItemAdjustment.parentAccountId
RevenueEventItemInvoiceItemAdjustment.productId = InvoiceItemAdjustment.productId
RevenueEventItemInvoiceItemAdjustment.productRatePlanChargeId = InvoiceItemAdjustment.productRatePlanChargeId
RevenueEventItemInvoiceItemAdjustment.ratePlanChargeId = InvoiceItemAdjustment.ratePlanChargeId
RevenueEventItemInvoiceItemAdjustment.ratePlanId = InvoiceItemAdjustment.ratePlanId
RevenueEventItemInvoiceItemAdjustment.recognizedRevenueAccountingCodeId = InvoiceItemAdjustment.recognizedRevenueAccountingCodeId
RevenueEventItemInvoiceItemAdjustment.subscriptionId = InvoiceItemAdjustment.subscriptionId
JournalEntry
RevenueEventItemInvoiceItemAdjustment.accountingPeriodId = JournalEntry.accountingPeriodId
RevenueEventItemInvoiceItemAdjustment.journalEntryId = JournalEntry.id
RevenueChargeSummaryItem
RevenueEventItemInvoiceItemAdjustment.accountingPeriodId = RevenueChargeSummaryItem.accountingPeriodId
RevenueEventItemInvoiceItemAdjustment.amendmentId = RevenueChargeSummaryItem.amendmentId
RevenueEventItemInvoiceItemAdjustment.billToContactId = RevenueChargeSummaryItem.billToContactId
RevenueEventItemInvoiceItemAdjustment.soldToContactId = RevenueChargeSummaryItem.billToContactId
RevenueEventItemInvoiceItemAdjustment.billToContactId = RevenueChargeSummaryItem.soldToContactId
RevenueEventItemInvoiceItemAdjustment.soldToContactId = RevenueChargeSummaryItem.soldToContactId
RevenueEventItemInvoiceItemAdjustment.parentAccountId = RevenueChargeSummaryItem.parentAccountId
RevenueEventItemInvoiceItemAdjustment.productId = RevenueChargeSummaryItem.productId
RevenueEventItemInvoiceItemAdjustment.productRatePlanChargeId = RevenueChargeSummaryItem.productRatePlanChargeId
RevenueEventItemInvoiceItemAdjustment.productRatePlanId = RevenueChargeSummaryItem.productRatePlanId
RevenueEventItemInvoiceItemAdjustment.ratePlanChargeId = RevenueChargeSummaryItem.ratePlanChargeId
RevenueEventItemInvoiceItemAdjustment.ratePlanId = RevenueChargeSummaryItem.ratePlanId
RevenueEventItemInvoiceItemAdjustment.revenueChargeSummaryId = RevenueChargeSummaryItem.revenueChargeSummaryId
RevenueEventItemInvoiceItemAdjustment.subscriptionId = RevenueChargeSummaryItem.subscriptionId
RevenueEventItemInvoiceItem
RevenueEventItemInvoiceItemAdjustment.accountingPeriodId = RevenueEventItemInvoiceItem.accountingPeriodId
RevenueEventItemInvoiceItemAdjustment.amendmentId = RevenueEventItemInvoiceItem.amendmentId
RevenueEventItemInvoiceItemAdjustment.billToContactId = RevenueEventItemInvoiceItem.billToContactId
RevenueEventItemInvoiceItemAdjustment.soldToContactId = RevenueEventItemInvoiceItem.billToContactId
RevenueEventItemInvoiceItemAdjustment.billToContactId = RevenueEventItemInvoiceItem.soldToContactId
RevenueEventItemInvoiceItemAdjustment.soldToContactId = RevenueEventItemInvoiceItem.soldToContactId
RevenueEventItemInvoiceItemAdjustment.deferredRevenueAccountingCodeId = RevenueEventItemInvoiceItem.deferredRevenueAccountingCodeId
RevenueEventItemInvoiceItemAdjustment.invoiceItemId = RevenueEventItemInvoiceItem.invoiceItemId
RevenueEventItemInvoiceItemAdjustment.journalEntryId = RevenueEventItemInvoiceItem.journalEntryId
RevenueEventItemInvoiceItemAdjustment.journalRunId = RevenueEventItemInvoiceItem.journalRunId
RevenueEventItemInvoiceItemAdjustment.parentAccountId = RevenueEventItemInvoiceItem.parentAccountId
RevenueEventItemInvoiceItemAdjustment.productId = RevenueEventItemInvoiceItem.productId
RevenueEventItemInvoiceItemAdjustment.productRatePlanChargeId = RevenueEventItemInvoiceItem.productRatePlanChargeId
RevenueEventItemInvoiceItemAdjustment.productRatePlanId = RevenueEventItemInvoiceItem.productRatePlanId
RevenueEventItemInvoiceItemAdjustment.ratePlanChargeId = RevenueEventItemInvoiceItem.ratePlanChargeId
RevenueEventItemInvoiceItemAdjustment.ratePlanId = RevenueEventItemInvoiceItem.ratePlanId
RevenueEventItemInvoiceItemAdjustment.recognizedRevenueAccountingCodeId = RevenueEventItemInvoiceItem.recognizedRevenueAccountingCodeId
RevenueEventItemInvoiceItemAdjustment.revenueChargeSummaryId = RevenueEventItemInvoiceItem.revenueChargeSummaryId
RevenueEventItemInvoiceItemAdjustment.subscriptionId = RevenueEventItemInvoiceItem.subscriptionId
RevenueScheduleItem
RevenueEventItemInvoiceItemAdjustment.accountingPeriodId = RevenueScheduleItem.accountingPeriodId
RevenueEventItemInvoiceItemAdjustment.amendmentId = RevenueScheduleItem.amendmentId
RevenueEventItemInvoiceItemAdjustment.billToContactId = RevenueScheduleItem.billToContactId
RevenueEventItemInvoiceItemAdjustment.soldToContactId = RevenueScheduleItem.billToContactId
RevenueEventItemInvoiceItemAdjustment.billToContactId = RevenueScheduleItem.soldToContactId
RevenueEventItemInvoiceItemAdjustment.soldToContactId = RevenueScheduleItem.soldToContactId
RevenueEventItemInvoiceItemAdjustment.deferredRevenueAccountingCodeId = RevenueScheduleItem.deferredRevenueAccountingCodeId
RevenueEventItemInvoiceItemAdjustment.parentAccountId = RevenueScheduleItem.parentAccountId
RevenueEventItemInvoiceItemAdjustment.productId = RevenueScheduleItem.productId
RevenueEventItemInvoiceItemAdjustment.productRatePlanChargeId = RevenueScheduleItem.productRatePlanChargeId
RevenueEventItemInvoiceItemAdjustment.productRatePlanId = RevenueScheduleItem.productRatePlanId
RevenueEventItemInvoiceItemAdjustment.ratePlanChargeId = RevenueScheduleItem.ratePlanChargeId
RevenueEventItemInvoiceItemAdjustment.ratePlanId = RevenueScheduleItem.ratePlanId
RevenueEventItemInvoiceItemAdjustment.recognizedRevenueAccountingCodeId = RevenueScheduleItem.recognizedRevenueAccountingCodeId
RevenueEventItemInvoiceItemAdjustment.revenueChargeSummaryId = RevenueScheduleItem.revenueChargeSummaryId
RevenueScheduleItemInvoiceItem
RevenueEventItemInvoiceItemAdjustment.accountingPeriodId = RevenueScheduleItemInvoiceItem.accountingPeriodId
RevenueEventItemInvoiceItemAdjustment.amendmentId = RevenueScheduleItemInvoiceItem.amendmentId
RevenueEventItemInvoiceItemAdjustment.billToContactId = RevenueScheduleItemInvoiceItem.billToContactId
RevenueEventItemInvoiceItemAdjustment.soldToContactId = RevenueScheduleItemInvoiceItem.billToContactId
RevenueEventItemInvoiceItemAdjustment.billToContactId = RevenueScheduleItemInvoiceItem.soldToContactId
RevenueEventItemInvoiceItemAdjustment.soldToContactId = RevenueScheduleItemInvoiceItem.soldToContactId
RevenueEventItemInvoiceItemAdjustment.deferredRevenueAccountingCodeId = RevenueScheduleItemInvoiceItem.deferredRevenueAccountingCodeId
RevenueEventItemInvoiceItemAdjustment.invoiceItemId = RevenueScheduleItemInvoiceItem.invoiceItemId
RevenueEventItemInvoiceItemAdjustment.parentAccountId = RevenueScheduleItemInvoiceItem.parentAccountId
RevenueEventItemInvoiceItemAdjustment.productId = RevenueScheduleItemInvoiceItem.productId
RevenueEventItemInvoiceItemAdjustment.productRatePlanChargeId = RevenueScheduleItemInvoiceItem.productRatePlanChargeId
RevenueEventItemInvoiceItemAdjustment.productRatePlanId = RevenueScheduleItemInvoiceItem.productRatePlanId
RevenueEventItemInvoiceItemAdjustment.ratePlanChargeId = RevenueScheduleItemInvoiceItem.ratePlanChargeId
RevenueEventItemInvoiceItemAdjustment.ratePlanId = RevenueScheduleItemInvoiceItem.ratePlanId
RevenueEventItemInvoiceItemAdjustment.recognizedRevenueAccountingCodeId = RevenueScheduleItemInvoiceItem.recognizedRevenueAccountingCodeId
RevenueEventItemInvoiceItemAdjustment.revenueChargeSummaryId = RevenueScheduleItemInvoiceItem.revenueChargeSummaryId
RevenueScheduleItemInvoiceItemAdjustment
RevenueEventItemInvoiceItemAdjustment.accountingPeriodId = RevenueScheduleItemInvoiceItemAdjustment.accountingPeriodId
RevenueEventItemInvoiceItemAdjustment.amendmentId = RevenueScheduleItemInvoiceItemAdjustment.amendmentId
RevenueEventItemInvoiceItemAdjustment.billToContactId = RevenueScheduleItemInvoiceItemAdjustment.billToContactId
RevenueEventItemInvoiceItemAdjustment.soldToContactId = RevenueScheduleItemInvoiceItemAdjustment.billToContactId
RevenueEventItemInvoiceItemAdjustment.billToContactId = RevenueScheduleItemInvoiceItemAdjustment.soldToContactId
RevenueEventItemInvoiceItemAdjustment.soldToContactId = RevenueScheduleItemInvoiceItemAdjustment.soldToContactId
RevenueEventItemInvoiceItemAdjustment.deferredRevenueAccountingCodeId = RevenueScheduleItemInvoiceItemAdjustment.deferredRevenueAccountingCodeId
RevenueEventItemInvoiceItemAdjustment.invoiceItemAdjustmentId = RevenueScheduleItemInvoiceItemAdjustment.invoiceItemAdjustmentId
RevenueEventItemInvoiceItemAdjustment.invoiceItemId = RevenueScheduleItemInvoiceItemAdjustment.invoiceItemId
RevenueEventItemInvoiceItemAdjustment.parentAccountId = RevenueScheduleItemInvoiceItemAdjustment.parentAccountId
RevenueEventItemInvoiceItemAdjustment.productId = RevenueScheduleItemInvoiceItemAdjustment.productId
RevenueEventItemInvoiceItemAdjustment.productRatePlanChargeId = RevenueScheduleItemInvoiceItemAdjustment.productRatePlanChargeId
RevenueEventItemInvoiceItemAdjustment.productRatePlanId = RevenueScheduleItemInvoiceItemAdjustment.productRatePlanId
RevenueEventItemInvoiceItemAdjustment.ratePlanChargeId = RevenueScheduleItemInvoiceItemAdjustment.ratePlanChargeId
RevenueEventItemInvoiceItemAdjustment.ratePlanId = RevenueScheduleItemInvoiceItemAdjustment.ratePlanId
RevenueEventItemInvoiceItemAdjustment.recognizedRevenueAccountingCodeId = RevenueScheduleItemInvoiceItemAdjustment.recognizedRevenueAccountingCodeId
RevenueEventItemInvoiceItemAdjustment.revenueChargeSummaryId = RevenueScheduleItemInvoiceItemAdjustment.revenueChargeSummaryId
RevenueEventItemInvoiceItemAdjustment.subscriptionId = RevenueScheduleItemInvoiceItemAdjustment.subscriptionId
Amendment
RevenueEventItemInvoiceItemAdjustment.amendmentId = Amendment.id
RevenueEventItemInvoiceItemAdjustment.subscriptionId = Amendment.subscriptionId
DiscountAppliedMetrics
RevenueEventItemInvoiceItemAdjustment.amendmentId = DiscountAppliedMetrics.amendmentId
RevenueEventItemInvoiceItemAdjustment.billToContactId = DiscountAppliedMetrics.billToContactId
RevenueEventItemInvoiceItemAdjustment.soldToContactId = DiscountAppliedMetrics.billToContactId
RevenueEventItemInvoiceItemAdjustment.billToContactId = DiscountAppliedMetrics.soldToContactId
RevenueEventItemInvoiceItemAdjustment.soldToContactId = DiscountAppliedMetrics.soldToContactId
RevenueEventItemInvoiceItemAdjustment.parentAccountId = DiscountAppliedMetrics.parentAccountId
RevenueEventItemInvoiceItemAdjustment.productId = DiscountAppliedMetrics.productId
RevenueEventItemInvoiceItemAdjustment.productRatePlanChargeId = DiscountAppliedMetrics.productRatePlanChargeId
RevenueEventItemInvoiceItemAdjustment.productRatePlanId = DiscountAppliedMetrics.productRatePlanId
RevenueEventItemInvoiceItemAdjustment.ratePlanChargeId = DiscountAppliedMetrics.ratePlanChargeId
RevenueEventItemInvoiceItemAdjustment.ratePlanId = DiscountAppliedMetrics.ratePlanId
RevenueEventItemInvoiceItemAdjustment.subscriptionId = DiscountAppliedMetrics.subscriptionId
ProcessedUsage
RevenueEventItemInvoiceItemAdjustment.amendmentId = ProcessedUsage.amendmentId
RevenueEventItemInvoiceItemAdjustment.billToContactId = ProcessedUsage.billToContactId
RevenueEventItemInvoiceItemAdjustment.soldToContactId = ProcessedUsage.billToContactId
RevenueEventItemInvoiceItemAdjustment.billToContactId = ProcessedUsage.soldToContactId
RevenueEventItemInvoiceItemAdjustment.soldToContactId = ProcessedUsage.soldToContactId
RevenueEventItemInvoiceItemAdjustment.invoiceItemId = ProcessedUsage.invoiceItemId
RevenueEventItemInvoiceItemAdjustment.parentAccountId = ProcessedUsage.parentAccountId
RevenueEventItemInvoiceItemAdjustment.productId = ProcessedUsage.productId
RevenueEventItemInvoiceItemAdjustment.productRatePlanChargeId = ProcessedUsage.productRatePlanChargeId
RevenueEventItemInvoiceItemAdjustment.productRatePlanId = ProcessedUsage.productRatePlanId
RevenueEventItemInvoiceItemAdjustment.ratePlanChargeId = ProcessedUsage.ratePlanChargeId
RevenueEventItemInvoiceItemAdjustment.ratePlanId = ProcessedUsage.ratePlanId
RatePlan
RevenueEventItemInvoiceItemAdjustment.amendmentId = RatePlan.amendmentId
RevenueEventItemInvoiceItemAdjustment.billToContactId = RatePlan.billToContactId
RevenueEventItemInvoiceItemAdjustment.soldToContactId = RatePlan.billToContactId
RevenueEventItemInvoiceItemAdjustment.productRatePlanId = RatePlan.productRatePlanId
RevenueEventItemInvoiceItemAdjustment.ratePlanId = RatePlan.id
RevenueEventItemInvoiceItemAdjustment.subscriptionId = RatePlan.subscriptionId
RatePlanChargeTier
RevenueEventItemInvoiceItemAdjustment.amendmentId = RatePlanChargeTier.amendmentId
RevenueEventItemInvoiceItemAdjustment.productRatePlanId = RatePlanChargeTier.productRatePlanId
RevenueEventItemInvoiceItemAdjustment.ratePlanChargeId = RatePlanChargeTier.ratePlanChargeId
RevenueEventItemInvoiceItemAdjustment.ratePlanId = RatePlanChargeTier.ratePlanId
RevenueEventItemInvoiceItemAdjustment.subscriptionId = RatePlanChargeTier.subscriptionId
RevenueEventItem
RevenueEventItemInvoiceItemAdjustment.amendmentId = RevenueEventItem.amendmentId
RevenueEventItemInvoiceItemAdjustment.billToContactId = RevenueEventItem.billToContactId
RevenueEventItemInvoiceItemAdjustment.soldToContactId = RevenueEventItem.billToContactId
RevenueEventItemInvoiceItemAdjustment.billToContactId = RevenueEventItem.soldToContactId
RevenueEventItemInvoiceItemAdjustment.soldToContactId = RevenueEventItem.soldToContactId
RevenueEventItemInvoiceItemAdjustment.deferredRevenueAccountingCodeId = RevenueEventItem.deferredRevenueAccountingCodeId
RevenueEventItemInvoiceItemAdjustment.journalEntryId = RevenueEventItem.journalEntryId
RevenueEventItemInvoiceItemAdjustment.journalRunId = RevenueEventItem.journalRunId
RevenueEventItemInvoiceItemAdjustment.parentAccountId = RevenueEventItem.parentAccountId
RevenueEventItemInvoiceItemAdjustment.productId = RevenueEventItem.productId
RevenueEventItemInvoiceItemAdjustment.productRatePlanChargeId = RevenueEventItem.productRatePlanChargeId
RevenueEventItemInvoiceItemAdjustment.productRatePlanId = RevenueEventItem.productRatePlanId
RevenueEventItemInvoiceItemAdjustment.ratePlanChargeId = RevenueEventItem.ratePlanChargeId
RevenueEventItemInvoiceItemAdjustment.ratePlanId = RevenueEventItem.ratePlanId
RevenueEventItemInvoiceItemAdjustment.recognizedRevenueAccountingCodeId = RevenueEventItem.recognizedRevenueAccountingCodeId
RevenueEventItemInvoiceItemAdjustment.revenueChargeSummaryId = RevenueEventItem.revenueChargeSummaryId
RevenueEventItemInvoiceItemAdjustment.subscriptionId = RevenueEventItem.subscriptionId
Account
RevenueEventItemInvoiceItemAdjustment.billToContactId = Account.billToContactId
RevenueEventItemInvoiceItemAdjustment.soldToContactId = Account.billToContactId
RevenueEventItemInvoiceItemAdjustment.billToContactId = Account.soldToContactId
RevenueEventItemInvoiceItemAdjustment.soldToContactId = Account.soldToContactId
RevenueEventItemInvoiceItemAdjustment.deferredRevenueAccountingCodeId = Account.id
RevenueEventItemInvoiceItemAdjustment.parentAccountId = Account.parentAccountId
Contact
RevenueEventItemInvoiceItemAdjustment.billToContactId = Contact.id
RevenueEventItemInvoiceItemAdjustment.soldToContactId = Contact.id
ContactSnapshot
RevenueEventItemInvoiceItemAdjustment.billToContactId = ContactSnapshot.contactId
RevenueEventItemInvoiceItemAdjustment.soldToContactId = ContactSnapshot.contactId
Invoice
RevenueEventItemInvoiceItemAdjustment.billToContactId = Invoice.billToContactId
RevenueEventItemInvoiceItemAdjustment.soldToContactId = Invoice.billToContactId
RevenueEventItemInvoiceItemAdjustment.billToContactId = Invoice.soldToContactId
RevenueEventItemInvoiceItemAdjustment.soldToContactId = Invoice.soldToContactId
RevenueEventItemInvoiceItemAdjustment.parentAccountId = Invoice.parentAccountId
Refund
RevenueEventItemInvoiceItemAdjustment.billToContactId = Refund.billToContactId
RevenueEventItemInvoiceItemAdjustment.soldToContactId = Refund.billToContactId
RevenueEventItemInvoiceItemAdjustment.billToContactId = Refund.soldToContactId
RevenueEventItemInvoiceItemAdjustment.soldToContactId = Refund.soldToContactId
RevenueEventItemInvoiceItemAdjustment.parentAccountId = Refund.parentAccountId
InvoiceItem
RevenueEventItemInvoiceItemAdjustment.invoiceItemId = InvoiceItem.id
RevenueEventItemInvoiceItemAdjustment.productId = InvoiceItem.productId
RevenueEventItemInvoiceItemAdjustment.productRatePlanChargeId = InvoiceItem.productRatePlanChargeId
RevenueEventItemInvoiceItemAdjustment.ratePlanChargeId = InvoiceItem.ratePlanChargeId
RevenueEventItemInvoiceItemAdjustment.subscriptionId = InvoiceItem.subscriptionId
JournalEntryItem
RevenueEventItemInvoiceItemAdjustment.journalEntryId = JournalEntryItem.journalEntryId
RevenueEventItemInvoiceItemAdjustment.journalRunId = JournalEntryItem.journalRunId
JournalRun
RevenueEventItemInvoiceItemAdjustment.journalRunId = JournalRun.id
Product
RevenueEventItemInvoiceItemAdjustment.productId = Product.id
ProductRatePlan
RevenueEventItemInvoiceItemAdjustment.productId = ProductRatePlan.productId
RevenueEventItemInvoiceItemAdjustment.productRatePlanId = ProductRatePlan.id
ProductRatePlanCharge
RevenueEventItemInvoiceItemAdjustment.productRatePlanChargeId = ProductRatePlanCharge.id
RevenueEventItemInvoiceItemAdjustment.productRatePlanId = ProductRatePlanCharge.productRatePlanId
ProductRatePlanChargeTier
RevenueEventItemInvoiceItemAdjustment.productRatePlanChargeId = ProductRatePlanChargeTier.productRatePlanChargeId
RevenueEventItemInvoiceItemAdjustment.productRatePlanId = ProductRatePlanChargeTier.productRatePlanId
RevenueEventItemInvoiceItemAdjustment.ratePlanChargeId = ProductRatePlanChargeTier.ratePlanChargeId
RevenueEventItemInvoiceItemAdjustment.ratePlanId = ProductRatePlanChargeTier.ratePlanId
RatePlanCharge
RevenueEventItemInvoiceItemAdjustment.ratePlanChargeId = RatePlanCharge.id
AccountingCode
RevenueEventItemInvoiceItemAdjustment.recognizedRevenueAccountingCodeId = AccountingCode.id
Subscription
RevenueEventItemInvoiceItemAdjustment.subscriptionId = Subscription.id

accountId

STRING

accountingPeriodId

STRING

amendmentId

STRING

amount

DOUBLE

billToContactId

STRING

createdById

STRING

createdDate

DATE-TIME

currency

STRING

defaultPaymentMethodId

STRING

deferredRevenueAccountingCodeId

STRING

deleted

BOOLEAN

id

STRING

invoiceId

STRING

invoiceItemAdjustmentId

STRING

invoiceItemId

STRING

journalEntryId

STRING

journalRunId

STRING

parentAccountId

STRING

productId

STRING

productRatePlanChargeId

STRING

productRatePlanId

STRING

ratePlanChargeId

STRING

ratePlanId

STRING

recognizedRevenueAccountingCodeId

STRING

revenueChargeSummaryId

STRING

revenueEventInvoiceId

STRING

revenueEventInvoiceItemAdjustmentId

STRING

revenueEventTypeId

STRING

revenueScheduleInvoiceItemAdjustmentId

STRING

soldToContactId

STRING

subscriptionId

STRING

updatedById

STRING

updatedDate

DATE-TIME

RevenueScheduleItem

The RevenueScheduleItem table contains information about revenue schedules. A revenue schedule represents how revenue amounts from single charges are distributed over time and recognized in accounting periods.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedDate

Useful links

Zuora documentation

Join RevenueScheduleItem with on
AccountingPeriod
RevenueScheduleItem.accountingPeriodId = AccountingPeriod.id
CreditBalanceAdjustment
RevenueScheduleItem.accountingPeriodId = CreditBalanceAdjustment.accountingPeriodId
RevenueScheduleItem.billToContactId = CreditBalanceAdjustment.billToContactId
RevenueScheduleItem.soldToContactId = CreditBalanceAdjustment.billToContactId
RevenueScheduleItem.billToContactId = CreditBalanceAdjustment.soldToContactId
RevenueScheduleItem.soldToContactId = CreditBalanceAdjustment.soldToContactId
RevenueScheduleItem.parentAccountId = CreditBalanceAdjustment.parentAccountId
InvoiceItemAdjustment
RevenueScheduleItem.accountingPeriodId = InvoiceItemAdjustment.accountingPeriodId
RevenueScheduleItem.amendmentId = InvoiceItemAdjustment.amendmentId
RevenueScheduleItem.billToContactId = InvoiceItemAdjustment.billToContactId
RevenueScheduleItem.soldToContactId = InvoiceItemAdjustment.billToContactId
RevenueScheduleItem.billToContactId = InvoiceItemAdjustment.soldToContactId
RevenueScheduleItem.soldToContactId = InvoiceItemAdjustment.soldToContactId
RevenueScheduleItem.parentAccountId = InvoiceItemAdjustment.parentAccountId
RevenueScheduleItem.productId = InvoiceItemAdjustment.productId
RevenueScheduleItem.productRatePlanChargeId = InvoiceItemAdjustment.productRatePlanChargeId
RevenueScheduleItem.ratePlanChargeId = InvoiceItemAdjustment.ratePlanChargeId
RevenueScheduleItem.ratePlanId = InvoiceItemAdjustment.ratePlanId
RevenueScheduleItem.recognizedRevenueAccountingCodeId = InvoiceItemAdjustment.recognizedRevenueAccountingCodeId
JournalEntry
RevenueScheduleItem.accountingPeriodId = JournalEntry.accountingPeriodId
RevenueChargeSummaryItem
RevenueScheduleItem.accountingPeriodId = RevenueChargeSummaryItem.accountingPeriodId
RevenueScheduleItem.amendmentId = RevenueChargeSummaryItem.amendmentId
RevenueScheduleItem.billToContactId = RevenueChargeSummaryItem.billToContactId
RevenueScheduleItem.soldToContactId = RevenueChargeSummaryItem.billToContactId
RevenueScheduleItem.billToContactId = RevenueChargeSummaryItem.soldToContactId
RevenueScheduleItem.soldToContactId = RevenueChargeSummaryItem.soldToContactId
RevenueScheduleItem.parentAccountId = RevenueChargeSummaryItem.parentAccountId
RevenueScheduleItem.productId = RevenueChargeSummaryItem.productId
RevenueScheduleItem.productRatePlanChargeId = RevenueChargeSummaryItem.productRatePlanChargeId
RevenueScheduleItem.productRatePlanId = RevenueChargeSummaryItem.productRatePlanId
RevenueScheduleItem.ratePlanChargeId = RevenueChargeSummaryItem.ratePlanChargeId
RevenueScheduleItem.ratePlanId = RevenueChargeSummaryItem.ratePlanId
RevenueScheduleItem.revenueChargeSummaryId = RevenueChargeSummaryItem.revenueChargeSummaryId
RevenueEventItemInvoiceItem
RevenueScheduleItem.accountingPeriodId = RevenueEventItemInvoiceItem.accountingPeriodId
RevenueScheduleItem.amendmentId = RevenueEventItemInvoiceItem.amendmentId
RevenueScheduleItem.billToContactId = RevenueEventItemInvoiceItem.billToContactId
RevenueScheduleItem.soldToContactId = RevenueEventItemInvoiceItem.billToContactId
RevenueScheduleItem.billToContactId = RevenueEventItemInvoiceItem.soldToContactId
RevenueScheduleItem.soldToContactId = RevenueEventItemInvoiceItem.soldToContactId
RevenueScheduleItem.deferredRevenueAccountingCodeId = RevenueEventItemInvoiceItem.deferredRevenueAccountingCodeId
RevenueScheduleItem.parentAccountId = RevenueEventItemInvoiceItem.parentAccountId
RevenueScheduleItem.productId = RevenueEventItemInvoiceItem.productId
RevenueScheduleItem.productRatePlanChargeId = RevenueEventItemInvoiceItem.productRatePlanChargeId
RevenueScheduleItem.productRatePlanId = RevenueEventItemInvoiceItem.productRatePlanId
RevenueScheduleItem.ratePlanChargeId = RevenueEventItemInvoiceItem.ratePlanChargeId
RevenueScheduleItem.ratePlanId = RevenueEventItemInvoiceItem.ratePlanId
RevenueScheduleItem.recognizedRevenueAccountingCodeId = RevenueEventItemInvoiceItem.recognizedRevenueAccountingCodeId
RevenueScheduleItem.revenueChargeSummaryId = RevenueEventItemInvoiceItem.revenueChargeSummaryId
RevenueEventItemInvoiceItemAdjustment
RevenueScheduleItem.accountingPeriodId = RevenueEventItemInvoiceItemAdjustment.accountingPeriodId
RevenueScheduleItem.amendmentId = RevenueEventItemInvoiceItemAdjustment.amendmentId
RevenueScheduleItem.billToContactId = RevenueEventItemInvoiceItemAdjustment.billToContactId
RevenueScheduleItem.soldToContactId = RevenueEventItemInvoiceItemAdjustment.billToContactId
RevenueScheduleItem.billToContactId = RevenueEventItemInvoiceItemAdjustment.soldToContactId
RevenueScheduleItem.soldToContactId = RevenueEventItemInvoiceItemAdjustment.soldToContactId
RevenueScheduleItem.deferredRevenueAccountingCodeId = RevenueEventItemInvoiceItemAdjustment.deferredRevenueAccountingCodeId
RevenueScheduleItem.parentAccountId = RevenueEventItemInvoiceItemAdjustment.parentAccountId
RevenueScheduleItem.productId = RevenueEventItemInvoiceItemAdjustment.productId
RevenueScheduleItem.productRatePlanChargeId = RevenueEventItemInvoiceItemAdjustment.productRatePlanChargeId
RevenueScheduleItem.productRatePlanId = RevenueEventItemInvoiceItemAdjustment.productRatePlanId
RevenueScheduleItem.ratePlanChargeId = RevenueEventItemInvoiceItemAdjustment.ratePlanChargeId
RevenueScheduleItem.ratePlanId = RevenueEventItemInvoiceItemAdjustment.ratePlanId
RevenueScheduleItem.recognizedRevenueAccountingCodeId = RevenueEventItemInvoiceItemAdjustment.recognizedRevenueAccountingCodeId
RevenueScheduleItem.revenueChargeSummaryId = RevenueEventItemInvoiceItemAdjustment.revenueChargeSummaryId
RevenueScheduleItemInvoiceItem
RevenueScheduleItem.accountingPeriodId = RevenueScheduleItemInvoiceItem.accountingPeriodId
RevenueScheduleItem.amendmentId = RevenueScheduleItemInvoiceItem.amendmentId
RevenueScheduleItem.billToContactId = RevenueScheduleItemInvoiceItem.billToContactId
RevenueScheduleItem.soldToContactId = RevenueScheduleItemInvoiceItem.billToContactId
RevenueScheduleItem.billToContactId = RevenueScheduleItemInvoiceItem.soldToContactId
RevenueScheduleItem.soldToContactId = RevenueScheduleItemInvoiceItem.soldToContactId
RevenueScheduleItem.deferredRevenueAccountingCodeId = RevenueScheduleItemInvoiceItem.deferredRevenueAccountingCodeId
RevenueScheduleItem.parentAccountId = RevenueScheduleItemInvoiceItem.parentAccountId
RevenueScheduleItem.productId = RevenueScheduleItemInvoiceItem.productId
RevenueScheduleItem.productRatePlanChargeId = RevenueScheduleItemInvoiceItem.productRatePlanChargeId
RevenueScheduleItem.productRatePlanId = RevenueScheduleItemInvoiceItem.productRatePlanId
RevenueScheduleItem.ratePlanChargeId = RevenueScheduleItemInvoiceItem.ratePlanChargeId
RevenueScheduleItem.ratePlanId = RevenueScheduleItemInvoiceItem.ratePlanId
RevenueScheduleItem.recognizedRevenueAccountingCodeId = RevenueScheduleItemInvoiceItem.recognizedRevenueAccountingCodeId
RevenueScheduleItem.revenueChargeSummaryId = RevenueScheduleItemInvoiceItem.revenueChargeSummaryId
RevenueScheduleItemInvoiceItemAdjustment
RevenueScheduleItem.accountingPeriodId = RevenueScheduleItemInvoiceItemAdjustment.accountingPeriodId
RevenueScheduleItem.amendmentId = RevenueScheduleItemInvoiceItemAdjustment.amendmentId
RevenueScheduleItem.billToContactId = RevenueScheduleItemInvoiceItemAdjustment.billToContactId
RevenueScheduleItem.soldToContactId = RevenueScheduleItemInvoiceItemAdjustment.billToContactId
RevenueScheduleItem.billToContactId = RevenueScheduleItemInvoiceItemAdjustment.soldToContactId
RevenueScheduleItem.soldToContactId = RevenueScheduleItemInvoiceItemAdjustment.soldToContactId
RevenueScheduleItem.deferredRevenueAccountingCodeId = RevenueScheduleItemInvoiceItemAdjustment.deferredRevenueAccountingCodeId
RevenueScheduleItem.parentAccountId = RevenueScheduleItemInvoiceItemAdjustment.parentAccountId
RevenueScheduleItem.productId = RevenueScheduleItemInvoiceItemAdjustment.productId
RevenueScheduleItem.productRatePlanChargeId = RevenueScheduleItemInvoiceItemAdjustment.productRatePlanChargeId
RevenueScheduleItem.productRatePlanId = RevenueScheduleItemInvoiceItemAdjustment.productRatePlanId
RevenueScheduleItem.ratePlanChargeId = RevenueScheduleItemInvoiceItemAdjustment.ratePlanChargeId
RevenueScheduleItem.ratePlanId = RevenueScheduleItemInvoiceItemAdjustment.ratePlanId
RevenueScheduleItem.recognizedRevenueAccountingCodeId = RevenueScheduleItemInvoiceItemAdjustment.recognizedRevenueAccountingCodeId
RevenueScheduleItem.revenueChargeSummaryId = RevenueScheduleItemInvoiceItemAdjustment.revenueChargeSummaryId
Amendment
RevenueScheduleItem.amendmentId = Amendment.id
DiscountAppliedMetrics
RevenueScheduleItem.amendmentId = DiscountAppliedMetrics.amendmentId
RevenueScheduleItem.billToContactId = DiscountAppliedMetrics.billToContactId
RevenueScheduleItem.soldToContactId = DiscountAppliedMetrics.billToContactId
RevenueScheduleItem.billToContactId = DiscountAppliedMetrics.soldToContactId
RevenueScheduleItem.soldToContactId = DiscountAppliedMetrics.soldToContactId
RevenueScheduleItem.parentAccountId = DiscountAppliedMetrics.parentAccountId
RevenueScheduleItem.productId = DiscountAppliedMetrics.productId
RevenueScheduleItem.productRatePlanChargeId = DiscountAppliedMetrics.productRatePlanChargeId
RevenueScheduleItem.productRatePlanId = DiscountAppliedMetrics.productRatePlanId
RevenueScheduleItem.ratePlanChargeId = DiscountAppliedMetrics.ratePlanChargeId
RevenueScheduleItem.ratePlanId = DiscountAppliedMetrics.ratePlanId
ProcessedUsage
RevenueScheduleItem.amendmentId = ProcessedUsage.amendmentId
RevenueScheduleItem.billToContactId = ProcessedUsage.billToContactId
RevenueScheduleItem.soldToContactId = ProcessedUsage.billToContactId
RevenueScheduleItem.billToContactId = ProcessedUsage.soldToContactId
RevenueScheduleItem.soldToContactId = ProcessedUsage.soldToContactId
RevenueScheduleItem.parentAccountId = ProcessedUsage.parentAccountId
RevenueScheduleItem.productId = ProcessedUsage.productId
RevenueScheduleItem.productRatePlanChargeId = ProcessedUsage.productRatePlanChargeId
RevenueScheduleItem.productRatePlanId = ProcessedUsage.productRatePlanId
RevenueScheduleItem.ratePlanChargeId = ProcessedUsage.ratePlanChargeId
RevenueScheduleItem.ratePlanId = ProcessedUsage.ratePlanId
RatePlan
RevenueScheduleItem.amendmentId = RatePlan.amendmentId
RevenueScheduleItem.billToContactId = RatePlan.billToContactId
RevenueScheduleItem.soldToContactId = RatePlan.billToContactId
RevenueScheduleItem.productRatePlanId = RatePlan.productRatePlanId
RevenueScheduleItem.ratePlanId = RatePlan.id
RatePlanChargeTier
RevenueScheduleItem.amendmentId = RatePlanChargeTier.amendmentId
RevenueScheduleItem.productRatePlanId = RatePlanChargeTier.productRatePlanId
RevenueScheduleItem.ratePlanChargeId = RatePlanChargeTier.ratePlanChargeId
RevenueScheduleItem.ratePlanId = RatePlanChargeTier.ratePlanId
RevenueEventItem
RevenueScheduleItem.amendmentId = RevenueEventItem.amendmentId
RevenueScheduleItem.billToContactId = RevenueEventItem.billToContactId
RevenueScheduleItem.soldToContactId = RevenueEventItem.billToContactId
RevenueScheduleItem.billToContactId = RevenueEventItem.soldToContactId
RevenueScheduleItem.soldToContactId = RevenueEventItem.soldToContactId
RevenueScheduleItem.deferredRevenueAccountingCodeId = RevenueEventItem.deferredRevenueAccountingCodeId
RevenueScheduleItem.parentAccountId = RevenueEventItem.parentAccountId
RevenueScheduleItem.productId = RevenueEventItem.productId
RevenueScheduleItem.productRatePlanChargeId = RevenueEventItem.productRatePlanChargeId
RevenueScheduleItem.productRatePlanId = RevenueEventItem.productRatePlanId
RevenueScheduleItem.ratePlanChargeId = RevenueEventItem.ratePlanChargeId
RevenueScheduleItem.ratePlanId = RevenueEventItem.ratePlanId
RevenueScheduleItem.recognizedRevenueAccountingCodeId = RevenueEventItem.recognizedRevenueAccountingCodeId
RevenueScheduleItem.revenueChargeSummaryId = RevenueEventItem.revenueChargeSummaryId
Account
RevenueScheduleItem.billToContactId = Account.billToContactId
RevenueScheduleItem.soldToContactId = Account.billToContactId
RevenueScheduleItem.billToContactId = Account.soldToContactId
RevenueScheduleItem.soldToContactId = Account.soldToContactId
RevenueScheduleItem.deferredRevenueAccountingCodeId = Account.id
RevenueScheduleItem.parentAccountId = Account.parentAccountId
Contact
RevenueScheduleItem.billToContactId = Contact.id
RevenueScheduleItem.soldToContactId = Contact.id
ContactSnapshot
RevenueScheduleItem.billToContactId = ContactSnapshot.contactId
RevenueScheduleItem.soldToContactId = ContactSnapshot.contactId
Invoice
RevenueScheduleItem.billToContactId = Invoice.billToContactId
RevenueScheduleItem.soldToContactId = Invoice.billToContactId
RevenueScheduleItem.billToContactId = Invoice.soldToContactId
RevenueScheduleItem.soldToContactId = Invoice.soldToContactId
RevenueScheduleItem.parentAccountId = Invoice.parentAccountId
Refund
RevenueScheduleItem.billToContactId = Refund.billToContactId
RevenueScheduleItem.soldToContactId = Refund.billToContactId
RevenueScheduleItem.billToContactId = Refund.soldToContactId
RevenueScheduleItem.soldToContactId = Refund.soldToContactId
RevenueScheduleItem.parentAccountId = Refund.parentAccountId
Product
RevenueScheduleItem.productId = Product.id
InvoiceItem
RevenueScheduleItem.productId = InvoiceItem.productId
RevenueScheduleItem.productRatePlanChargeId = InvoiceItem.productRatePlanChargeId
RevenueScheduleItem.ratePlanChargeId = InvoiceItem.ratePlanChargeId
ProductRatePlan
RevenueScheduleItem.productId = ProductRatePlan.productId
RevenueScheduleItem.productRatePlanId = ProductRatePlan.id
ProductRatePlanCharge
RevenueScheduleItem.productRatePlanChargeId = ProductRatePlanCharge.id
RevenueScheduleItem.productRatePlanId = ProductRatePlanCharge.productRatePlanId
ProductRatePlanChargeTier
RevenueScheduleItem.productRatePlanChargeId = ProductRatePlanChargeTier.productRatePlanChargeId
RevenueScheduleItem.productRatePlanId = ProductRatePlanChargeTier.productRatePlanId
RevenueScheduleItem.ratePlanChargeId = ProductRatePlanChargeTier.ratePlanChargeId
RevenueScheduleItem.ratePlanId = ProductRatePlanChargeTier.ratePlanId
RatePlanCharge
RevenueScheduleItem.ratePlanChargeId = RatePlanCharge.id
AccountingCode
RevenueScheduleItem.recognizedRevenueAccountingCodeId = AccountingCode.id

accountId

STRING

accountingPeriodId

STRING

amendmentId

STRING

amount

DOUBLE

billToContactId

STRING

createdById

STRING

createdDate

DATE-TIME

currency

STRING

defaultPaymentMethodId

STRING

deferredRevenueAccountingCodeId

STRING

deleted

BOOLEAN

id

STRING

parentAccountId

STRING

productId

STRING

productRatePlanChargeId

STRING

productRatePlanId

STRING

ratePlanChargeId

STRING

ratePlanId

STRING

recognizedRevenueAccountingCodeId

STRING

revenueChargeSummaryId

STRING

revenueEventId

STRING

revenueEventTypeId

STRING

revenueScheduleId

STRING

soldToContactId

STRING

subscription

STRING

updatedById

STRING

updatedDate

DATE-TIME

RevenueScheduleItemInvoiceItem

The RevenueScheduleItemInvoiceItem table contains information about revenue schedule item - invoice items.

Replication Method

Key-based Incremental