TDV Adapter for Zuora

Build 22.0.8462

Views

Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.

Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.

Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.

Zuora Adapter Views

Name Description
Account An account is a customer account that collects all of the critical information about the customer, such as contact information, payment terms, and payment methods.
AccountingCode Each row of this table represents an accounting code.
AccountingPeriod Accounting periods match your financial periods.An accounting period holds the information you need to perform your company's bookkeeping activities, especially tracking and reporting financial activities such as earnings, expenses, and taxes.
Amendment An amendment to a subscription.
ApplicationGroup A group of payment, refund, and credit memo applications.
Attachment The information of a file attached to a Zuora object.
BillingRun Each row of this table represents a billing run.
ChargeMetrics A charge metrics service for accessing the key metrics for Rate Plan Charges in Zuora.
Contact A contact person. For example, the Bill To contact of a customer account
ContactSnapshot A copy of the Bill To or Sold To contact information from a posted invoice.
CreditBalanceAdjustment An adjustment to the credit balance of a customer account.
CreditMemo A credit memo that is owned by a customer account.
CreditMemoApplication A credit memo that is applied to an invoice or a debit memo.
CreditMemoApplicationItem A credit memo that is applied to a line item in an invoice or a line item in a debit memo.
CreditMemoItem A line item in a credit memo.
CreditMemoPart An applied or unapplied portion of a credit memo.
CreditMemoPartItem A portion of a credit memo that is applied to a line item in an invoice or a line item in a debit memo.
CreditTaxationItem A taxation line item in a credit memo.
DebitMemo A debit memo that is owned by a customer account.
DebitMemoItem A line item in a debit memo.
DebitTaxationItem A taxation line item in a debit memo.
DiscountAppliedMetrics A discount rate plan charge that is applied to another rate plan charge.
DiscountApplyDetail Details for the applied discount.
Feature Each row of this table represents a feature.
FXCustomRate A custom exchange rate.
Invoice An invoice represents a bill to a customer.
InvoiceAdjustment An adjustment to an invoice.
InvoiceItem A line item in an invoice.
InvoiceItemAdjustment An adjustment to a line item in an invoice.
InvoicePayment A payment that is applied to an invoice.
JournalEntry A journal entry.
JournalEntryItem A line item in a journal entry.
JournalRun A journal run.
OrderAction An order action that is applied to a subscription.
OrderElp An extended list price metric for an order action.
OrderItem An order item.
OrderMrr A monthly recurring revenue metric for an order action.
OrderQuantity A quantity metric for an order action.
Orders Each row of this table represents an order.
OrderTcb A total contracted billing metric for an order action.
OrderTcv A total contract value metric for an order action.
Payment Each row of this table represents a payment.
PaymentApplication A payment that is applied to an invoice or a debit memo.
PaymentApplicationItem A payment that is applied to a line item in an invoice or a line item in a debit memo.
PaymentGatewayReconciliationEventLog An event that was processed by a payment reconciliation job.
PaymentMethod A payment method.
PaymentMethodSnapshot A copy of the payment method that was used in a transaction.
PaymentMethodTransactionLog A transaction from Zuora to the payment gateway associated with a payment method.
PaymentPart An applied or unapplied portion of a payment.
PaymentPartItem A portion of a payment that is applied to a line item in an invoice or a line item in a debit memo.
PaymentReconciliationJob A payment reconciliation job.
PaymentReconciliationLog A reconciled transaction that was processed by a payment reconciliation job.
PaymentRun A payment run.
PaymentTransactionLog A transaction from Zuora to the payment gateway associated with a payment.
ProcessedUsage Uploaded usage that has been processed.
Product A product in your product catalog.
ProductFeature A feature in your product catalog.
ProductRatePlan A rate plan in your product catalog.
ProductRatePlanCharge A charge in your product catalog.
ProductRatePlanChargeTier A charge tier in your product catalog.
RatePlan A rate plan in a subscription.
RatePlanCharge A charge in a subscription.
RatePlanChargeTier A charge tier in a subscription.
Refund Each row of this table represents a refund.
RefundApplication A refund that is applied to a payment or a credit memo.
RefundApplicationItem A refund that is applied to a line item in a credit memo.
RefundInvoicePayment A refunded portion of a payment that is applied to an invoice.
RefundPart An applied or unapplied portion of a refund.
RefundPartItem A portion of a refund that is applied to a line item in a credit memo.
RefundTransactionLog A transaction from Zuora to the payment gateway associated with a payment.
RevenueChargeSummary A revenue distribution summary of a charge.
RevenueChargeSummaryItem An item in a revenue distribution summary of a charge.
RevenueEvent A revenue event.
RevenueEventCreditMemoItem A revenue event that is associated with a line item in a credit memo.
RevenueEventDebitMemoItem A revenue event that is associated with a line item in a debit memo.
RevenueEventInvoiceItem A revenue event that is associated with a line item in an invoice.
RevenueEventInvoiceItemAdjustment A revenue event that is associated with an adjustment to a line item in an invoice.
RevenueEventItem A revenue event item.
RevenueEventItemCreditMemoItem A revenue event item that is associated with a line item in a credit memo.
RevenueEventItemDebitMemoItem A revenue event item that is associated with a line item in a debit memo.
RevenueEventItemInvoiceItem A revenue event item that is associated with a line item in an invoice.
RevenueEventItemInvoiceItemAdjustment A revenue event item that is associated with an adjustment to a line item in an invoice.
RevenueEventType A revenue event type.
RevenueSchedule A revenue schedule.
RevenueScheduleCreditMemoItem A revenue schedule that is associated with a line item in a credit memo.
RevenueScheduleDebitMemoItem A revenue schedule that is associated with a line item in a debit memo.
RevenueScheduleInvoiceItem A revenue schedule that is associated with a line item in an invoice.
RevenueScheduleInvoiceItemAdjustment A revenue schedule that is associated with an adjustment to a line item in an invoice.
RevenueScheduleItem A revenue schedule item.
RevenueScheduleItemCreditMemoItem A revenue schedule item that is associated with a line item in a credit memo.
RevenueScheduleItemInvoiceItem A revenue schedule item that is associated with a line item in an invoice.
RevenueScheduleItemInvoiceItemAdjustment A revenue schedule item that is associated with an adjustment to a line item in an invoice.
Subscription Each row of this table represents a subscription.
SubscriptionProductFeature Each row of this table represents a subscription for a product feature.
TaxationItem A taxation line item in an invoice.
UpdaterBatch A batch of payment methods that was sent to a payment method updater service provider.
UpdaterDetail A payment method update.
Usage A usage record.f the Active Rating feature is enabled, each row represents a usage record that was created via the Active Rating feature.
User A user in your Zuora tenant. Only platform admin users can access this table.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462