Views

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

CData Excel Add-In for Zuora 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.