Data Sources and Objects

A comprehensive list of objects available in each data source, highlighting dependencies on Zuora features and offering guidance on data source object availability.

Objects marked with * depend on Zuora features.

Data Source	Objects
Account	Base object: Account Joined objects: BillToContact DefaultPaymentMethod Entity * ParentAccount * SoldToContact
Accounting Code	Base object: AccountingCode Joined objects: Entity *
Application Group Part of the Invoice Settlement feature.	Base object: ApplicationGroup Joined objects: Entity * Payment PaymentMethod PaymentMethodSnapshot Refund
AR Transaction	Base object: AR Transaction Joined objects: Account >Credit Accounting Code >Credit Memo >Credit Memo Item >Credit Taxation Item >Debit Accounting Code >Debit Memo >Debit Memo Item >Debit Taxation Item >Default Payment Method >Invoice >Invoice Item >Payment >Payment Method >Product >Product Rate Plan Charge >Rate Plan >Rate Plan Charge >Refund >Taxation Item
Billing Run	Base object: BillingRun The BillingRun object is different from the BillRun object. Joined objects: Entity *
Billing Transaction	Base object: Billing Transaction Joined objects: Amendment Bill To Default Payment Method Discount Applied To Rate Plan Charge Entity Parent Account Product Product Rate Plan Product Rate Plan Charge Rate Plan Rate Plan Charge Sold To Subscription Subscription Owner Subscription Rate Plan
Booking Transaction	Base object: Booking Transaction Joined objects: Amendment Bill To Default Payment Method Discount Applied To Rate Plan Charge Discount Applied To Subscription Rate Plan Entity Invoice Owner Invoice Schedule Order Order Line Item Parent Account Product Product Rate Plan Product Rate Plan Charge Rate Plan Rate Plan Charge Sold To Subscription Subscription Owner Subscription Rate Plan
Contact	Base object: Contact Joined objects: Entity *
Credit Balance Adjustment Part of the Credit Balance feature. Deprecated if the Invoice Settlement feature is enabled.	Base object: CreditBalanceAdjustment Joined objects: Account AccountReceivableAccountingCode AccountingPeriod * BillToContact CashAccountingCode CustomerCashOnAccountAccountingCode DefaultPaymentMethod Entity * Invoice JournalEntry * JournalRun * ParentAccount * Payment PaymentMethod PaymentMethodSnapshot Refund SoldToContact
Credit Memo Part of the Invoice Settlement feature.	Base object: CreditMemo Joined objects: Account BillToContact DefaultPaymentMethod Entity * Invoice ParentAccount * SoldToContact
Credit Memo Application Part of the Invoice Settlement feature.	Base object: CreditMemoApplication Joined objects: Account ApplicationGroup BillToContact CreditMemo DebitMemo DefaultPaymentMethod Entity * Invoice ParentAccount * SoldToContact
Credit Memo Application Item Part of the Invoice Settlement feature.	Base object: CreditMemoApplicationItem Joined objects: Account AccountingPeriod * ApplicationGroup BillToContact CreditMemo CreditMemoApplication CreditMemoItem CreditTaxationItem DebitMemo DebitMemoItem DebitTaxationItem DefaultPaymentMethod Entity * Invoice InvoiceItem JournalEntry * JournalRun * ParentAccount * SoldToContact TaxationItem
Credit Memo Item Part of the Invoice Settlement feature.	Base object: CreditMemoItem Joined objects: Account AccountReceivableAccountingCode AccountingPeriod * Amendment BillToContact CreditMemo DefaultPaymentMethod DeferredRevenueAccountingCode Entity * Invoice InvoiceItem JournalEntry * JournalRun * OnAccountAccountingCode ParentAccount * Product ProductRatePlan ProductRatePlanCharge RatePlan RatePlanCharge RecognizedRevenueAccountingCode SoldToContact Subscription
Credit Memo Part Part of the Invoice Settlement feature.	Base object: CreditMemoPart Joined objects: Account BillToContact CreditMemo DebitMemo DefaultPaymentMethod Entity * Invoice ParentAccount * SoldToContact
Credit Memo Part Item Part of the Invoice Settlement feature.	Base object: CreditMemoPartItem Joined objects: Account BillToContact CreditMemo CreditMemoItem CreditMemoPart CreditTaxationItem DebitMemo DebitMemoItem DebitTaxationItem DefaultPaymentMethod Entity * Invoice InvoiceItem ParentAccount * SoldToContact TaxationItem
Credit Taxation Item Part of the Invoice Settlement feature.	Base object: CreditTaxationItem Joined objects: Account AccountReceivableAccountingCode AccountingPeriod * Amendment BillToContact CreditMemo CreditMemoItem DefaultPaymentMethod Entity * Invoice JournalEntry * JournalRun * OnAccountAccountingCode ParentAccount * Product ProductRatePlan ProductRatePlanCharge RatePlan RatePlanCharge SalesTaxPayableAccountingCode SoldToContact Subscription TaxationItem
Custom Exchange Rate Part of the Custom Foreign Currency Exchange Rates feature.	Base object: FXCustomRate Joined objects: Entity *
Daily Consumption Summary Part of the Prepaid with Drawdown feature.	Base object: DailyConsumptionSummary Joined objects: PrepaidBalanceFund Product ProductRatePlan ProductRatePlanCharge RatePlan RatePlanCharge
Debit Memo Part of the Invoice Settlement feature.	Base object: DebitMemo Joined objects: Account BillToContact DefaultPaymentMethod Entity * Invoice ParentAccount * SoldToContact
Debit Memo Item Part of the Invoice Settlement feature.	Base object: DebitMemoItem Joined objects: Account AccountReceivableAccountingCode AccountingPeriod * Amendment BillToContact DebitMemo DefaultPaymentMethod DeferredRevenueAccountingCode Entity * Invoice InvoiceItem JournalEntry * JournalRun * ParentAccount * Product ProductRatePlan ProductRatePlanCharge RatePlan RatePlanCharge RecognizedRevenueAccountingCode SoldToContact Subscription
Debit Taxation Item Part of the Invoice Settlement feature.	Base object: DebitTaxationItem Joined objects: Account AccountReceivableAccountingCode AccountingPeriod * Amendment BillToContact DebitMemo DebitMemoItem DefaultPaymentMethod Entity * Invoice JournalEntry * JournalRun * ParentAccount * Product ProductRatePlan ProductRatePlanCharge RatePlan RatePlanCharge SalesTaxPayableAccountingCode SoldToContact Subscription TaxationItem
Discount Applied Metrics Limited Availability feature.	Base object:DiscountAppliedMetrics Joined objects: Account Amendment BillToContact DefaultPaymentMethod Entity * ParentAccount * Product ProductRatePlan ProductRatePlanCharge RatePlan RatePlanCharge SoldToContact Subscription
Gateway Reconciliation Event	Base object: PaymentGatewayReconciliationEventLog Joined objects: Entity * PaymentReconciliationJob
Gateway Reconciliation Log	Base object: PaymentReconciliationLog Joined objects: Entity * PaymentGatewayReconciliationEventLog PaymentReconciliationJob
Guided Usage Part of the Unbilled Usage feature.	Base object: GuidedUsage Joined objects: Account BillTo DefaultPaymentMethod ParentAccount Product ProductRatePlan ProductRatePlanCharge RatePlan RatePlanCharge SoldTo Subscription Usage
Invoice	Base object: Invoice Joined objects: Account BillToContact BillToContactSnapshot * DefaultPaymentMethod Entity * ParentAccount * SoldToContact SoldToContactSnapshot *
Invoice Adjustment Deprecated if the Invoice Settlement feature is enabled.	Base object: InvoiceAdjustment Joined objects: Account AccountReceivableAccountingCode AccountingPeriod * BillToContact DefaultPaymentMethod DeferredRevenueAccountingCode Entity * Invoice JournalEntry * JournalRun * ParentAccount * SoldToContact
Invoice Item	Base object: InvoiceItem Joined objects: Account AccountReceivableAccountingCode AccountingPeriod * Amendment BillToContact BillToContactSnapshot * DefaultPaymentMethod DeferredRevenueAccountingCode Entity * Invoice JournalEntry * JournalRun * ParentAccount * Product ProductRatePlan ProductRatePlanCharge RatePlan RatePlanCharge RecognizedRevenueAccountingCode SoldToContact SoldToContactSnapshot * Subscription
Invoice Item Adjustment Deprecated if the Invoice Settlement feature is enabled.	Base object: InvoiceItemAdjustment Joined objects: Account AccountReceivableAccountingCode AccountingPeriod * Amendment BillToContact DefaultPaymentMethod DeferredRevenueAccountingCode Entity * Invoice InvoiceItem JournalEntry * JournalRun * ParentAccount * Product ProductRatePlan ProductRatePlanCharge RatePlan RatePlanCharge RecognizedRevenueAccountingCode SalesTaxPayableAccountingCode SoldToContact Subscription TaxationItem
Invoice Payment Deprecated if the Invoice Settlement feature is enabled.	Base object: InvoicePayment Joined objects: Account AccountReceivableAccountingCode AccountingPeriod * BillToContact CashAccountingCode DefaultPaymentMethod Entity * Invoice JournalEntry * JournalRun * ParentAccount * Payment PaymentMethod PaymentMethodSnapshot SoldToContact
Journal Entry Item Requires Zuora Finance.	Base object: JournalEntryItem Joined objects: AccountingCode AccountingPeriod * Entity * JournalEntry * JournalRun *
Notification History - Email	Base object: EmailHistory Joined objects: Account BillToContact DefaultPaymentMethod ParentAccount * SoldToAccount
Notification History - Callout	Base object: CalloutHistory Joined objects: Account BillToContact DefaultPaymentMethod ParentAccount * SoldToAccount
Order Part of the Order Metrics feature.	Base object: Order Joined objects: Account BillToContact DefaultPaymentMethod ParentAccount * SoldToAccount
Order Action Part of the Order Metrics feature.	Base object: OrderAction Joined objects: Account Add Rate Plan BillToContact DefaultPaymentMethod Order ParentAccount * Remove Rate Plan SoldToContact Subscription SubscriptionVersionAmendment Update Rate Plan
Order Contact Part of the Order Metrics feature.	Base object: OrderContact Joined objects: None
Order Elp Part of the Order Metrics feature.	Base object: OrderElp Joined objects: Account Amendment BillToContact DefaultPaymentMethod Entity * Order OrderAction ParentAccount * Product ProductRatePlan ProductRatePlanCharge RatePlan RatePlanCharge SoldToContact Subscription SubscriptionVersionAmendment
Order Item Part of the Order Metrics feature.	Base object: OrderItem Joined objects: Amendment Entity * Order OrderAction Product ProductRatePlan ProductRatePlanCharge RatePlan RatePlanCharge Subscription
Order Line Item Part of the Order Metrics feature.	Base object: OrderLineItem Joined objects: Account BillToContact DefaultPaymentMethod Order OrderContact SoldToContact ParentAccount *
Order Mrr Part of the Order Metrics feature.	Base object: OrderMrr Joined objects: Account Amendment BillToContact DefaultPaymentMethod Order OrderAction ParentAccount * Product ProductRatePlan ProductRatePlanCharge RatePlan RatePlanCharge SoldToContact Subscription SubscriptionVersionAmendment
Order Quantity Part of the Order Metrics feature.	Base object: OrderQuantity Joined objects: Account Amendment BillToContact DefaultPaymentMethod Order OrderAction ParentAccount * Product ProductRatePlan ProductRatePlanCharge RatePlan RatePlanCharge SoldToContact Subscription SubscriptionVersionAmendment
Order Tcb Part of the Order Metrics feature.	Base object: OrderTcb Joined objects: Account Amendment BillToContact DefaultPaymentMethod Order OrderAction ParentAccount * Product ProductRatePlan ProductRatePlanCharge RatePlan RatePlanCharge SoldToContact Subscription SubscriptionVersionAmendment
Order Tcv Part of the Order Metrics feature.	Base object: OrderTcv Joined objects: Account Amendment BillToContact DefaultPaymentMethod Order OrderAction ParentAccount * Product ProductRatePlan ProductRatePlanCharge RatePlan RatePlanCharge SoldToContact Subscription SubscriptionVersionAmendment
Payment	Base object: Payment Joined objects: Account BillToContact DefaultPaymentMethod Entity * ParentAccount * PaymentMethod PaymentMethodSnapshot SoldToContact
Payment Application Part of the Invoice Settlement feature.	Base object: PaymentApplication Joined objects: Account AccountReceivableAccountingCode AccountingPeriod * ApplicationGroup BillToContact CashAccountingCode DebitMemo DefaultPaymentMethod Entity * Invoice JournalEntry * JournalRun * ParentAccount * Payment PaymentMethod PaymentMethodSnapshot SoldToContact UnappliedPaymentAccountingCode
Payment Application Item Part of the Invoice Item Settlement feature.	Base object: PaymentApplicationItem Joined objects: Account AccountReceivableAccountingCode AccountingPeriod * ApplicationGroup BillToContact CashAccountingCode DebitMemo DebitMemoItem DebitTaxationItem DefaultPaymentMethod Entity * Invoice InvoiceItem JournalEntry * JournalRun * ParentAccount * Payment PaymentApplication PaymentMethod PaymentMethodSnapshot SoldToContact TaxationItem UnappliedPaymentAccountingCode
Payment Method	Base object: PaymentMethod Joined objects: Entity * StoredCredentialProfile If you want to query data by joining Payment Method and Stored Credential Profile, use StoredCredentialProfile as the base object to achieve better query performance.
Payment Method Transaction Log	Base object: PaymentMethodTransactionLog Joined objects: Account BillToContact DefaultPaymentMethod Entity * ParentAccount * PaymentMethod SoldToContact
Payment Method Update	Base object: UpdaterDetail Joined objects: Entity * NewPaymentMethod PaymentMethod UpdaterBatch
Payment Part Part of the Invoice Settlement feature.	Base object: PaymentPart Joined objects: Account BillToContact DebitMemo DefaultPaymentMethod Entity * Invoice ParentAccount * Payment PaymentMethod PaymentMethodSnapshot SoldToContact
Payment Part Item Part of the Invoice Item Settlement feature.	Base object: PaymentPartItem Joined objects: Account BillToContact DebitMemo DebitMemoItem DebitTaxationItem DefaultPaymentMethod Entity * Invoice InvoiceItem ParentAccount * Payment PaymentMethod PaymentMethodSnapshot PaymentPart SoldToContact TaxationItem
Payment Run	Base object:PaymentRun Joined objects: Entity *
Payment Schedule	Base object: PaymentSchedule Joined objects: Account Bill To Debit Memo Default Payment Method Invoice Parent Account Payment Schedule Sold To
Payment Schedule Item	Base object: PaymentScheduleItem Joined objects: Account Bill To Debit Memo Default Payment Method Invoice Parent Account Payment Payment Method Payment Method Snapshot Payment Schedule Payment Schedule Item Sold To
Payment Schedule Item Payment	Base object: PaymentScheduleItemPart Joined objects: Payment Schedule Item Payment Entity Payment Payment Method Payment Method Snapshot Payment Schedule Item
Payment Transaction Log	Base object: PaymentTransactionLog Joined objects: Account BillToContact DefaultPaymentMethod Entity * ParentAccount * Payment PaymentMethod PaymentMethodSnapshot SoldToContact
Prepaid Balance Fund Part of the Prepaid with Drawdown feature.	Base object: Fund Joined objects: Product ProductRatePlan ProductRatePlanCharge RatePlan RatePlanCharge
Prepaid Validity Period Summary Part of the Prepaid with Drawdown feature.	Base object: PrepaidValidityPeriodSummary
Processed Usage	Base object: ProcessedUsage Joined objects: Account Amendment BillToContact DefaultPaymentMethod Entity * Invoice InvoiceItem ParentAccount * Product ProductRatePlan ProductRatePlanCharge RatePlan RatePlanCharge SoldToContact Subscription Usage
Product	Base object: Product Joined objects: Entity *
Product Rate Plan Charge	Base object: ProductRatePlanCharge Joined objects: AccountReceivableAccountingCode AdjustmentLiabilityAccountingCode AdjustmentRevenueAccountingCode ContractAssetAccountingCode ContractLiabilityAccountingCode ContractRecognizedRevenueAccountingCode DeferredRevenueAccountingCode Entity * Product ProductRatePlan RecognizedRevenueAccountingCode UnbilledReceivablesAccountingCode
Product Rate Plan Charge Tier	Base object: ProductRatePlanChargeTier Joined objects: Entity * Product ProductRatePlan ProductRatePlanCharge
Rate Plan	Base object: RatePlan Joined objects: Account Amendment BillToContact DefaultPaymentMethod Entity * ParentAccount * Product ProductRatePlan SoldToContact Subscription SubscriptionVersionAmendment
Rate Plan Charge	Base object: RatePlanCharge Joined objects: Account AccountReceivableAccountingCode Amendment BillToContact DefaultPaymentMethod DeferredRevenueAccountingCode Entity * ParentAccount * Product ProductRatePlan ProductRatePlanCharge RatePlan RecognizedRevenueAccountingCode SoldToContact Subscription
Rate Plan Charge Tier	Base object: RatePlanChargeTier Joined objects: Amendment Entity * Product ProductRatePlan ProductRatePlanCharge RatePlan RatePlanCharge Subscription
Rating Result Part of the Unbilled Usage feature.	Base object: RatingResult Joined objects: Account BillTo DefaultPaymentMethod Invoice InvoiceItem ParentAccount Product ProductRatePlan ProductRatePlanCharge RatePlan RatePlanCharge SoldTo Subscription
Refund	Base object: Refund Joined objects: Account BillToContact DefaultPaymentMethod Entity * ParentAccount * PaymentMethodSnapshot SoldToContact
Refund Application Part of the Invoice Settlement feature.	Base object: RefundApplication Joined objects: Account AccountReceivableAccountingCode AccountingPeriod * ApplicationGroup BillToContact CashAccountingCode CreditMemo DefaultPaymentMethod Entity * JournalEntry * JournalRun * OnAccountAccountingCode ParentAccount * Payment PaymentMethod PaymentMethodSnapshot Refund SoldToContact UnappliedPaymentAccountingCode
Refund Application Item Part of the Invoice Item Settlement feature.	Base object: RefundApplicationItem Joined objects: Account AccountReceivableAccountingCode AccountingPeriod * ApplicationGroup BillToContact CashAccountingCode CreditMemo CreditMemoItem CreditTaxationItem DefaultPaymentMethod Entity * JournalEntry * JournalRun * OnAccountAccountingCode ParentAccount * Payment PaymentMethod PaymentMethodSnapshot Refund RefundApplication SoldToContact UnappliedPaymentAccountingCode
Refund Invoice Payment Deprecated if the Invoice Settlement feature is enabled.	Base object: RefundInvoicePayment Joined objects: Account AccountReceivableAccountingCode AccountingPeriod * BillToContact CashAccountingCode DefaultPaymentMethod Entity * Invoice InvoicePayment JournalEntry * JournalRun * ParentAccount * Payment PaymentMethod PaymentMethodSnapshot Refund SoldToContact
Refund Part Part of the Invoice Settlement feature.	Base object: RefundPart Joined objects: Account BillToContact CreditMemo DefaultPaymentMethod Entity * ParentAccount * Payment PaymentMethod PaymentMethodSnapshot Refund SoldToContact
Refund Part Item Part of the Invoice Item Settlement feature.	Base object: RefundPartItem Joined objects: Account BillToContact CreditMemo CreditMemoItem DefaultPaymentMethod Entity * ParentAccount * Payment PaymentMethod PaymentMethodSnapshot Refund RefundPart SoldToContact
Revenue Recognition Events Transaction	Base object: Revenue Recognition Events Transaction Joined objects: Entity
Refund Transaction Log	Base object: RefundTransactionLog Joined objects: Entity * PaymentMethodSnapshot Refund
Revenue Charge Summary Item Requires the Zuora Finance - Revenue feature.	Base object: RevenueChargeSummaryItem Joined objects: Account AccountingPeriod * Amendment BillToContact DefaultPaymentMethod Entity * ParentAccount * Product ProductRatePlan ProductRatePlanCharge RatePlan RatePlanCharge RevenueChargeSummary SoldToContact Subscription
Revenue Event Item Requires the Zuora Finance - Revenue feature.	Base object: RevenueEventItem Joined objects: Account AccountingPeriod * Amendment BillToContact DefaultPaymentMethod DeferredRevenueAccountingCode Entity * JournalEntry * JournalRun * ParentAccount * Product ProductRatePlan ProductRatePlanCharge RatePlan RatePlanCharge RecognizedRevenueAccountingCode RevenueChargeSummary RevenueEvent RevenueEventType RevenueSchedule SoldToContact Subscription
Revenue Event Item Credit Memo Item Requires the Zuora Finance - Revenue feature. Zuora strongly recommends that you only use this data source if the Invoice Settlement feature is enabled.	Base object: RevenueEventItemCreditMemoItem Joined objects: Account AccountingPeriod * Amendment BillToContact CreditMemo CreditMemoItem DefaultPaymentMethod DeferredRevenueAccountingCode Entity * JournalEntry * JournalRun * ParentAccount * Product ProductRatePlan ProductRatePlanCharge RatePlan RatePlanCharge RecognizedRevenueAccountingCode RevenueChargeSummary RevenueEventCreditMemoItem RevenueEventType RevenueScheduleCreditMemoItem SoldToContact Subscription
Revenue Event Item Debit Memo Item Requires the Zuora Finance - Revenue feature. Zuora strongly recommends that you only use this data source if the Invoice Settlement feature is enabled.	Base object: RevenueEventItemDebitMemoItem Joined objects: Account AccountingPeriod * Amendment BillToContact DebitMemo DebitMemoItem DefaultPaymentMethod DeferredRevenueAccountingCode Entity * JournalEntry * JournalRun * ParentAccount * Product ProductRatePlan ProductRatePlanCharge RatePlan RatePlanCharge RecognizedRevenueAccountingCode RevenueChargeSummary RevenueEventDebitMemoItem RevenueEventType RevenueScheduleDebitMemoItem SoldToContact Subscription
Revenue Event Item Invoice Item Requires the Zuora Finance - Revenue feature.	Base object: RevenueEventItemInvoiceItem Joined objects: Account AccountingPeriod * Amendment BillToContact DefaultPaymentMethod DeferredRevenueAccountingCode Entity * Invoice InvoiceItem JournalEntry * JournalRun * ParentAccount * Product ProductRatePlan ProductRatePlanCharge RatePlan RatePlanCharge RecognizedRevenueAccountingCode RevenueChargeSummary RevenueEventInvoiceItem RevenueEventType RevenueScheduleInvoiceItem SoldToContact Subscription
Revenue Event Item Invoice Item Adjustment Requires the Zuora Finance - Revenue feature.	Base object: RevenueEventItemInvoiceItemAdjustment Joined objects: Account AccountingPeriod * Amendment BillToContact DefaultPaymentMethod DeferredRevenueAccountingCode Entity * Invoice InvoiceItem InvoiceItemAdjustment JournalEntry * JournalRun * ParentAccount * Product ProductRatePlan ProductRatePlanCharge RatePlan RatePlanCharge RecognizedRevenueAccountingCode RevenueChargeSummary RevenueEventInvoiceItemAdjustment RevenueEventType RevenueScheduleInvoiceItemAdjustment SoldToContact Subscription
Revenue Schedule Item Requires the Zuora Finance - Revenue feature.	Base object: RevenueScheduleItem Joined objects: Account AccountingPeriod * Amendment BillToContact DefaultPaymentMethod DeferredRevenueAccountingCode Entity * ParentAccount * Product ProductRatePlan ProductRatePlanCharge RatePlan RatePlanCharge RecognizedRevenueAccountingCode RevenueChargeSummary RevenueSchedule SoldToContact Subscription
Revenue Schedule Item Credit Memo Item Requires the Zuora Finance - Revenue feature. Zuora strongly recommends that you only use this data source if the Invoice Settlement feature is enabled.	Base object: RevenueScheduleItemCreditMemoItem Joined objects: Account AccountingPeriod * Amendment BillToContact CreditMemo CreditMemoItem DefaultPaymentMethod DeferredRevenueAccountingCode Entity * ParentAccount * Product ProductRatePlan ProductRatePlanCharge RatePlan RatePlanCharge RecognizedRevenueAccountingCode RevenueChargeSummary RevenueScheduleCreditMemoItem SoldToContact Subscription
Revenue Schedule Item Debit Memo Item Requires the Zuora Finance - Revenue feature. Zuora strongly recommends that you only use this data source if the Invoice Settlement feature is enabled.	Base object: RevenueScheduleItemDebitMemoItem Joined objects: Account AccountingPeriod * Amendment BillToContact DebitMemo DebitMemoItem DefaultPaymentMethod DeferredRevenueAccountingCode Entity * ParentAccount * Product ProductRatePlan ProductRatePlanCharge RatePlan RatePlanCharge RecognizedRevenueAccountingCode RevenueChargeSummary RevenueScheduleDebitMemoItem SoldToContact Subscription
Revenue Schedule Item Invoice Item Requires the Zuora Finance - Revenue feature.	Base object: RevenueScheduleItemInvoiceItem Joined objects: Account AccountingPeriod * Amendment BillToContact DefaultPaymentMethod DeferredRevenueAccountingCode Entity * Invoice InvoiceItem ParentAccount * Product ProductRatePlan ProductRatePlanCharge RatePlan RatePlanCharge RecognizedRevenueAccountingCode RevenueChargeSummary RevenueScheduleInvoiceItem SoldToContact Subscription
Revenue Schedule Item Invoice Item Adjustment Requires the Zuora Finance - Revenue feature.	Base object: RevenueScheduleItemInvoiceItemAdjustment Joined objects: Account AccountingPeriod * Amendment BillToContact DefaultPaymentMethod DeferredRevenueAccountingCode Entity * Invoice InvoiceItem InvoiceItemAdjustment ParentAccount * Product ProductRatePlan ProductRatePlanCharge RatePlan RatePlanCharge RecognizedRevenueAccountingCode RevenueChargeSummary RevenueScheduleInvoiceItemAdjustment SoldToContact Subscription
Stored Credential Profile	Base object: StoredCredentialProfile Joined object:PaymentMethod If you want to query data by joining Payment Method and Stored Credential Profile, use StoredCredentialProfile as the base object to achieve better query performance.
Subscription	Base object: Subscription Joined objects: Account BillToContact DefaultPaymentMethod Entity * ParentAccount * SoldToContact SubscriptionVersionAmendment
Taxation Item	Base object: TaxationItem Joined objects: Account AccountReceivableAccountingCode AccountingPeriod * Amendment BillToContact DefaultPaymentMethod Entity * Invoice InvoiceItem JournalEntry * JournalRun * ParentAccount * Product ProductRatePlan ProductRatePlanCharge RatePlan RatePlanCharge SalesTaxPayableAccountingCode SoldToContact Subscription TaxableItemSnapshot *
Usage	Base object: Usage Joined objects: Account Amendment BillToContact DefaultPaymentMethod Entity * ParentAccount * Product ProductRatePlan ProductRatePlanCharge RatePlan RatePlanCharge SoldToContact Subscription

