Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CUSTORDER


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

       

   FILE - CUSTORDER


  Condition         Type
--------------------------------------------------------------------------------
  AUDIT-EXISTS      OTOFLDS

  where  (              Relation: Oeaudit 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
--------------------------------------------------------------------------------
  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 - ORDER-ZERO
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  CARRIER           FILEFLD

  where  (                        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
--------------------------------------------------------------------------------
  COD-ORDER         FILEFLD

  where  (                         Cod 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
--------------------------------------------------------------------------------
  COD-TERM          OTOFLDS

  where  (              Terms->Proc Indic  = "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 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  COMMENTS-EXIST    OTOFLDS

  where  (         Relation: Hdr Comments Exists         
     Or            Relation: Trl 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 CndFld - COMM-LIT
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  CORSET4           FILEFLD

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

  where  (                      Hold Code != Spaces                         )


  Is Used In Index - CORSET6
  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-PO           FILEFLD

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



  Condition         Type
--------------------------------------------------------------------------------
  FREIGHT-CODE      FILEFLD

  where  (                   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
--------------------------------------------------------------------------------
  FUTURE-ORDER      FILEFLD

  where  (                      Future 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
--------------------------------------------------------------------------------
  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
--------------------------------------------------------------------------------
  HDR-COMMENTS      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
--------------------------------------------------------------------------------
  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 CndFld - HOLD-LIT
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ICLOCATION        FILEFLD

  where  (                   Inv Location != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - ICLOCATION
  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
--------------------------------------------------------------------------------
  INVOICES-EXIST    OTOFLDS

  where  (            Relation: Oeinvoice 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
--------------------------------------------------------------------------------
  METHOD            FILEFLD

  where  (                         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
--------------------------------------------------------------------------------
  MULT-RATE         OTOFLDS

  where  (              Curelat->Mult Div  = "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 - ACTUAL-FR-CH-B
                    - DISC-BASE
                    - DISC-TKN-BASE
                    - DISCNTBL-BASE
                    - FRT-CHG-BASE
                    - MISC-TTL-BASE
                    - ORD-DISC-BASE
                    - PMNT-BASE
                    - TAX-TTL-BASE
                    - TXBL-TTL-BASE
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  MULTI-CURRENCY    OTOFLDS

  where  (       Oecompany->Multi Curr 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
--------------------------------------------------------------------------------
  NO-CURR-OVR       OTOFLDS

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



  Condition         Type
--------------------------------------------------------------------------------
  NO-OVERRIDE       OTOFLDS

  where  (          Custdesc->Ovr Addr 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 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  NO-RATE-OVR       OTOFLDS

  where  (          Operator->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
--------------------------------------------------------------------------------
  NON-POD-ORDER     FILEFLD

  where  (                     Pod Req Fl  = 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 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  NOT-BASE-CURR     FILEFLD, OTOFLDS

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


  Is Used In No Indexes
  Is Used In Rel - CUCODES
  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       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-SA-UPDATED    FILEFLD

  where  (                  Sa Updated Fl != "Y"                            
    And                            Status  > 1                              )


  Is Used In Index - CORSET10
  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
--------------------------------------------------------------------------------
  OEREASON          FILEFLD

  where  (                     Cxl Reason != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - CXL-OPERATOR
                 - 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
--------------------------------------------------------------------------------
  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 1 Rule



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

  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
--------------------------------------------------------------------------------
  ORD-TYPE-CHNGD    FILEFLD

  where  (                Old(Order Type) != Order 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
--------------------------------------------------------------------------------
  ORDER-DISCOUNT    FILEFLD

  where  (                  Ord Disc Code  > Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - OEORDDISC
  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
--------------------------------------------------------------------------------
  PACKING-REQD      OTOFLDS

  where  (             Ordertype->Pack 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
--------------------------------------------------------------------------------
  PK-LIST-PRNTED    FILEFLD

  where  (                      Pk Prt 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
--------------------------------------------------------------------------------
  PKLIST-NT-PRTD    FILEFLD

  where  (                      Pk Prt 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 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  POSRC-EXISTS      OTOFLDS

  where  (            Relation: Polinesrc 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
--------------------------------------------------------------------------------
  PROC-IND-SAME     OTOFLDS

  where  (         Old(Terms->Proc Indic)  = Terms->Proc Indic              )


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

  where  (                   Sls Quote 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
--------------------------------------------------------------------------------
  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
--------------------------------------------------------------------------------
  SHIPMENT-EXIST    OTOFLDS

  where  (           Relation: Whshipment 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
--------------------------------------------------------------------------------
  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
--------------------------------------------------------------------------------
  SHIPTO-ENTERED    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 No CndFlds
  Is Used In No AvfFlds
  Is Used In 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  SHPMNT-CREATED    OTOFLDS

  where  (           Relation: Whshipment 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 1 Rule



  Condition         Type
--------------------------------------------------------------------------------
  SOURCE            FILEFLD

  where  (                   Order Source != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - OESOURCE
  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
--------------------------------------------------------------------------------
  TERITORY          FILEFLD

  where  (                      Territory != Spaces                         )


  Is Used In No Indexes
  Is Used In Rel - TERITORY
  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-EXIST       FILEFLD

  where  (                       Terms Cd != 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 - TERM-2
                    - TERMS-1
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  TRL-COMM-EXIST    OTOFLDS

  where  (         Relation: Trl 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
--------------------------------------------------------------------------------
  UNRELEASED        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