收发存汇总表
--收发存汇总表
select
ia.iYear as 年,ia.iMonth as 月,ia.cWhCode as 仓库编码,war.cWhName as 仓库,ia.cInvCode as 存货编码,invc.cInvCName as 存货分类,
inv.cInvName as 存货名称,inv.cInvStd as 规格型号,ia.iNum as 结存数量,ia.iMoney as 结存金额
from
IA_Summary ia
left join Inventory inv on ia.cInvCode = inv.cInvCode
left join InventoryClass invc on left(inv.cInvCCode,2) = invc.cInvCCode
left join Warehouse war on ia.cWhCode = war.cWhCode
这是一个记录~~~
2
· Obsidian + DeepSeek：免费 AI 助力你的知识管理，让你的笔记飞起来！
· 分享4款.NET开源、免费、实用的商城系统
· 解决跨域问题的这6种方案，真香！
· 一套基于 Material Design 规范实现的 Blazor 和 Razor 通用组件库
· 5. Nginx 负载均衡配置案例(附有详细截图说明++)