警告:检验单-来料检验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)