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
detail auditing is enabled at the row level and also for the
Birth Date,
Hire Date and
Reports To columns.
Detail auditing records a history of all the updates to a row/column. For column auditing the previous value of the column is also saved.