易飞ERP安全库存预警提示:以HTML表格发送至邮箱

if exists(select *from sysobjects where name='jf_SafetyStock')
drop procedure jf_SafetyStock
go
create procedure jf_SafetyStock
as
begin
if exists(
SELECT MB001,MB002,MB003,CAST((ISNULL(PURTB.TB009,0)+ISNULL(PURTD.TD008,0)+ISNULL(PURTD2.TD008,0)-ISNULL(MOCTA.TA015,0)-ISNULL(MOCTB.TB004,0)-ISNULL(COPTD.TD008,0)+ISNULL(INVMC.MC007,0)) AS INT) AS QTY1,CAST((INVMC2.MC004)AS INT) AS QTY2,((ISNULL(PURTB.TB009,0)+ISNULL(PURTD.TD008,0)+ISNULL(PURTD2.TD008,0)-ISNULL(MOCTA.TA015,0)-ISNULL(MOCTB.TB004,0)-ISNULL(COPTD.TD008,0)+ISNULL(INVMC.MC007,0))/INVMC2.MC004) AS RATE FROM INVMB
 LEFT JOIN (SELECT TB004,SUM(TB009) AS TB009 FROM PURTB WHERE TB025='Y' AND TB039='N' GROUP BY TB004) AS PURTB ON INVMB.MB001=PURTB.TB004
 LEFT JOIN (SELECT TD004,SUM(TD008) AS TD008 FROM PURTD WHERE TD018='N' GROUP BY TD004) AS PURTD ON INVMB.MB001=PURTD.TD004
 
评论 2
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值