Skip to main content

The audit tables where the audit information is kept

If a stocked part record is amended, user presses Ctrl and A and generates an Audit Trail of who has created or made changes to that part. Where in the SQL database views or table this information is kept?

B
Written by Bogdan B

From the audit archive database (e.g. FMAST13_A), use tables AuditHead and AuditDetail (case sensitive) to extract the information you require.

On the live and play database (e.g. FMAST13) the HSAUDITHEAD and HSAUDITDETAIL tables contain no data.

Did this answer your question?