• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Locating DB Tables/Fields

 5 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
dukeslater
Basic Member Send Private Message
Posts: 9
Basic Member
5/17/2012 3:08 PM

Somewhat new to Lawson, and so far I've been able to find all the fields needed for reporting (Crystal - native connection to Oracle).

But now I'm having some trouble locating these two fields:

IC12 - Expense account #

IC12 - Purchase From Location

TIA for any help you can provide, specific to this problem or for locating db fields in general.
Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
5/17/2012 3:12 PM
Do you know about Ctrl-Shift-O ?
In Portal, position your cursor into the field that you have questions about and perform the Ctrl-Shift-O.
The field name should appear in your IE status bar.
David Williams
Veteran Member Send Private Message
Posts: 1127
Veteran Member
5/17/2012 3:22 PM
The expense account is in the ICCATEGORY table - it's tied to the GL Category on IC12. The Vendor and Purchase From Location is in the ITEMSRC table.
David Williams
Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
5/17/2012 3:23 PM
Note: when performing ctrl-shift-o, the information returned contains the table abbreviation then a dash and then the field name.
ie: Purchase from: ITM-PURCH-FRM-LOC --- ITM means the ITEMSRC table, then the field is PURCH-FRM-LOC

Our report writers here, have found a script I wrote particularly helpful too. If you are on Windows, you can perform the steps manually, I suppose? It's just making use of some of the Lawson utilities.
I'll attach it here, and if you have any questions, please post back.
Attachments
Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
5/17/2012 3:32 PM
You can get a listing of your table abbreviations by:
rngdbdump -cnt gen filedef -f Prefix FileName SystemCode | sort
dukeslater
Basic Member Send Private Message
Posts: 9
Basic Member
5/17/2012 7:18 PM

Problem solved, knowledge increased. Thanks to you both!