/****** Script for SelectTopNRows command from SSMS  ******/
CREATE VIEW dbo.CARI_FISI_LISTESI
AS
SELECT        CASE WHEN FST.IPTAL = 0 THEN 'BORÇ' ELSE 'ALACAK' END AS BA, FST.FIS_TURU, CMP.DEFINITION_, CLF.FICHENO, CLF.DATE_, CLF.AMOUNT, CLF.CANCELLED, CLF.GENEXP, KLL.KULLANICI
FROM            dbo.CLFLINE AS CLF LEFT OUTER JOIN
                         dbo.COMPANIES AS CMP ON CMP.REF = CLF.COMPANYREF LEFT OUTER JOIN
                         dbo.FICHE_TYPES AS FST ON FST.REF = CLF.STATUS LEFT OUTER JOIN
                         dbo.KULLANICILAR AS KLL ON KLL.REF = CLF.USERREF
WHERE        (CLF.CANCELLED = 0)