CREATE OR REPLACE VIEW food600.s_mondieu_dodavatelia
 AS
 SELECT partneri.c_partner,
    partneri.partner,
    partneri.ico,
    partneri.dic,
    partneri.banka,
    partneri.ucet,
    partneri.telefon,
    partneri.naz1,
    partneri.naz2,
    partneri.naz3,
    partneri.naz4,
    partneri.naz5,
    partneri.naz6,
    partneri.splatnost,
    partneri.cen_hlad,
    partneri.sleva_proc,
    partneri.c_data,
    partneri.idriadok,
    partneri.icdph,
    partneri.alkokod,
    partneri.ext_id,
    partneri.ext_intern,
    partneri.platcadph,
    partneri.zmena,
    partneri.edi_kod,
    partneri.typ_obj,
    partneri.edi_mankod,
    partneri.platba,
    partneri.email
   FROM food600.partneri
  WHERE partneri.c_partner > 0;
