跳至主要內容

批次库存报表

五六零网校小于 1 分钟

代码示例

SELECT T0.[ItemCode], T0.itemname, t1.InvntryUom AS 单位, T0.[WhsCode], T0.[BatchNum] AS 批次
	, T0.[Quantity]
FROM OIBT T0
	LEFT JOIN OITM T1 ON T1.ITEMCODE = T0.ITEMCODE
WHERE T0.[Quantity] > 0
ORDER BY T0.[WhsCode]