Data Source

Objects

Account

Base object: Account

Joined objects:

BillToContact
DefaultPaymentMethod
Entity *
ParentAccount *
SoldToContact

Accounting Code

Base object: AccountingCode

Joined objects:

Entity *

Application Group

Part of the Invoice Settlement feature.

Base object: ApplicationGroup

Joined objects:

Entity *
Payment
PaymentMethod
PaymentMethodSnapshot
Refund

AR Transaction

Base object: AR Transaction

Joined objects:

Account
>Credit Accounting Code
>Credit Memo
>Credit Memo Item
>Credit Taxation Item
>Debit Accounting Code
>Debit Memo
>Debit Memo Item
>Debit Taxation Item
>Default Payment Method
>Invoice
>Invoice Item
>Payment
>Payment Method
>Product
>Product Rate Plan Charge
>Rate Plan
>Rate Plan Charge
>Refund
>Taxation Item

Billing Run

Base object: BillingRun

The BillingRun object is different from the BillRun object.

Joined objects:

Entity *

Billing Transaction

Base object: Billing Transaction

Joined objects:

Amendment
Bill To
Default Payment Method
Discount Applied To Rate Plan Charge
Entity
Parent Account
Product
Product Rate Plan
Product Rate Plan Charge
Rate Plan
Rate Plan Charge
Sold To
Subscription
Subscription Owner
Subscription Rate Plan

