用友U8销售发货单序列号明细查询SQL语句

SELECT 'A'+b.cdlcode AS 发货退货单号 ,

b.ccuscode AS 客户编码 ,

b.ccusabbname AS 客户简称 ,

b.cmaker AS 制单人 ,

b.ddate AS 单据日期 ,

b.cstname AS 销售类型名称 ,

b.cverifier AS 审核人 ,

b.dverifydate AS 审核日期 ,

(CASE b.breturnflag

WHEN 0 THEN '发货单'

WHEN 1 THEN '退货单' end)

AS 退货标志 ,

b.csocode AS 销售订单号 ,

b.csbvcode AS 销售发票号 ,

b.cpersonname AS 业务员名称 ,

b.cdepname AS 部门名称 ,

b.cmemo AS 表头备注 ,

a.cwhcode AS 仓库编码 ,

a.cwhname AS 仓库名称 ,

b.cdefine1 AS 合同自编号 ,

a.citemcode AS 项目编码 ,

a.irowno AS 发货单行号,

a.cinvcode AS 存货编码 ,

a.cinvaddcode AS 存货代码 ,

a.cinvname AS 存货名称 ,

a.cinvstd AS 规格型号 ,

a.cinvm_unit AS 主计量单位 ,

a.cbatch AS 批号 ,

( CASE a.bserial

WHEN 0 THEN '非序列号管理'

WHEN 1 THEN '序列号管理'

END ) AS 是否有序列号管理 ,

a.iquantity AS 数量 ,

a.