用友U8后台_SQL_出入库明细查询

两条SQL语句都可以查询
SELECT [单据类型] ,[单据号],
(CASE WHEN [仓库]=‘10’ then ‘原料仓’
when [仓库]=‘20’ then ‘半成品仓’
when [仓库]=‘30’ then ‘成品仓’
when [仓库]=‘40’ then ‘产线不良仓’
when [仓库]=‘50’ then ‘研发仓’
when [仓库]=‘60’ then ‘车间仓’
when [仓库]=‘70’ then ‘来料不良’
when [仓库]=‘80’ then ‘返修良品’
when [仓库]=‘81’ then ‘返修不良’
when [仓库]=‘90’ then ‘售后仓’
when [仓库]=‘91’ then ‘销售服务仓’ END) as [仓库] ,
(CASE WHEN [收发类别]=‘202’ THEN ‘普通销售出库’
WHEN [收发类别]=‘203’ THEN ‘委外发料’
WHEN [收发类别]=‘204’ THEN ‘调拨出库’
WHEN [收发类别]=‘205’ THEN ‘委外发料’
WHEN [收发类别]=‘206’ THEN ‘生产补料’
WHEN [收发类别]=‘207’ THEN ‘辅料领用’
WHEN [收发类别]=‘208’ THEN ‘研发领料’
WHEN [收发类别]=‘209’ THEN ‘委外补料’
WHEN [收发类别]=‘210’ THEN ‘部门领料’
WHEN [收发类别]=‘211’ THEN ‘借出领料’
WHEN [收发类别]=‘212’ THEN ‘客供料出库’
WHEN [收发类别]=‘213’ THEN ‘售后领料’
WHEN [收发类别]=‘29