技术区 › 用友E-cell › 金蝶库龄分析处理逻辑很简洁

ksuser 发表于 2023-3-29 15:28:51

金蝶库龄分析处理逻辑很简洁

SELECTT0.ItemCode, T0.BatchNum, T0.ItemName, T0.Quantity, T0.CreateDate ,'0-30'=case whenT0.CreateDate >= getdate()-30 then T0.Quantity else 0 end,'31-60'=casewhen T0.CreateDate >= getdate()-60 and T0.CreateDate < getdate() -30 thenT0.Quantity else 0 end,'61-90'=casewhen T0.CreateDate >= getdate()-90 and T0.CreateDate < getdate() -60 thenT0.Quantity else 0 end,'91-180'=casewhen T0.CreateDate >= getdate()-180 and T0.CreateDate < getdate()-90 thenT0.Quantity else 0 end,'181-360'=casewhen T0.CreateDate >= getdate()-360 and T0.CreateDate < getdate()-180then T0.Quantity else 0 end,'360++'=casewhen T0.CreateDate < getdate()-360 then T0.Quantity else 0 end,T0.CardCode,T0.CardName
FROM OIBT T0 WHERE WhsCode='BJ111' and T0.Quantity <>0

sfl2012 发表于 2023-3-29 20:52:28

没看出有多大增量价值。

查看完整版本: 金蝶库龄分析处理逻辑很简洁