成品现存量报表

代码示例

SELECT T0.[ItemCode], T1.[ItemName], T1.[FrgnName], T0.[WhsCode], T0.[OnHand]
	, T0.[IsCommited] AS '待发货数量', T0.[OnOrder] AS '已采购数量'
FROM OITW T0
	INNER JOIN OITM T1 ON T0.[ItemCode] = T1.[ItemCode]
WHERE T0.[WhsCode] = [%0]
	AND T0.[OnHand] > 0