CONDITION REPORT
----------------
FILE - ITEMMAST
Condition Type
--------------------------------------------------------------------------------
ACTIVE FILEFLD
where ( Active Status = "A" )
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
--------------------------------------------------------------------------------
CW-ITEM FILEFLD
where ( Ctw Code != "N" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - ALLOC-UOM
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
GENERICNAME FILEFLD
where ( Generic != Spaces
And Active Status = "A" )
Is Used In Index - ITESET3
Is Used In Rel - GENERICNAME
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-COMMENTS OTOFLDS
where ( Relation: Itemcomments 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-DESC2 FILEFLD
where ( Description2 != Spaces )
Is Used In Index - ITESET13
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-IC-OBJ-ID FILEFLD
where ( Ic Obj Id != Zeroes )
Is Used In Index - ITESET9
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
--------------------------------------------------------------------------------
HAZARD FILEFLD
where ( Hazard Code != Spaces )
Is Used In No Indexes
Is Used In Rel - HAZARD
Is Used In No SubType
Is Used In No States
Is Used In CndFld - HAZARD-FL
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
ICSEGMENT FILEFLD
where ( Icsegment != Spaces
And Active Status = "A" )
Is Used In Index - ITESET10
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
--------------------------------------------------------------------------------
INACTIVE FILEFLD
where ( Active Status = "I" )
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
--------------------------------------------------------------------------------
INVENTORYCLASS FILEFLD
where ( Inven Majcl != Spaces
And Active Status = "A" )
Is Used In Index - ITESET5
Is Used In Rel - INVENTORYCLASS
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
--------------------------------------------------------------------------------
ITEM-ENTERED FILEFLD
where ( Item != 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 - ITEM-CODE-USED
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
Condition Type
--------------------------------------------------------------------------------
MANUF-CD-ENTRD FILEFLD
where ( Manuf Code != Spaces
And Active Status = "A" )
Is Used In Index - ITESET8
Is Used In Rel - ICMANFCODE
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
--------------------------------------------------------------------------------
MANUF-NBR FILEFLD
where ( Manuf Nbr != Spaces
And Active Status = "A" )
Is Used In Index - ITESET11
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
--------------------------------------------------------------------------------
PHARMACY-ITEM FILEFLD
where ( Use Identifier = "D"
And Old(Use Identifier) = "P" )
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
--------------------------------------------------------------------------------
PURCHASECLASS FILEFLD
where ( Purch Majcl != Spaces
And Active Status = "A" )
Is Used In Index - ITESET4
Is Used In Rel - PURCHASECLASS
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
--------------------------------------------------------------------------------
REPLACE-ITEM FILEFLD
where ( Replace Item != Spaces )
Is Used In Index - ITESET12
Is Used In Rel - REPLACE-ITEM
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
--------------------------------------------------------------------------------
SALESCLASS FILEFLD
where ( Sales Majcl != Spaces
And Active Status = "A" )
Is Used In Index - ITESET6
Is Used In Rel - SALESCLASS
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
--------------------------------------------------------------------------------
TRACKED-1 FILEFLD
where ( Track 1 != 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 - VALUE-1
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
TRACKED-2 FILEFLD
where ( Track 2 != 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 - VALUE-2
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
TRACKED-3 FILEFLD
where ( Track 3 != 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 - VALUE-3
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
TRACKED-4 FILEFLD
where ( Track 4 != 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 - VALUE-4
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
TRACKED-5 FILEFLD
where ( Track 5 != 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 - VALUE-5
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
TRACKED-6 FILEFLD
where ( Track 6 != 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 - VALUE-6
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
USER-FLD-USED FILEFLD
where ( User Field1 != Spaces
And Active Status = "A" )
Is Used In Index - ITESET7
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
|
