====== Transactions Log ======

The Payroll transactions log stores information about all changes made to database tables. User actions like creating, deleting, modifying a table record are recorded in the log.

{{:spay:setupmanual:logstrans.jpg|}}

Action: Recorded action on a table (Add, Update, Delete)


{{:spay:setupmanual:logstrans1.jpg|}}

**Table Name:** The table that was affected by the user's action.

**Primary key:** The primary key identifies the table's record that was affected by the user's action. \\

**Primary key name:** The primary key name helps to identify visually the table's record that was affected.

**Event details:** The details of the user's action on the table's record. This is blank when action is //Delete//.


<code>
In the example for log id 4, user gdi has updated employee 10 - Lecoq Gilles master record,
by changing the monthly basic from 3500 to 3799, and transaction type from 0 to 4.

Two foreign currencies USD and EUR were added to the ForeignCurrency table.
</code>

===== Additional Information =====

{{:skb:info.png|}} Logs generated by the system internal libraries are categorised under System. \\
{{:skb:info.png|}} Logs generated by the running application are categorised under Application. \\
{{:skb:info.png|}} Logs generated by the running application or internal libraries and related to a security issue are categorised under Security.

{{:skb:info.png|}} To identify a record with a primary key consisting of multiple fields the system stores each field one after the other separated by a semi-colon.



===== Related Links =====