CREATE VIEW dbo.KASA_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, 
                         REPLACE(RIGHT(REPLACE(REPLACE(CLF.GENEXP, 'NOLU SIPARISE ÖDEME', ''), ' ', ''), 8), 'T', '') AS FISNO, CMP2.DEFINITION_ AS FIRMA
FROM            dbo.CLFLINE AS CLF LEFT OUTER JOIN
                         dbo.COMPANIES AS CMP ON CMP.REF = CLF.KASAREF LEFT OUTER JOIN
                         dbo.COMPANIES AS CMP2 ON CMP2.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) AND (FST.REF NOT IN (3))