CREATE VIEW MY_BS 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 (101,204)                                                              
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 (802,804)
UNION ALL
SELECT  3 AS TIP, VE_SMM.TRANSTYPE AS ISLEMTIPI, 
VE_SMM.COMPANYID AS SIRKETID, 
VE_SMM.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_SMM.TOTAL AS TUTAR, 
VE_SMM.VATTOTAL AS KDVTUTAR, 
0 AS TEVKIFAT,
VE_ACT.COUNTRY,
VE_ACT.ACTNAME                                                                        
FROM VE_SMM, VE_ACT                 
WHERE VE_SMM.COMPANYID = VE_ACT.COMPANYID
AND VE_SMM.ACTID = VE_ACT.ACTID
AND VE_SMM.ACCCHECK= 1
AND VE_SMM.TRANSTYPE = 811)