if exists (select name from sysobjects where name='采購入庫_物料_PROC' and type='P')
drop PROC 采購入庫_物料_PROC
go
create PROC 采購入庫_物料_PROC
@VEND_to varchar (10),
@VEND_fr varchar (10)
as 
CREATE TABLE [#采購入庫單明細表] 
(
	
	[采購單號] [int],
	[行] [int],
	[入庫日期] [datetime],
	[到期日期] [datetime],
	[供應(yīng)商編碼] [varchar] (10),
	[物料編碼] [varchar] (30),
	[貨幣編碼] [varchar] (10),
	[計量單位] [varchar] (10),
	[增值稅額] [numeric](18, 0) DEFAULT (0),
	[訂購數(shù)量] [numeric](18, 0) DEFAULT (0),
	[入庫數(shù)量] [numeric](18, 6) DEFAULT (0),
	[拒收數(shù)量] [numeric](18, 6) DEFAULT (0),
	[倉庫] [varchar] (10),
	[貨位] [varchar] (10) ,
	[批號] [varchar] (15) DEFAULT (0),
	[拒收原因] [varchar] (10) DEFAULT (0),
	[單位材料成本] [numeric](18, 0) DEFAULT (0),
	[材料成本] [numeric](18, 0) DEFAULT (0)) 

INSERT INTO #采購入庫單明細表(采購單號,行,入庫日期,到期日期,供應(yīng)商編碼,物料編碼,貨幣編碼,
計量單位,增值稅額,訂購數(shù)量,入庫數(shù)量,拒收數(shù)量,
倉庫,貨位,批號,拒收原因,單位材料成本,材料成本) 
SELECT 采購單號,行,入庫日期,到期日期,供應(yīng)商編碼,物料編碼,貨幣編碼,
計量單位,增值稅額,訂購數(shù)量,入庫數(shù)量,拒收數(shù)量,
倉庫,貨位,批號,拒收原因,單位材料成本,材料成本 from 采購入庫單明細表
WHERE 供應(yīng)商編碼>=@VEND_to and 供應(yīng)商編碼<=@VEND_fr
	
select *from #采購入庫單明細表

--- EXEC 采購入庫_供應(yīng)商_PROC 'V01','V01'