2015

Logo Finansal Hatırlatıcı

SELECT CL.CODE,CL.DEFINITION_,PY.CARDREF,PY.CLOSINGRATE,PY.DATE_,PY.PAYNO,PY.MODULENR,PY.TRCODE,PY.TOTAL, CASE when PY.TRCODE =1 and PY.MODULENR=10 then ‘Nakit Tahsilat’ when PY.TRCODE =2 and PY.MODULENR=10 then ‘Nakit Ödeme’ when PY.TRCODE =11 and PY.MODULENR=10 then ‘Cari Hesap Tahsilat’

Stok Kart Update

// Lot Update – Dağıtılabilir bölünebilir SELECT * FROM LG_001_UNITSETF SELECT DIVLOTSIZE,DISTLOTUNITS,COMBLOTUNITS,CODE FROM LG_001_ITEMS WHERE UNITSETREF=5 UPDATE LG_001_ITEMS SET DIVLOTSIZE=1,DISTLOTUNITS=1,COMBLOTUNITS=1 WHERE UNITSETREF=5 // Stok Kdv update SELECT VAT,SELLVAT,RETURNVAT FROM LG_001_ITEMS…