The
audit property allows you to track changes to the record generally and/or columns specifically. No changes to existing tables are required to implement auditing as the changes are recorded in a separate database table created automatically by DbNetSuite. Auditing can be implemeneted at both the row and column level. Setting the control
audit property activates auditing at a row level and setting the column
audit property activates auditing at the column level. In this example
summary auditing is enabled at the row level and also for the
Birth Date,
Hire Date and
Reports To columns.
Summary auditing only records date/user of the last update. Auditing can also be implemented in
detail mode which records a history of all the updates to a row/column.