CONDITION REPORT
----------------
FILE - ARACPIVOT
Condition Type
--------------------------------------------------------------------------------
ACHSTHDR-EXIST OTOFLDS
where ( Relation: Achisthdr 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
--------------------------------------------------------------------------------
CCPSET2 FILEFLD
where((( Trans Type = "I"
Or Trans Type = "C"
Or Trans Type = "D" )
And ( Status = 1 ))
Or (( Trans Type = "P" )
And ( Status = Zeroes
Or Status = 2 )))
Is Used In Index - CCPSET2
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
--------------------------------------------------------------------------------
CCPSET3 FILEFLD
where((( Trans Type = "I"
Or Trans Type = "C"
Or Trans Type = "D" )
And ( Status = 1 ))
Or (( Trans Type = "P" )
And ( Status = Zeroes
Or Status = 2 )))
Is Used In Index - CCPSET3
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
--------------------------------------------------------------------------------
CCPSET4 FILEFLD
where((( Trans Type = "I"
Or Trans Type = "C"
Or Trans Type = "D" )
And ( Status = 1 ))
Or (( Trans Type = "P" )
And ( Status = Zeroes
Or Status = 2 )))
Is Used In Index - CCPSET4
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
--------------------------------------------------------------------------------
CCPSET5 FILEFLD
where ( Status > Zeroes
And Status < 9 )
Is Used In Index - CCPSET5
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
--------------------------------------------------------------------------------
CCPSET6 FILEFLD
where ( Status > Zeroes
And Status < 9 )
Is Used In Index - CCPSET6
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
--------------------------------------------------------------------------------
CCPSET7 FILEFLD
where ( Status > Zeroes
And Status < 9 )
Is Used In Index - CCPSET7
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
--------------------------------------------------------------------------------
CLOSED-PAYMENT FILEFLD
where((( Trans Type = "P" )
And ( Status = 7
Or Status = 8
Or Status = 9 )))
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
--------------------------------------------------------------------------------
CLOSED-TRANS FILEFLD
where((( Trans Type = "I"
Or Trans Type = "C"
Or Trans Type = "D" )
And ( Status = 7
Or Status = 8
Or Status = 9 )))
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
--------------------------------------------------------------------------------
CONTRACT-EXIST FILEFLD
where ( Contract != "SPACES" )
Is Used In No Indexes
Is Used In Rel - ACHISTHDR
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
--------------------------------------------------------------------------------
OPEN-PAYMENTS FILEFLD
where((( Trans Type = "P" )
And ( Status = 1
Or Status = 2 )))
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
--------------------------------------------------------------------------------
OPEN-TRANS FILEFLD
where((( Trans Type = "I"
Or Trans Type = "D"
Or Trans Type = "C" )
And ( Status = 1 )))
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
|
