易飞ERP系统供应商准时交货分析表
-- =============================================
-- Author: <Tony ZHOU>
-- Create date: <2019-04-20>
-- Description: <供应商准时交货分析>
-- =============================================
SELECT PURTD.TD001 AS 采购单别,
PURTD.TD002 AS 采购单号,
PURTD.TD003 AS 采购序号,
PURTD.TD004 AS 品号,
PURTD.TD005 AS 品名,
PURTD.TD006 AS 规格,
PURTD.TD008 AS 采购数量,
PURTD.TD015 AS 已交数量,
(PURTD.TD008-PURTD.TD015) AS 未交货数量,
PURTD.TD018 AS 审核码,
(CASE WHEN PURTD.TD016='Y' THEN '已结束' WHEN