CREATE VIEW VU_FINANSDURUM AS (SELECT     COMPANYID, 1 AS TIP, 'CARI' AS TIPADI, ACTID AS KARTID, ACTNO AS KARTNO, ACTNAME AS KARTADI, TRANSDATE AS TARIH, ROOT AS KAYNAK, ROOTID AS FISID, 
                      ROOTRECEIPTNO AS FISNO, ROOTRECEIPTITEMNO AS FISSIRANO, CURRCODE AS DOVIZ, 0.00 AS MIKTAR, DEBIT AS BORC, CREDIT AS ALACAK, 
                      CURRDEBIT AS DOVIZBORC, CURRCREDIT AS DOVIZALACAK
FROM         VE_ACTTRANS
UNION ALL
SELECT     VE_CASHTRANS.COMPANYID, 2 AS TIP, 'KASA' AS TIPADI, VE_CASHTRANS.CASHID AS KARTID, VE_CASHTRANS.CASHNO AS KARTNO, 
                      VE_CASHTRANS.CASHNAME AS KARTADI, VE_CASHTRANS.TRANSDATE AS TARIH, VE_CASHTRANS.ROOT AS KAYNAK, VE_CASHTRANS.ROOTID AS FISID, 
                      VE_CASHTRANS.ROOTRECEIPTNO AS FISNO, VE_CASHTRANS.ROOTRECEIPTITEMNO AS FISSIRANO, VE_CASHTRANS.CURRCODE AS DOVIZ, 0.00 AS MIKTAR, 
                      VE_CASHTRANS.DEBIT AS BORC, VE_CASHTRANS.CREDIT AS ALACAK, VE_CASHTRANS.CURRDEBIT AS DOVIZBORC, 
                      VE_CASHTRANS.CURRCREDIT AS DOVIZALACAK
FROM         VE_CASHTRANS, VE_CASH
WHERE     VE_CASHTRANS.COMPANYID = VE_CASH.COMPANYID AND VE_CASHTRANS.CASHID = VE_CASH.CASHID AND VE_CASH.CASHTYPE = 700
UNION ALL
SELECT     VE_BANKTRANS.COMPANYID, 3 AS TIP, 'BANKA' AS TIPADI, VE_BANK.BANKID AS KARTID, VE_BANK.BANKNO AS KARTNO, VE_BANK.BANKNAME AS KARTADI, 
                      VE_BANKTRANS.TRANSDATE AS TARIH, VE_BANKTRANS.ROOT AS KAYNAK, VE_BANKTRANS.ROOTID AS FISID, VE_BANKTRANS.ROOTRECEIPTNO AS FISNO, 
                      VE_BANKTRANS.ROOTRECEIPTITEMNO AS FISSIRANO, VE_BANKTRANS.CURRCODE AS DOVIZ, 0.00 AS MIKTAR, VE_BANKTRANS.DEBIT AS BORC, 
                      VE_BANKTRANS.CREDIT AS ALACAK, VE_BANKTRANS.CURRDEBIT AS DOVIZBORC, VE_BANKTRANS.CURRCREDIT AS DOVIZALACAK
FROM         VE_BANKTRANS, VE_BANK
WHERE     VE_BANKTRANS.COMPANYID = VE_BANK.COMPANYID AND VE_BANKTRANS.BANKID = VE_BANK.BANKID AND VE_BANK.BILLTYPE IN (1400, 1401)
UNION ALL
SELECT     COMPANYID, 4 AS TIP, VE_CS.LASTPOSITIONNAME AS TIPADI, BANKID AS KARTID, '' AS KARTNO, BANKNAME AS KARTADI, TRANSDATE AS TARIH, ROOT AS KAYNAK,
                       ROOTID AS FISID, ROOTRECEIPTNO AS FISNO, ROOTRECEIPTITEMNO AS FISSIRANO, CURRCODE AS DOVIZ, 0.00 AS MIKTAR, TOTAL AS BORC, 0.00 AS ALACAK, 
                      CURRTOTAL AS DOVIZBORC, 0.00 AS DOVIZALACAK
FROM         VE_CS
WHERE     CSTYPE IN (502, 510) AND LASTPOSITION IN (1504, 1500, 1503, 3300, 3303, 3304)
UNION ALL
SELECT     COMPANYID AS SIRKETID, 5 AS TIP, VE_CS.LASTPOSITIONNAME AS TIPADI, BANKID AS KARTID, '' AS KARTNO, BANKNAME AS KARTADI, TRANSDATE AS TARIH, 
                      ROOT AS KAYNAK, ROOTID AS FISID, ROOTRECEIPTNO AS FISNO, ROOTRECEIPTITEMNO AS FISSIRANO, CURRCODE AS DOVIZ, 0.00 AS MIKTAR, 0.00 AS BORC, 
                      TOTAL AS ALACAK, 0.00 AS DOVIZBORC, CURRTOTAL AS DOVIZALACAK
FROM         VE_CS
WHERE     CSTYPE IN (506, 514) AND LASTPOSITION = 3100
UNION ALL
SELECT     VE_STOCKTRANS.COMPANYID, 6 AS TIP, VE_STOCK.STOCKTYPENAME AS TIPADI, VE_STOCK.STOCKID AS KARTID, VE_STOCK.STOCKNO AS KARTNO, 
                      VE_STOCK.STOCKNAME AS KARTADI, VE_STOCKTRANS.TRANSDATE AS TARIH, VE_STOCKTRANS.ROOT AS KAYNAK, VE_STOCKTRANS.ROOTID AS FISID, 
                      VE_STOCKTRANS.ROOTRECEIPTNO AS FISNO, VE_STOCKTRANS.ROOTRECEIPTITEMNO AS FISSIRANO, '' AS DOVIZ, 
                      (VE_STOCKTRANS.QENTRY - VE_STOCKTRANS.QEXIT) AS MIKTAR, 0.00 AS BORC, 0.00 AS ALACAK, 0.00 AS DOVIZBORC, 0.00 AS DOVIZALACAK
FROM         VE_STOCKTRANS, VE_STOCK
WHERE     VE_STOCKTRANS.COMPANYID = VE_STOCK.COMPANYID AND VE_STOCKTRANS.STOCKID = VE_STOCK.STOCKID)