Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ICLOCATION


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

       

   FILE - ICLOCATION


  Condition         Type
--------------------------------------------------------------------------------
  CART-LOCATION     FILEFLD

  where  (                  Location Type  = "E"                            )


  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
--------------------------------------------------------------------------------
  CUSTOMER-ROLE     FILEFLD

  where  (                       Customer != Spaces                         )


  Is Used In Index - ICLSET5
  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
--------------------------------------------------------------------------------
  FREIGHT-ACCT      FILEFLD

  where  (                  Frt Acct Unit != Spaces                         
     Or                       Frt Account != Zeroes                         
     Or                      Frt Sub Acct != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - FRT-ACCOUNT
  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
--------------------------------------------------------------------------------
  HANDLING-ACCT     FILEFLD

  where  (                 Hdlg Acct Unit != Spaces                         
     Or                      Hdlg Account != Zeroes                         
     Or                     Hdlg Sub Acct != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - HDLG-ACCOUNT
  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-ICL-OBJ-ID    FILEFLD

  where  (                     Icl Obj Id != Zeroes                         )


  Is Used In Index - ICLSET6
  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
--------------------------------------------------------------------------------
  LOC-TYPE-ENTRD    FILEFLD

  where  (                  Location Type  = "E"                            
     Or                     Location Type  = "P"                            )


  Is Used In Index - ICLSET2
  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
--------------------------------------------------------------------------------
  PAR-LOCATION      FILEFLD

  where  (                  Location Type  = "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
--------------------------------------------------------------------------------
  REG-LOCATION      FILEFLD

  where  (                  Location Type != "E"                            
    And                     Location Type != "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
--------------------------------------------------------------------------------
  REPL-LOCATION     FILEFLD

  where  (                  Repl From Loc != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - REPL-FROM-LOC
  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
--------------------------------------------------------------------------------
  SCRAP-ACCT        FILEFLD

  where  (                 Scrp Acct Unit != Spaces                         
     Or                      Scrp Account != Zeroes                         
     Or                     Scrp Sub Acct != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - SCRAP-ACCOUNT
  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
--------------------------------------------------------------------------------
  SUSPENSE-ACCT     FILEFLD

  where  (                 Susp Acct Unit != Spaces                         
     Or                      Susp Account != Zeroes                         
     Or                     Susp Sub Acct != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - SUSPENSE-ACCT
  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
--------------------------------------------------------------------------------
  VENDOR-ROLE       FILEFLD

  where  (                         Vendor != Spaces                         )


  Is Used In Index - ICLSET4
  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
--------------------------------------------------------------------------------
  WO-LOC-SETUP      FILEFLD

  where  (                    Wo Loc Type != "N"                            )


  Is Used In Index - ICLSET3
  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
--------------------------------------------------------------------------------
  WO-LOCATION       FILEFLD

  where  (                    Wo Loc Type  = "O"                            
     Or                       Wo Loc Type  = "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
--------------------------------------------------------------------------------
  WO-OFFSITE-LOC    FILEFLD

  where  (                    Wo Loc Type  = "O"                            )


  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
--------------------------------------------------------------------------------
  WO-PROD-FACLTY    FILEFLD

  where  (                    Wo Loc Type  = "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