ODBC Driver for Zuora

Build 24.0.9062

ビュー

ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。

クエリは、ビューに対して通常のテーブルと同様に実行することができます。

CData ODBC Driver for Zuora ビュー

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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062