Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ITEMLOC


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

       

   FILE - ITEMLOC


  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
--------------------------------------------------------------------------------
  ALC-ALLOC-ADD     OTOFLDS

  where  (          Company->Alc Alloc Fl  = "+"                            )


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



  Condition         Type
--------------------------------------------------------------------------------
  ALC-ALLOC-SUB     OTOFLDS

  where  (          Company->Alc Alloc Fl  = "-"                            )


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



  Condition         Type
--------------------------------------------------------------------------------
  ALC-BKORD-ADD     OTOFLDS

  where  (         Company->Alc Bckord Fl  = "+"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - ALC-BACKORD
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ALC-BKORD-SUB     OTOFLDS

  where  (         Company->Alc Bckord Fl  = "-"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - ALC-BACKORD
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ALC-HOLD-ADD      OTOFLDS

  where  (           Company->Alc Hold Fl  = "+"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - ALC-HOLD
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ALC-HOLD-SUB      OTOFLDS

  where  (           Company->Alc Hold Fl  = "-"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - ALC-HOLD
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ALC-INPRC-ADD     OTOFLDS

  where  (         Company->Alc Inproc Fl  = "+"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - ALC-INPROC
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ALC-INPRC-SUB     OTOFLDS

  where  (         Company->Alc Inproc Fl  = "-"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - ALC-INPROC
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ALC-INTRN-ADD     OTOFLDS

  where  (         Company->Alc Intrnc Fl  = "+"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - ALC-INTRAN
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ALC-INTRN-SUB     OTOFLDS

  where  (         Company->Alc Intrnc Fl  = "-"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - ALC-INTRAN
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ALC-ONORD-ADD     OTOFLDS

  where  (          Company->Alc Onord Fl  = "+"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - ALC-ONORD
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ALC-ONORD-SUB     OTOFLDS

  where  (          Company->Alc Onord Fl  = "-"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - ALC-ONORD
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ALC-WIP-ADD       OTOFLDS

  where  (            Company->Alc Wip Fl  = "+"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - ALC-WIP
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ALC-WIP-SUB       OTOFLDS

  where  (            Company->Alc Wip Fl  = "-"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - ALC-WIP
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  AVAIL-CW-OPT-1    OTOFLDS

  where  (             Itemmast->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 No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  CWT-ITEM          OTOFLDS

  where  (             Itemmast->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 No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  HAS-DEMAND        OTOFLDS

  where  (             Relation: Whdemand 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-DETAIL        OTOFLDS

  where  (            Relation: Sohdetail 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-PURCH-TAX     FILEFLD

  where  (                   Purch Tax Cd != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - TAX-CODE-PURCH
  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-SELL-TAX      FILEFLD

  where  (                    Sell Tax Cd != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - TAX-CODE-SELL
  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-SERIAL        OTOFLDS

  where  (             Relation: Itserial 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
--------------------------------------------------------------------------------
  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
--------------------------------------------------------------------------------
  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
--------------------------------------------------------------------------------
  MANUF-CD-ENTRD    FILEFLD

  where  (                     Manuf Code != 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 - MANUF-CODE-DER
                    - MANUF-DIV-DER
                    - MANUF-NBR-DER
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  NON-CWT-ITEM      OTOFLDS

  where  (             Itemmast->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 No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  PHARITEM-EXIST    OTOFLDS

  where  (       Relation: Pharittoitmloc 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
--------------------------------------------------------------------------------
  PREFERRED-BIN     FILEFLD

  where  (                     Prefer Bin != Spaces                         
    And                      Bin Track Fl  = "Y"                            )


  Is Used In No Indexes
  Is Used In Rel - BINGRPDTL
                 - PREFERRED-BIN
  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-MFG-ENTRD    OTOFLDS

  where  (       Repl Itemloc->Manuf Code != 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 - MANUF-CODE-DER
                    - MANUF-DIV-DER
                    - MANUF-NBR-DER
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  RRPL-MFG-ENTRD    OTOFLDS

  where  (       Rrpl Itemloc->Manuf Code != 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 - MANUF-CODE-DER
                    - MANUF-DIV-DER
                    - MANUF-NBR-DER
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  SELL-ALLOC-ADD    OTOFLDS

  where  (         Company->Sell Alloc Fl  = "+"                            )


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



  Condition         Type
--------------------------------------------------------------------------------
  SELL-ALLOC-SUB    OTOFLDS

  where  (         Company->Sell Alloc Fl  = "-"                            )


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



  Condition         Type
--------------------------------------------------------------------------------
  SELL-BKORD-ADD    OTOFLDS

  where  (        Company->Sell Bckord Fl  = "+"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - SELL-BACKORD
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  SELL-BKORD-SUB    OTOFLDS

  where  (        Company->Sell Bckord Fl  = "-"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - SELL-BACKORD
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  SELL-HOLD-ADD     OTOFLDS

  where  (          Company->Sell Hold Fl  = "+"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - SELL-HOLD
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  SELL-HOLD-SUB     OTOFLDS

  where  (          Company->Sell Hold Fl  = "-"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - SELL-HOLD
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  SELL-INPRC-ADD    OTOFLDS

  where  (        Company->Sell Inproc Fl  = "+"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - SELL-INPROC
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  SELL-INPRC-SUB    OTOFLDS

  where  (        Company->Sell Inproc Fl  = "-"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - SELL-INPROC
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  SELL-INTRN-ADD    OTOFLDS

  where  (        Company->Sell Intrnc Fl  = "+"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - SELL-INTRAN
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  SELL-INTRN-SUB    OTOFLDS

  where  (        Company->Sell Intrnc Fl  = "-"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - SELL-INTRAN
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  SELL-ONORD-ADD    OTOFLDS

  where  (         Company->Sell Onord Fl  = "+"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - SELL-ONORD
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  SELL-ONORD-SUB    OTOFLDS

  where  (         Company->Sell Onord Fl  = "-"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - SELL-ONORD
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  SELL-WIP-ADD      OTOFLDS

  where  (           Company->Sell Wip Fl  = "+"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - SELL-WIP
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  SELL-WIP-SUB      OTOFLDS

  where  (           Company->Sell Wip Fl  = "-"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - SELL-WIP
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  STORAGE-CODE      FILEFLD

  where  (                   Storage Code != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - STORAGE-CODE
  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