SELECT A.*,A.rowid FROM OUTSTOCKINDICATIONTBL A WHERE 1=1 AND A.OUTSTOCKINDICATIONID='GA5GA1702150512868709202' ; --出库指示明细表

SELECT A.*,A.rowid FROM OUTSTOCKINDICATIONDTTBL A WHERE 1=1 AND A.OUTSTOCKINDICATIONID='GA5GA1702150512868709213' AND GOODSID='QD12158' ; --出库指示明细表


SELECT A.*,A.rowid FROM STOCKGOODSTBL A WHERE  1=1
and A.GOODSID in ('QD19826') 
and OWNERID='SFWL' and a.qualityflg =1  AND (A.BIGUNITNUM>0 OR A.STANDUNITNUM >0 ) 
--AND 
AND (MID3 <> '-' OR A.BILLID <>'-' ) 
 AND (A.GOODSAREAID <>'BUFFERAREA' OR A.GOODSAREAID <>'TEMPRAREA' ) 
order by goodsbatch  ; --在线库存

SELECT  TOTALNUM,GOODSID,GOODSBATCH,QUALITYFLG,MID3,A.rowid FROM STOCKGOODSTBL_COMPANY A WHERE  1=1
--AND MID3 <> '-'
and OWNERID='SFWL' and a.companyid='GA' and a.qualityflg =1 AND A.TOTALNUM >0 
order by a.goodsid, a.goodsbatch,a.qualityflg ; --在线库存
文档更新时间: 2024-03-25 13:34   作者:周骏