CONDITION REPORT
----------------
FILE - MAINVDTL
Condition Type
--------------------------------------------------------------------------------
AOC-APPROVAL FILEFLD
where((( Aoc Code != Spaces )
And ( Tax Code = Spaces )))
Is Used In No Indexes
Is Used In Rel - POAOCMAST
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
--------------------------------------------------------------------------------
AOC-TAX-APPV FILEFLD
where ( Aoc Code != Spaces
And Tax Code != 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
--------------------------------------------------------------------------------
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
--------------------------------------------------------------------------------
HAS-PO FILEFLD
where ( Po Number != 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
--------------------------------------------------------------------------------
INVENTORY FILEFLD
where (( Item Type = "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
--------------------------------------------------------------------------------
ITEM-TAX-APPRV FILEFLD
where ( Tax Code != Spaces
And Aoc Code = 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
--------------------------------------------------------------------------------
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
--------------------------------------------------------------------------------
LINE-APPV FILEFLD
where ( Line Nbr != Zeroes
And Aoc Code = Spaces
And Tax Code = 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
--------------------------------------------------------------------------------
LINEAOCAPPROVL FILEFLD
where ( Line Nbr != Zeroes
And Aoc Code != 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
--------------------------------------------------------------------------------
LINEAPPROVAL FILEFLD
where ( Line Nbr != Zeroes
And Aoc Code = 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
--------------------------------------------------------------------------------
MADSET3 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
Condition Type
--------------------------------------------------------------------------------
MADSET7 FILEFLD
where ( Aoc Code = Spaces )
Is Used In Index - MADSET7
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
--------------------------------------------------------------------------------
MAINVMSG-EXIST OTOFLDS
where ( Relation: Mainvmsg 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
--------------------------------------------------------------------------------
MATCHED FILEFLD
where ( Status = 1 )
Is Used In Index - MADSET10
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
--------------------------------------------------------------------------------
MISCAOCAPPROVL FILEFLD
where ( Line Nbr = Zeroes
And Aoc Code != 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
--------------------------------------------------------------------------------
MMUAVAL-EXISTS OTOFLDS
where ( Relation: Mmuaval 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
--------------------------------------------------------------------------------
NON-INVENTORY FILEFLD
where ( Item Type != "I" )
Is Used In No Indexes
Is Used In Rel - MMDIST
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
--------------------------------------------------------------------------------
POAOCDTL FILEFLD
where ( Aoc Code != 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
--------------------------------------------------------------------------------
POASET4 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
Condition Type
--------------------------------------------------------------------------------
POASET5 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
Condition Type
--------------------------------------------------------------------------------
REGULAR-INV FILEFLD
where ( Invoice Type = Spaces )
Is Used In Index - MADSET9
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
|
