Logo Kredi Kartı Fiş Listesi

Logo Kredi Kartı fiş listesi
Logoda Cari hesap fiş listesini aldığımızda kredi kartının detayını vermiyor
aşağıdaki sql size kredi fişinin satırlarınıda listeler

SELECT DISTINCT 

                         CTRNS.DATE_, CLCARD.CODE AS CLCARD_CODE, CLCARD.DEFINITION_ AS CLCARD_DEFINITION_, CTRNS.AMOUNT, CTRNS.LINEEXP, BANKACC.CODE AS BANKACC_CODE, 

                         BANKACC.DEFINITION_ AS BANKACC_DEFINITION_, CLFICHE.FICHENO

FROM            LG_999_01_CLFLINE AS CTRNS LEFT OUTER JOIN

                             (SELECT        LOGICALREF, FICHENO

                               FROM            LG_999_01_CLFICHE) AS CLFICHE ON CTRNS.SOURCEFREF = CLFICHE.LOGICALREF LEFT OUTER JOIN

                             (SELECT        LOGICALREF, CODE, DEFINITION_

                               FROM            LG_999_BANKACC) AS BANKACC ON CTRNS.BANKACCREF = BANKACC.LOGICALREF LEFT OUTER JOIN

                             (SELECT        LOGICALREF, CODE, DEFINITION_

                               FROM            LG_999_CLCARD) AS CLCARD ON CTRNS.CLIENTREF = CLCARD.LOGICALREF

WHERE        (CTRNS.TRCODE = 70) AND (CTRNS.MODULENR = 5) AND (CTRNS.CANCELLED = 0)