MERHABALAR;
Kredi kartı cari hesap fişlerini döken bir rapor yaptım. fakat takıldığım yer her gün toplam raporu versin bana, mesela günlük kasa toplamları gibi. yardımcı olursanız sevinirim.
SELECT dbo.LG_101_01_CLFICHE.FICHENO AS [FİŞ NO], dbo.LG_101_01_CLFICHE.DATE_ AS TARİH,
CASE dbo.LG_101_01_CLFICHE.TRCODE WHEN 70 THEN 'Kredi Kartı Fişi' ELSE 'Ne Oldugu Belirsiz' END 'Fiş Türü',
dbo.LG_101_BNCARD.DEFINITION_ AS [BANKA ADI], dbo.LG_101_BANKACC.CODE AS [HESAP KODU],
dbo.LG_101_BANKACC.DEFINITION_ AS [HESAP ADI], dbo.LG_101_01_PAYTRANS.TOTAL AS TUTAR, dbo.LG_101_01_PAYTRANS.DATE_ AS VADE,
dbo.LG_101_01_CLFLINE.BRANCH AS İŞ_YERİ, dbo.LG_101_01_CLFLINE.DEPARTMENT AS BÖLÜM
FROM dbo.LG_101_01_CLFLINE INNER JOIN
dbo.LG_101_01_PAYTRANS ON dbo.LG_101_01_CLFLINE.LOGICALREF = dbo.LG_101_01_PAYTRANS.FICHEREF INNER JOIN
dbo.LG_101_01_CLFICHE ON dbo.LG_101_01_CLFLINE.SOURCEFREF = dbo.LG_101_01_CLFICHE.LOGICALREF INNER JOIN
dbo.LG_101_BANKACC ON dbo.LG_101_01_PAYTRANS.BANKACCREF = dbo.LG_101_BANKACC.LOGICALREF INNER JOIN
dbo.LG_101_BNCARD ON dbo.LG_101_BANKACC.BANKREF = dbo.LG_101_BNCARD.LOGICALREF INNER JOIN
dbo.LG_101_01_BNFLINE ON dbo.LG_101_01_CLFLINE.SOURCEFREF = dbo.LG_101_01_BNFLINE.LOGICALREF LEFT OUTER JOIN
dbo.LG_101_01_CSTRANS ON dbo.LG_101_01_CLFLINE.SOURCEFREF = dbo.LG_101_01_CSTRANS.LOGICALREF
WHERE dbo.LG_101_01_CLFICHE.TRCODE = 70 AND dbo.LG_101_01_CLFLINE.BRANCH = 0 AND dbo.LG_101_01_CLFLINE.DEPARTMENT = 1