CREATE VIEW MY_BA AS (SELECT     1 AS TIP, VE_INVOICE.TRANSTYPE AS ISLEMTIPI, VE_INVOICE.COMPANYID AS SIRKETID, VE_INVOICE.TRANSDATE AS TARIH, VE_ACT.TAXNO AS VERGINO, 
                      VE_ACT.TCNO AS TCNO, (CASE WHEN VE_ACT.TAXNO = '' THEN VE_ACT.TCNO ELSE VE_ACT.TAXNO END) AS NO, VE_INVOICE.TOTAL AS TUTAR, 
                      VE_INVOICE.VATSUM AS KDVTUTAR, VE_INVOICE.TAKEUPTAXSUM AS TEVKIFAT, VE_ACT.COUNTRY, VE_ACT.ACTNAME
FROM         VE_INVOICE, VE_ACT
WHERE     VE_INVOICE.COMPANYID = VE_ACT.COMPANYID AND VE_INVOICE.ACTID = VE_ACT.ACTID AND VE_INVOICE.ACCCHECK = 1 AND VE_INVOICE.TRANSTYPE IN (201, 
                      104)
UNION ALL
SELECT     2 AS TIP, VE_EXPREVRECEIPT.TRANSTYPE AS ISLEMTIPI, VE_EXPREVRECEIPT.COMPANYID AS SIRKETID, VE_EXPREVRECEIPT.TRANSDATE AS TARIH, 
                      VE_ACT.TAXNO AS VERGINO, VE_ACT.TCNO AS TCNO, (CASE WHEN VE_ACT.TAXNO = '' THEN VE_ACT.TCNO ELSE VE_ACT.TAXNO END) AS NO, 
                      VE_EXPREVRECEIPT.TOTAL AS TUTAR, VE_EXPREVRECEIPT.VATSUM AS KDVTUTAR, VE_EXPREVRECEIPT.TAKEUPTAXSUM AS TEVKIFAT, VE_ACT.COUNTRY, 
                      VE_ACT.ACTNAME
FROM         VE_EXPREVRECEIPT, VE_ACT
WHERE     VE_EXPREVRECEIPT.COMPANYID = VE_ACT.COMPANYID AND VE_EXPREVRECEIPT.ACTID = VE_ACT.ACTID AND VE_EXPREVRECEIPT.ACCCHECK = 1 AND 
                      VE_EXPREVRECEIPT.TRANSTYPE IN (803, 806)
UNION ALL
SELECT     3 AS TIP, VE_SMMSALES.TRANSTYPE AS ISLEMTIPI, VE_SMMSALES.COMPANYID AS SIRKETID, VE_SMMSALES.TRANSDATE AS TARIH, VE_ACT.TAXNO AS VERGINO, 
                      VE_ACT.TCNO AS TCNO, (CASE WHEN VE_ACT.TAXNO = '' THEN VE_ACT.TCNO ELSE VE_ACT.TAXNO END) AS NO, VE_SMMSALES.TOTAL AS TUTAR, 
                      VE_SMMSALES.VATTOTAL AS KDVTUTAR, 0 AS TEVKIFAT, VE_ACT.COUNTRY, VE_ACT.ACTNAME
FROM         VE_SMMSALES, VE_ACT
WHERE     VE_SMMSALES.COMPANYID = VE_ACT.COMPANYID AND VE_SMMSALES.ACTID = VE_ACT.ACTID AND VE_SMMSALES.ACCCHECK = 1 AND 
                      VE_SMMSALES.TRANSTYPE = 809)