Audit Details Dialog#
The Show Audit Details dialog displays the current information for each record on the table that is currently in focus.
The dialog can be called up by pressing the Show Audit Details icon or by pressing F12.
The user can navigate through the list of column names to determine the changed value for each column on the table in focus.
The dialog can be used to determine the row id of the parent table as well as the dependent table.
The user can determine when the last change was made to the table and by whom by reviewing the Change_Date and Change_User columns.
The dialog also displays a preference value should one exist for a column within the table in focus.
- Column Name
- These field identifies the column names available on the selected record.
- Prompt
- The prompt given to the field will display here.
- Domain
- The domain name of the column will be displayed here.
- In Query
- This toggle indicates which fields on the selected record may be queried.
- Preference Value
- If a preference value was defined for the column, the preference value will appear here.
- Column Name
- These field identifies the column name.
- Base Column
- This field identifies the base column associated to the column in focus above.
- Function
- The name of the function where the change took place will display here.
- Form Group
- This field identifies the Form Group the column may be found in within the form definition in IMFD.
- LOV Code
- If the field is tied to a List Of Values, the LOV Code will display here.
- LOV Where Clause
- If a Where Clause is tied to the LOV, the Where Clause Code will display here.
- Form Item Usage
- This field displays the usage of the Form Item, i.e. Pre-Defined, User Defined
- Old Value
- This field will display the value before the change was made.
- Current Value
- This field will display the current value of the field.