CREATE VIEW dbo.CARI_LISTE_BAKIYELI
AS
SELECT CC.CODE, CC.DEFINITION_, UPPER(CC.CITY) AS CITY, CC.SPECODE2, CC.DISCRATE, CASE WHEN CC.ACTIVE = 0 THEN 'KULLAMIMDA' ELSE 'KULLANIM DISI' END AS DURUM, ISNULL(CB.DEBIT, 0) AS DEBIT, ISNULL(CB.CREDIT, 0) AS CREDIT, ABS(ISNULL(CB.BAKIYE, 0)) AS BAKIYE, 
CASE WHEN CB.BAKIYE<0 THEN 'A' WHEN CB.BAKIYE>0 THEN 'B' ELSE '' END AS BDURUM, CC.LOGICALREF FROM LG_011_CLCARD AS CC LEFT OUTER JOIN
dbo.CARI_BAKIYELER AS CB ON CB.CARDREF=CC.LOGICALREF WHERE CC.DEFINITION_<>''