CONDITION REPORT
----------------
FILE - PHARITEM
Condition Type
--------------------------------------------------------------------------------
ACTIVE-STATUS FILEFLD
where ( Active Status = "A"
Or Inactive Date > )
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-AHFS FILEFLD
where ( Ahfs != Spaces )
Is Used In Index - PHISET6
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-BRAND-NAME FILEFLD
where ( Brand Name != Spaces )
Is Used In Index - PHISET14
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-GIPP FILEFLD
where ( Gipp != Spaces )
Is Used In Index - PHISET7
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-GPO-NBR FILEFLD
where ( Gpo Nbr != Spaces )
Is Used In Index - PHISET9
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-GPPC FILEFLD
where ( Gppc != Spaces )
Is Used In Index - PHISET5
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-MDPRODDESC FILEFLD
where ( Mdproddesc != Spaces )
Is Used In Index - PHISET8
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-NDC-NBR FILEFLD
where ( Ndc Nbr != Spaces )
Is Used In No Indexes
Is Used In Rel - PHARITEMTONDC
Is Used In No SubType
Is Used In No States
Is Used In CndFld - ITEM-CODE-USED
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
HAS-UPC FILEFLD
where ( Upc != Spaces )
Is Used In No Indexes
Is Used In Rel - PHARITEMTOUPC
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
--------------------------------------------------------------------------------
INACTIVE-STAT FILEFLD
where ( Active Status = "I"
And Inactive Date <= )
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
--------------------------------------------------------------------------------
ITEMVEN-EXISTS OTOFLDS
where ( Relation: Poitemven 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
|
