Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Querying a business class

 0 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Casy
Advanced Member
Posts: 31
Advanced Member
8/12/2019 7:27 PM
    We pull data from the SQL database for our Landmark environment. There is a field that we were unable to locate a table for and according to support, this field is only located in the audit log. The instructions provided on how to query the audit log are convoluted at best. Is anyone aware of a table that houses the below:

    Business Class: Employee
    Form Name: Terminate
    BusFormAttribute Name: Employee_reason_code

    Any idea if it truly does ONLY exist in the audit log?? We are on V10 Landmark. Thank you!