CONDITION REPORT
----------------
FILE - APVENLOC
Condition Type
--------------------------------------------------------------------------------
ACTIVE-LOC FILEFLD
where ( Active Status != "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
--------------------------------------------------------------------------------
ADDR-LOC OTOFLDS
where (( Relation: Address1 Exists ))
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - VDR-ADDR1
- VDR-ADDR2
- VDR-ADDR3
- VDR-ADDR4
- VDR-CITY-ADDR5
- VDR-COUNTRY
- VDR-COUNTY
- VDR-POSTAL
- VDR-STATE
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
ADDRESS1 OTOFLDS
where (( Relation: Apvenaddr 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
--------------------------------------------------------------------------------
COMMENT-EXIST OTOFLDS
where ( Relation: Apcomments 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
--------------------------------------------------------------------------------
DIVERSE-EXISTS OTOFLDS
where ( Relation: Apvendiv 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
--------------------------------------------------------------------------------
NO-PRENOTIFY FILEFLD
where ( Ach Prenot = "N"
Or Ach Prenot = "P" )
Is Used In Index - VLOSET4
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-ADD-ACTIVE FILEFLD
where (( Active Status != "I" )
And ( Active Status != "D" ))
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-ADD-INACTIV FILEFLD
where (( Active Status = "D" ))
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
--------------------------------------------------------------------------------
VLOCPY-EXISTS OTOFLDS
where ( Relation: Apcpyvnd 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
--------------------------------------------------------------------------------
VLOSET2 FILEFLD
where ( Loc Type != "P" )
Is Used In Index - VLOSET2
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
--------------------------------------------------------------------------------
VLOSET3 FILEFLD
where ( Loc Type != "R" )
Is Used In Index - VLOSET3
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
|