Booking Transaction

Base object: Booking Transaction

Joined objects:

Amendment
Bill To
Default Payment Method
Discount Applied To Rate Plan Charge
Discount Applied To Subscription Rate Plan
Entity
Invoice Owner
Invoice Schedule
Order
Order Line Item
Parent Account
Product
Product Rate Plan
Product Rate Plan Charge
Rate Plan
Rate Plan Charge
Sold To
Subscription
Subscription Owner
Subscription Rate Plan

Contact

Base object: Contact

Joined objects:

Entity *

Credit Balance Adjustment

Part of the Credit Balance feature. Deprecated if the Invoice Settlement feature is enabled.

Base object: CreditBalanceAdjustment

Joined objects:

Account
AccountReceivableAccountingCode
AccountingPeriod *
BillToContact
CashAccountingCode
CustomerCashOnAccountAccountingCode
DefaultPaymentMethod
Entity *
Invoice
JournalEntry *
JournalRun *
ParentAccount *
Payment
PaymentMethod
PaymentMethodSnapshot
Refund
SoldToContact

Credit Memo

Part of the Invoice Settlement feature.

Base object: CreditMemo

Joined objects:

Account
BillToContact
DefaultPaymentMethod
Entity *
Invoice
ParentAccount *
SoldToContact

Credit Memo Application

Part of the Invoice Settlement feature.

Base object: CreditMemoApplication

Joined objects:

Account
ApplicationGroup
BillToContact
CreditMemo
DebitMemo
DefaultPaymentMethod
Entity *
Invoice
ParentAccount *
SoldToContact

Credit Memo Application Item

Part of the Invoice Settlement feature.

Base object: CreditMemoApplicationItem

Joined objects:

Account
AccountingPeriod *
ApplicationGroup
BillToContact
CreditMemo
CreditMemoApplication
CreditMemoItem
CreditTaxationItem
DebitMemo
DebitMemoItem
DebitTaxationItem
DefaultPaymentMethod
Entity *
Invoice
InvoiceItem
JournalEntry *
JournalRun *
ParentAccount *
SoldToContact
TaxationItem

Credit Memo Item

Part of the Invoice Settlement feature.

Base object: CreditMemoItem

Joined objects:

Account
AccountReceivableAccountingCode
AccountingPeriod *
Amendment
BillToContact
CreditMemo
DefaultPaymentMethod
DeferredRevenueAccountingCode
Entity *
Invoice
InvoiceItem
JournalEntry *
JournalRun *
OnAccountAccountingCode
ParentAccount *
Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RatePlanCharge
RecognizedRevenueAccountingCode
SoldToContact
Subscription

Credit Memo Part

Part of the Invoice Settlement feature.

Base object: CreditMemoPart

Joined objects:

Account
BillToContact
CreditMemo
DebitMemo
DefaultPaymentMethod
Entity *
Invoice
ParentAccount *
SoldToContact

Credit Memo Part Item

Part of the Invoice Settlement feature.

Base object: CreditMemoPartItem

Joined objects:

Account
BillToContact
CreditMemo
CreditMemoItem
CreditMemoPart
CreditTaxationItem
DebitMemo
DebitMemoItem
DebitTaxationItem
DefaultPaymentMethod
Entity *
Invoice
InvoiceItem
ParentAccount *
SoldToContact
TaxationItem

Credit Taxation Item

Part of the Invoice Settlement feature.

Base object: CreditTaxationItem

Joined objects:

Account
AccountReceivableAccountingCode
AccountingPeriod *
Amendment
BillToContact
CreditMemo
CreditMemoItem
DefaultPaymentMethod
Entity *
Invoice
JournalEntry *
JournalRun *
OnAccountAccountingCode
ParentAccount *
Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RatePlanCharge
SalesTaxPayableAccountingCode
SoldToContact
Subscription
TaxationItem

Custom Exchange Rate

Part of the Custom Foreign Currency Exchange Rates feature.

Base object: FXCustomRate

Joined objects:

Entity *

Daily Consumption Summary

Part of the Prepaid with Drawdown feature.

Base object: DailyConsumptionSummary

Joined objects:

PrepaidBalanceFund
Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RatePlanCharge

Debit Memo

Part of the Invoice Settlement feature.

Base object: DebitMemo

Joined objects:

Account
BillToContact
DefaultPaymentMethod
Entity *
Invoice
ParentAccount *
SoldToContact

Debit Memo Item

Part of the Invoice Settlement feature.

Base object: DebitMemoItem

Joined objects:

Account
AccountReceivableAccountingCode
AccountingPeriod *
Amendment
BillToContact
DebitMemo
DefaultPaymentMethod
DeferredRevenueAccountingCode
Entity *
Invoice
InvoiceItem
JournalEntry *
JournalRun *
ParentAccount *
Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RatePlanCharge
RecognizedRevenueAccountingCode
SoldToContact
Subscription

Debit Taxation Item

Part of the Invoice Settlement feature.

Base object: DebitTaxationItem

Joined objects:

Account
AccountReceivableAccountingCode
AccountingPeriod *
Amendment
BillToContact
DebitMemo
DebitMemoItem
DefaultPaymentMethod
Entity *
Invoice
JournalEntry *
JournalRun *
ParentAccount *
Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RatePlanCharge
SalesTaxPayableAccountingCode
SoldToContact
Subscription
TaxationItem

Discount Applied Metrics

Limited Availability feature.

Base object:DiscountAppliedMetrics

Joined objects:

Account
Amendment
BillToContact
DefaultPaymentMethod
Entity *
ParentAccount *
Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RatePlanCharge
SoldToContact
Subscription

Gateway Reconciliation Event

Base object: PaymentGatewayReconciliationEventLog

Joined objects:

Entity *
PaymentReconciliationJob

Gateway Reconciliation Log

Base object: PaymentReconciliationLog

Joined objects:

Entity *
PaymentGatewayReconciliationEventLog
PaymentReconciliationJob

Guided Usage

Part of the Unbilled Usage feature.

Base object: GuidedUsage

Joined objects:

Account
BillTo
DefaultPaymentMethod
ParentAccount
Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RatePlanCharge
SoldTo
Subscription
Usage

Invoice

Base object: Invoice

Joined objects:

Account
BillToContact
BillToContactSnapshot *
DefaultPaymentMethod
Entity *
ParentAccount *
SoldToContact
SoldToContactSnapshot *

Invoice Adjustment

Deprecated if the Invoice Settlement feature is enabled.

Base object: InvoiceAdjustment

Joined objects:

Account
AccountReceivableAccountingCode
AccountingPeriod *
BillToContact
DefaultPaymentMethod
DeferredRevenueAccountingCode
Entity *
Invoice
JournalEntry *
JournalRun *
ParentAccount *
SoldToContact

