Data Model of Audit Trail
The Audit Trail records are stored in the following tables:
auditloginevent
auditsettingchangeevent
auditobjectchangeevent
Table auditloginevent
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:
|
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:
|
sequencenumber | bigint | The sequence number of the login record |
status | varchar |
The login status. Possible values are:
|
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:
|
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:
|
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:
|
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:
|
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 |