[Supplier_Code] = suppcode
and
not (deleted)