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 作者:周骏