Invoice Item

Base object: InvoiceItem

Joined objects:

Account
AccountReceivableAccountingCode
AccountingPeriod *
Amendment
BillToContact
BillToContactSnapshot *
DefaultPaymentMethod
DeferredRevenueAccountingCode
Entity *
Invoice
JournalEntry *
JournalRun *
ParentAccount *
Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RatePlanCharge
RecognizedRevenueAccountingCode
SoldToContact
SoldToContactSnapshot *
Subscription

Invoice Item Adjustment

Deprecated if the Invoice Settlement feature is enabled.

Base object: InvoiceItemAdjustment

Joined objects:

Account
AccountReceivableAccountingCode
AccountingPeriod *
Amendment
BillToContact
DefaultPaymentMethod
DeferredRevenueAccountingCode
Entity *
Invoice
InvoiceItem
JournalEntry *
JournalRun *
ParentAccount *
Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RatePlanCharge
RecognizedRevenueAccountingCode
SalesTaxPayableAccountingCode
SoldToContact
Subscription
TaxationItem

Invoice Payment

Deprecated if the Invoice Settlement feature is enabled.

Base object: InvoicePayment

Joined objects:

Account
AccountReceivableAccountingCode
AccountingPeriod *
BillToContact
CashAccountingCode
DefaultPaymentMethod
Entity *
Invoice
JournalEntry *
JournalRun *
ParentAccount *
Payment
PaymentMethod
PaymentMethodSnapshot
SoldToContact

Journal Entry Item

Requires Zuora Finance.

Base object: JournalEntryItem

Joined objects:

AccountingCode
AccountingPeriod *
Entity *
JournalEntry *
JournalRun *

Notification History - Email

Base object: EmailHistory

Joined objects:

Account
BillToContact
DefaultPaymentMethod
ParentAccount *
SoldToAccount

Notification History - Callout

Base object: CalloutHistory

Joined objects:

Account
BillToContact
DefaultPaymentMethod
ParentAccount *
SoldToAccount

Order

Part of the Order Metrics feature.

Base object: Order

Joined objects:

Account
BillToContact
DefaultPaymentMethod
ParentAccount *
SoldToAccount

Order Action

Part of the Order Metrics feature.

Base object: OrderAction

Joined objects:

Account
Add Rate Plan
BillToContact
DefaultPaymentMethod
Order
ParentAccount *
Remove Rate Plan
SoldToContact
Subscription
SubscriptionVersionAmendment
Update Rate Plan

Order Contact

Part of the Order Metrics feature.

Base object: OrderContact

Joined objects: None

Order Elp

Part of the Order Metrics feature.

Base object: OrderElp

Joined objects:

Account
Amendment
BillToContact
DefaultPaymentMethod
Entity *
Order
OrderAction
ParentAccount *
Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RatePlanCharge
SoldToContact
Subscription
SubscriptionVersionAmendment

Order Item

Part of the Order Metrics feature.

Base object: OrderItem

Joined objects:

Amendment
Entity *
Order
OrderAction
Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RatePlanCharge
Subscription

Order Line Item

Part of the Order Metrics feature.

Base object: OrderLineItem

Joined objects:

Account
BillToContact
DefaultPaymentMethod
Order
OrderContact
SoldToContact
ParentAccount *

Order Mrr

Part of the Order Metrics feature.

Base object: OrderMrr

Joined objects:

Account
Amendment
BillToContact
DefaultPaymentMethod
Order
OrderAction
ParentAccount *
Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RatePlanCharge
SoldToContact
Subscription
SubscriptionVersionAmendment

Order Quantity

Part of the Order Metrics feature.

Base object: OrderQuantity

Joined objects:

Account
Amendment
BillToContact
DefaultPaymentMethod
Order
OrderAction
ParentAccount *
Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RatePlanCharge
SoldToContact
Subscription
SubscriptionVersionAmendment

Order Tcb

Part of the Order Metrics feature.

Base object: OrderTcb

Joined objects:

Account
Amendment
BillToContact
DefaultPaymentMethod
Order
OrderAction
ParentAccount *
Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RatePlanCharge
SoldToContact
Subscription
SubscriptionVersionAmendment

Order Tcv

Part of the Order Metrics feature.

Base object: OrderTcv

Joined objects:

Account
Amendment
BillToContact
DefaultPaymentMethod
Order
OrderAction
ParentAccount *
Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RatePlanCharge
SoldToContact
Subscription
SubscriptionVersionAmendment

Payment

Base object: Payment

Joined objects:

Account
BillToContact
DefaultPaymentMethod
Entity *
ParentAccount *
PaymentMethod
PaymentMethodSnapshot
SoldToContact

Payment Application

Part of the Invoice Settlement feature.

Base object: PaymentApplication

Joined objects:

Account
AccountReceivableAccountingCode
AccountingPeriod *
ApplicationGroup
BillToContact
CashAccountingCode
DebitMemo
DefaultPaymentMethod
Entity *
Invoice
JournalEntry *
JournalRun *
ParentAccount *
Payment
PaymentMethod
PaymentMethodSnapshot
SoldToContact
UnappliedPaymentAccountingCode

Payment Application Item

Part of the Invoice Item Settlement feature.

Base object: PaymentApplicationItem

Joined objects:

Account
AccountReceivableAccountingCode
AccountingPeriod *
ApplicationGroup
BillToContact
CashAccountingCode
DebitMemo
DebitMemoItem
DebitTaxationItem
DefaultPaymentMethod
Entity *
Invoice
InvoiceItem
JournalEntry *
JournalRun *
ParentAccount *
Payment
PaymentApplication
PaymentMethod
PaymentMethodSnapshot
SoldToContact
TaxationItem
UnappliedPaymentAccountingCode

Payment Method

Base object: PaymentMethod

Joined objects:

Entity *
StoredCredentialProfile

If you want to query data by joining Payment Method and Stored Credential Profile, use StoredCredentialProfile as the base object to achieve better query performance.

Payment Method Transaction Log

Base object: PaymentMethodTransactionLog

Joined objects:

Account
BillToContact
DefaultPaymentMethod
Entity *
ParentAccount *
PaymentMethod
SoldToContact

Payment Method Update

Base object: UpdaterDetail

Joined objects:

Entity *
NewPaymentMethod
PaymentMethod
UpdaterBatch

Payment Part

Part of the Invoice Settlement feature.

Base object: PaymentPart

Joined objects:

Account
BillToContact
DebitMemo
DefaultPaymentMethod
Entity *
Invoice
ParentAccount *
Payment
PaymentMethod
PaymentMethodSnapshot
SoldToContact

Payment Part Item

Part of the Invoice Item Settlement feature.

Base object: PaymentPartItem

Joined objects:

Account
BillToContact
DebitMemo
DebitMemoItem
DebitTaxationItem
DefaultPaymentMethod
Entity *
Invoice
InvoiceItem
ParentAccount *
Payment
PaymentMethod
PaymentMethodSnapshot
PaymentPart
SoldToContact
TaxationItem

Payment Run

Base object:PaymentRun

Joined objects:

Entity *

Payment Schedule

Base object: PaymentSchedule

