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.
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 Branetiu
Updated this week