|
|
CONDITION REPORT
----------------
FILE - PORECLINE
Condition Type
--------------------------------------------------------------------------------
AVAIL-TO-MATCH FILEFLD, OTOFLDS
where ( Status > Zeroes
And Match Obj Id = Zeroes
And Poreceive->Status = 1
And Poreceive->Match Amt > Zeroes
And (( Status = 1 )
Or ( Vendor->Hold Insp Flag = "N" )
Or ( Vendor->Hold Insp Flag = Spaces
And Macompany->Hold Insp Flag != "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
--------------------------------------------------------------------------------
BUYER-MESSAGE FILEFLD
where ( Buyer Msg Flag = "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
--------------------------------------------------------------------------------
DETAILS-EXIST FILEFLD
where ( Last Pot Seq > 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
--------------------------------------------------------------------------------
ERS-AOC-EXISTS OTOFLDS
where ( Relation: Recaocdtl Exists
And Vendor->Ers Capable = "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
--------------------------------------------------------------------------------
HAS-ADJ-IN OTOFLDS
where ( Relation: Porecadjln 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
--------------------------------------------------------------------------------
HAS-DIST OTOFLDS
where ( Relation: Mmdist 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
--------------------------------------------------------------------------------
ICBIN FILEFLD
where ( Bin != Spaces
And Bin != "*" )
Is Used In No Indexes
Is Used In Rel - ICBIN
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
--------------------------------------------------------------------------------
INSPECTION FILEFLD
where ( Status = 5
Or Status = 6 )
Is Used In Index - PRLSET10
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
--------------------------------------------------------------------------------
ITEMLOC FILEFLD
where ( Item Type = "I" )
Is Used In No Indexes
Is Used In Rel - ICCATEGORY
- ICTRANS
- ITEMLOC
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
--------------------------------------------------------------------------------
ITEMMAST FILEFLD
where ( Item Type = "I"
Or Item Type = "N" )
Is Used In No Indexes
Is Used In Rel - ITEMMAST
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
--------------------------------------------------------------------------------
MATCHED FILEFLD
where ( Match Obj Id != 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
--------------------------------------------------------------------------------
MFG-INFO-EXIST FILEFLD
where ( Manuf Id != Zeroes )
Is Used In Index - PRLSET14
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-INVENTORY FILEFLD
where ( Item Type = "N"
Or Item 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
--------------------------------------------------------------------------------
ORIG-RECEIVING FILEFLD
where ( Line Nbr = Po Line Nbr )
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
--------------------------------------------------------------------------------
REFERENCE-NO FILEFLD
where ( Reference No != 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
--------------------------------------------------------------------------------
RELEASED FILEFLD
where ( Status > Zeroes )
Is Used In Index - PRLSET5
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
--------------------------------------------------------------------------------
SUB-RECEIVING FILEFLD
where ( Po Line Nbr != Line Nbr )
Is Used In No Indexes
Is Used In Rel - SUBSTITUTES
Is Used In No SubType
Is Used In No States
Is Used In CndFld - SUBSTITUTE
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
UNDELIVERED FILEFLD
where ( Fully Deliv = "N"
And Status = 1 )
Is Used In Index - PRLSET3
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 = 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
|
