Audit Fields

Audit fields keep meta information on the creation of a database record and the last change to the record. The MYOB Acumatica Framework automatically updates audit fields.

To enable the tracking of audit data for a particular table, you should add the columns listed below to the table and declare the corresponding audit data fields in the data access class. You have to add the corresponding type attribute to each audit field.

If the audit columns are properly created in the database table and the corresponding data fields are declared in the data access class, the MYOB Acumatica Framework automatically updates the audit data in these fields every time a data record is modified from the application. The date and time values are stored in the database (in UTC).

The following table shows the database column names, data types and the DAC attributes corresponding to each audit field.