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 
                 LGMAIN.LOGICALREF, LGMAIN.TRCODE, LGMAIN.FICHENO, LGMAIN.DOCODE, LGMAIN.DATE_, CLNTC.CODE, CLNTC.DEFINITION_,  CTRNS.AMOUNT, BNACC.CODE AS BANKCODE, BNACC.DEFINITION_ AS BANKDEFINITION_
FROM     LG_001_01_CLFICHE AS LGMAIN LEFT OUTER JOIN
                  LG_001_01_CLFLINE AS CTRNS ON LGMAIN.LOGICALREF = CTRNS.SOURCEFREF AND CTRNS.MODULENR = 5 LEFT OUTER JOIN
                  LG_001_CLCARD AS CLNTC ON CTRNS.CLIENTREF = CLNTC.LOGICALREF LEFT OUTER JOIN
                  LG_001_BANKACC AS BNACC ON LGMAIN.BANKACCREF = BNACC.LOGICALREF
WHERE  (LGMAIN.TRCODE = 70) AND LGMAIN.CANCELLED = 0
ORDER BY LGMAIN.LOGICALREF,LGMAIN.TRCODE, LGMAIN.FICHENO