Lawson Data Column Xref

Are you Oracle, SQL, or DB2?

SELECT DISTINCT FILENAME FROM GEN.FILEFLD WHERE PRODUCTLINE = 'PROD' AND (FIELDNAME = 'DEPARTMENT' OR ELEMENTNAME = 'DEPARTMENT')

I don't have the SQL or DB2 query handy, but you can do this in Oracle with something along these lines:

SELECT DISTINCT TABLE_NAME, COLUMN_NAME
FROM ALL_TAB_COLUMNS
WHERE OWNER = 'PROD'
AND (COLUMN_NAME = 'DEPARTMENT' OR
         COLUMN_NAME LIKE '%DEPT%' OR
         COLUMN_NAME LIKE '%DPT%')

You will need to replace 'PROD'  with the schema name where your Lawson tables reside.

We are on MS SQL - not sure what the equivalent of all_tab_columns is in SQL but John's query worked - just had to change column name from "fieldname" to "fldname".

Thanks guys!

Here is another way if anyone is interested - this came from Lawson:

 o into dbdef, select the productline, Click F6 and choose A. Files, Enter a table into the File Name field, like EMPLOYEE, which contains the DEPARTMENT field.
Click F5 and choose A. Field Usage Report.