CONDITION REPORT
----------------
FILE - MMDIST
Condition Type
--------------------------------------------------------------------------------
ATN-OBJ-ID-EX FILEFLD
where ( Atn Obj Id != Zeroes )
Is Used In Index - MMDSET2
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
--------------------------------------------------------------------------------
FROM-IC FILEFLD
where ( System Cd = "IC" )
Is Used In No Indexes
Is Used In Rel - ICTRANS
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
--------------------------------------------------------------------------------
FROM-PO FILEFLD
where ( System Cd = "PO"
And Doc Type = "PT" )
Is Used In No Indexes
Is Used In Rel - POAOCDTL
- POLINE
- PURCHORDER
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
--------------------------------------------------------------------------------
FROM-RECEIVING FILEFLD
where ( Doc Type = "PO"
Or Doc Type = "RA"
Or Doc Type = "RJ" )
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
--------------------------------------------------------------------------------
FROM-REQLINE FILEFLD
where ( System Cd = "RQ"
And Doc Type = "RQ" )
Is Used In Index - MMDSET8
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
--------------------------------------------------------------------------------
FROM-RETURN FILEFLD
where ( Doc Type = "VR" )
Is Used In No Indexes
Is Used In Rel - PORETURNHD
- PORETURNLN
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
--------------------------------------------------------------------------------
FROM-RQ FILEFLD
where ( System Cd = "RQ" )
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-ACTIVITY FILEFLD
where ( Activity != 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
--------------------------------------------------------------------------------
IC-FIN-RPTG-D FILEFLD
where (( Pull For Fr 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
--------------------------------------------------------------------------------
IC-FIN-RPTING FILEFLD
where (( Pull For Fr Fl = "Y" ))
Is Used In Index - MMDSET10
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
--------------------------------------------------------------------------------
INTERCOMPANY FILEFLD
where ( Company != Dist Company )
Is Used In No Indexes
Is Used In Rel - REQLINE3
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
--------------------------------------------------------------------------------
INTERFACE FILEFLD
where ( Doc Type = "IF" )
Is Used In Index - MMDSET6
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
--------------------------------------------------------------------------------
MMDSET5-AP FILEFLD
where ( System Cd = "AP" )
Is Used In Index - MMDSET5
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
--------------------------------------------------------------------------------
NOT-PO-MNR FILEFLD
where ( Posting Type != "MN" )
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
--------------------------------------------------------------------------------
NOT-PO-RNI FILEFLD
where ( Line Seq != 999 )
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
--------------------------------------------------------------------------------
PO-MMDIST FILEFLD
where ( System Cd = "PO"
And Doc Type = "PT"
And Line Seq < 997 )
Is Used In Index - MMDSET4
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
--------------------------------------------------------------------------------
PO-OR-RQ FILEFLD
where (( System Cd = "PO"
And Doc Type = "PT"
And Line Seq < 997 )
Or ( System Cd = "RQ"
And Doc Type = "RQ" ))
Is Used In Index - MMDSET9
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
--------------------------------------------------------------------------------
PO-RECEIVING FILEFLD
where (( Doc Type = "PO" ))
Is Used In No Indexes
Is Used In Rel - PORECLINE
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
--------------------------------------------------------------------------------
POSTED FILEFLD
where ( Glt Obj Id != Zeroes )
Is Used In Index - MMDSET3
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
--------------------------------------------------------------------------------
RNI-OBJ-ID-EX FILEFLD
where ( Rni Obj Id != Zeroes )
Is Used In Index - MMDSET12
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
--------------------------------------------------------------------------------
SLTRANS-EXISTS OTOFLDS
where ( Relation: Sltrans 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
--------------------------------------------------------------------------------
TO-REQLINE FILEFLD
where (( System Cd = "RQ" )
And ( Doc Type = "DT"
Or Doc Type = "IS"
Or Doc Type = "IT" ))
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
--------------------------------------------------------------------------------
UNPOSTED-PO-RQ FILEFLD
where ( Status = Zeroes
And (( System Cd = "PO" )
And ( Doc Type != "VA" )
And ( Doc Type != "VR" ))
Or (( System Cd = "RQ" )
And ( Doc Type = "IS" )
Or ( Doc Type = "RR" )))
Is Used In Index - MMDSET7
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
|
