Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

IC Audit Table Field Number

 3 Replies
 1 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
John Turpin
Basic Member
Posts: 7
Basic Member
2/1/2016 11:19 AM

    Hi,

    In the ICAUDIT table, we are able to dump the data using an SQL script. What I am struggling to find is a list of all of the field names that are associated to the field number value on that table. Does anyone know if there is such a list?

    Would be great if we could find a list for both the ITL and ITE DB_FILES. Thanks

    Kat V
    Veteran Member
    Posts: 1020
    Veteran Member
    2/1/2016 1:43 PM
      My IT once gave me one in v8 - but the field numbers change all the time - the field names are what I use to query and I typically just use ctrl+shift+o for those.
      JonA
      Veteran Member
      Posts: 1163
      Veteran Member
      2/1/2016 3:29 PM

        If you modify your script to include ICDICT (join on FIELD_NBR) you can select ICDICT.FLD_NAME in your output.


        A note about Ctrl-Shfit-O: The field numbers displayed in the IE status bar are not the same as in ICAUDIT.  Ctrl-Shift-O is good for identifying the table and field for use in MS Addins uploads but not for ICAUDIT. For instance, Ctrl-Shift-O in the Active Status field displays

        Which matches MS Addins

        But in ICAUDIT the field number is 34

         

        Ctrl-Shift-O for Item Description is Id=_f7. In ICAUDIT the field number is 515.

         

        Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
        kyle
        Basic Member
        Posts: 16
        Basic Member
        10/10/2016 7:19 PM
          join on the ICDICT table.  This should contain the field_nbr names.