Data File Text equivalent for PLM tables?

Hi Chris!!

You probably already know this trick so forgive me if I'm preaching to the choir.

I can't remember where I picked up this trick but here is a super quick way to link back the 3 character table name to a Lawson table (without cracking the data file text book). I open up the MS Add in (v 2.0.5), select my data source, and type the 3 character table name in the table prefix field. I tab over to the translation field and it displays the Lawson table (example PLANMASTER TA). If I am not familar with the table I log into the Lawson knowledge base and type "data file text for TA system". If I'm not logged into the support site, I use lid to form transfer F8 to the Environment TAB. I enter GENDOC and then dbdoc. I run my little query on PLANMASTER and write the output to a text file. The last step if to transfer the text file to my workstation.

Take care and thanks for the help you've given me in the past!!

If you have LID then use rngdbdump to gen table called filedef. Also if you have sql access to your tables then you can do an sql select statement to gen.filedef

ex... select filename from gen.filedef
where prefix = 'API';

Sorry guys, I should have clarified. PLM refers to Lawson's Fashion app (Product Lifecycle Management).

I've written a little script which produces a web page dbdoc type of output that I have linked to our "?" menu here. Let me see if I can find it, if anyone is interested?

Run it once, and it creates the html files that you can then display from any web server.

I'm not familiar with PLM, though, so this may or may not work to your satisfaction.

Here is a copy of the script I was talking about.
I hope that some of you are able to use it effectively.
I know that it has been wonderful for especially our LBI report writers here.

This script in conjunction with an old script of David Schronce's are linked under our "?" menu.

Cheers,
-Greg

It won't work for PLM, but I appreciate you sharing the script.