Joined objects:

Account
Bill To
Debit Memo
Default Payment Method
Invoice
Parent Account
Payment Schedule
Sold To

Payment Schedule Item

Base object: PaymentScheduleItem

Joined objects:

Account
Bill To
Debit Memo
Default Payment Method
Invoice
Parent Account
Payment
Payment Method
Payment Method Snapshot
Payment Schedule
Payment Schedule Item
Sold To

Payment Schedule Item Payment

Base object: PaymentScheduleItemPart

Joined objects:

Payment Schedule Item Payment
Entity
Payment
Payment Method
Payment Method Snapshot
Payment Schedule Item

Payment Transaction Log

Base object: PaymentTransactionLog

Joined objects:

Account
BillToContact
DefaultPaymentMethod
Entity *
ParentAccount *
Payment
PaymentMethod
PaymentMethodSnapshot
SoldToContact

Prepaid Balance Fund

Part of the Prepaid with Drawdown feature.

Base object: Fund

Joined objects:

Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RatePlanCharge

Prepaid Validity Period Summary

Part of the Prepaid with Drawdown feature.

Base object: PrepaidValidityPeriodSummary

Processed Usage

Base object: ProcessedUsage

Joined objects:

Account
Amendment
BillToContact
DefaultPaymentMethod
Entity *
Invoice
InvoiceItem
ParentAccount *
Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RatePlanCharge
SoldToContact
Subscription
Usage

Product

Base object: Product

Joined objects:

Entity *

Product Rate Plan Charge

Base object: ProductRatePlanCharge

Joined objects:

AccountReceivableAccountingCode
AdjustmentLiabilityAccountingCode
AdjustmentRevenueAccountingCode
ContractAssetAccountingCode
ContractLiabilityAccountingCode
ContractRecognizedRevenueAccountingCode
DeferredRevenueAccountingCode
Entity *
Product
ProductRatePlan
RecognizedRevenueAccountingCode
UnbilledReceivablesAccountingCode

Product Rate Plan Charge Tier

Base object: ProductRatePlanChargeTier

Joined objects:

Entity *
Product
ProductRatePlan
ProductRatePlanCharge

Rate Plan

Base object: RatePlan

Joined objects:

Account
Amendment
BillToContact
DefaultPaymentMethod
Entity *
ParentAccount *
Product
ProductRatePlan
SoldToContact
Subscription
SubscriptionVersionAmendment

Rate Plan Charge

Base object: RatePlanCharge

Joined objects:

Account
AccountReceivableAccountingCode
Amendment
BillToContact
DefaultPaymentMethod
DeferredRevenueAccountingCode
Entity *
ParentAccount *
Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RecognizedRevenueAccountingCode
SoldToContact
Subscription

Rate Plan Charge Tier

Base object: RatePlanChargeTier

Joined objects:

Amendment
Entity *
Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RatePlanCharge
Subscription

Rating Result

Part of the Unbilled Usage feature.

Base object: RatingResult

Joined objects:

Account
BillTo
DefaultPaymentMethod
Invoice
InvoiceItem
ParentAccount
Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RatePlanCharge
SoldTo
Subscription

Refund

Base object: Refund

Joined objects:

Account
BillToContact
DefaultPaymentMethod
Entity *
ParentAccount *
PaymentMethodSnapshot
SoldToContact

Refund Application

Part of the Invoice Settlement feature.

Base object: RefundApplication

Joined objects:

Account
AccountReceivableAccountingCode
AccountingPeriod *
ApplicationGroup
BillToContact
CashAccountingCode
CreditMemo
DefaultPaymentMethod
Entity *
JournalEntry *
JournalRun *
OnAccountAccountingCode
ParentAccount *
Payment
PaymentMethod
PaymentMethodSnapshot
Refund
SoldToContact
UnappliedPaymentAccountingCode

Refund Application Item

Part of the Invoice Item Settlement feature.

Base object: RefundApplicationItem

Joined objects:

Account
AccountReceivableAccountingCode
AccountingPeriod *
ApplicationGroup
BillToContact
CashAccountingCode
CreditMemo
CreditMemoItem
CreditTaxationItem
DefaultPaymentMethod
Entity *
JournalEntry *
JournalRun *
OnAccountAccountingCode
ParentAccount *
Payment
PaymentMethod
PaymentMethodSnapshot
Refund
RefundApplication
SoldToContact
UnappliedPaymentAccountingCode

Refund Invoice Payment

Deprecated if the Invoice Settlement feature is enabled.

Base object: RefundInvoicePayment

Joined objects:

Account
AccountReceivableAccountingCode
AccountingPeriod *
BillToContact
CashAccountingCode
DefaultPaymentMethod
Entity *
Invoice
InvoicePayment
JournalEntry *
JournalRun *
ParentAccount *
Payment
PaymentMethod
PaymentMethodSnapshot
Refund
SoldToContact

Refund Part

Part of the Invoice Settlement feature.

Base object: RefundPart

Joined objects:

Account
BillToContact
CreditMemo
DefaultPaymentMethod
Entity *
ParentAccount *
Payment
PaymentMethod
PaymentMethodSnapshot
Refund
SoldToContact

Refund Part Item

Part of the Invoice Item Settlement feature.

Base object: RefundPartItem

Joined objects:

Account
BillToContact
CreditMemo
CreditMemoItem
DefaultPaymentMethod
Entity *
ParentAccount *
Payment
PaymentMethod
PaymentMethodSnapshot
Refund
RefundPart
SoldToContact

Revenue Recognition Events Transaction

Base object: Revenue Recognition Events Transaction

Joined objects: Entity

Refund Transaction Log

Base object: RefundTransactionLog

Joined objects:

Entity *
PaymentMethodSnapshot
Refund

Revenue Charge Summary Item

Requires the Zuora Finance - Revenue feature.

Base object: RevenueChargeSummaryItem

Joined objects:

Account
AccountingPeriod *
Amendment
BillToContact
DefaultPaymentMethod
Entity *
ParentAccount *
Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RatePlanCharge
RevenueChargeSummary
SoldToContact
Subscription

Revenue Event Item

Requires the Zuora Finance - Revenue feature.

Base object: RevenueEventItem

Joined objects:

Account
AccountingPeriod *
Amendment
BillToContact
DefaultPaymentMethod
DeferredRevenueAccountingCode
Entity *
JournalEntry *
JournalRun *
ParentAccount *
Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RatePlanCharge
RecognizedRevenueAccountingCode
RevenueChargeSummary
RevenueEvent
RevenueEventType
RevenueSchedule
SoldToContact
Subscription

Revenue Event Item Credit Memo Item

Requires the Zuora Finance - Revenue feature. Zuora strongly recommends that you only use this data source if the Invoice Settlement feature is enabled.

Base object: RevenueEventItemCreditMemoItem

Joined objects:

Account
AccountingPeriod *
Amendment
BillToContact
CreditMemo
CreditMemoItem
DefaultPaymentMethod
DeferredRevenueAccountingCode
Entity *
JournalEntry *
JournalRun *
ParentAccount *
Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RatePlanCharge
RecognizedRevenueAccountingCode
RevenueChargeSummary
RevenueEventCreditMemoItem
RevenueEventType
RevenueScheduleCreditMemoItem
SoldToContact
Subscription

