[易飞]订单产销明细表

客户订单产销明细表

-- =============================================      

-- Author: <Tony ZHOU>      

-- Create date: <2019-04-20>      

-- Description: <订单产销明细>      

-- =============================================

SELECT (LTRIM(RTRIM(COPTC.TC004))) as 客户编号,
       COPTC.TC003 as 订单日期,
       COPTC.TC005 as 部门,
       COPTD.TD001+'-'+LTRIM(RTRIM(COPTD.TD002))+'-'+COPTD.TD003 as 订单号,
       COPTD.TD004 as 品号,
       COPTD.TD005 as 品名,
       COPTD.TD006 as 规格,
       (LTRIM(RTRIM(COPTD.TD007))) as 订单仓库,
       COPTD.TD008 as 订单数量,
       COPTD.TD009