Skip to main content

Data Model of Audit Trail

Zuora

Data Model of Audit Trail

The Audit Trail records are stored in the following tables:

  • auditloginevent
  • auditsettingchangeevent
  • auditobjectchangeevent

Table auditloginevent

The Zuora system records every login for each user in the auditloginevent table and allows you to monitor the login history for each and every user. See the table structure below.

Attribute Type Description
browsertype varchar

The login user's browser type. Possible values are:

  • IE
  • FireFox
  • Safari
  • Netscape
  • Chrome
  • Opera
  • Api
  • Unknown
  • RestLogin
  • RestBiz
browserversion varchar The login user's browser version
createdbyid varchar The login user's id
createddate timestamp with time zone The record's creation date
eventid varchar Id of the login event
hostname varchar The device connected to the network (currently not work, the value is the same as ipaddress)
id varchar Id of the record
ipaddress varchar The login IP address
logintype varchar

The login type. Possible values are:

  • CLIENT_CREDENTIALS
  • SSO
  • PASSWORD
  • SWITCH_ENTITY_UI
sequencenumber bigint The sequence number of the login record
status varchar

The login status. Possible values are:

  • Success
  • AuthFail
  • PasswordExpired
timestamp timestamp with time zone The timestamp of the login
tokenid varchar The id of the login token
userid varchar Id of the login user
username varchar The user name of the login user
version varchar Login History API version

Table auditsettingchangeevent

Zuora system records every setting changes in the auditsettingchangeevent table and allows you to monitor the setting changes that impact accounting and financials.

Changes on the following settings can be monitored by Zuora Audit Trail:

  • Billing
    • Define Billing Rules
    • Manage Tax codes
    • Define Discount Settings
    • Manage Revenue Recognition Codes
    • Configure Tax Dates 
  • Payment
    • Configure Application Rules
  • Commerce
    • Synchronize Salesforce.com Data
  • Finance
    • Configure Accounting Codes
    • Configure Accounting Rules
    • Manage Currency Conversion
    • Set Revenue Automation Start Date
    • Configure Revenue Event Types
    • Manage Revenue Recognition Models
    • Configure Segments
    • Configure GL Segmentation Rules
    • Manage Revenue Recognition Rules
    • Manage Chart of Accounts
  • User
  • Role & Permission

See the auditsettingchangeevent table structure below.

Attribute Type Description
action varchar

The setting change action. Possible values are:

  • UPDATED
  • CREATED
  • DELETED
  • ADDED_TO_COLLECTION
  • REMOVED_FROM_COLLECTION
attributeid varchar Id of the changed setting item
attributename varchar The name of the changed setting item
createdbyid varchar The Id of the user who changes the setting item
createddate timestamp with time zone The record's creation date
eventid varchar Id of the event
id varchar Id of the record
namespace varchar

The namespace of the setting change. Possible values are:

  • Finance & Revenue
  • Billing
  • Invoicing
  • Commerce
  • Tenant Property
  • Payments
  • UserManagement
newvalue varchar The new value of the setting
oldvalue varchar The previous value of the setting
sequencenumber bigint The sequence number of the record
settingobjectname varchar

The setting object name.

settingtype varchar

The setting type. For example, BillingRules, TaxCode, RevenueRecognition, and so on.

timestamp timestamp with time zone The timestamp of the setting change 
tokenid varchar The Id of the login token
transactionid varchar The Id of the setting change transaction
userid varchar The Id of the user who changes the setting item
username varchar user name

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:

  • Account
  • Contact
  • Product Catalog
    • Product
    • ProductRatePlan
    • ProductRatePlanCharge
    • ProductRatePlanChargeTier
    • ProductDiscountApplyDetail
    • ProductUnusedUnitsPrice
  • PaymentMethod
  • Payment
  • Refund

See the auditobjectchangeevent table structure below.

Attribute Type Description

action

varchar

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

  • UPDATED
  • CREATED
  • DELETED

username

varchar

The name of the user who changes the object

objectid

varchar

Id of the changed object

attributeid

varchar

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.

oldvalue

varchar

The previous value of the changed attribute

timestamp

timestamp with time zone

The timestamp of the object change

namespace

varchar

The namespace of the object change. Possible values are:

  • com.zuora.billing

objectname

varchar

The name of the changed object

transactionid

varchar

Id of the transaction that the change belongs to

objecttype

varchar

The type of the changed object

createdbyid

varchar

The Id of the user who changes the object

userid

varchar

Id of the user who changes the object

createddate

timestamp with time zone

The record's creation date

sequencenumber

bigint

The sequence number of the record

eventid

varchar

Id of the object change event

newvalue

varchar

The new value of the changed attribute

id

varchar

Id of the record

tokenid

varchar

Id of the login Token