Revenue Event Item Debit Memo Item

Requires the Zuora Finance - Revenue feature. Zuora strongly recommends that you only use this data source if the Invoice Settlement feature is enabled.

Base object: RevenueEventItemDebitMemoItem

Joined objects:

Account
AccountingPeriod *
Amendment
BillToContact
DebitMemo
DebitMemoItem
DefaultPaymentMethod
DeferredRevenueAccountingCode
Entity *
JournalEntry *
JournalRun *
ParentAccount *
Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RatePlanCharge
RecognizedRevenueAccountingCode
RevenueChargeSummary
RevenueEventDebitMemoItem
RevenueEventType
RevenueScheduleDebitMemoItem
SoldToContact
Subscription

Revenue Event Item Invoice Item

Requires the Zuora Finance - Revenue feature.

Base object: RevenueEventItemInvoiceItem

Joined objects:

Account
AccountingPeriod *
Amendment
BillToContact
DefaultPaymentMethod
DeferredRevenueAccountingCode
Entity *
Invoice
InvoiceItem
JournalEntry *
JournalRun *
ParentAccount *
Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RatePlanCharge
RecognizedRevenueAccountingCode
RevenueChargeSummary
RevenueEventInvoiceItem
RevenueEventType
RevenueScheduleInvoiceItem
SoldToContact
Subscription

Revenue Event Item Invoice Item Adjustment

Requires the Zuora Finance - Revenue feature.

Base object: RevenueEventItemInvoiceItemAdjustment

Joined objects:

Account
AccountingPeriod *
Amendment
BillToContact
DefaultPaymentMethod
DeferredRevenueAccountingCode
Entity *
Invoice
InvoiceItem
InvoiceItemAdjustment
JournalEntry *
JournalRun *
ParentAccount *
Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RatePlanCharge
RecognizedRevenueAccountingCode
RevenueChargeSummary
RevenueEventInvoiceItemAdjustment
RevenueEventType
RevenueScheduleInvoiceItemAdjustment
SoldToContact
Subscription

Revenue Schedule Item

Requires the Zuora Finance - Revenue feature.

Base object: RevenueScheduleItem

Joined objects:

Account
AccountingPeriod *
Amendment
BillToContact
DefaultPaymentMethod
DeferredRevenueAccountingCode
Entity *
ParentAccount *
Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RatePlanCharge
RecognizedRevenueAccountingCode
RevenueChargeSummary
RevenueSchedule
SoldToContact
Subscription

Revenue Schedule Item Credit Memo Item

Requires the Zuora Finance - Revenue feature. Zuora strongly recommends that you only use this data source if the Invoice Settlement feature is enabled.

Base object: RevenueScheduleItemCreditMemoItem

Joined objects:

Account
AccountingPeriod *
Amendment
BillToContact
CreditMemo
CreditMemoItem
DefaultPaymentMethod
DeferredRevenueAccountingCode
Entity *
ParentAccount *
Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RatePlanCharge
RecognizedRevenueAccountingCode
RevenueChargeSummary
RevenueScheduleCreditMemoItem
SoldToContact
Subscription

Revenue Schedule Item Debit Memo Item

Requires the Zuora Finance - Revenue feature. Zuora strongly recommends that you only use this data source if the Invoice Settlement feature is enabled.

Base object: RevenueScheduleItemDebitMemoItem

Joined objects:

Account
AccountingPeriod *
Amendment
BillToContact
DebitMemo
DebitMemoItem
DefaultPaymentMethod
DeferredRevenueAccountingCode
Entity *
ParentAccount *
Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RatePlanCharge
RecognizedRevenueAccountingCode
RevenueChargeSummary
RevenueScheduleDebitMemoItem
SoldToContact
Subscription

Revenue Schedule Item Invoice Item

Requires the Zuora Finance - Revenue feature.

Base object: RevenueScheduleItemInvoiceItem

Joined objects:

Account
AccountingPeriod *
Amendment
BillToContact
DefaultPaymentMethod
DeferredRevenueAccountingCode
Entity *
Invoice
InvoiceItem
ParentAccount *
Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RatePlanCharge
RecognizedRevenueAccountingCode
RevenueChargeSummary
RevenueScheduleInvoiceItem
SoldToContact
Subscription

Revenue Schedule Item Invoice Item Adjustment

Requires the Zuora Finance - Revenue feature.

Base object: RevenueScheduleItemInvoiceItemAdjustment

Joined objects:

Account
AccountingPeriod *
Amendment
BillToContact
DefaultPaymentMethod
DeferredRevenueAccountingCode
Entity *
Invoice
InvoiceItem
InvoiceItemAdjustment
ParentAccount *
Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RatePlanCharge
RecognizedRevenueAccountingCode
RevenueChargeSummary
RevenueScheduleInvoiceItemAdjustment
SoldToContact
Subscription

Stored Credential Profile

Base object: StoredCredentialProfile

Joined object:PaymentMethod

If you want to query data by joining Payment Method and Stored Credential Profile, use StoredCredentialProfile as the base object to achieve better query performance.

Subscription

Base object: Subscription

Joined objects:

Account
BillToContact
DefaultPaymentMethod
Entity *
ParentAccount *
SoldToContact
SubscriptionVersionAmendment

Taxation Item

Base object: TaxationItem

Joined objects:

Account
AccountReceivableAccountingCode
AccountingPeriod *
Amendment
BillToContact
DefaultPaymentMethod
Entity *
Invoice
InvoiceItem
JournalEntry *
JournalRun *
ParentAccount *
Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RatePlanCharge
SalesTaxPayableAccountingCode
SoldToContact
Subscription
TaxableItemSnapshot *

Usage

Base object: Usage

Joined objects:

Account
Amendment
BillToContact
DefaultPaymentMethod
Entity *
ParentAccount *
Product
ProductRatePlan
ProductRatePlanCharge
RatePlan
RatePlanCharge
SoldToContact
Subscription

Availability of Data Source Objects

Depending on the features that are enabled in your Zuora tenant, some joined objects may not be available or may not contain any data. The following joined objects depend on Zuora features:

AccountingPeriod - Requires Zuora Finance
BillToContactSnapshot - Requires the Preserve snapshot of bill-to and sold-to contacts when billing documents are posted? billing rule to be enabled
Entity - Part of the Multi-entity feature
JournalEntry - Requires Zuora Finance
JournalRun - Requires Zuora Finance
ParentAccount - Part of the Customer Hierarchy feature
SoldToContactSnapshot - Requires the Preserve snapshot of bill-to and sold-to contacts when billing documents are posted? billing rule to be enabled
TaxableItemSnapshot - Part of the Taxable Item Snapshot feature

Additionally, any existing Subscribe and Amend customers who are on Orders (not on Orders Harmonization) will not have access to the objects related to Amendments.

Additional Data Source Fields

If you have defined custom fields for an object, your custom fields are available in every data source that provides the object. To specify a custom field in an Export ZOQL query, use the API name that you defined for the custom field.
If you have enabled foreign currency conversion in Zuora, you can include currency conversion data in data source exports. Currency conversion data is available through additional fields in some objects.