> This page is for Docs.

> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://zuora.ferndocs.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://zuora.ferndocs.com/_mcp/server.

# Available tables

> This reference provides an overview of available tables in Data Query, differences between tenants, and methods to retrieve table lists using the SHOW TABLES statement and Data Query Schema Browser.

This reference provides an overview of available tables in Data Query, differences between tenants, and methods to retrieve table lists using the SHOW TABLES statement and Data Query Schema Browser.

Depending on the available features in each tenant, the available tables in Data Query might be different between tenants. You can use the `SHOW` `TABLES` statement to retrieve a complete and exact list of the available tables. You can also use [Data Query Schema Browser](/docs/platform/data/data-query/use-data-query-through-user-interface) to view the full list of all available tables.

Each table corresponds to a Zuora object type, and most tables correspond to the base object of a Zuora data source. For more information, refer to [Data source availability](/docs/platform/data/reporting/data-sources-and-exports/data-source-availability) and [Field types](/docs/platform/integration/apis/soap-api/soap-api-object-reference/field-types)

The main difference between tables in Data Query and data sources is that tables in Data Query are not pre-joined to other tables. When you query a table in Data Query, you can arbitrarily join other tables to retrieve any data that you require. In the corresponding data source, Zuora has pre-joined the base object to a fixed set of related object types; you cannot retrieve data from other object types.

To learn how different object types relate to one another, see:

* Zuora Business Object Model
* Invoice Settlement Object Model
* Orders Object Model

To get a complete and exact list of the available tables in your tenant, use `SHOW TABLES`. For more information, refer to [Data Model of Audit Trail](/docs/platform/security-and-identity/audit-trail/audit-trail-using-data-query/data-model-of-audit-trail).

