CONDITION REPORT
----------------
FILE - ARPAYMENT
Condition Type
--------------------------------------------------------------------------------
APMSET3 FILEFLD
where ( Trans Type = "P"
And ( Customer = Spaces
Or Customer = "000000000" ))
Is Used In Index - APMSET3
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
--------------------------------------------------------------------------------
APMSET4 FILEFLD
where ( Trans Type = "P"
And Status = 2 )
Is Used In Index - APMSET4
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
--------------------------------------------------------------------------------
APMSET5 FILEFLD
where ( Trans Type = "N" )
Is Used In Index - APMSET5
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
--------------------------------------------------------------------------------
APMSET6 FILEFLD
where ( Trans Type != "N"
And Status = 2 )
Is Used In Index - APMSET6
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
--------------------------------------------------------------------------------
APMSET8 FILEFLD
where (( Status > 1
And Status < 9 )
And ( Trans Type = "P"
Or Trans Type = "B" ))
Is Used In Index - APMSET8
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
--------------------------------------------------------------------------------
APMSET9 FILEFLD
where (( Trans Type = "P"
Or Trans Type = "B" )
And ( Status = Zeroes
Or Status = 2 ))
Is Used In Index - APMSET9
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
--------------------------------------------------------------------------------
ARADJUST-EXIST OTOFLDS
where ( Relation: Aradjust 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
--------------------------------------------------------------------------------
ARAPMUF-EXISTS OTOFLDS
where ( Relation: Arapmuf 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
--------------------------------------------------------------------------------
ARAPPL-EXISTS OTOFLDS
where ( Relation: Arapplied 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
--------------------------------------------------------------------------------
ARAPSEL-EXIST OTOFLDS
where ( Relation: Arapselect 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
--------------------------------------------------------------------------------
ARMEMODIST FILEFLD
where ( Trans Type = "P" )
Is Used In No Indexes
Is Used In Rel - ARMEMODIST
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
--------------------------------------------------------------------------------
ARREMIT-EXISTS OTOFLDS
where ( Relation: Arremit 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
--------------------------------------------------------------------------------
ARSADJ-EXISTS OTOFLDS
where ( Relation: Arsadjust 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
--------------------------------------------------------------------------------
ARSAPL-EXISTS OTOFLDS
where ( Relation: Arsapplied 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
--------------------------------------------------------------------------------
COMMENTS-EXIST OTOFLDS
where ( Relation: Arcomment 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
--------------------------------------------------------------------------------
CUSTDESC FILEFLD
where ( Customer != Spaces
And Customer != "000000000" )
Is Used In No Indexes
Is Used In Rel - CUSTDESC
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
--------------------------------------------------------------------------------
CUSTOMER FILEFLD
where ( Customer != Spaces
And Customer != "000000000" )
Is Used In No Indexes
Is Used In Rel - CUSTOMER
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-AR-DISTRIB FILEFLD
where ( Trans Type = "N" )
Is Used In No Indexes
Is Used In Rel - NON-AR-DISTRIB
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-OPEN FILEFLD
where ( 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 FILEFLD
where ( 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
--------------------------------------------------------------------------------
PP-EXIST OTOFLDS
where ( Relation: Arprepay 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
--------------------------------------------------------------------------------
PROCESS-LEV-EQ FILEFLD
where ( Process Level = Ar Pymnt Hdr->Process Level )
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 1 Rule
|
