CREATE VIEW VU_ODEMETAHSILAT AS (SELECT     COMPANYID, 1 AS TIP, '' AS DURUM, ACTID AS KARTID, ACTNO AS KARTNO, ACTNAME AS KARTNAME, '0' AS HESAPNO, TRANSDATE AS TARIH, DUEDATE AS VADE, 
                      DATEPART(WW, DUEDATE) AS HAFTA, DEBIT AS BORC, CREDIT AS ALACAK
FROM         VE_ACTTRANS
UNION ALL
SELECT     COMPANYID, 3 AS TIP, LASTPOSITIONNAME AS DURUM, BANKID AS KARTID, BANKNO AS KARTNO,
                          (SELECT     A.BANKNAME
                            FROM          VE_BANK A
                            WHERE      A.COMPANYID = VE_CS.COMPANYID AND A.BANKID =
                                                       (SELECT     B.PARENTBRANCH
                                                         FROM          BANK B
                                                         WHERE      B.COMPANYID = VE_CS.COMPANYID AND B.BANKID = VE_CS.BANKID)) AS KARTNAME, '0' AS HESAPNO, TRANSDATE AS TARIH, 
                      DUEDATE AS VADE, DATEPART(WW, DUEDATE) AS HAFTA, 0.00 AS BORC, TOTAL AS ALACAK
FROM         VE_CS
WHERE     CSTYPE IN (506, 514) AND LASTPOSITION = 3100
UNION ALL
SELECT     COMPANYID, 2 AS TIP, LASTPOSITIONNAME AS DURUM, CASHID AS KARTID, CASHNO AS KARTNO,
                          (SELECT     A.CASHNAME
                            FROM          VE_CASH A
                            WHERE      A.COMPANYID = VE_CS.COMPANYID AND A.CASHID = VE_CS.CASHID) AS KARTNAME, '0' AS HESAPNO, TRANSDATE AS TARIH, DUEDATE AS VADE, 
                      DATEPART(WW, DUEDATE) AS HAFTA, TOTAL AS BORC, 0.00 AS ALACAK
FROM         VE_CS
WHERE     CSTYPE IN (502, 510) AND LASTPOSITION IN (1504, 1500, 1503, 3300, 3303, 3304))