U8常用表2

select * from VouchType where cVouchType IN('32','09')   --单据类型

select * from InvPosition where cinvcode='10500490' and cFree2='ZB240306071' and AutoID='50434'   ---货位

--update InvPosition set iQuantity=1 where cinvcode='10500490' and cFree2='ZB240306071' and AutoID='50434'

 

--select * from CurrentStock where cinvcode='12700007' and cfree2='ZB230509048' and AutoID='676' --现存量

--update CurrentStock set iQuantity=0 where cinvcode='12700007' and cfree2='ZB230509048' and AutoID='676'