Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OEINVCLINE


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

       

   FILE - OEINVCLINE


  Condition         Type
--------------------------------------------------------------------------------
  AR-GL-UPDATED     OTOFLDS

  where  (              Oeinvoice->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
--------------------------------------------------------------------------------
  BATCH-EXISTS      OTOFLDS

  where  (           Oeinvoice->Batch Nbr != Zeroes                         )


  Is Used In No Indexes
  Is Used In Rel - OEINVHDR
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In 3 Rules



  Condition         Type
--------------------------------------------------------------------------------
  CATCH-WT-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
--------------------------------------------------------------------------------
  COMMITTED         FILEFLD

  where  (                     Atn Obj Id != Zeroes                         )


  Is Used In Index - OILSET3
  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
--------------------------------------------------------------------------------
  COMMITTED-C       FILEFLD

  where  (                   Atn Obj Id C != Zeroes                         )


  Is Used In Index - OILSET4
  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
--------------------------------------------------------------------------------
  CREATE-PO         OTOFLDS

  where  (              Coline->Create Po  = "Y"                            )


  Is Used In No Indexes
  Is Used In Rel - POLINESRC
  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
--------------------------------------------------------------------------------
  D1-ACCOUNT        FILEFLD

  where  (                   D1 Acct Unit != Spaces                         
     Or                        D1 Account != Zeroes                         
     Or                       D1 Sub Acct != 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
--------------------------------------------------------------------------------
  D2-ACCOUNT        FILEFLD

  where  (                   D2 Acct Unit != Spaces                         
     Or                        D2 Account != Zeroes                         
     Or                       D2 Sub Acct != 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
--------------------------------------------------------------------------------
  D3-ACCOUNT        FILEFLD

  where  (                   D3 Acct Unit != Spaces                         
     Or                        D3 Account != Zeroes                         
     Or                       D3 Sub Acct != 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
--------------------------------------------------------------------------------
  DESC-CHANGED      FILEFLD

  where  (               Old(Description) != Description                    )


  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 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  DISC-CODE-CHGD    FILEFLD

  where  (                 Old(Disc Code) != Disc 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 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  DISCOUNTABLE      FILEFLD

  where  (                    Ord Disc 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
--------------------------------------------------------------------------------
  ICCOMPANY         FILEFLD

  where  (                      Line Type != "X"                            )


  Is Used In No Indexes
  Is Used In Rel - ICCOMPANY
  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
--------------------------------------------------------------------------------
  INVENTORY-ITEM    FILEFLD

  where  (                      Line 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
--------------------------------------------------------------------------------
  ITEM-CHANGED      FILEFLD

  where  (                      Old(Item) != Item                           )


  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 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  ITEMLOC           FILEFLD

  where  (                      Line Type  = "I"                            )


  Is Used In No Indexes
  Is Used In Rel - ICCATEGORY
                 - ITEMLOC
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - C-ACCOUNT
                    - C-ACCT-UNIT
                    - C-SUB-ACCT
                    - I-ACCOUNT
                    - I-ACCT-UNIT
                    - I-SUB-ACCT
                    - S-ACCOUNT
                    - S-ACCT-UNIT
                    - S-SUB-ACCT
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ITEMMAST          FILEFLD

  where  (                      Line Type  = "I"                            
     Or                         Line Type  = "N"                            )


  Is Used In No Indexes
  Is Used In Rel - ITEMMAST
                 - OESLSACCT
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - I-ACCOUNT
                    - I-ACCT-UNIT
                    - I-SUB-ACCT
  Is Used In No AvfFlds
  Is Used In 2 Rules



  Condition         Type
--------------------------------------------------------------------------------
  LINE-TAX          OTOFLDS

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


  Is Used In No Indexes
  Is Used In Rel - LINE-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
--------------------------------------------------------------------------------
  LINE-TYPE-CHGD    FILEFLD

  where  (                 Old(Line Type) != Line 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 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  MADE-TO-ORDER     OTOFLDS

  where  (         Oeinvoice->Invc Source  = "S"                            
    And                    Coline->Kit Fl  = "O"                            )


  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
--------------------------------------------------------------------------------
  MANUAL-INVOICE    OTOFLDS

  where  (         Oeinvoice->Invc Source  = "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
--------------------------------------------------------------------------------
  MULT-RATE         OTOFLDS

  where  (           Oeinvoice->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
--------------------------------------------------------------------------------
  MULT-SPR-UOMS     FILEFLD

  where  (                    Mult Spr Fl  = "Y"                            )


  Is Used In No Indexes
  Is Used In Rel - OEINVCUOM
  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-CHARGE         FILEFLD

  where  (                   No Charge 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 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  NON-CWT-ITEM      FILEFLD, OTOFLDS

  where ((                      Line Type != "X"                            
    And                Itemmast->Ctw Code  = "N"                            )
     Or  (                      Line Type  = "X"                            ))


  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-IN-BASE       OTOFLDS

  where  (       Oeinvoice->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
--------------------------------------------------------------------------------
  OILSET2           FILEFLD

  where  (                   Price Status  = "A"                            )


  Is Used In Index - OILSET2
  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
--------------------------------------------------------------------------------
  OILSET3           FILEFLD

  where  (                      Line 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
--------------------------------------------------------------------------------
  REASON-ENTERED    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    OTOFLDS

  where  (       Oeinvoice->Recur Invoice != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - BLRICLINE
                 - BLRIMAST
                 - BLRIMLINE
                 - OECSLINE
                 - OEMASTSRVC
                 - OEMSLINE
  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
--------------------------------------------------------------------------------
  RETURN-INVC       OTOFLDS

  where  (         Oeinvoice->Invc Source  = "R"                            )


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

  where  (           Relation: Returnline 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
--------------------------------------------------------------------------------
  SALESMAN2         FILEFLD

  where  (                     Salesman 2 != Zeroes                         )


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

  where  (                      Line Type  = "X"                            )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - C-ACCOUNT
                    - C-ACCT-UNIT
                    - C-SUB-ACCT
  Is Used In No AvfFlds
  Is Used In 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  SYSTEM-INVOICE    OTOFLDS

  where  (         Oeinvoice->Invc Source  = "S"                            )


  Is Used In No Indexes
  Is Used In Rel - OESHIPMENT
  Is Used In No SubType
  Is Used In No States
  Is Used In No CndFlds
  Is Used In No AvfFlds
  Is Used In 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  TAXED             FILEFLD

  where  (                       Tax Code != Spaces                         
    And                     Tax Exempt Cd  = "T"                            )


  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
--------------------------------------------------------------------------------
  UOM-REQUIRED      OTOFLDS

  where  (          Oecompany->Uom Req 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 1 Rule