Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ITEMMAST


                               CONDITION REPORT
                               ----------------

       

   FILE - ITEMMAST


  Condition         Type
--------------------------------------------------------------------------------
  ACTIVE            FILEFLD

  where  (                  Active Status  = "A"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  CW-ITEM           FILEFLD

  where  (                       Ctw Code != "N"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - ALLOC-UOM
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  GENERICNAME       FILEFLD

  where  (                        Generic != Spaces                         
    And                     Active Status  = "A"                            )


  Is Used In Index - ITESET3
  Is Used In Rel - GENERICNAME
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  HAS-COMMENTS      OTOFLDS

  where  (         Relation: Itemcomments Exists         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  HAS-DESC2         FILEFLD

  where  (                   Description2 != Spaces                         )


  Is Used In Index - ITESET13
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  HAS-IC-OBJ-ID     FILEFLD

  where  (                      Ic Obj Id != Zeroes                         )


  Is Used In Index - ITESET9
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  HAZARD            FILEFLD

  where  (                    Hazard Code != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - HAZARD
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - HAZARD-FL
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ICSEGMENT         FILEFLD

  where  (                      Icsegment != Spaces                         
    And                     Active Status  = "A"                            )


  Is Used In Index - ITESET10
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  INACTIVE          FILEFLD

  where  (                  Active Status  = "I"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  INVENTORYCLASS    FILEFLD

  where  (                    Inven Majcl != Spaces                         
    And                     Active Status  = "A"                            )


  Is Used In Index - ITESET5
  Is Used In Rel - INVENTORYCLASS
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ITEM-ENTERED      FILEFLD

  where  (                           Item != Spaces                         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - ITEM-CODE-USED
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ITEMVEN-EXISTS    OTOFLDS

  where  (            Relation: Poitemven Exists         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  MANUF-CD-ENTRD    FILEFLD

  where  (                     Manuf Code != Spaces                         
    And                     Active Status  = "A"                            )


  Is Used In Index - ITESET8
  Is Used In Rel - ICMANFCODE
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  MANUF-NBR         FILEFLD

  where  (                      Manuf Nbr != Spaces                         
    And                     Active Status  = "A"                            )


  Is Used In Index - ITESET11
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  PHARMACY-ITEM     FILEFLD

  where  (                 Use Identifier  = "D"                            
    And               Old(Use Identifier)  = "P"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  PURCHASECLASS     FILEFLD

  where  (                    Purch Majcl != Spaces                         
    And                     Active Status  = "A"                            )


  Is Used In Index - ITESET4
  Is Used In Rel - PURCHASECLASS
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  REPLACE-ITEM      FILEFLD

  where  (                   Replace Item != Spaces                         )


  Is Used In Index - ITESET12
  Is Used In Rel - REPLACE-ITEM
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  SALESCLASS        FILEFLD

  where  (                    Sales Majcl != Spaces                         
    And                     Active Status  = "A"                            )


  Is Used In Index - ITESET6
  Is Used In Rel - SALESCLASS
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  TRACKED-1         FILEFLD

  where  (                        Track 1 != Spaces                         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - VALUE-1
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  TRACKED-2         FILEFLD

  where  (                        Track 2 != Spaces                         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - VALUE-2
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  TRACKED-3         FILEFLD

  where  (                        Track 3 != Spaces                         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - VALUE-3
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  TRACKED-4         FILEFLD

  where  (                        Track 4 != Spaces                         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - VALUE-4
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  TRACKED-5         FILEFLD

  where  (                        Track 5 != Spaces                         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - VALUE-5
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  TRACKED-6         FILEFLD

  where  (                        Track 6 != Spaces                         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - VALUE-6
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  USER-FLD-USED     FILEFLD

  where  (                    User Field1 != Spaces                         
    And                     Active Status  = "A"                            )


  Is Used In Index - ITESET7
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules