- Katılım
- 25 May 2018
- Mesajlar
- 1,610
- 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 Kasa Gider Raporu oluşturmak için bu sorguyu kullanabilirsiniz.
[HIDEREPLYTHANKS]
[/HIDEREPLYTHANKS]
[HIDEREPLYTHANKS]
SQL:
ALTER VIEW [dbo].[SNM_GIDER_LISTESI_054] AS
SELECT * FROM(SELECT CASE STL.LINETYPE WHEN 0 THEN (SELECT CODE FROM LG_054_ITEMS WHERE LOGICALREF=STL.STOCKREF)
WHEN 4 THEN (SELECT CODE FROM LG_054_SRVCARD WHERE LOGICALREF=STL.STOCKREF)ELSE'' END STOKKODU,
CASE STL.LINETYPE WHEN 0 THEN (SELECT NAME FROM LG_054_ITEMS WHERE LOGICALREF=STL.STOCKREF)
WHEN 4 THEN (SELECT DEFINITION_ FROM LG_054_SRVCARD WHERE LOGICALREF=STL.STOCKREF)ELSE'' END STOKADI,
STL.DATE_ TARIH,MONTH(STL.DATE_)AY,YEAR(STL.DATE_)YIL,VATMATRAH,
(SELECT GENEXP1+' '+GENEXP2+' '+GENEXP3+' '+GENEXP4 FROM LG_054_01_INVOICE
WHERE LOGICALREF=STL.INVOICEREF)+' '+STL.LINEEXP ACIKLAMA
FROM LG_054_01_STLINE STL WHERE STL.INVOICEREF>0 AND STL.CANCELLED=0 )SNM
WHERE STOKKODU LIKE '7%'
Son düzenleme:
