IC81 Information

 4 Replies
 1 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
Bev Edwards
Veteran Member
Posts: 366
Veteran Member

    Is there a Lawson table that correlates to the IC81?

    I need to dump all of my IC81 info into a spreadsheet to see what common items we have in each location.

    JonA
    Veteran Member
    Posts: 1163
    Veteran Member
      ITEMLOC
      Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
      Bev Edwards
      Veteran Member
      Posts: 366
      Veteran Member

        Thanks Jon.

         I thought ITEMLOC pertained to only the IC12.

        Kat V
        Veteran Member
        Posts: 1020
        Veteran Member
          IC81 creates an IC12 (RQ01 too) as it goes. You can't maintain from IC12, but that's where the data is stored.
          JonA
          Veteran Member
          Posts: 1163
          Veteran Member
            Same table for both just a couple of the fields are named differently in IC81. For instance

            Par Level = Reorder Point
            Shelf Location = Preferred Bin

            And if you need the line sequence number you'll get that from the BINGRPDTL table
            Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health