This is an old revision of the document!
6.5.3. Audit trail
The “Audit trail” function in the Produmex Office module allows to document the change history of relevant Organizational Structure Elements or relevant aspects or characteristics of items, business partners, etc.
6.5.3.1. Prerequisites
Set the changes to track on the History config tab of the Organizational Structure before starting to use the Audit trail function. Changes made in the following tables can be tracked:
| TABLE | |
|---|---|
| Audi | PMX_AUDI |
| Can be lined up | PMX_CBLU |
| Document locking | PMX_DOLL |
| History table | PMX_HCOH |
| History column | PMX_HCOL |
| Item shelf life for partner | PMX_ICSL |
| Inventory locking | PMX_INLD |
| Item zone type | PMX_ITZT |
| Current lined up location | PMX_LIUP |
| Logistic unit | PMX_LUID |
| Link zone – zone type | PMX_LZZT |
| Bin | PMX_OSBI |
| Company | PMX_OSCO |
| Dock | PMX_OSDO |
| Ose element | PMX_OSEL |
| Moveable location | PMX_OSML |
| Packing line | PMX_OSPA |
| Production line | PMX_OSPL |
| Printer | PMX_OSPR |
| Ose storage location | PMX_OSSL |
| Silo/Tank | PMX_OSST |
| Thin client | PMX_OSTC |
| Pmx Warehouse | PMX_OSWH |
| Zone | PMX_OSZO |
| Page size | PMX_PGSZ |
| Print report events | PMX_PRRP |
| Production step list | PMX_PSLH |
| Production step list line | PMX_PSLL |
| Quality status transition | PMX_QSTT |
| Quality status | PMX_QYST |
| Reasons | PMX_REAS |
| Report | PMX_RPRT |
| Route template | PMX_RTTH |
| Route template line | PMX_RTTL |
| Fixed item on location | PMX_SLIT |
| SSCC | PMX_SSCC |
| Zone type | PMX_ZOTY |
EXAMPLE: Route template lines
In the example we will track the changes in route templates.
First we set the PMX_RTTH table to track on the History config window.
For the sake of the example, we updated a route template:
We removed the Customer 3 with the ‘Turkey _Istanbul’ shipping code and added Customer 5 instead. We also changed the route sequence.
6.5.3.2. Audit trail search
To see the change history of the tables you set to track on the History config tab of the Organizational Structure, open the Audit trail search window via the following path: Produmex > Reports > Audit trail.
On this windows filters for the Audit trail can be added.
- Table: The filer will get changes only from the selected table. Please note: every table that can be tracked will be listed, not only the ones that are set to track.
- Column: When a table is selected, it is possible to select a column from a dropdown list. Every column from the table is listed. The filter will get changes only from the selected column(s) of the table.
- User: The filter will only get changes made by the added user.
- From: The filter will get changes made from the selected date.
- Till: The filter will only get changes made until the selected date.
Press the ‘Update’ button to see the details of the Audit trail. The Audit trail details window will open up. In case the user makes no selection, an overview of the complete audit trail will be shown.
EXAMPLE: Route template lines
On the Audit trail search window we select the ‘PMX_RTTL - Route Template Line’ table.
6.5.3.3. Audit trail details
On the Audit trail details window an overview of the changes is shown. Displayed information:
- Table: The table where the record was created.
- Column: The column of the table where the record was created.
- PK: The primary key value of the record of logged table column.
- Type: The type of the change. Possible values are: A -Add, U -Update, D -Delete.
- Old value: The value before the update.
- New value: The value after the update.
- User: The user who updated the record.
- DB User: The database user name.
- Host: The database server.
- Date: Date of creation of the record.
- Time: Time of creation of the record
The list can be filtered further with the standard SBO Filter table function.
EXAMPLE: Route template lines
The overview shows that we deleted ‘Customer 3’ customer from the template, added ‘Customer 5’ to the template then changed the route sequence.
