------------------------------------------------
--报表名：生产收货明细查询
--逻辑：查询生产收货明细
--条件：日期范围必选
--作者：五六零网校
------------------------------------------------
SELECT T0.[DocNum] AS '收货单号', T0.[DocDate], T1.[BaseRef] AS '生产订单号', T1.[ItemCode], T1.[Dscription]
, T1.[Quantity], T1.[WhsCode], T2.[WhsName], T1.[Price] AS '物料成本', T1.[LineTotal]
FROM OIGN T0
INNER JOIN IGN1 T1 ON T0.[DocEntry] = T1.[DocEntry]
INNER JOIN OWHS T2 ON T1.[WhsCode] = T2.[WhsCode]
WHERE T1.[BaseType] = '202'
AND T0.[DocDate] >= [%0]
AND T0.[DocDate] <= [%1]
ORDER BY T0.[DocNum] DESC声明：欢迎来到五六零学院。
