> 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.

# Table auditobjectchangeevent

Zuora system records changes of the business objects in the `auditobjectchangeevent` table and allows you to monitor the changes on the following objects, including both regular changes that occur during your business processes and changes triggered by custom logic. Administrators can enable or disable auditing the objects through Manage Audit Trail Settings .

* Account
* Billing Document

  * Invoice
  * CreditMemo
  * DebitMemo
* Billing Document Item

  * InvoiceItem
  * CreditMemoItem
  * DebitMemoItem
  * TaxationItem
  * CreditMemoTaxationItem
  * DebitMemoTaxationItem
* Contact
* CustomFieldDefinition
* Custom Logic

  * CustomLogicDecisionTable
  * CustomLogicDecisionTree
  * CustomLogicFunction
* Custom Object

  * CustomObjectDefinition
  * CustomObjectRecord
* Notification

  * AdvancedSMTPServerSetting
  * CalloutOption (For more information, see [Configure callout settings](/docs/platform/extensibility/events-and-notifications/notifications/callout-notification-overview).)
  * CalloutTemplate
  * CommunicationProfile
  * CustomEvent
  * CustomScheduledEvent
  * EmailTemplate
  * NotificationDefinition
  * OAuth2Provider
  * ReusableBlock
* Order

  * Orders
  * OrderAction
* Order Line Item

  * Order Line Item
  * Order Contact
  * Fulfillment
* Product Catalog

  * Product
  * ProductRatePlan
  * ProductRatePlanCharge
  * ProductRatePlanChargeTier
  * ProductChargeDefinition
  * ProductDiscountApplyDetail
  * ProductUnusedUnitsPrice
* Payment
* PaymentMethod
* PaymentGateway (Only available to Chase Orbital payment gateway)
* Refund
* Subscription

  * Subscription
  * RatePlanCharge
* Workflow

  * GlobalConstants
  * Linkage
  * TaskDefinition
  * WorkflowDefinition
  * WorkflowVersion
* HpmCaptchaCredential (for Google Cloud Enterprise credentials used for Payment Page reCAPTCHA Enterprise configuration)
* Reporting (For more information, see Audit trail for reports )

The `auditobjectchangeevent` table also includes the CustomFieldDefinition object, which represents a custom field that has been defined on a business object.

See the `auditobjectchangeevent` table structure below.

<table>
  <tr>
    <th>
      Attribute
    </th>

    <th>
      Type
    </th>

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

  <tr>
    <td>
      action
    </td>

    <td>
      varchar
    </td>

    <td>
      The change action that is made on the object. Possible values are:

      * UPDATED
      * CREATED
      * DELETED
      * ADDED_TO_COLLECTION
      * REMOVED_FROM_COLLECTION

      The action is `ADDED_TO_COLLECTION` or `REMOVED_FROM_COLLECTION` only if you add or remove picklist values for custom object definitions.
    </td>
  </tr>

  <tr>
    <td>
      username
    </td>

    <td>
      varchar
    </td>

    <td>
      The name of the user who changed the object

      For the following Workflow auditing scenarios, Zuora system user is identified as the user in this field:

      * Users coming through Zuora Connect make changes on the above Workflow objects
      * Basic authentication transactions
    </td>
  </tr>

  <tr>
    <td>
      objectid
    </td>

    <td>
      varchar
    </td>

    <td>
      Id of the changed object
    </td>
  </tr>

  <tr>
    <td>
      attributeid
    </td>

    <td>
      varchar
    </td>

    <td>
      Id of the attribute that is changed. Note that the attributeid is null if the change action is DELETED. The reason is that DELETED action is an object level action. No attribute is changed during DELETED action.
    </td>
  </tr>

  <tr>
    <td>
      oldvalue
    </td>

    <td>
      varchar
    </td>

    <td>
      The previous value of the changed attribute
    </td>
  </tr>

  <tr>
    <td>
      timestamp
    </td>

    <td>
      timestamp with time zone
    </td>

    <td>
      Indicates the time when the event actually occurred in the system.
    </td>
  </tr>

  <tr>
    <td>
      namespace
    </td>

    <td>
      varchar
    </td>

    <td>
      The namespace of the object change. Possible values are:

      * com.zuora.billing
      * com.zuora.custom.logic
      * Workflow
      * com.zuora.custom.objects
    </td>
  </tr>

  <tr>
    <td>
      objectname
    </td>

    <td>
      varchar
    </td>

    <td>
      The name of the changed object
    </td>
  </tr>

  <tr>
    <td>
      transactionid
    </td>

    <td>
      varchar
    </td>

    <td>
      Id of the transaction that the change belongs to
    </td>
  </tr>

  <tr>
    <td>
      objecttype
    </td>

    <td>
      varchar
    </td>

    <td>
      The type of the changed object
    </td>
  </tr>

  <tr>
    <td>
      createdbyid
    </td>

    <td>
      varchar
    </td>

    <td>
      The Id of the user who changes the object
    </td>
  </tr>

  <tr>
    <td>
      userid\*\*
    </td>

    <td>
      varchar
    </td>

    <td>
      Id of the user who changes the object
    </td>
  </tr>

  <tr>
    <td>
      createddate
    </td>

    <td>
      timestamp with time zone
    </td>

    <td>
      Indicates when the audit trail record was generated. The creation time might not match the event change time and can be delayed slightly.
    </td>
  </tr>

  <tr>
    <td>
      sequencenumber
    </td>

    <td>
      bigint
    </td>

    <td>
      The sequence number of the record
    </td>
  </tr>

  <tr>
    <td>
      eventid
    </td>

    <td>
      varchar
    </td>

    <td>
      Id of the object change event
    </td>
  </tr>

  <tr>
    <td>
      newvalue
    </td>

    <td>
      varchar
    </td>

    <td>
      The new value of the changed attribute
    </td>
  </tr>

  <tr>
    <td>
      id
    </td>

    <td>
      varchar
    </td>

    <td>
      Id of the record
    </td>
  </tr>

  <tr>
    <td>
      tokenid
    </td>

    <td>
      varchar
    </td>

    <td>
      Id of the login Token
    </td>
  </tr>

  <tr>
    <td>
      year
    </td>

    <td>
      integer
    </td>

    <td>
      The year when the record is created.
    </td>
  </tr>

  <tr>
    <td>
      month
    </td>

    <td>
      integer
    </td>

    <td>
      The month when the record is created.
    </td>
  </tr>

  <tr>
    <td>
      day
    </td>

    <td>
      integer
    </td>

    <td>
      The day when the record is created.
    </td>
  </tr>
</table>

\*\* While exporting the user table from Data Query, the `userid` is generally expected to be the user ID of the logged-in user who made the change. However, this does not apply when exporting the user table from Data Query for Audit Trail. Zuora recommends you use the `username` field here in place of `userid` to join audit trail tables to the user table.

> **Note**
>
> Currently, the UI does not support retrieving permissions for each role. To obtain entitlements for each role, please contact the Zuora Support team at [support@zuora.com](mailto:support@zuora.com) to request an offline report for auditing purposes.