[易飞]订单产销明细表

原创

于 2019-04-20 11:51:56 发布 · 726 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#易飞 #sql

本文详细介绍了易飞系统中的客户订单产销明细表，包括数据结构、关键字段解析以及如何通过SQL查询进行数据分析。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

客户订单产销明细表


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

-- 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 as 已交数量,
       COPTD.TD024 as 赠品数量,
       COPTD.TD025 as 赠品已交量,
       (LTRIM(RTRIM(COPTD.TD010))) as 单位,
       COPTD.TD016 as 结束码,
       CONVERT(varchar(255),(SELECT STUFF ((SELECT LTRIM(RTRIM(';'+'工单号['+MOCTA.TA001+'-'+LTRIM(RTRIM(MOCTA.TA002))+']状态码['+MOCTA.TA011+']预生产['+CONVERT(VARCHAR,CAST(MOCTA.TA015 AS NUMERIC(16,2)))+']已生产['+CONVERT(VARCHAR,CAST(MOCTA.TA017 AS NUMERIC(16,2)))+