Logo Malzeme Hareketleri SQL Sorgu
SELECT CONVERT(DATETIME, STLINE.DATE_, 104) AS TARİH, CASE STLINE.TRCODE WHEN 1 THEN 'Mal Alım İrsaliyesi' WHEN 2 THEN 'Per.Sat.İade İrs' WHEN 3 THEN 'Top. Sat. İade İrs' WHEN 6 THEN 'Alım İade İrs' WHEN 7 THEN 'Per. Sat. İade İrs' WHEN 8 THEN 'Top. Satış. İrs' WHEN 11 THEN 'Fire Fişi' WHEN 12 THEN 'Sarf Fişi' WHEN 13 THEN 'Üretim Fişi' WHEN 14 THEN 'Devir Fişi' WHEN 50 THEN 'Sayım Fazlası Fişi' WHEN 51 THEN 'Sayım Eksiği Fişi ' END AS [FİŞ TÜRÜ], CASE WHEN STLINE.IOCODE IN (1, 2) THEN 'Giriş' ELSE 'Çıkış' END AS Yön, CASE WHEN STF.IOCODE IN (1, 2) THEN STLINE.AMOUNT END AS [GİRİŞ MİKTAR], CASE WHEN STF.IOCODE IN (3, 4) THEN STLINE.AMOUNT END AS [ÇIKIŞ MİKTAR], IT.CODE AS [MALZEME KODU], IT.NAME AS [MALZEME AÇIKLAMASI],BRM.CODE AS BİRİM, STLINE.AMOUNT AS ADET, STLINE.PRICE AS FİYAT, STLINE.TOTAL AS TOPLAM,STF.FICHENO AS [FİŞ. NO],INV.FICHENO [FATURA NO], INV.DOCODE [BELGE NO],INV.SPECODE [ÖZEL KODU], INV.CYPHCODE[CYPHCODE], CLC.DEFINITION_ AS AÇIKLAMA
FROM LG_001_05_STLINE AS STLINE LEFT OUTER JOIN LG_001_CLCARD AS CLC WITH (NOLOCK) ON CLC.LOGICALREF = STLINE.CLIENTREF LEFT OUTER JOIN LG_001_ITEMS AS IT ON STLINE.STOCKREF = IT.LOGICALREF LEFT OUTER JOIN LG_001_PRCLIST AS PRC ON STLINE.STOCKREF = PRC.CARDREF AND PRC.PTYPE = 2 LEFT OUTER JOIN LG_001_UNITSETL AS BRM ON STLINE.UOMREF = BRM.LOGICALREF LEFT OUTER JOIN LG_001_05_STFICHE AS STF ON STF.LOGICALREF=STLINE.STFICHEREF LEFT OUTER JOIN LG_001_05_INVOICE INV ON INV.LOGICALREF=STLINE.INVOICEREF LEFT OUTER JOIN L_CAPIWHOUSE AS AMBAR ON STLINE.SOURCEINDEX = AMBAR.NR AND AMBAR.FIRMNR = 1 AND STLINE.IOCODE IN (1, 2) LEFT OUTER JOIN L_CAPIWHOUSE AS AMBAR2 ON STLINE.SOURCEINDEX = AMBAR2.NR AND AMBAR2.FIRMNR = 1 AND STLINE.IOCODE IN (3, 4) WHERE (STLINE.CANCELLED = 0) ORDER BY STLINE.DATE_