CREATE VIEW dbo.KASA_HAREKETLERI
AS
SELECT        *
FROM            ((SELECT        [BA], [FICHENO], [FIS_TURU], [DEFINITION_], [DATE_], [AMOUNT], [GENEXP], [KULLANICI], CANCELLED,  RIGHT(REPLACE(REPLACE(GENEXP,'NOLU SIPARISE ÖDEME',''),' ',''),7) AS FISNO
                            FROM            [IHR].[dbo].[KASA_FISI_LISTESI])) QQ