CONDITION REPORT
----------------
FILE - APVENMAST
Condition Type
--------------------------------------------------------------------------------
ACTIVE-VENDOR FILEFLD
where ( Vendor 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: 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
--------------------------------------------------------------------------------
ADDR-VENDOR OTOFLDS
where (( Relation: Apvenaddr Exists )
And ( Address1->Cur Addr = "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 - 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
--------------------------------------------------------------------------------
CHECK-EXISTS OTOFLDS
where ( Relation: Cbcheck 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: Apvcomments 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
--------------------------------------------------------------------------------
HANDCODE-EXIST FILEFLD
where ( Handling Code != 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
--------------------------------------------------------------------------------
LOCATION-EXIST OTOFLDS
where ( Relation: Apvenloc 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 - LOC-INDICATOR
- VCOMMENT-EXIST
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 - VENSET8
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
--------------------------------------------------------------------------------
NUMERIC-VENDOR OTOFLDS
where ( Apvengroup->Num Ven Nbr = "N" )
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
--------------------------------------------------------------------------------
OBJ-ID-EXISTS FILEFLD
where ( Ap Obj Id != Zeroes )
Is Used In Index - VENSET11
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
--------------------------------------------------------------------------------
ON-HOLD FILEFLD
where (( Hold Flag = "Y" ))
Is Used In No Indexes
Is Used In Rel - APHLDINV
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 (( Vendor Status != "I" )
And ( Vendor 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 (( Vendor 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
--------------------------------------------------------------------------------
REP-INC-VENDOR FILEFLD
where ( Income Code != 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
--------------------------------------------------------------------------------
TAX-VENDOR FILEFLD
where ( Tax Code != Spaces
Or Tax Id != 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
--------------------------------------------------------------------------------
VDRCPY-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
|