/****** Script for SelectTopNRows command from SSMS  ******/
CREATE VIEW dbo.FIRMAYA_GORE_FIS_TOPLAMLARI
AS
SELECT        'BORÇ' AS BA, FIS.FICHENO, 'ALIM FISI' AS FIS_TURU, CMP.DEFINITION_, FIS.DATE_, FST.TPL AS TOPLAM, FIS.GENEXP, KLL.KULLANICI, CASE WHEN FIS.[STATUS] = 4 THEN 1 ELSE 0 END AS CANCELLED, FIS.STATUS
FROM            dbo.FIRMA_SIPARISLERI_FIS_TOPLAMLARI AS FST LEFT OUTER JOIN
                         dbo.FICHES AS FIS ON FIS.REF = FST.FICHEREF LEFT OUTER JOIN
                         dbo.COMPANIES AS CMP ON CMP.REF = FST.COMPANYREF LEFT OUTER JOIN
                         dbo.KULLANICILAR AS KLL ON KLL.REF = FIS.USERREF
WHERE        (FIS.STATUS <> 4)