[易飞]供应商准时交货分析

易飞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