CREATE procedure UF_Po_ScheduleSp
as
declare @CurrDate NVARCHAR(10)
set @CurrDate=convert(varchar(10),getdate(),120)
/*
* delete today
*/
delete
from Uf_Po_Schedule
where convert(varchar(10),schedule_date,120)=@CurrDate
-- and item='LW-01000080'
/*
* 拷贝计划明细表数据到Uf_Po_Schedule
*/
--SET FORCEPLAN OFF
insert Uf_Po_Schedule(
schedule_date
,item
,due_date
,ExceptMessage
,mrp_ref
,lead_time
,Shrink_fact --物料损耗因子
,Ori_Qty_On_Hand --预计在库量
,Ori_Qty_Req
,Ori_qty_recv
,Qty_On_Hand --现有在库量
,ref_num
,ref_linesuf
,ordtype)
select
getdate()
,p.Item