销售交货查询

代码示例

SELECT T0.[DocDate], T1.[ItemCode], T1.[Dscription], T1.[Quantity]
FROM ODLN T0
	INNER JOIN DLN1 T1 ON T0.[DocEntry] = T1.[DocEntry]
WHERE T0.[CANCELED] = 'N'
	AND T0.[DocDate] >= [%0]
	AND T0.[DocDate] <= [%1]
ORDER BY T0.[DocNum] DESC