CONDITION REPORT
----------------
FILE - LMINVOICE
Condition Type
--------------------------------------------------------------------------------
APAPIHIST OTOFLDS
where ( Relation: Apapihist 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
--------------------------------------------------------------------------------
APINVOICE OTOFLDS
where ( Relation: Apinvoice 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
--------------------------------------------------------------------------------
CANCELLED-AP FILEFLD
where ( Cancel Seq != Zeroes )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - CANCELLED-AP
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
CANCELLED-LM FILEFLD
where ( Cancelled 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 CndFld - CANCELLED-LM
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
LMDISTRIB OTOFLDS
where ( Relation: Lmdistrib 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
--------------------------------------------------------------------------------
NOT-CANCELLED FILEFLD
where (( Cancel Seq = Zeroes )
And ( Status = Zeroes ))
Is Used In Index - INVSET2
- INVSET3
- INVSET4
- INVSET8
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
--------------------------------------------------------------------------------
UPDATE-BALANCE FILEFLD
where((( Status = 1 )
And ( Cancel Seq = Zeroes ))
Or (( Status = 9 )
And ( Cancel Seq != Zeroes )
And ( Cancelled Fl != "Y" )))
Is Used In Index - INVSET5
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
|
