生产收货明细表

五六零网校小于 1 分钟

代码示例

SELECT T1.[BaseEntry] AS '生产单号', T0.[DocNum] AS '收货单号', T1.[ItemCode], T1.[Dscription]
	, T1.[Quantity], T1.[WhsCode], T0.[DocDate] AS '生产收货日期'
FROM OIGN T0
	INNER JOIN IGN1 T1 ON T0.[DocEntry] = T1.[DocEntry]
	INNER JOIN OWOR T2 ON T2.docentry = t1.baseentry
WHERE T1.[BaseType] = '202'
	AND T0.[DocDate] >= [%1]
	AND T0.[DocDate] <= [%2]
ORDER BY T1.[BaseEntry] DESC, T1.[ItemCode]