库存转入查询

五六零网校小于 1 分钟

代码示例

SELECT T0.[DocNum], T0.[DocDate], T1.[ItemCode], T1.[Dscription], T1.[U_MaterialName]
	, T1.[Quantity], T1.[FromWhsCod] AS 从仓库, T1.[WhsCode] AS 到仓库
FROM OWTR T0
	INNER JOIN WTR1 T1 ON T0.[DocEntry] = T1.[DocEntry]
WHERE T1.[WhsCode] = 'C03'
	AND T0.[DocDate] >= [%1]
	AND T0.[DocDate] <= [%2]