1.超期(14天)未交货采购单
SELECT K.TD001+'-'+rtrim(K.TD002)+'-'+K.TD003 单据号, K.TD004 品号, K.TD005 品名, K.TD006 规格,convert(decimal(15,2),K.TD008) 采购数量, convert(decimal(15,2),K.TD015) 已交数量, ZE.dbo.Date10(K.TD012) 预交日期,ZE.dbo.Date10(T.TC003) 采购日期, DATEDIFF(DAY,TD012,GETDATE()) 超期天数, T.TC025 审核者, A.MA002 供应商简称
FROM ZE.dbo.PURTD K, ZE.dbo.PURTC T, ZE.dbo.PURMA A
WHERE T.TC004=A.MA001 AND K.TD001 = T.TC001 AND K.TD002 = T.TC002 AND ((K.TD016='N')
AND (K.TD012<CONVERT(CHAR(8),GETDATE(),112)) AND (T.TC014<>'V') AND (K.TD008<>0)
AND (SUBSTRING(K.CREATE_DATE,1,8)>='20070501') AND (DATEDIFF(DAY,TC003,GETDATE())>1))
AND DATEDIFF(DAY,TD012,GETDATE())>14