Audit and Service Logs; remove link between these two tables

Previously Service Logs would store charge/ billing information in the Audit Log table. Service Log records included a link back to the Audit Log record where this information was saved.

However, this is not ideal, therefore Service Logs no longer rely on Audit Logs to hold this information.

The following additional fields are now stored in the ISServiceLog table:

• Chargeable
• ChargeCount (Number of SMS Message Parts sent)
• BillingReference1
• BillingReference2
• MachineName
• IPAddress
• IPAddressExternal
• WindowsUser

During the database upgrade this information is moved from the ISAuditLog table to the ISServiceLog table.

In addition, since they are no longer used, these fields have been removed from the ISAuditLog table and all Chargeable and Non-Chargeable records have been deleted.

Note, the Service Log form includes additional information such as Charge/ Billing information and additional Audit details for IP Address, Machine Name and Windows User.