CREATE VIEW dbo.POS_CEKIM_ORANLARI
AS
SELECT        CLF.TRANNO, CAST(CLF.DATE_ AS DATE) AS DATE_, CC.DEFINITION_ AS FIRMA, CLF.TRNET, BCC.DEFINITION_ AS BANKA, CLF.LINEEXP, ISNULL(POS.TAKSIT, '1') AS TAKSIT, CASE WHEN ISNULL(POS.TAKSIT, '1') 
                         = '2' THEN CONVERT(FLOAT, BCC.SPECODE) WHEN ISNULL(POS.TAKSIT, '1') = '3' THEN CONVERT(FLOAT, BCC.CYPHCODE) ELSE '0' END AS ORAN, CASE WHEN ISNULL(POS.TAKSIT, '1') = '2' THEN ((CONVERT(FLOAT, 
                         BCC.SPECODE)) / 100) * CLF.TRNET WHEN ISNULL(POS.TAKSIT, '1') = '3' THEN ((CONVERT(FLOAT, BCC.CYPHCODE)) / 100) * CLF.TRNET ELSE 0 END AS KOMISYON, CASE WHEN ISNULL(POS.TAKSIT, '1') 
                         = '1' THEN CLF.TRNET WHEN ISNULL(POS.TAKSIT, '1') = '2' THEN CLF.TRNET - (((CONVERT(FLOAT, BCC.SPECODE)) / 100) * CLF.TRNET) WHEN ISNULL(POS.TAKSIT, '1') = '3' THEN CLF.TRNET - (((CONVERT(FLOAT, 
                         BCC.CYPHCODE)) / 100) * CLF.TRNET) ELSE CLF.TRNET END AS GEREKEN
FROM            dbo.LG_011_08_CLFLINE AS CLF LEFT OUTER JOIN
                         dbo.LG_011_CLCARD AS CC ON CC.LOGICALREF = CLF.CLIENTREF LEFT OUTER JOIN
                         dbo.LG_011_BANKACC AS BCC ON BCC.LOGICALREF = CLF.BANKACCREF LEFT OUTER JOIN
                         dbo.POS_CEKIM_TAKSIT_ORANLARI AS POS ON POS.LOGICALREF = CLF.LOGICALREF
WHERE        (CLF.TRCODE = 70)