- Katılım
- 25 May 2018
- Mesajlar
- 1,609
- 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 Rezerve Detayları raporu için bu sorguyu kullanabilirsiniz.
[HIDEREPLYTHANKS]
[/HIDEREPLYTHANKS]
[HIDEREPLYTHANKS]
SQL:
SELECT * FROM (SELECT (SELECT CODE FROM LG_500_ITEMS WHERE LOGICALREF=STL.STOCKREF)STOKKODU,
(SELECT NAME FROM LG_500_ITEMS WHERE LOGICALREF=STL.STOCKREF)STOKADI,
ISNULL(DBO.LG_500_01_GETSTTRANSCOEF(TRCODE,IOCODE,LINETYPE,0,LPRODSTAT,LPRODRSRVSTAT,0,SOURCELINK,BILLED,31)
* (CASE WHEN PLNAMOUNT + PLNUNRSRVAMOUNT + PORDCLSPLNUNRSRVAMNT >= AMOUNT THEN 0
ELSE AMOUNT - PLNUNRSRVAMOUNT - PORDCLSPLNUNRSRVAMNT - PLNAMOUNT END)
* (DBO.LG_500_01_GETUNITCOEF(UINFO1, UINFO2)),0) AS REZERVEADET,
(SELECT DATE_ FROM LG_500_PRODORD WHERE LOGICALREF=STL.PRODORDERREF)URETIMFISTARIHI,
(SELECT FICHENO FROM LG_500_PRODORD WHERE LOGICALREF=STL.PRODORDERREF)URETIMFISNO,
(SELECT NAME FROM L_CAPIWHOUSE WHERE FIRMNR=500 AND NR=STL.SOURCEINDEX) AMBAR
FROM LG_500_01_STLINE STL
WHERE STL.STOCKREF=(SELECT LOGICALREF FROM LG_500_ITEMS WHERE CODE='1000120LNWH')) AS SNM WHERE REZERVEADET>0
Son düzenleme: