Prev
Next
Forums Human Capital Management Infor Global HR (GHR)

What table contains CHANGEDFIELDS

 1 Replies
 0 Subscribed to this topic
 45 Subscribed to this forum
Sort:
Author
Messages
TimC
Veteran Member Send Private Message
Posts: 84
Veteran Member
6/19/2017 5:55 PM
I need to query the export tables and need the CHANGEDFIELDS field as it doesn't exists on the ...EXPORT tables (WorkassignmentExport, EmployeeExport. What tables correlate that I can join to fetch this field? Landmark V10.
TimC
Veteran Member Send Private Message
Posts: 84
Veteran Member
6/20/2017 1:03 PM
I figured it out. This is the SQL Server version SELECT t.name,c.name FROM sys.columns c JOIN sys.tables t ON c.object_id = t.object_id WHERE c.name LIKE '%CHANGEDFIELDS%'