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