SentezKNIT Kumaş Üretim Takip Sistemi

SentezKNIT Kumaş Üretim Takip Sistemi SQL Sorguları

• Termin Kontrol Listesi
  Select SIPFD.TERMIN As Termin, SIPFD.FISNO As [Fiş No],  ISNULL((Select CKART.ADI From CKART Where CKART.SIRKET = SIPFD.SIRKET And CKART.KOD = SIPFD.CKOD), '') As Müşteri
  ,SIPFD.MKOD As Stok, SIPFD.OZEL5 As Varyant, SIPFD.MIKTAR As Miktar,SIPFD.DOVIZ As Döviz
  ,SIPFD.DFIYAT As [Döviz Fiyat],SIPFD.TARIH As Tarih
  From SIPFD
  Where SIPFD.SIRKET = '01' And SIPFD.TIP = 2 And SIPFD.AK = 0 And
  FLOOR(Cast(SIPFD.TERMIN As Float)) <= floor(cast(GETDATE() AS float))
  Order By SIPFD.TERMIN, SIPFD.FISNO

• Günlük Sipariş Listesi
  Select FISNO AS [Fiş No],ISNULL((SELECT ADI FROM CKART WHERE CKART.SIRKET=SIPFD.SIRKET AND CKART.KOD=SIPFD.CKOD),'') AS [Müşteri]
  ,MKOD AS [Stok],OZEL5 AS [Varyant],TERMIN AS [Termin],MIKTAR AS [Miktar],DOVIZ AS [Döviz],DFIYAT AS [Döviz Fiyat]
  FROM SIPFD
  WHERE SIRKET='01' AND TIP=2 AND floor(cast(TARIH AS float))=floor(cast(GETDATE() AS float))
  ORDER BY FISNO

• Günlük Sevkiyat Listesi
  Select FISNO AS [Fiş No],ISNULL((SELECT ADI FROM CKART WHERE CKART.SIRKET=SFISD.SIRKET AND CKART.KOD=SFISD.CKOD),'') AS [Müşteri]
  ,MKOD AS [Stok],OZEL5 AS [Varyant],MIKTAR AS [Miktar]
  FROM SFISD
  WHERE SIRKET='01' AND (TIP=20 OR TIP=25) AND floor(cast(TARIH AS float))=floor(cast(GETDATE() AS float))
  ORDER BY TIP,FISNO

• Günlük Stok Hareketleri
  Select case when TIP=1 then 'Alım' when TIP=11 then 'Fason Giriş' when TIP=12 then 'Fason İade' when TIP=34 then 'Fason Çıkış' else 'Stok Fişi' end As [Hareket Tipi]
  ,FISNO AS [Fiş No],ISNULL((SELECT ADI FROM CKART WHERE CKART.SIRKET=SFISD.SIRKET AND CKART.KOD=SFISD.CKOD),'') AS [Müşteri]
  ,MKOD AS [Stok],OZEL5 AS [Varyant],MIKTAR AS [Miktar]
  FROM SFISD
  WHERE SIRKET='01' AND (TIP=1 OR TIP=11 or TIP=12 or TIP=34) AND floor(cast(TARIH AS float))=floor(cast(GETDATE() AS float))
  ORDER BY TIP,FISNO