跳至主要內容

警告:检验单-来料检验NG的提醒

五六零网校小于 1 分钟

  • 示例代码
SELECT T0.[U_TaxDate], T0.[U_DocNum] AS '采购订单号', T0.[U_BaseEntry], T0.[DocEntry] AS '检验单号', T0.[U_CardCode]
	, T0.[U_CardName], T0.[U_ItemCode], T0.[U_ItemName], T0.[U_Spec], T0.[U_BatchNum]
	, T0.[U_Qty], T0.[U_Qty1], T1.[U_Qty], T1.[U_Qty1], T1.[U_Status]
FROM [dbo].[@OQAD] T0
	INNER JOIN [dbo].[@QAD1] T1 ON T1.docentry = t0.docentry
WHERE T1.[U_Status] = 'NG'
	AND T0.[U_DocType] = 'A'
	AND T0.[U_TaxDate] = CONVERT(varchar(100), GETDATE(), 102)