已入库未开票明细

五六零网校小于 1 分钟

代码示例

SELECT T0.[CardName], T1.[BaseEntry] AS '采购订单号', T0.[DocNum] AS '采购收货单号', T0.[DocDate] AS '收货日期', T1.[ItemCode]
	, T1.[Dscription], T1.[Quantity], T1.[Price], T1.[LineTotal]
FROM OPDN T0
	INNER JOIN PDN1 T1 ON T0.[DocEntry] = T1.[DocEntry]
WHERE T0.[DocStatus] = 'O'
	AND T0.[CANCELED] = 'N'
	AND T0.[DocDate] >= [%0]
	AND T0.[DocDate] <= [%1]