Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APAPIHIST


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

       

   FILE - APAPIHIST


  Condition         Type
--------------------------------------------------------------------------------
  ADVANCE-INV       FILEFLD

  where  (                   Invoice Type  = "A"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - TYPE-SHORT-NME
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  APMATCHSTATUS     FILEFLD

  where(((                   Match Status  = Zeroes                         )
     Or  (                   Match Status  = 1                              ))
    And  (                       Match Fl  = "Y"                            )
    And ((                     Rec Status  = Zeroes                         )
     Or  (                     Rec Status  = 1                              )))


  Is Used In Index - AH1SET8
  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
--------------------------------------------------------------------------------
  APVENLOCPURCH     FILEFLD

  where  (                   Purch Fr Loc != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - APVENLOCPURCH
  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
--------------------------------------------------------------------------------
  APVENLOCREMIT     FILEFLD

  where  (                  Remit To Code != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - APVENLOCREMIT
  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
--------------------------------------------------------------------------------
  AVAIL-ADVANCE     FILEFLD

  where ((                         Suffix  = 1                              )
    And  (                   Invoice Type  = "M"                            )
    And  (                     Rec 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
--------------------------------------------------------------------------------
  CANCEL-INVOICE    FILEFLD

  where  (                     Cancel Seq != 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
--------------------------------------------------------------------------------
  CREDIT-INVOICE    FILEFLD

  where  (                   Invoice Type  = "C"                            
     Or                      Invoice Type  = "Y"                            
     Or                      Invoice Type  = "M"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - TYPE-SHORT-NME
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  CREDIT-MEMO       FILEFLD

  where  (                   Invoice Type  = "C"                            )


  Is Used In Index - AH1SET12
  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-INVOICE     FILEFLD

  where  (                   Invoice 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 CndFld - TYPE-SHORT-NME
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  DTLS-EXIST        OTOFLDS

  where  (          Relation: Mamadhist 2 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
--------------------------------------------------------------------------------
  EMP-ADVANCE       FILEFLD

  where  (                   Invoice Type  = "A"                            )


  Is Used In No Indexes
  Is Used In Rel - EEADVANCE-A
  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
--------------------------------------------------------------------------------
  EMP-CREDIT        FILEFLD

  where  (                   Invoice Type  = "M"                            )


  Is Used In No Indexes
  Is Used In Rel - EEADVANCE-M
  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
--------------------------------------------------------------------------------
  EMP-EXPENSE       FILEFLD

  where  (                   Invoice Type  = "E"                            )


  Is Used In No Indexes
  Is Used In Rel - EEEXPENSE
  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
--------------------------------------------------------------------------------
  EXPENSE-INV       FILEFLD

  where  (                   Invoice 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 CndFld - TYPE-SHORT-NME
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  FACTOR-VENDOR     FILEFLD

  where  (                     Pay Vendor != Vendor                         )


  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
--------------------------------------------------------------------------------
  INV-HISTORY       FILEFLD

  where  (                     Rec Status  = 9                              
    And                        Cancel Seq  = 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 - INV-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  INV-RELEASED      FILEFLD

  where  (                     Rec 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 CndFld - INV-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  INV-UNRELEASED    FILEFLD

  where  (                     Rec Status  = 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 - INV-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  LAWSON-PO         FILEFLD

  where  (                       Match Fl  = "A"                            
     Or                          Match Fl  = "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
--------------------------------------------------------------------------------
  MATCH-REF         FILEFLD

  where  (                  Match Ref Nbr != Spaces                         )


  Is Used In Index - AH1SET11
  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
--------------------------------------------------------------------------------
  MATCHED           FILEFLD

  where  (                   Match Obj Id != Zeroes                         
    And  (                     Rec Status  = 1                              
     Or                        Rec Status  = 9                              ))


  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
--------------------------------------------------------------------------------
  NON-BASE-INV      FILEFLD, OTOFLDS

  where  (                   Inv Currency != Apcompany->Base Currency       )


  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
--------------------------------------------------------------------------------
  OUT-OF-BALANCE    FILEFLD

  where(((                   Tran Inv Amt != Base Tot Dist                  )
     Or  (                   Tran Inv Amt != Tran Tot Pmt                   )
     Or  (                   Tran Tax Amt != Tran Tot Tax                   ))
    And ((                       Match Fl != "Y"                            )
    And  (                       Match Fl != "A"                            )
    And  (                   Bypass Match != "Y"                            )
    And  (                     Service Fl != "Y"                            )))


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - OUT-BAL-FLAG
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  PO-NUMBER-USED    FILEFLD

  where  (                      Po Number != 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



  Condition         Type
--------------------------------------------------------------------------------
  PREPAYMENT        FILEFLD

  where  (                   Invoice 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 CndFld - TYPE-SHORT-NME
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  REGULAR-INVOIC    FILEFLD

  where  (                   Invoice Type  = 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 - TYPE-SHORT-NME
  Is Used In No AvfFlds
  Is Used In No Rules