SELECT T0.[DocNum], T0.[DocDate], T0.[CardCode], T0.[CardName], T1.[ItemCode]
	, T1.[Dscription], T4.[SlpName] AS 业务员, T1.[UseBaseUn], T1.[Quantity], T1.[Price]
	, T1.[VatPrcnt], T1.[DiscPrcnt], T1.[LineTotal], TS.[Quantity] AS 交货数量, T0.[DocStatus]
	, T0.[TotalExpns], T1.[WhsCode], T1.[OpenQty], T2.[OnHand], T0.[Comments]
FROM ORDR T0
	INNER JOIN RDR1 T1 ON T0.[DocEntry] = T1.[DocEntry]
	INNER JOIN OITM T2 ON T1.[ItemCode] = T2.[ItemCode]
	INNER JOIN OITB T3 ON T2.[ItmsGrpCod] = T3.[ItmsGrpCod]
	INNER JOIN OSLP T4 ON T0.[SlpCode] = T4.[SlpCode]
	LEFT JOIN (
		SELECT T1.[Quantity], T1.[BaseEntry], T1.[BaseLine]
		FROM ODLN T0
			INNER JOIN DLN1 T1 ON T0.[DocEntry] = T1.[DocEntry]
	) TS
	ON TS.[BaseEntry] = t0.docentry
		AND Ts.[BaseLine] = T1.[LineNum]
WHERE (T1.[ItemCode] LIKE '%%[%0]%%'
		OR '[%0]' = '')
	AND (T0.[taxDate] LIKE '%%[%4]%%'
		OR '[%4]' = '')
	AND (T0.[DocStatus] LIKE '%%[%5]%%'
		OR '[%5]' = '')
	AND (T3.[ItmsGrpNam] LIKE '%%[%6]%%'
		OR '[%6]' = '')
	AND (T4.[slpname] LIKE '%%[%7]%%'
		OR '[%7]' = '')
	AND (T0.[CARDCODE] LIKE '%%[%8]%%'
		OR '[%8]' = '')
	AND (T0.[Cardname] LIKE '%%[%9]%%'
		OR '[%9]' = '')
	AND (T0.[DOCNUM] LIKE '%%[%10]%%'
		OR [%10] = '')
	AND T0.[CANCELED] = 'N'
ORDER BY T0.[DocNum] DESC, T1.[LineNum]

发表回复

后才能评论