|
|
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
--------------------------------------------------------------------------------
OPEN FILEFLD
where ( Status < 4 )
Is Used In Index - WHSSET10
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
|
