> This page is for Docs. > For clean Markdown of any page, append .md to the page URL. > For a complete documentation index, see https://zuora.ferndocs.com/llms.txt. > For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://zuora.ferndocs.com/_mcp/server. # 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. 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 > **Note** > > 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.