Knowledge Center

Knowledge Center > API > Export ZOQL

Export ZOQL

Zuora Export ZOQL (Zuora Object Query Language) is the query language you use to create data source exports through the Zuora API. Export ZOQL is more powerful than ZOQL because Export ZOQL queries can select data from related business objects in a single operation.

You can perform Export ZOQL queries in the following ways:

Overview of Queries

When you write an Export ZOQL query, you must specify the data source to select data from. Each data source provides all your business objects of a particular type. Most data sources also provide related business objects. This saves you the effort of constructing nested queries, and results in better performance.

For example, the Invoice Item data source provides every Invoice Item object in your Zuora tenant, along with related Account, Contact, Invoice, Product, Rate Plan, and Subscription objects. See Data Sources and Objects for a listing of the objects provided by each data source.

You must use API names of data sources, objects, fields, and field values in Export ZOQL queries. API names do not necessarily match the corresponding names displayed in the Zuora user interface. For example, you must use "InvoiceItem" instead of "Invoice Item" or "Rechnungsposten" (German):

select BillToContact.FirstName from InvoiceItem

In the above example:

  • InvoiceItem is the API name of the Invoice Item data source.
  • BillToContact is the API name of a Contact object that is related to an Invoice Item object.
  • FirstName is the API name of the First Name field in the Contact object.

InvoiceItem is also called the "base" object of the Invoice Item data source. BillToContact is called a "joined" object.

To determine API names:

Prior to version 79 of the Zuora WSDL, some fields in data sources had different values from the corresponding fields in SOAP API objects. See Field Values in Export ZOQL Data Sources for more information.

Limitations

Characters per Query

A maximum of 20,000 characters is allowed in an Export ZOQL query.

File Size

The maximum export file size is 2047MB. If you have large data requests that go over this limit, you will get the following 403 HTTP response code from Zuora:
  <security:max-object-size>2047MB</security:max-object-size>

Submit a request at Zuora Global Support if you require additional assistance.

We can work with you to determine if large file optimization is an option for you.

Data Sources and Objects

The following table lists the objects that are provided by each data source. 

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 Advanced AR Settlement feature.

Base object: ApplicationGroup

Joined objects:

  • Entity
  • Payment
  • PaymentMethod
  • PaymentMethodSnapshot
  • Refund

Billing Run

Base object: BillingRun

Joined objects:

  • Entity

Contact

Base object: Contact

Joined objects:

  • Entity

Credit Balance Adjustment

Part of the Credit Balance feature. Deprecated if the Advanced AR 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 Advanced AR Settlement feature.

Base object: CreditMemo

Joined objects:

  • Account
  • BillToContact
  • DefaultPaymentMethod
  • Entity
  • Invoice
  • ParentAccount
  • SoldToContact

Credit Memo Application

Part of the Advanced AR Settlement feature.

Base object: CreditMemoApplication

Joined objects:

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

Credit Memo Application Item

Part of the Advanced AR 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 Advanced AR 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 Advanced AR Settlement feature.

Base object: CreditMemoPart

Joined objects:

  • Account
  • BillToContact
  • CreditMemo
  • DebitMemo
  • DefaultPaymentMethod
  • Entity
  • Invoice
  • ParentAccount
  • SoldToContact

Credit Memo Part Item

Part of the Advanced AR 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 Advanced AR 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

Debit Memo

Part of the Advanced AR Settlement feature.

Base object: DebitMemo

Joined objects:

  • Account
  • BillToContact
  • DefaultPaymentMethod
  • Entity
  • Invoice
  • ParentAccount
  • SoldToContact

Debit Memo Item

Part of the Advanced AR 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 Advanced AR 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

Gateway Reconciliation Event

Base object: PaymentGatewayReconciliationEventLog

Joined objects:

  • Entity
  • PaymentReconciliationJob

Gateway Reconciliation Log

Base object: PaymentReconciliationLog

Joined objects:

  • Entity
  • PaymentGatewayReconciliationEventLog
  • PaymentReconciliationJob

Invoice

Base object: Invoice

Joined objects:

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

Invoice Adjustment

Deprecated if the Advanced AR 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 Advanced AR 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 Advanced AR 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

Order

Part of the Revenue Metrics feature.

Base object: Order

Joined objects:

  • Account
  • BillToContact
  • DefaultPaymentMethod
  • ParentAccount
  • SoldToAccount

Order Action

Part of the Revenue Metrics feature.

Base object: OrderAction

Joined objects:

  • Account
  • BillToContact
  • DefaultPaymentMethod
  • Order
  • ParentAccount
  • SoldToContact
  • Subscription

Order Mrr

Part of the Revenue Metrics feature.

Base object: OrderMrr

Joined objects:

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

Order Quantity

Part of the Revenue Metrics feature.

Base object: OrderQuantity

Joined objects:

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

Order Tcb

Part of the Revenue Metrics feature.

Base object: OrderTcb

Joined objects:

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

Order Tcv

Part of the Revenue Metrics feature.

Base object: OrderTcv

Joined objects:

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

Payment

Base object: Payment

Joined objects:

  • Account
  • BillToContact
  • DefaultPaymentMethod
  • Entity
  • ParentAccount
  • PaymentMethod
  • PaymentMethodSnapshot
  • SoldToContact

Payment Application

Part of the Advanced AR 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

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 Advanced AR 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 Transaction Log

Base object: PaymentTransactionLog

Joined objects:

  • Account
  • BillToContact
  • DefaultPaymentMethod
  • Entity
  • ParentAccount
  • Payment
  • PaymentMethod
  • PaymentMethodSnapshot
  • SoldToContact

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
  • DeferredRevenueAccountingCode
  • Entity
  • Product
  • ProductRatePlan
  • RecognizedRevenueAccountingCode

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

Refund

Base object: Refund

Joined objects:

  • Account
  • BillToContact
  • DefaultPaymentMethod
  • Entity
  • ParentAccount
  • PaymentMethodSnapshot
  • SoldToContact

Refund Application

Part of the Advanced AR 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 Advanced AR 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 Advanced AR 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

Refund Transaction Log

Base object: RefundTransactionLog

Joined objects:

  • Entity
  • PaymentMethodSnapshot
  • Refund

Revenue Charge Summary Item

Requires Zuora Revenue.

Base object: RevenueChargeSummaryItem

Joined objects:

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

Revenue Event Item

Requires Zuora Revenue.

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 Zuora Revenue. Zuora strongly recommends that you only use this data source if the Advanced AR 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 Zuora Revenue. Zuora strongly recommends that you only use this data source if the Advanced AR 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 Zuora Revenue.

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 Zuora Revenue.

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 Zuora Revenue.

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 Zuora Revenue. Zuora strongly recommends that you only use this data source if the Advanced AR 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 Zuora Revenue. Zuora strongly recommends that you only use this data source if the Advanced AR 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 Zuora Revenue.

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 Zuora Revenue.

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

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

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 in data sources. The following joined objects require Zuora features to be enabled:

  • AccountingPeriod - Requires Zuora Finance
  • Entity - Part of the Multi-entity feature
  • JournalEntry - Requires Zuora Finance
  • JournalRun - Requires Zuora Finance

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. See Foreign Currency Conversion for Data Source Exports for more information.
Last modified
19:13, 5 Sep 2017

Tags

Classifications

(not set)