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)