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
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
    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
      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
        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
          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
            Posts: 9
            Basic Member
            5/17/2012 7:18 PM

              Problem solved, knowledge increased. Thanks to you both!