Billing objects supported for Zuora Connectors for Data Warehouses
Available billing objects
Zuora supports syncing both standard and custom objects to your chosen destination, depending on the selected connectors. All synced objects contribute to your Total Active Rows (TAR) usage. You can choose to sync any combination of objects from the list below:
- Account
- AccountingCode
- AccountingPeriod
- Amendment
- ARTransaction
- BillingRun
- Contact
- CreditBalanceAdjustment
- CreditMemo
- CreditMemoApplication
- CreditMemoApplicationItem
- CreditMemoItem
- CreditMemoPart
- CreditMemoPartItem
- CreditTaxationItem
- DailyConsumptionSummary
- DebitMemo
- DebitMemoItem
- DebitTaxationItem
- Feature
- FXCustomRate
- GuidedUsage
- Invoice
- InvoiceAdjustment
- InvoiceItem
- InvoiceItemAdjustment
- InvoicePayment
- JournalEntry
- JournalEntryItem
- JournalRun
- MinCommitPeriod
- MinCommitTransaction
- NonSubscriptionInvoiceItem
- OrderAction
- OrderContact
- OrderElp
- OrderItem
- OrderMrr
- OrderQuantity
- Orders
- OrderTcb
- OrderTcv
- Payment
- PaymentApplication
- PaymentApplicationItem
- PaymentMethod
- PaymentMethodSnapshot
- PaymentPart
- PaymentPartItem
- PaymentRun
- PaymentTransactionLog
- PrepaidBalance
- PrepaidBalanceFund
- PrepaidBalanceTransaction
- ProcessedUsage
- Product
- ProductFeature
- ProductRatePlan
- ProductRatePlanCharge
- ProductRatePlanChargeTier
- RatePlan
- RatePlanCharge
- RatePlanChargeTier
- RatingResult
- RealTimeRatingProcessedUsage
- Refund
- RefundApplication
- RefundApplicationItem
- RefundInvoicePayment
- RefundPart
- RefundPartItem
- RevenueChargeSummary
- RevenueChargeSummaryItem
- RevenueEvent
- RevenueEventCreditMemoItem
- RevenueEventDebitMemoItem
- RevenueEventInvoiceItem
- RevenueEventInvoiceItemAdjustment
- RevenueEventItem
- RevenueEventItemCreditMemoItem
- RevenueEventItemDebitMemoItem
- RevenueEventItemInvoiceItem
- RevenueEventItemInvoiceItemAdjustment
- RevenueEventType
- RevenueSchedule
- RevenueScheduleCreditMemoItem
- RevenueScheduleDebitMemoItem
- RevenueScheduleInvoiceItem
- RevenueScheduleInvoiceItemAdjustment
- RevenueScheduleItem
- RevenueScheduleItemCreditMemoItem
- RevenueScheduleItemDebitMemoItem
- RevenueScheduleItemInvoiceItem
- RevenueScheduleItemInvoiceItemAdjustment
- Subscription
- SubscriptionProductFeature
- SubscriptionStatusHistory
- TaxationItem
- UpdaterBatch
- UpdaterDetail
- Usage
- User
- ValidityPeriodSummary
Supported FX Data Tables
When the currency conversion feature is enabled on your tenant, you can export transaction amounts converted into your home currency and other specified currencies. This functionality applies to a set of transaction tables. See Data source objects that support FX data conversion, for the complete list of tables that support FX data conversion.
Example format for tables that support FX data conversion:
In your destination, the tables related to transaction amounts converted into your specified currencies will appear as follows:
- Payment Object
PaymentPaymentFXData
- Credit Memo Object
CreditMemoCreditMemoFXData
These FX data tables contain the foreign currency conversion amounts for the corresponding transaction types (e.g., PaymentFXData for payments, InvoiceFXData for invoices). You will find both the original transaction data and the converted data in the specified currencies based on the Currency Conversion feature.
Custom objects
Zuora Connectors for Data Warehousing supports all custom objects in your tenant. The custom object names in Zuora Connectors are consistent with the custom object names in Data Query, which are prefixed with default__. For example, default__vehicle.