Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OEINVOICE


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

       

   FILE - OEINVOICE


  Condition         Type
--------------------------------------------------------------------------------
  AR/GL-UPDATED     FILEFLD, STATE

  where  (                         Status  = 9                              )


  Is Used In No Indexes
  Is Used In Rel - OEDIST
  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
--------------------------------------------------------------------------------
  ARICREDIT         FILEFLD

  where  (                         Status  = 9                              
    And  (                    Invc Source  = "R"                            
     Or                       Invc Source  = "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
--------------------------------------------------------------------------------
  ARIOHDR           FILEFLD, OTOFLDS

  where  (                         Status  = 9                              
    And          Oeinvctype->Invc Cred Fl  = "N"                            )


  Is Used In No Indexes
  Is Used In Rel - AROIHDR
  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
--------------------------------------------------------------------------------
  AROIHDR-CM        FILEFLD, OTOFLDS

  where  (                         Status  = 9                              
    And          Oeinvctype->Invc Cred Fl  = "Y"                            )


  Is Used In No Indexes
  Is Used In Rel - AROIHDR-CM
  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-EXISTS      FILEFLD

  where  (                      Batch Nbr != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - INVCHDR
  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-REQUIRED    FILEFLD

  where  (                    Invc Source != "S"                            )


  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
--------------------------------------------------------------------------------
  BILL-TO-ENTERD    FILEFLD

  where  (                        Bill To != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - BILLTO
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - BT-ADDR1
                    - BT-ADDR2
                    - BT-ADDR3
                    - BT-ADDR4
                    - BT-CITY
                    - BT-COUNTRY
                    - BT-COUNTY
                    - BT-NAME
                    - BT-STATE
                    - BT-ZIP
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  CANCELLED         FILEFLD, STATE

  where  (                         Status  = 8                              )


  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       OTOFLDS

  where  (       Oeinvctype->Invc Cred 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
--------------------------------------------------------------------------------
  CURR-CHANGED      FILEFLD

  where  (             Old(Currency Code) != Currency Code                  )


  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
--------------------------------------------------------------------------------
  CURR-ENTERED      FILEFLD

  where  (                  Currency 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
--------------------------------------------------------------------------------
  CURR-OVERRDDN     FILEFLD, OTOFLDS

  where  (                  Currency Code != Arcustomer->Currency Cd        )


  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
--------------------------------------------------------------------------------
  CURR-RATE-CHGD    FILEFLD

  where  (                 Old(Curr Rate) != Curr Rate                      )


  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
--------------------------------------------------------------------------------
  CUST-CHANGED      FILEFLD

  where  (                  Old(Customer) != Customer                       )


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

  where  (                      Order Nbr != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - CUSTORDER
  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
--------------------------------------------------------------------------------
  CUSTORDER-USED    FILEFLD, OTOFLDS

  where ((            Relation: Custorder Exists         )
    And  (                        Bill To  = Custorder->Bill To             ))


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - BT-ADDR1
                    - BT-ADDR2
                    - BT-ADDR3
                    - BT-ADDR4
                    - BT-CITY
                    - BT-COUNTRY
                    - BT-COUNTY
                    - BT-NAME
                    - BT-STATE
                    - BT-ZIP
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  EDITTED           FILEFLD, STATE

  where  (                         Status  = 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
--------------------------------------------------------------------------------
  FRT-CODE          FILEFLD

  where  (                    Invc Source  = "S"                            
    And                      Freight Code != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - OEFRTCODE
  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
--------------------------------------------------------------------------------
  HDR-COMM-EXIST    OTOFLDS

  where  (         Relation: Hdr Comments 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
--------------------------------------------------------------------------------
  HEADER-TAX        OTOFLDS

  where  (        Oecompany->Tax Print Cd  = "S"                            )


  Is Used In No Indexes
  Is Used In Rel - HEADER-TAX
  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
--------------------------------------------------------------------------------
  HOLDCODES         FILEFLD

  where  (                      Hold Code != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - HOLDCODES
  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-EDIT-REQ      OTOFLDS

  where  (       Oecompany->Invc Edit Opt  = "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
--------------------------------------------------------------------------------
  INV-TYPE-CHG      FILEFLD

  where  (                 Old(Invc Type) != Invc Type                      )


  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           OTOFLDS

  where  (       Oeinvctype->Invc Cred 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
--------------------------------------------------------------------------------
  MULT-RATE         FILEFLD

  where  (                      Curr Mudv  = "M"                            )


  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
--------------------------------------------------------------------------------
  NO-CURR-OVERR     OTOFLDS

  where  (         Oecompany->Curr Ovr 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
--------------------------------------------------------------------------------
  NO-RATE-OVERR     OTOFLDS

  where  (         Oecompany->Rate Ovr 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
--------------------------------------------------------------------------------
  NO-TAX-CODE       FILEFLD

  where  (                       Tax 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
--------------------------------------------------------------------------------
  NON-SYSTEM-INV    FILEFLD

  where  (                    Invc Source != "S"                            )


  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
--------------------------------------------------------------------------------
  NONBASE-TRAN      FILEFLD, OTOFLDS

  where  (                  Currency Code != Oecompany->Currency Code       )


  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-GL-UPDATED    FILEFLD

  where  (                         Status  < 4                              )


  Is Used In Index - OEISET7
  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-SA-UPDATED    FILEFLD

  where  (                  Sa Invoice Fl != "Y"                            
    And                            Status  = 9                              )


  Is Used In Index - OEISET10
  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
--------------------------------------------------------------------------------
  OEISET2           FILEFLD

  where  (                         Status  < 9                              )


  Is Used In Index - OEISET2
  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
--------------------------------------------------------------------------------
  OEISET5           FILEFLD

  where  (                      Hold Code != Spaces                         )


  Is Used In Index - OEISET5
  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
--------------------------------------------------------------------------------
  OEISET6           FILEFLD

  where(((                         Status  = 3                              )
     Or  (                         Status  = 9                              ))
    And  (                  Sa Invoice 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
--------------------------------------------------------------------------------
  OEISET9           FILEFLD

  where  (                         Status  = 1                              
     Or                            Status  = 2                              )


  Is Used In Index - OEISET9
  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
--------------------------------------------------------------------------------
  ONE-CURRENCY      OTOFLDS

  where  (       Oecompany->Multi Curr 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
--------------------------------------------------------------------------------
  ORDER-NE-ZERO     FILEFLD

  where  (                      Order Nbr != 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
--------------------------------------------------------------------------------
  ORDER-SHIP-TO     FILEFLD

  where  (                      Order Nbr != Zeroes                         
    And                      Shipment Nbr != Zeroes                         
    And                       Invc Source  = "S"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - ST-ADDR1
                    - ST-ADDR2
                    - ST-ADDR3
                    - ST-ADDR4
                    - ST-CITY
                    - ST-COUNTRY
                    - ST-COUNTY
                    - ST-NAME
                    - ST-STATE
                    - ST-ZIP
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  PL-CHANGED        FILEFLD

  where  (             Old(Process Level) != Process Level                  )


  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
--------------------------------------------------------------------------------
  PRINTED           FILEFLD, STATE

  where  (                         Status  = 3                              )


  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
--------------------------------------------------------------------------------
  PROCESSED         FILEFLD, STATE

  where  (                         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
--------------------------------------------------------------------------------
  REASON-CODE       FILEFLD

  where  (                    Reason Code != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - OEREASON
  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
--------------------------------------------------------------------------------
  RECURRING-INVC    FILEFLD

  where  (                  Recur Invoice != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - BLRICUST
                 - BRIMAST
                 - OECUSTSRVC
                 - OEMASTSRVC
  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
--------------------------------------------------------------------------------
  RELEASED          FILEFLD, STATE

  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
--------------------------------------------------------------------------------
  RET-AUTH-ENTRD    FILEFLD

  where  (                        Auth No != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - RETURNHDR
  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
--------------------------------------------------------------------------------
  SALESMAN2         FILEFLD

  where  (                     Salesman 2 != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - SALESMAN2
  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
--------------------------------------------------------------------------------
  SHIP-TO-ENTERD    FILEFLD

  where  (                        Ship To != 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 - ST-ADDR1
                    - ST-ADDR2
                    - ST-ADDR3
                    - ST-ADDR4
                    - ST-CITY
                    - ST-COUNTRY
                    - ST-COUNTY
                    - ST-NAME
                    - ST-STATE
                    - ST-ZIP
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  SHIPMENT-VEND     FILEFLD, OTOFLDS

  where  (                    Invc Source  = "S"                            
    And               Whshipment->Carrier != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - APCOMPANY
                 - APVENMAST
  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
--------------------------------------------------------------------------------
  SHIPMNT-METHOD    FILEFLD, OTOFLDS

  where  (                    Invc Source  = "S"                            
    And                Whshipment->Method != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - OEMETHOD
  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
--------------------------------------------------------------------------------
  SHIPTO            FILEFLD

  where  (                        Ship To != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - SHIPTO
  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
--------------------------------------------------------------------------------
  SYSTEM-INVOICE    FILEFLD

  where  (                   Shipment Nbr != Zeroes                         )


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

  where  (                       Tax Code != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - TXTAXCODE
  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
--------------------------------------------------------------------------------
  TERMS-CD          FILEFLD

  where  (                       Terms Cd != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - TERMS
  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
--------------------------------------------------------------------------------
  TLR-COMM-EXIST    OTOFLDS

  where  (         Relation: Tlr Comments 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
--------------------------------------------------------------------------------
  TXCODEMAST        OTOFLDS

  where  (           Relation: Txcodemast Exists         )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - TAX-DESC
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  TXCOMPANY         OTOFLDS

  where  (            Relation: Txcompany 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
--------------------------------------------------------------------------------
  TXTAXCODE         OTOFLDS

  where  (            Relation: Txtaxcode 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
--------------------------------------------------------------------------------
  UNRELEASED        FILEFLD, STATE

  where  (                         Status  = Zeroes                         )


  Is Used In Index - OEISET8
  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
--------------------------------------------------------------------------------
  ZERO-PAYMENT      FILEFLD

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