ビュー
ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。
クエリは、ビューに対して通常のテーブルと同様に実行することができます。
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. |