Merhaba portföyde ve bankamda tahsilde olan çeklerin dökümünü almak istiyorum ama
banka tahsil çek tutarı çift geliyor teşekkür ederim
SELECT CLCARD.CODE, CLCARD.DEFINITION_,
CASE WHEN CSCARD.CURRSTAT = 1 THEN 'KASADA' WHEN CSCARD.CURRSTAT = 4 THEN 'BANKADA' END AS [BULUNDUĞU YER],
CASE WHEN CSCARD.CURRSTAT = 1 THEN 'PORTFÖYDE' WHEN CSCARD.CURRSTAT = 4 THEN 'TAHSİLE VERİLDİ' END AS [SON DURUMU],
ISNULL(CASE WHEN CSCARD.TRCURR = 0 THEN CSCARD.TRNET END, 0) AS [TL-TUTAR], ISNULL(CASE WHEN CSCARD.TRCURR = 1 THEN CSCARD.TRNET END, 0)
AS [DOLAR-TUTAR], ISNULL(CASE WHEN CSCARD.TRCURR = 17 THEN CSCARD.TRNET END, 0) AS [STERLİN-TUTAR],
ISNULL(CASE WHEN CSCARD.TRCURR = 20 THEN CSCARD.TRNET END, 0) AS [EURO-TUTAR], dbo.LG_117_BANKACC.CODE AS Expr1
FROM dbo.LG_117_01_CSTRANS AS CSTRANS INNER JOIN
dbo.LG_117_01_CSCARD AS CSCARD WITH (NOLOCK) ON CSTRANS.CSREF = CSCARD.LOGICALREF left JOIN
dbo.LG_117_CLCARD AS CLCARD WITH (NOLOCK) ON CSTRANS.CARDREF = CLCARD.LOGICALREF LEFT JOIN
dbo.LG_117_BANKACC WITH (NOLOCK) ON CSTRANS.CARDREF = dbo.LG_117_BANKACC.LOGICALREF
WHERE (CSCARD.DOC = 1) AND (CSCARD.CURRSTAT IN (1, 4))
banka tahsil çek tutarı çift geliyor teşekkür ederim
SELECT CLCARD.CODE, CLCARD.DEFINITION_,
CASE WHEN CSCARD.CURRSTAT = 1 THEN 'KASADA' WHEN CSCARD.CURRSTAT = 4 THEN 'BANKADA' END AS [BULUNDUĞU YER],
CASE WHEN CSCARD.CURRSTAT = 1 THEN 'PORTFÖYDE' WHEN CSCARD.CURRSTAT = 4 THEN 'TAHSİLE VERİLDİ' END AS [SON DURUMU],
ISNULL(CASE WHEN CSCARD.TRCURR = 0 THEN CSCARD.TRNET END, 0) AS [TL-TUTAR], ISNULL(CASE WHEN CSCARD.TRCURR = 1 THEN CSCARD.TRNET END, 0)
AS [DOLAR-TUTAR], ISNULL(CASE WHEN CSCARD.TRCURR = 17 THEN CSCARD.TRNET END, 0) AS [STERLİN-TUTAR],
ISNULL(CASE WHEN CSCARD.TRCURR = 20 THEN CSCARD.TRNET END, 0) AS [EURO-TUTAR], dbo.LG_117_BANKACC.CODE AS Expr1
FROM dbo.LG_117_01_CSTRANS AS CSTRANS INNER JOIN
dbo.LG_117_01_CSCARD AS CSCARD WITH (NOLOCK) ON CSTRANS.CSREF = CSCARD.LOGICALREF left JOIN
dbo.LG_117_CLCARD AS CLCARD WITH (NOLOCK) ON CSTRANS.CARDREF = CLCARD.LOGICALREF LEFT JOIN
dbo.LG_117_BANKACC WITH (NOLOCK) ON CSTRANS.CARDREF = dbo.LG_117_BANKACC.LOGICALREF
WHERE (CSCARD.DOC = 1) AND (CSCARD.CURRSTAT IN (1, 4))