Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AROITEMS


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

       

   FILE - AROITEMS


  Condition         Type
--------------------------------------------------------------------------------
  ACHSTHDR-EXIST    OTOFLDS

  where  (            Relation: Achisthdr 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
--------------------------------------------------------------------------------
  ACPMHST-EXISTS    OTOFLDS

  where  (           Relation: Acpmhsthdr 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
--------------------------------------------------------------------------------
  APPLIED           FILEFLD

  where  (                   Orig App Amt != Zeroes                         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - APPL-DISP
  Is Used In No AvfFlds
  Is Used In 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  ARADJUST-EXIST    OTOFLDS

  where  (             Relation: Aradjust 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
--------------------------------------------------------------------------------
  ARAPPL-EXISTS     OTOFLDS

  where  (            Relation: Arapplied 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
--------------------------------------------------------------------------------
  ARAPSEL-EXIST     OTOFLDS

  where  (           Relation: Arapselect 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
--------------------------------------------------------------------------------
  ARARHUF-EXISTS    OTOFLDS

  where  (              Relation: Ararhuf 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
--------------------------------------------------------------------------------
  ARDSPUTE-EXIST    OTOFLDS

  where  (            Relation: Ardispute 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
--------------------------------------------------------------------------------
  ARDUNHIS-EXIST    OTOFLDS

  where  (            Relation: Ardunhist 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
--------------------------------------------------------------------------------
  AROSET2           FILEFLD

  where  (                         Status  = 1                              
     Or                            Status  = 2                              )


  Is Used In Index - AROSET2
  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
--------------------------------------------------------------------------------
  AROSET3           FILEFLD

  where  (                         Status  = 1                              )


  Is Used In Index - AROSET3
  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
--------------------------------------------------------------------------------
  AROSET4           FILEFLD

  where  (                         Status  > Zeroes                         
    And                            Status  < 9                              )


  Is Used In Index - AROSET4
  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
--------------------------------------------------------------------------------
  AROSET5           FILEFLD

  where  (                         Status  = 1                              )


  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
--------------------------------------------------------------------------------
  AROSET6           FILEFLD

  where  (                         Status  > Zeroes                         
    And                            Status  < 9                              )


  Is Used In Index - AROSET6
  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
--------------------------------------------------------------------------------
  AROSET7           FILEFLD

  where  (                         Status  = 1                              )


  Is Used In Index - AROSET7
  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
--------------------------------------------------------------------------------
  AROSET9           FILEFLD

  where  (                         Status  = 1                              )


  Is Used In Index - AROSET9
  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
--------------------------------------------------------------------------------
  ARSADJ-EXISTS     OTOFLDS

  where  (            Relation: Arsadjust 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
--------------------------------------------------------------------------------
  ARSAPL-EXISTS     OTOFLDS

  where  (           Relation: Arsapplied 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
--------------------------------------------------------------------------------
  CONTRACT-EXIST    FILEFLD

  where  (                       Contract != "SPACES"                       )


  Is Used In No Indexes
  Is Used In Rel - ACHISTHDR
                 - ACPMHSTHDR
  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
--------------------------------------------------------------------------------
  CRARAPPL-EXIST    FILEFLD, OTOFLDS

  where  (            Relation: Crapplied Exists         
    And                        Trans Type  = "C"                            )


  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
--------------------------------------------------------------------------------
  CREDIT-MEMO       FILEFLD

  where  (                     Trans Type  = "C"                            )


  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
--------------------------------------------------------------------------------
  DEBIT-MEMO        FILEFLD

  where  (                     Trans Type  = "D"                            )


  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
--------------------------------------------------------------------------------
  DTCREDIT-EXIST    OTOFLDS

  where  (             Relation: Dtcredit 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
--------------------------------------------------------------------------------
  INVOICE           FILEFLD

  where  (                     Trans Type  = "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
--------------------------------------------------------------------------------
  ITEMAUD-EXISTS    OTOFLDS

  where  (            Relation: Aritemaud 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
--------------------------------------------------------------------------------
  MULTIPLE-DTL      OTOFLDS

  where  (              Aroihdr->Sum Line != "Y"                            )


  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
--------------------------------------------------------------------------------
  NOT-APPLIED       FILEFLD

  where  (                   Orig App Amt  = Zeroes                         )


  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
--------------------------------------------------------------------------------
  NOT-OPEN          FILEFLD

  where  (                         Status  > 1                              )


  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
--------------------------------------------------------------------------------
  OPEN-CUST-PO      FILEFLD

  where  (                         Status  = 1                              )


  Is Used In Index - AROSET11
  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
--------------------------------------------------------------------------------
  OPEN-PROC-LEV     FILEFLD

  where  (                         Status  = 1                              )


  Is Used In Index - AROSET13
  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
--------------------------------------------------------------------------------
  OPEN-SORT-AMT     FILEFLD

  where  (                         Status  = 1                              )


  Is Used In Index - AROSET10
  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
--------------------------------------------------------------------------------
  OPEN-TRAN-USR1    FILEFLD

  where  (                         Status  = 1                              )


  Is Used In Index - AROSET12
  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
--------------------------------------------------------------------------------
  USERSORT-EXIST    FILEFLD

  where  (                         Sort 1 != Spaces                         
     Or                            Sort 2 != Spaces                         
     Or                            Sort 3 != Spaces                         
     Or                            Sort 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 No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules