insert into oss6.SCHETOV(NOMER,COAN,DATASCH,TOVAR,TOVTYPE,EDIZM,KOLVO,CENA,SUMMA)
         SELECT  inbase.ninv AS NOMER,
         inbase.coan AS COAN,
         to_date((to_char(inbase.invdate,'YYYY-MM-DD')),'YYYY-MM-DD') AS DATASCH,
         substring(idetails1.payfor from  1  for  50 ) AS TOVAR,
         (CASE  inbase.itype WHEN  12  THEN  0  ELSE  1  END) AS TOVTYPE,
         'штука' AS EDIZM,
          1  AS KOLVO,
         oss6.idetails1.charge AS CENA,
         oss6.idetails1.charge AS SUMMA
         FROM  oss6.inbase, oss6.idetails1
         WHERE (inbase.ninv IN (SELECT tmpin.ninv FROM  oss6.tmpin)) and oss6.inbase.ninv = oss6.idetails1.ninv
         ORDER BY  inbase.ninv2, oss6.idetails1.payfor DESC;

substring(idetails1.payfor from  1  for  50 ) AS TOVAR 

idetails1.payfor AS TOVAR

(CASE  inbase.itype WHEN  12  THEN  0  ELSE  1  END)