Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WHSHIPMENT


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

       

   FILE - WHSHIPMENT


  Condition         Type
--------------------------------------------------------------------------------
  BILL-OF-LADING    FILEFLD

  where ((                        Bol 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
--------------------------------------------------------------------------------
  BOL               FILEFLD

  where ((                        Bol Nbr != Spaces                         ))


  Is Used In Index - WHSSET2
  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
--------------------------------------------------------------------------------
  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
--------------------------------------------------------------------------------
  CASEHEADER        FILEFLD

  where  (                      System Cd  = "CX"                           )


  Is Used In No Indexes
  Is Used In Rel - CASEHEADER
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - ORIGIN
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  CUSTORDER         FILEFLD

  where  (                      System Cd  = "OE"                           )


  Is Used In No Indexes
  Is Used In Rel - CUSTORDER
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - ORIGIN
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  DIFF-DHDR-DEST    FILEFLD, OTOFLDS

  where ((                      System Cd  = "OE"                           
    And                       Destination != Spaces                         
    And                       Destination != Whdemndhdr->Destination        ))


  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
--------------------------------------------------------------------------------
  LATE-SHIPMENT     FILEFLD, OTOFLDS

  where  (                      Ship Date  > Rqst Ship Dt                   )


  Is Used In No Indexes
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - DAYS-LATE-COND
                    - DAYS-LATE-CTR
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  METHOD-ENTERED    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
--------------------------------------------------------------------------------
  NO-DHDR-DEST      FILEFLD, OTOFLDS

  where ((                      System Cd  = "OE"                           
    And                       Destination  = Spaces                         
    And                       Destination  = Whdemndhdr->Destination        ))


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

  where ((                   Pack List 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
--------------------------------------------------------------------------------
  RDY-TO-PACK       FILEFLD

  where  (                    Packing Req  = "Y"                            
    And ((                         Status  = 1                              )
     Or  (                    Picking Req  = "N"                            
    And                            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 - LAST-DATE
                    - RDY-TO-LITERAL
                    - RDY-TO-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  RDY-TO-PICK       FILEFLD

  where  (                         Status  = Zeroes                         
    And                       Picking Req  = "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 - LAST-DATE
                    - RDY-TO-LITERAL
                    - RDY-TO-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  RDY-TO-SHIP       FILEFLD

  where  (                         Status  = 2                              
     Or  (                    Packing Req  = "N"                            
    And                            Status  = 1                              )
     Or  (                    Packing Req  = "N"                            
    And                       Picking Req  = "N"                            
    And                            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 - LAST-DATE
                    - RDY-TO-LITERAL
                    - RDY-TO-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  READY-TO-INVC     FILEFLD

  where ((                      System Cd  = "OE"                           )
    And  (                         Status  = 4                              ))


  Is Used In Index - WHSSET6
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - RDY-TO-LITERAL
                    - RDY-TO-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



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

  where  (                         Status  = 4                              )


  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
--------------------------------------------------------------------------------
  REQ-RELEASED      FILEFLD

  where ((                      System Cd  = "RQ"                           )
    And  (                         Status  = 4                              ))


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

  where  (                      System Cd  = "RQ"                           )


  Is Used In No Indexes
  Is Used In Rel - REQHEADER
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - ORIGIN
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  ROUTE             FILEFLD

  where ((                           Stop != 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
--------------------------------------------------------------------------------
  SAME-DHDR-DEST    FILEFLD, OTOFLDS

  where ((                      System Cd  = "OE"                           
    And                       Destination != Spaces                         
    And                       Destination  = Whdemndhdr->Destination        ))


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

  where ((                         Status  = 3                              ))


  Is Used In Index - WHSSET4
  Is Used In No Rels
  Is Used In No SubType
  Is Used In No States
  Is Used In CndFld - RDY-TO-LITERAL
                    - RDY-TO-STATUS
  Is Used In No AvfFlds
  Is Used In No Rules



  Condition         Type
--------------------------------------------------------------------------------
  WO-DHDR-DEST      FILEFLD, OTOFLDS

  where ((                      System Cd  = "OE"                           
    And                       Destination  = Spaces                         
    And                       Destination != Whdemndhdr->Destination        ))


  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