- Katılım
- 25 May 2018
- Mesajlar
- 1,608
- En iyi yanıt
- 14
- Puanları
- 113
- Konum
- İstanbul
- Web sitesi
- excelarsivi.com
- Ad Soyad
- Murat OSMA
- Office Vers.
- Microsoft 365 TR+EN
Logo'da Proje Kodlu Cari Hareketler tablosu için bu sorguyu kullanabilirsiniz.
[HIDEREPLYTHANKS]
[/HIDEREPLYTHANKS]
[HIDEREPLYTHANKS]
SQL:
SELECT CASE C.TRCODE WHEN 20 THEN 'GELEN HAVALE' WHEN 5 THEN 'VIRMAN' WHEN 38 THEN 'SATIS FATURASI'
WHEN 31 THEN 'ALIS FATURASI' WHEN 34 THEN 'ALINAN HIZMET FATURASI' ELSE 'DIGER' END AS ISLEMTURU,
(SELECT CODE FROM LG_042_CLCARD WHERE LOGICALREF=C.CLIENTREF)CARIKODU,
(SELECT DEFINITION_ FROM LG_042_CLCARD WHERE LOGICALREF=C.CLIENTREF)CARIADI,
CASE C.MODULENR
WHEN 4 THEN
(SELECT PROJECTREF FROM LG_042_01_INVOICE WHERE LOGICALREF=C.SOURCEFREF)
WHEN 7 THEN
(SELECT PROJECTREF FROM LG_042_01_BNFLINE WHERE LOGICALREF=C.SOURCEFREF)
WHEN 5 THEN
(SELECT PROJECTREF FROM LG_042_01_CLFICHE WHERE LOGICALREF=C.SOURCEFREF)
END PROJEKODU,C.SIGN B_A,C.LINEEXP SATIRACIKLAMA,C.AMOUNT TUTAR,
CONVERT(DATE,C.DATE_)TARIH,C.MONTH_ AY,C.YEAR_ YIL,
(SELECT VADEGUN FROM LG_XT020 WHERE CARLOGREF=C.CLIENTREF)VADEGUN,
(SELECT SUM(YUZDE) FROM LG_XT030 WHERE CARLOGREF=C.CLIENTREF)KES_YUZDE_TOPLAM,
CASE WHEN C.MODULENR=4 AND C.SIGN=1 THEN -(C.AMOUNT*3/100)
WHEN C.MODULENR=4 AND C.SIGN=0 THEN +(C.AMOUNT*3/100) ELSE 0 END AS STOPAJ
FROM LG_042_01_CLFLINE C WHERE C.CLIENTREF=2400 AND C.CANCELLED=0
Son düzenleme:
