Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APINVOICE


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

       

   FILE - APINVOICE


  Condition         Type
--------------------------------------------------------------------------------
  ACCRUED-TAX       OTOFLDS

  where  (              Relation: Taxcode Exists         
    And               Taxcode->Accrual Fl  = "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
--------------------------------------------------------------------------------
  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
--------------------------------------------------------------------------------
  AOC-DTLS-EXIST    OTOFLDS

  where  (           Relation: Maaocdtl 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
--------------------------------------------------------------------------------
  APAUTHOR          FILEFLD

  where  (                      Auth Code  > Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - APAUTHOR
  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
--------------------------------------------------------------------------------
  APBATCH           FILEFLD

  where  (                      Batch Num != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - APBATCH
  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
--------------------------------------------------------------------------------
  APINCCODE         FILEFLD

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



  Condition         Type
--------------------------------------------------------------------------------
  APISET11          FILEFLD

  where ((                   Tran Tot Pmt != Tran Inv Amt                   )
     Or  (                   Base Tot Pmt != Base Inv Amt                   ))


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

  where ((                  Approved Flag  = "N"                            )
     Or  (                  Approved Flag  = "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
--------------------------------------------------------------------------------
  APISET2           FILEFLD

  where  (                     Rec Status  = Zeroes                         )


  Is Used In Index - APISET2
  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
--------------------------------------------------------------------------------
  APISET3           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 No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  APISET7           FILEFLD

  where  (                  Tran Tot Dist != Tran Inv Amt                   
     Or                      Tran Tot Pmt != Tran Inv Amt                   
     Or                      Base Tot Pmt != Base Inv Amt                   
     Or                      Tran Tot Tax != Tran Tax Amt                   )


  Is Used In Index - APISET7
  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
--------------------------------------------------------------------------------
  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 - APISET14
                   - APISET8
  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
--------------------------------------------------------------------------------
  APUAVAL-EXISTS    OTOFLDS

  where  (              Relation: Apuaval 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
--------------------------------------------------------------------------------
  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
--------------------------------------------------------------------------------
  AVAIL-TO-MATCH    FILEFLD

  where  (                       Match Fl  = "Y"                            
    And                      Match Status  = Zeroes                         
    And                        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 No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  BATCH-INVOICE     FILEFLD

  where  (                      Batch Num != 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
--------------------------------------------------------------------------------
  BUYER-MESSAGES    OTOFLDS

  where  (            Relation: Pomessage 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
--------------------------------------------------------------------------------
  BYPASS-INV        FILEFLD

  where  (                   Bypass Match  = "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
--------------------------------------------------------------------------------
  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-APPLIED    FILEFLD, OTOFLDS

  where ((                   Invoice Type != "C"                            
     Or                      Invoice Type != "Y"                            
     Or                      Invoice Type != "M"                            )
    And                Relation: Apcrmemo 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
--------------------------------------------------------------------------------
  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 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-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
--------------------------------------------------------------------------------
  DISC-TOT          FILEFLD

  where ((                     Disc Point  = 2                              ))


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

  where ((                    Dropship 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
--------------------------------------------------------------------------------
  DTLS-EXIST        OTOFLDS

  where  (           Relation: Mainvdtl 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
--------------------------------------------------------------------------------
  FROM-RETURN       FILEFLD

  where  (                  Return Number != 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
--------------------------------------------------------------------------------
  INTRAST-EXIST     FILEFLD

  where ((                           Notc != Spaces                         )
     Or  (                      Stat Proc != Spaces                         )
     Or  (                       Ship Via != Spaces                         )
     Or  (                 Unloading Port != Spaces                         )
     Or  (                  Intrastat Nbr != Zeroes                         )
     Or  (                    Dropship Fl != Spaces                         )
     Or  (                       Fob 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 No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  INV-APPLIED       FILEFLD, OTOFLDS

  where ((                   Invoice Type  = "C"                            
     Or                      Invoice Type  = "Y"                            
     Or                      Invoice Type  = "M"                            )
    And               Relation: Apcrmemo2 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
--------------------------------------------------------------------------------
  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
--------------------------------------------------------------------------------
  INVOICED-TAX      OTOFLDS

  where  (              Relation: Taxcode Exists         
    And               Taxcode->Accrual Fl  = "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
--------------------------------------------------------------------------------
  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
--------------------------------------------------------------------------------
  LINK-NOT-MATCH    FILEFLD

  where  (                   Match 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
--------------------------------------------------------------------------------
  MAINVMSG-EXIST    OTOFLDS

  where  (             Relation: Mainvmsg 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
--------------------------------------------------------------------------------
  MATCH-REF         FILEFLD

  where  (                  Match Ref Nbr != Spaces                         )


  Is Used In Index - APISET11
  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
--------------------------------------------------------------------------------
  NON-MATCH-INV     FILEFLD

  where  (                       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
--------------------------------------------------------------------------------
  OPEN-CREDIT       FILEFLD

  where(((                   Invoice Type  = "C"                            )
     Or  (                   Invoice Type  = "M"                            )
     Or  (                   Invoice Type  = "Y"                            ))
    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
--------------------------------------------------------------------------------
  OPEN-INVOICES     FILEFLD

  where  (                     Rec Status  = Zeroes                         
     Or                        Rec Status  = 1                              )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In SubType - OPEN-INVOICES
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  OPEN-PREPAY       FILEFLD

  where  (                   Invoice Type  = "Y"                            
    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
--------------------------------------------------------------------------------
  OUT-BAL-PO-INV    FILEFLD

  where(((                   Tran Inv Amt != Tran Tot Dist                  )
     Or  (                   Tran Inv Amt != Tran Tot Pmt                   )
     Or  (                   Tran Tax Amt != Tran Tot Tax                   ))
    And  (                       Match Fl  = "Y"                            )
    And  (                     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 No CndFlds
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  OUT-BAL-TXBL      FILEFLD, OTOFLDS

  where  (            Relation: Txcompany Exists         
    And           Txcompany->Taxable Cntr  = "Y"                            
    And                     Tran Txbl Amt != Tran Tot Txbl                  
    And                          Match Fl  = "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
--------------------------------------------------------------------------------
  OUT-OF-BALANCE    FILEFLD

  where(((                   Tran Inv Amt != Tran 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  (                    Dropship Fl != "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-EXISTS         OTOFLDS

  where  (           Relation: Purchorder 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
--------------------------------------------------------------------------------
  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
--------------------------------------------------------------------------------
  POD-AVAIL         FILEFLD

  where  (                   Match Status  = Zeroes                         
    And                          Match Fl  = "Y"                            
    And  (                     Rec Status  = Zeroes                         
     Or                        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
--------------------------------------------------------------------------------
  PONUM-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
--------------------------------------------------------------------------------
  POOL-1            OTOFLDS

  where  (         Apvenmast->Pool Option  = 1                              
     Or  (         Apvenmast->Pool Option  = Zeroes                         
    And            Macompany->Pool Option  = 1                              ))


  Is Used In No Indexes
  Is Used In Rel - MAPOOL1
  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
--------------------------------------------------------------------------------
  POOL-2            OTOFLDS

  where ((         Apvenmast->Pool Option  = 2                              )
     Or ((         Apvenmast->Pool Option  = Zeroes                         )
    And  (         Macompany->Pool Option  = 2                              )))


  Is Used In No Indexes
  Is Used In Rel - MAPOOL2
  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
--------------------------------------------------------------------------------
  POOL-3            OTOFLDS

  where ((         Apvenmast->Pool Option  = 3                              )
     Or ((         Apvenmast->Pool Option  = Zeroes                         )
    And  (         Macompany->Pool Option  = 3                              )))


  Is Used In No Indexes
  Is Used In Rel - MAPOOL3
  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
--------------------------------------------------------------------------------
  PREPAY-CREDIT     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 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
--------------------------------------------------------------------------------
  REC-STAT-1-9      FILEFLD

  where(((                     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
--------------------------------------------------------------------------------
  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



  Condition         Type
--------------------------------------------------------------------------------
  SERVICE-INV       FILEFLD

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



  Condition         Type
--------------------------------------------------------------------------------
  TAXCNTRL          FILEFLD, OTOFLDS

  where  (                        Company  = Txcompany->Company             
    And           Txcompany->Taxable Cntr  = "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
--------------------------------------------------------------------------------
  USER-FIELD-ENT    OTOFLDS

  where  (            Relation: Invusrfld 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
--------------------------------------------------------------------------------
  VENAGRMT-EXIST    OTOFLDS

  where ((           Relation: Povagrmthd Exists         ))


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

  where  (                    Voucher Nbr != 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