<table>
  <tr>
    <th>
      Table
    </th>

    <th>
      Each Row Represents
    </th>

    <th>
      Columns
    </th>
  </tr>

  <tr>
    <td>
      `Account`
    </td>

    <td>
      A customer account
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns. For more information, refer to [Account](/docs/platform/integration/apis/soap-api/soap-api-object-reference/account).
    </td>
  </tr>

  <tr>
    <td>
      `AccountingPeriod`

      Only available if you use Zuora Finance
    </td>

    <td>
      An accounting period
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns. For more information, refer to [AccountingPeriod](/docs/platform/integration/apis/soap-api/soap-api-object-reference/accountingperiod).
    </td>
  </tr>

  <tr>
    <td>
      `AccountingCode`
    </td>

    <td>
      An accounting code
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns. For more information, refer to [AccountingCode](/docs/platform/integration/apis/soap-api/soap-api-object-reference/accountingcode).
    </td>
  </tr>

  <tr>
    <td>
      `Amendment`

      Not available if the Orders feature is enabled
    </td>

    <td>
      An amendment to a subscription
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns. For more information, refer to [Amendment](/docs/platform/integration/apis/soap-api/soap-api-object-reference/amendment).
    </td>
  </tr>

  <tr>
    <td>
      `ApplicationGroup`

      Only available if the Invoice Settlement feature is enabled
    </td>

    <td>
      A group of payment, refund, and credit memo applications
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `BillingRun`
    </td>

    <td>
      A billing run
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns. For more information, refer to [BillRun](/docs/platform/integration/apis/soap-api/soap-api-object-reference/billrun).
    </td>
  </tr>

  <tr>
    <td>
      `ChargeMetrics`
    </td>

    <td>
      A charge metrics service for accessing the key metrics for Rate Plan Charges in Zuora.
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `ChargeMetricsDiscountAllocationDetail`
    </td>

    <td>
      The discount allocation detail in the charge metrics
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `ChargeMetricsTcb`
    </td>

    <td>
      A charge metrics record for accessing the TCB metric date of Rate Plan Charges.
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `ChargeMetricsTcbDiscount`
    </td>

    <td>
      The discount allocation details for accessing the TCB metric data of Discount Rate Plan Charges.
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `Collections_ApmPaymentRuns`
    </td>

    <td>
      A payment run initiated in the Advanced Payment Manager feature
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `Collections_CollectionsWindowInfo`
    </td>

    <td>
      An account that is in collection based on the system condition and the conditions you defined in the Collections Window feature
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `Collections_ConnectorExecutions`
    </td>

    <td>
      A processing record of the configured lockbox file format in the Configurable Lockbox feature
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `Collections_LockboxRecords`
    </td>

    <td>
      A file record of the configured lockbox file format in the Configurable Lockbox feature
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `Collections_Lockboxes`
    </td>

    <td>
      A lockbox file format configured in the Configurable Lockbox feature
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `Collections_LockboxPayment`
    </td>

    <td>
      A payment record that has been completed or is in progress in the Configurable Lockbox feature
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `Collections_RetryAttempts`
    </td>

    <td>
      A payment retry attempt initiated in the Configurable Payment Retry feature
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `Collections_CustomerGroups`
    </td>

    <td>
      A customer group configured in the Configurable Payment Retry feature
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `Collections_MetricSnapshots`
    </td>

    <td>
      A record of the retry metics in the Configurable Payment Retry feature
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `Collections_RetryCycles`
    </td>

    <td>
      A retry cycle in the Configurable Payment Retry feature
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `Collections_Groups`
    </td>

    <td>
      A user group in the Notes feature
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `Collections_Note`
    </td>

    <td>
      A note in the Notes feature
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `Collections_Replies`
    </td>

    <td>
      A reply in the Notes feature
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `Collections_Commentables`
    </td>

    <td>
      A user in the Notes feature
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `Contact`
    </td>

    <td>
      A contact person. For example, the Bill To contact of a customer account
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns. For more information, refer to [Contact](/docs/platform/integration/apis/soap-api/soap-api-object-reference/contact).
    </td>
  </tr>

  <tr>
    <td>
      `ContactSnapshot`
    </td>

    <td>
      A copy of the Bill To or Sold To contact information from a posted invoice
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns. For more information, refer to [ContactSnapshot](/docs/platform/integration/apis/soap-api/soap-api-object-reference/contactsnapshot).
    </td>
  </tr>

  <tr>
    <td>
      `Country`
    </td>

    <td>
      A country or region
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns. For more information, refer to country state and province codes.
    </td>
  </tr>

  <tr>
    <td>
      `CreditBalanceAdjustment`

      Deprecated if the Invoice Settlement feature is enabled
    </td>

    <td>
      An adjustment to the credit balance of a customer account
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns. For more information, refer to [CreditBalanceAdjustment](/docs/platform/integration/apis/soap-api/soap-api-object-reference/creditbalanceadjustment).
    </td>
  </tr>

  <tr>
    <td>
      `CreditMemo`

      Only available if the Invoice Settlement feature is enabled
    </td>

    <td>
      A credit memo that is owned by a customer account
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `CreditMemoApplication`

      Only available if the Invoice Settlement feature is enabled
    </td>

    <td>
      A credit memo that is applied to an invoice or a debit memo
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `CreditMemoApplicationItem`

      Only available if the Invoice Settlement feature is enabled
    </td>

    <td>
      A credit memo that is applied to a line item in an invoice or a line item in a debit memo
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `CreditMemoItem`

      Only available if the Invoice Settlement feature is enabled
    </td>

    <td>
      A line item in a credit memo
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `CreditMemoPart`

      Only available if the Invoice Settlement feature is enabled
    </td>

    <td>
      An applied or unapplied portion of a credit memo
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `CreditMemoPartItem`

      Only available if the Invoice Settlement feature is enabled
    </td>

    <td>
      A portion of a credit memo that is applied to a line item in an invoice or a line item in a debit memo
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `CreditTaxationItem`

      Only available if the Invoice Settlement feature is enabled
    </td>

    <td>
      A taxation line item in a credit memo
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `DebitMemo`

      Only available if the Invoice Settlement feature is enabled
    </td>

    <td>
      A debit memo that is owned by a customer account
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `DebitMemoItem`

      Only available if the Invoice Settlement feature is enabled
    </td>

    <td>
      A line item in a debit memo
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `DebitTaxationItem`

      Only available if the Invoice Settlement feature is enabled
    </td>

    <td>
      A taxation line item in a debit memo
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `DiscountAppliedMetrics`
    </td>

    <td>
      A discount rate plan charge that is applied to another rate plan charge
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `FXCustomRate`

      Only available if the Custom Foreign Currency Exchange Rates feature is enabled
    </td>

    <td>
      A custom exchange rate
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `Invoice`
    </td>

    <td>
      An invoice
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns. For more information, refer to [Invoice](/docs/platform/integration/apis/soap-api/soap-api-object-reference/invoice).
    </td>
  </tr>

  <tr>
    <td>
      `InvoiceAdjustment`

      Deprecated
    </td>

    <td>
      An adjustment to an invoice
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns. For more information, refer to [InvoiceAdjustment](/docs/platform/integration/apis/soap-api/soap-api-object-reference/invoiceadjustment).
    </td>
  </tr>

  <tr>
    <td>
      `InvoiceItem`
    </td>

    <td>
      A line item in an invoice
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns. For more information, refer to [InvoiceItem](/docs/platform/integration/apis/soap-api/soap-api-object-reference/invoiceitem).
    </td>
  </tr>

  <tr>
    <td>
      `InvoiceItemAdjustment`

      Deprecated if the Invoice Settlement feature is enabled
    </td>

    <td>
      An adjustment to a line item in an invoice
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns. For more information, refer to [InvoiceItemAdjustment](/docs/platform/integration/apis/soap-api/soap-api-object-reference/invoiceitemadjustment).
    </td>
  </tr>

  <tr>
    <td>
      `InvoicePayment`

      Deprecated if the Invoice Settlement feature is enabled
    </td>

    <td>
      A payment that is applied to an invoice
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns. For more information, refer to [InvoicePayment](/docs/platform/integration/apis/soap-api/soap-api-object-reference/invoicepayment).
    </td>
  </tr>

  <tr>
    <td>
      `JournalEntry`

      Only available if you use Zuora Finance
    </td>

    <td>
      A journal entry
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `JournalEntryItem`

      Only available if you use Zuora Finance
    </td>

    <td>
      A line item in a journal entry
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `JournalRun`

      Only available if you use Zuora Finance
    </td>

    <td>
      A journal run
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `notificationhistorycallout`
    </td>

    <td>
      A callout notification history
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `notificationhistoryemail`
    </td>

    <td>
      An email notification history
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `notificationhistoryemailevent`
    </td>

    <td>
      An email-sending event, such as Bounced events, or Delivered events.

      Note that you can find events of a particular email history in this table only if this email was sent from the default email server or Advanced SMTP server. For more information, refer to [SMTP server for email notifications](/docs/platform/extensibility/events-and-notifications/configure-email-settings/smtp-server-for-email-notifications).
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `OrderAction`

      Only available if the Order Metrics feature, the Orders feature, or the Orders Harmonization feature is enabled
    </td>

    <td>
      An order action that is applied to a subscription
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `OrderActionRatePlan`

      Only available if the Orders feature or the Orders Harmonization feature is enabled. Click the use case below to see a query sample.

      Query the rate plan added by the Add Product order action in an order `SELECT rp.Id, rp.Name, rp.ProductRatePlanId, rp.SubscriptionId, rp.CreatedDate FROM Orders o JOIN OrderAction oa ON oa.OrderId = o.Id JOIN OrderActionRatePlan oaRp ON oaRp.OrderActionId = oa.Id JOIN RatePlan rp ON rp.Id = oaRp.RatePlanId WHERE o.OrderNumber = 'O-00001' AND oa.Type = 'AddProduct'`
    </td>

    <td>
      A rate plan (in a subscription) that has been created or amended by a specific order action
    </td>

    <td>
      Use SHOW COLUMNS to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `OrderLineItem`

      > **Note**
      >
      > The Order Line Items feature is now generally available. You need to enable the Orders or Orders Harmonization feature to access the Order Line Items feature.
    </td>

    <td>
      An order line item
    </td>

    <td>
      Use SHOW COLUMNS to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `OrderElp`

      Only available if the Order Metrics feature or the Orders feature is enabled

      > **Note**
      >
      > The following Order Metrics have been deprecated. Any new customers who onboard on Orders or Orders Harmonization will not get these metrics.
      >
      > * The Order ELP and Order Item objects
      > * The "Generated Reason" and "Order Item ID" fields in the Order MRR, Order TCB, Order TCV, and Order Quantity objects
      >
      > Existing Orders customers who have these metrics will continue to be supported.
    </td>

    <td>
      An "extended list price" metric for an order action
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `OrderItem`

      Only available if the Order Metrics feature or the Orders feature is enabled

      > **Note**
      >
      > The following Order Metrics have been deprecated. Any new customers who onboard on Orders or Orders Harmonization will not get these metrics.
      >
      > * The Order ELP and Order Item objects
      > * The "Generated Reason" and "Order Item ID" fields in the Order MRR, Order TCB, Order TCV, and Order Quantity objects
      >
      > Existing Orders customers who have these metrics will continue to be supported.
    </td>

    <td>
      An order item
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `OrderMrr`

      Only available if the Order Metrics feature, the Orders feature, or the Orders Harmonization feature is enabled

      > **Note**
      >
      > The following Order Metrics have been deprecated. Any new customers who onboard on Orders or Orders Harmonization will not get these metrics.
      >
      > * The Order ELP and Order Item objects
      > * The "Generated Reason" and "Order Item ID" fields in the Order MRR, Order TCB, Order TCV, and Order Quantity objects
      >
      > Existing Orders customers who have these metrics will continue to be supported.
    </td>

    <td>
      A "monthly recurring revenue" metric for an order action
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `OrderQuantity`

      Only available if the Order Metrics feature, the Orders feature, or the Orders Harmonization feature is enabled

      > **Note**
      >
      > The following Order Metrics have been deprecated. Any new customers who onboard on Orders or Orders Harmonization will not get these metrics.
      >
      > * The Order ELP and Order Item objects
      > * The "Generated Reason" and "Order Item ID" fields in the Order MRR, Order TCB, Order TCV, and Order Quantity objects
      >
      > Existing Orders customers who have these metrics will continue to be supported.
    </td>

    <td>
      A "quantity" metric for an order action
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `Orders`

      Only available if the Order Metrics feature, the Orders feature, or the Orders Harmonization feature is enabled
    </td>

    <td>
      An order
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `OrderTcb`

      Only available if the Order Metrics feature, the Orders feature, or the Orders Harmonization feature is enabled

      > **Note**
      >
      > The following Order Metrics have been deprecated. Any new customers who onboard on Orders or Orders Harmonization will not get these metrics.
      >
      > * The Order ELP and Order Item objects
      > * The "Generated Reason" and "Order Item ID" fields in the Order MRR, Order TCB, Order TCV, and Order Quantity objects
      >
      > Existing Orders customers who have these metrics will continue to be supported.
    </td>

    <td>
      A "total contracted billing" metric for an order action
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `OrderTcv`

      Only available if the Order Metrics feature, the Orders feature, or the Orders Harmonization feature is enabled

      > **Note**
      >
      > The following Order Metrics have been deprecated. Any new customers who onboard on Orders or Orders Harmonization will not get these metrics.
      >
      > * The Order ELP and Order Item objects
      > * The "Generated Reason" and "Order Item ID" fields in the Order MRR, Order TCB, Order TCV, and Order Quantity objects
      >
      > Existing Orders customers who have these metrics will continue to be supported.
    </td>

    <td>
      A "total contract value" metric for an order action
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `Payment`
    </td>

    <td>
      A payment
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns. For more information, refer to [Payment](/docs/platform/integration/apis/soap-api/soap-api-object-reference/payment-object).
    </td>
  </tr>

  <tr>
    <td>
      `PaymentApplication`

      Only available if the Invoice Settlement feature is enabled
    </td>

    <td>
      A payment that is applied to an invoice or a debit memo
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `PaymentApplicationItem`

      Only available if the Invoice Settlement feature is enabled
    </td>

    <td>
      A payment that is applied to a line item in an invoice or a line item in a debit memo
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `PaymentGatewayReconciliation EventLog`
    </td>

    <td>
      An event that was processed by a payment reconciliation job
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `PaymentMethod`
    </td>

    <td>
      A payment method
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns. For more information, refer to [PaymentMethod](/docs/platform/integration/apis/soap-api/soap-api-object-reference/paymentmethod).
    </td>
  </tr>

  <tr>
    <td>
      `PaymentMethodSnapshot`
    </td>

    <td>
      A copy of the payment method that was used in a transaction
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns. For more information, refer to [PaymentMethodSnapshot](/docs/platform/integration/apis/soap-api/soap-api-object-reference/paymentmethodsnapshot).
    </td>
  </tr>

  <tr>
    <td>
      `PaymentMethodTransactionLog`
    </td>

    <td>
      A transaction from Zuora to the payment gateway associated with a payment method.

      If Zuora Fraud Protection is enabled, the record of data related to the fraud protection service is also included.
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `PaymentPart`

      Only available if the Invoice Settlement feature is enabled
    </td>

    <td>
      An applied or unapplied portion of a payment
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `PaymentPartItem`

      Only available if both Invoice Settlement and Invoice Item Settlement are enabled
    </td>

    <td>
      A portion of a payment that is applied to a line item in an invoice or a line item in a debit memo
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `PaymentReconciliationJob`
    </td>

    <td>
      A payment reconciliation job
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `PaymentReconciliationLog`
    </td>

    <td>
      A reconciled transaction that was processed by a payment reconciliation job
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns
    </td>
  </tr>

  <tr>
    <td>
      `PaymentRun`
    </td>

    <td>
      A payment run
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `PaymentTransactionLog`
    </td>

    <td>
      A transaction from Zuora to the payment gateway associated with a payment.

      If Zuora Fraud Protection is enabled, the record of data related to the fraud protection service is also included.
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `ProcessedUsage`
    </td>

    <td>
      Uploaded usage that has been processed
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `Product`
    </td>

    <td>
      A product in your product catalog
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns. For more information, refer to [Product](/docs/platform/integration/apis/soap-api/soap-api-object-reference/product).
    </td>
  </tr>

  <tr>
    <td>
      `ProductFeature`

      Only available if you use Entitlements
    </td>

    <td>
      A feature in your product catalog
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns. For more information, refer to [ProductFeature](/docs/platform/integration/apis/soap-api/soap-api-object-reference/productfeature).
    </td>
  </tr>

  <tr>
    <td>
      `ProductRatePlan`
    </td>

    <td>
      A rate plan in your product catalog
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns. For more information, refer to [ProductRatePlan](/docs/platform/integration/apis/soap-api/soap-api-object-reference/productrateplan).
    </td>
  </tr>

  <tr>
    <td>
      `ProductRatePlanCharge`
    </td>

    <td>
      A charge in your product catalog
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns. For more information, refer to [ProductRatePlanCharge](/docs/platform/integration/apis/soap-api/soap-api-object-reference/productrateplancharge).
    </td>
  </tr>

  <tr>
    <td>
      `ProductRatePlanChargeTier`
    </td>

    <td>
      A charge tier in your product catalog
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns. For more information, refer to [ProductRatePlanChargeTier](/docs/platform/integration/apis/soap-api/soap-api-object-reference/productrateplanchargetier).
    </td>
  </tr>

  <tr>
    <td>
      `RatePlan`
    </td>

    <td>
      A rate plan in a subscription
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns. For more information, refer to [RatePlan](/docs/platform/integration/apis/soap-api/soap-api-object-reference/rateplan).
    </td>
  </tr>

  <tr>
    <td>
      `RatePlanCharge`
    </td>

    <td>
      A charge in a subscription
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns. For more information, refer to [RatePlanCharge](/docs/platform/integration/apis/soap-api/soap-api-object-reference/rateplancharge).
    </td>
  </tr>

  <tr>
    <td>
      `RatePlanChargeTier`
    </td>

    <td>
      A charge tier in a subscription
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns. For more information, refer to [RatePlanChargeTier](/docs/platform/integration/apis/soap-api/soap-api-object-reference/rateplanchargetier).
    </td>
  </tr>

  <tr>
    <td>
      `Ramp`
    </td>

    <td>
      A ramp in an order defined in a ramp deal
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `RampInterval`
    </td>

    <td>
      A ramp interval in a ramp
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `Refund`
    </td>

    <td>
      A refund
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns. For more information, refer to [Refund](/docs/platform/integration/apis/soap-api/soap-api-object-reference/refund-object).
    </td>
  </tr>

  <tr>
    <td>
      `RefundApplication`

      Only available if the Invoice Settlement feature is enabled
    </td>

    <td>
      A refund that is applied to a payment or a credit memo
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `RefundApplicationItem`

      Only available if the Invoice Settlement feature is enabled
    </td>

    <td>
      a refund that is applied to a line item in a credit memo
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `RefundInvoicePayment`

      Deprecated if the Invoice Settlement feature is enabled
    </td>

    <td>
      A refunded portion of a payment that is applied to an invoice
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns. For more information, refer to [RefundInvoicePayment](/docs/platform/integration/apis/soap-api/soap-api-object-reference/refundinvoicepayment).
    </td>
  </tr>

  <tr>
    <td>
      `RefundPart`

      Only available if the Invoice Settlement feature is enabled
    </td>

    <td>
      An applied or unapplied portion of a refund
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `RefundPartItem`

      Only available if both Invoice Settlement and Invoice Item Settlement are enabled
    </td>

    <td>
      A portion of a refund that is applied to a line item in a credit memo
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `RefundTransactionLog`
    </td>

    <td>
      A transaction from Zuora to the payment gateway associated with a payment
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `RevenueChargeSummary`

      Only available if you use Zuora Finance - Revenue
    </td>

    <td>
      A revenue distribution summary of a charge
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `RevenueChargeSummaryItem`

      Only available if you use Zuora Finance - Revenue
    </td>

    <td>
      An item in a revenue distribution summary of a charge
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `RevenueEvent`

      Only available if you use Zuora Finance - Revenue
    </td>

    <td>
      A revenue event
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `RevenueEventCreditMemoItem`

      Only available if you use Zuora Finance - Revenue and the Invoice Settlement feature is enabled
    </td>

    <td>
      A revenue event that is associated with a line item in a credit memo
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `RevenueEventDebitMemoItem`

      Only available if you use Zuora Finance - Revenue and the Invoice Settlement feature is enabled
    </td>

    <td>
      A revenue event that is associated with a line item in a debit memo
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `RevenueEventInvoiceItem`

      Only available if you use Zuora Finance - Revenue
    </td>

    <td>
      A revenue event that is associated with a line item in an invoice
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `RevenueEventInvoiceItem Adjustment`

      Only available if you use Zuora Finance - Revenue
    </td>

    <td>
      A revenue event that is associated with an adjustment to a line item in an invoice
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `RevenueEventItem`

      Only available if you use Zuora Finance - Revenue
    </td>

    <td>
      A revenue event item
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `RevenueEventItemCreditMemo Item`

      Only available if you use Zuora Finance - Revenue and the Invoice Settlement feature is enabled
    </td>

    <td>
      A revenue event item that is associated with a line item in a credit memo
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `RevenueEventItemDebitMemo Item`

      Only available if you use Zuora Finance - Revenue and the Invoice Settlement feature is enabled
    </td>

    <td>
      A revenue event item that is associated with a line item in a debit memo
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `RevenueEventItemInvoice Item`

      Only available if you use Zuora Finance - Revenue
    </td>

    <td>
      A revenue event item that is associated with a line item in an invoice
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `RevenueEventItemInvoice ItemAdjustment`

      Only available if you use Zuora Finance - Revenue
    </td>

    <td>
      A revenue event item that is associated with an adjustment to a line item in an invoice
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `RevenueEventType`

      Only available if you use Zuora Finance - Revenue
    </td>

    <td>
      A revenue event type
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `RevenueSchedule`

      Only available if you use Zuora Finance - Revenue
    </td>

    <td>
      A revenue schedule
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `RevenueScheduleCreditMemo Item`

      Only available if you use Zuora Finance - Revenue and the Invoice Settlement feature is enabled
    </td>

    <td>
      A revenue schedule that is associated with a line item in a credit memo
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `RevenueScheduleDebitMemo Item`

      Only available if you use Zuora Finance - Revenue and the Invoice Settlement feature is enabled
    </td>

    <td>
      A revenue schedule that is associated with a line item in a debit memo
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `RevenueScheduleInvoice Item`

      Only available if you use Zuora Finance - Revenue
    </td>

    <td>
      A revenue schedule that is associated with a line item in an invoice
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `RevenueScheduleInvoice ItemAdjustment`

      Only available if you use Zuora Finance - Revenue
    </td>

    <td>
      A revenue schedule that is associated with an adjustment to a line item in an invoice
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `RevenueScheduleItem`

      Only available if you use Zuora Finance - Revenue
    </td>

    <td>
      a revenue schedule item
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `RevenueScheduleItemCreditMemo Item`

      Only available if you use Zuora Finance - Revenue and the Invoice Settlement feature is enabled
    </td>

    <td>
      A revenue schedule item that is associated with a line item in a credit memo
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `RevenueScheduleItemDebitMemo Item`

      Only available if you use Zuora Finance - Revenue and the Invoice Settlement feature is enabled
    </td>

    <td>
      A revenue schedule item that is associated with a line item in a debit memo
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `RevenueScheduleItemInvoice Item`

      Only available if you use Zuora Finance - Revenue
    </td>

    <td>
      a revenue schedule item that is associated with a line item in an invoice
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `RevenueScheduleItemInvoice ItemAdjustment`

      Only available if you use Zuora Finance - Revenue
    </td>

    <td>
      A revenue schedule item that is associated with an adjustment to a line item in an invoice
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `State`
    </td>

    <td>
      A subregion of a country or region
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns. For more information, refer to view subregions of a specific country or region.
    </td>
  </tr>

  <tr>
    <td>
      `Subscription`
    </td>

    <td>
      A subscription
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns. For more information, refer to [Subscription](/docs/platform/integration/apis/soap-api/soap-api-object-reference/subscription).
    </td>
  </tr>

  <tr>
    <td>
      `SubscriptionStatusHistory`
    </td>

    <td>
      The status history of a subscription
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `TaxableItemSnapshot`

      Only available if the Taxable Item Snapshot feature is enabled
    </td>

    <td>
      A copy of information that was used in a tax calculation
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns. For more information, refer to [TaxableItemSnapshot](/docs/platform/integration/apis/soap-api/soap-api-object-reference/taxableitemsnapshot).
    </td>
  </tr>

  <tr>
    <td>
      `TaxationItem`
    </td>

    <td>
      A taxation line item in an invoice
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns. For more information, refer to [TaxationItem](/docs/platform/integration/apis/soap-api/soap-api-object-reference/taxationitem).
    </td>
  </tr>

  <tr>
    <td>
      `UpdaterBatch`
    </td>

    <td>
      A batch of payment methods that was sent to a payment method updater service provider
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `UpdaterDetail`
    </td>

    <td>
      A payment method update
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `Usage`
    </td>

    <td>
      A usage record

      If the Active Rating feature is enabled, Each row represents a usage record that was created via the Active Rating feature
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns. For more information, refer to [Usage](/docs/platform/integration/apis/soap-api/soap-api-object-reference/usage).
    </td>
  </tr>

  <tr>
    <td>
      `User`

      Only platform admin users can access the `User` table
    </td>

    <td>
      A user in your Zuora tenant
    </td>

    <td>
      * `email`
      * `firstname`
      * `id`
      * `lastname`
      * `username`
    </td>
  </tr>

  <tr>
    <td>
      `workflow`
    </td>

    <td>
      A workflow version or a workflow run. For more information, refer to [Use Data Query to report on Workflow](/docs/platform/extensibility/workflow/report-on-workflow/use-data-query-to-report-on-workflow).
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `workflow_api_call`
    </td>

    <td>
      An API call made during a workflow run. For more information, refer to [Use Data Query to report on Workflow](/docs/platform/extensibility/workflow/report-on-workflow/use-data-query-to-report-on-workflow).
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `workflow_linkage`
    </td>

    <td>
      A connection between two tasks in a workflow version. For more information, refer to [Use Data Query to report on Workflow](/docs/platform/extensibility/workflow/report-on-workflow/use-data-query-to-report-on-workflow).
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `workflow_task`
    </td>

    <td>
      A task that is part of a workflow version or a workflow run. For more information, refer to [Use Data Query to report on Workflow](/docs/platform/extensibility/workflow/report-on-workflow/use-data-query-to-report-on-workflow).
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `workflow_task_usage`
    </td>

    <td>
      Your entity's usage of Workflow over a single day. For more information, refer to [Use Data Query to report on Workflow](/docs/platform/extensibility/workflow/report-on-workflow/use-data-query-to-report-on-workflow).
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `workflow_definition`
    </td>

    <td>
      A workflow definition that has at least one workflow version. For more information, refer to [Use Data Query to report on Workflow](/docs/platform/extensibility/workflow/report-on-workflow/use-data-query-to-report-on-workflow).
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>

  <tr>
    <td>
      `attachment`
    </td>

    <td>
      The information of a file attached to a Zuora object. You can now query the attachment file information of the following Zuora objects:

      * `debitmemo`
      * `creditmemo`
      * `account`
      * `subscription`
      * `invoice`
    </td>

    <td>
      Use `SHOW COLUMNS` to list the available columns.
    </td>
  </tr>
</table>

By default, all UUIDs are handled as 32-character strings. To enable 36-character UUIDs, submit a request at [Zuora Global Support](https://support.zuora.com/).

To assist with converting between 32-character UUIDs and 36-character UUIDs, Zuora provides the following custom functions:

<table>
  <tr>
    <th>
      Function
    </th>

    <th>
      Description
    </th>
  </tr>

  <tr>
    <td>
      `to_uuid32`
    </td>

    <td>
      Converts a 36-character object identifier to a 32-character object identifier. Newer Zuora features such as Data Query and the Active Rating feature use 36-character object identifiers, while older features use 32-character object identifiers.

      For example:

      ```
      to_uuid32('2c92c0f9-67bb-659c-0167-be58d878735f')
      ```

      Returns:

      ```
      2c92c0f967bb659c0167be58d878735f
      ```

      See the "Examples" section below for a sample query that uses the `to_uuid32` function.
    </td>
  </tr>

  <tr>
    <td>
      `to_uuid36`
    </td>

    <td>
      Converts a 32-character object identifier to a 36-character object identifier. Newer Zuora features such as Data Query and the Active Rating feature use 36-character object identifiers, while older features use 32-character object identifiers.

      For example:

      ```
      to_uuid36('2c92c0f967bb659c0167be58d878735f')
      ```

      Returns:

      ```
      2c92c0f9-67bb-659c-0167-be58d878735f
      ```

      See the "Examples" section below for a sample query that uses the `to_uuid36` function.
    </td>
  </tr>
</table>

## Get the date value of a timestamp

You can get the date value of a timestamp by calling the `date` function. The syntax of this function is as follows:

* `date(<timestamp>)`
* `date(<timestamp> AT TIME ZONE <timezone>)`

The `date` function takes the `timestamp` parameter and returns a date value. The `timestamp` parameter is required. You can get the date in a particular time zone by specifying a `timezone` after the `timestamp`.

Assuming the current date and time are 2023-01-12 04:30:00 UTC, the results of some typical examples are as follows:

| Function expression                                                | Result     | Description                                                                                                          |
| ------------------------------------------------------------------ | ---------- | -------------------------------------------------------------------------------------------------------------------- |
| date(CURRENT_TIMESTAMP)                                            | 2023-01-12 | Returns the date of current UTC.                                                                                     |
| date(CURRENT_TIMESTAMP AT TIME ZONE '-08:00')                      | 2023-01-11 | Returns the date of current UTC in UTC-08:00 time zone.                                                              |
| date(CURRENT_TIMESTAMP AT TIME ZONE 'America/Los_Angeles')         | 2023-01-11 | Returns the date of current UTC in Los Angeles time zone (UTC-07:00 or UTC-08:00 depending on the time of the year). |
| date(timestamp '2022-12-30 13:30:00')                              | 2022-12-30 | Returns the date of 2022-12-30 13:30:00 UTC.                                                                         |
| date(timestamp '2022-12-30 13:30:00 -08:00')                       | 2022-12-30 | Returns the date of 2022-12-30 13:30:00 UTC-08:00.                                                                   |
| date(timestamp '2022-12-30 13:30:00 -08:00' AT TIME ZONE 'UTC')    | 2022-12-30 | Returns the date of 2022-12-30 13:30:00 UTC-08:00 in UTC time zone.                                                  |
| date(timestamp '2022-12-30 13:30:00 -08:00' AT TIME ZONE '+08:00') | 2022-12-31 | Returns the date of 2022-12-30 13:30:00 UTC-08:00 in UTC+08:00 time zone.                                            |

For more information about how to use the date function in queries, see [Best-practice samples for common queries](/docs/platform/data/data-query/best-practices-when-writing-data-queries/best-practice-samples-for-common-queries).