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:
|
|
Accounting Code |
Base object: AccountingCode Joined objects:
|
|
Application Group Part of the Invoice Settlement feature. |
Base object: ApplicationGroup Joined objects:
|
| AR Transaction |
Base object: AR Transaction Joined objects:
|
|
Billing Run |
Base object: BillingRun Note: The BillingRun object is different from the BillRun object.
Joined objects:
|
| Billing Transaction |
Base object: Billing Transaction Joined objects:
|
| Booking Transaction |
Base object: Booking Transaction Joined objects:
|
|
Contact |
Base object: Contact Joined objects:
|
|
Credit Balance Adjustment Part of the Credit Balance feature. Deprecated if the Invoice Settlement feature is enabled. |
Base object: CreditBalanceAdjustment Joined objects:
|
|
Credit Memo Part of the Invoice Settlement feature. |
Base object: CreditMemo Joined objects:
|
|
Credit Memo Application Part of the Invoice Settlement feature. |
Base object: CreditMemoApplication Joined objects:
|
|
Credit Memo Application Item Part of the Invoice Settlement feature. |
Base object: CreditMemoApplicationItem Joined objects:
|
|
Credit Memo Item Part of the Invoice Settlement feature. |
Base object: CreditMemoItem Joined objects:
|
|
Credit Memo Part Part of the Invoice Settlement feature. |
Base object: CreditMemoPart Joined objects:
|
|
Credit Memo Part Item Part of the Invoice Settlement feature. |
Base object: CreditMemoPartItem Joined objects:
|
|
Credit Taxation Item Part of the Invoice Settlement feature. |
Base object: CreditTaxationItem Joined objects:
|
|
Custom Exchange Rate Part of the Custom Foreign Currency Exchange Rates feature. |
Base object: FXCustomRate Joined objects:
|
|
Daily Consumption Summary Part of the Prepaid with Drawdown feature. |
Base object: DailyConsumptionSummary Joined objects:
|
|
Debit Memo Part of the Invoice Settlement feature. |
Base object: DebitMemo Joined objects:
|
|
Debit Memo Item Part of the Invoice Settlement feature. |
Base object: DebitMemoItem Joined objects:
|
|
Debit Taxation Item Part of the Invoice Settlement feature. |
Base object: DebitTaxationItem Joined objects:
|
|
Discount Applied Metrics Limited Availability feature. |
Base object:DiscountAppliedMetrics Joined objects:
|
|
Gateway Reconciliation Event |
Base object: PaymentGatewayReconciliationEventLog Joined objects:
|
|
Gateway Reconciliation Log |
Base object: PaymentReconciliationLog Joined objects:
|
|
Guided Usage Part of the Unbilled Usage feature. |
Base object: GuidedUsage Joined objects:
|
|
Invoice |
Base object: Invoice Joined objects:
|
|
Invoice Adjustment Deprecated if the Invoice Settlement feature is enabled. |
Base object: InvoiceAdjustment Joined objects:
|
|
Invoice Item |
Base object: InvoiceItem Joined objects:
|
|
Invoice Item Adjustment Deprecated if the Invoice Settlement feature is enabled. |
Base object: InvoiceItemAdjustment Joined objects:
|
|
Invoice Payment Deprecated if the Invoice Settlement feature is enabled. |
Base object: InvoicePayment Joined objects:
|
|
Journal Entry Item Requires Zuora Finance. |
Base object: JournalEntryItem Joined objects:
|
| Notification History - Email |
Base object: EmailHistory Joined objects:
|
| Notification History - Callout |
Base object: CalloutHistory Joined objects:
|
|
Order Part of the Order Metrics feature. |
Base object: Order Joined objects:
|
|
Order Action Part of the Order Metrics feature. |
Base object: OrderAction Joined objects:
|
|
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:
|
|
Order Item Part of the Order Metrics feature. |
Base object: OrderItem Joined objects:
|
|
Order Line Item Part of the Order Metrics feature. |
Base object: OrderLineItem Joined objects:
|
|
Order Mrr Part of the Order Metrics feature. |
Base object: OrderMrr Joined objects:
|
|
Order Quantity Part of the Order Metrics feature. |
Base object: OrderQuantity Joined objects:
|
|
Order Tcb Part of the Order Metrics feature. |
Base object: OrderTcb Joined objects:
|
|
Order Tcv Part of the Order Metrics feature. |
Base object: OrderTcv Joined objects:
|
|
Payment |
Base object: Payment Joined objects:
|
|
Payment Application Part of the Invoice Settlement feature. |
Base object: PaymentApplication Joined objects:
|
|
Payment Application Item Part of the Invoice Item Settlement feature. |
Base object: PaymentApplicationItem Joined objects:
|
|
Payment Method |
Base object: PaymentMethod Joined objects:
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:
|
|
Payment Method Update |
Base object: UpdaterDetail Joined objects:
|
|
Payment Part Part of the Invoice Settlement feature. |
Base object: PaymentPart Joined objects:
|
|
Payment Part Item Part of the Invoice Item Settlement feature. |
Base object: PaymentPartItem Joined objects:
|
|
Payment Run |
Base object:PaymentRun Joined objects:
|
| Payment Schedule |
Base object: PaymentSchedule Joined objects:
|
| Payment Schedule Item |
Base object: PaymentScheduleItem Joined objects:
|
| Payment Schedule Item Payment |
Base object: PaymentScheduleItemPart Joined objects:
|
|
Payment Transaction Log |
Base object: PaymentTransactionLog Joined objects:
|
|
Prepaid Balance Fund Part of the Prepaid with Drawdown feature. |
Base object: Fund Joined objects:
|
|
Prepaid Validity Period Summary Part of the Prepaid with Drawdown feature. |
Base object: PrepaidValidityPeriodSummary |
|
Processed Usage |
Base object: ProcessedUsage Joined objects:
|
|
Product |
Base object: Product Joined objects:
|
|
Product Rate Plan Charge |
Base object: ProductRatePlanCharge Joined objects:
|
|
Product Rate Plan Charge Tier |
Base object: ProductRatePlanChargeTier Joined objects:
|
|
Rate Plan |
Base object: RatePlan Joined objects:
|
|
Rate Plan Charge |
Base object: RatePlanCharge Joined objects:
|
|
Rate Plan Charge Tier |
Base object: RatePlanChargeTier Joined objects:
|
|
Rating Result Part of the Unbilled Usage feature. |
Base object: RatingResult Joined objects:
|
|
Refund |
Base object: Refund Joined objects:
|
|
Refund Application Part of the Invoice Settlement feature. |
Base object: RefundApplication Joined objects:
|
|
Refund Application Item Part of the Invoice Item Settlement feature. |
Base object: RefundApplicationItem Joined objects:
|
|
Refund Invoice Payment Deprecated if the Invoice Settlement feature is enabled. |
Base object: RefundInvoicePayment Joined objects:
|
|
Refund Part Part of the Invoice Settlement feature. |
Base object: RefundPart Joined objects:
|
|
Refund Part Item Part of the Invoice Item Settlement feature. |
Base object: RefundPartItem Joined objects:
|
| Revenue Recognition Events Transaction |
Base object: Revenue Recognition Events Transaction Joined objects: Entity |
|
Refund Transaction Log |
Base object: RefundTransactionLog Joined objects:
|
|
Revenue Charge Summary Item Requires the Zuora Finance - Revenue feature. |
Base object: RevenueChargeSummaryItem Joined objects:
|
|
Revenue Event Item Requires the Zuora Finance - Revenue feature. |
Base object: RevenueEventItem Joined objects:
|
|
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:
|
|
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:
|
|
Revenue Event Item Invoice Item Requires the Zuora Finance - Revenue feature. |
Base object: RevenueEventItemInvoiceItem Joined objects:
|
|
Revenue Event Item Invoice Item Adjustment Requires the Zuora Finance - Revenue feature. |
Base object: RevenueEventItemInvoiceItemAdjustment Joined objects:
|
|
Revenue Schedule Item Requires the Zuora Finance - Revenue feature. |
Base object: RevenueScheduleItem Joined objects:
|
|
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:
|
|
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:
|
|
Revenue Schedule Item Invoice Item Requires the Zuora Finance - Revenue feature. |
Base object: RevenueScheduleItemInvoiceItem Joined objects:
|
|
Revenue Schedule Item Invoice Item Adjustment Requires the Zuora Finance - Revenue feature. |
Base object: RevenueScheduleItemInvoiceItemAdjustment Joined objects:
|
| 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:
|
|
Taxation Item |
Base object: TaxationItem Joined objects:
|
|
Usage |
Base object: Usage Joined objects:
|
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.