IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME='應(yīng)付折算本位幣_PROC' AND TYPE='P')
DROP PROC 應(yīng)付折算本位幣_PROC
GO
create  PROC 應(yīng)付折算本位幣_PROC
AS
CREATE TABLE [#應(yīng)付明細(xì)本位幣]
 (
	[供應(yīng)商編碼] [varchar] (10)  ,
	[采購單] [int]  ,
	[貨幣] [varchar] (10)  ,
	[憑證號] [int] ,
	[發(fā)票號碼] [varchar] (20),
	[發(fā)票日期] [datetime] NULL,
	[借方金額] [numeric](18, 6)  DEFAULT (0),
    借方本位幣 AS 借方金額*匯率 ,
	[貸方金額] [numeric](18, 6)  DEFAULT (0),
     貸方本位幣 AS 貸方金額*匯率,
	[余額] [numeric](18, 6)  DEFAULT (0),
    余額本位幣 AS 余額*匯率,
匯率 NUMERIC(18,6)DEFAULT (0),
外幣編碼 VARCHAR(10),
年月 DATETIME)

INSERT INTO #應(yīng)付明細(xì)本位幣 (供應(yīng)商編碼,采購單,貨幣,憑證號,發(fā)票號碼,發(fā)票日期,借方金額,貸方金額,余額,匯率,外幣編碼,年月)
select a.供應(yīng)商編碼,a.采購單,a.貨幣,a.憑證號,a.發(fā)票號碼,a.發(fā)票日期,a.借方金額,a.貸方金額,a.余額,b.匯率,b.外幣編碼,b.年月
from 應(yīng)付賬款明細(xì)賬 a join 貨幣匯率 b on a.貨幣=b.外幣編碼 
where year(B.年月)= year(GETDATE())  AND MONTH(B.年月)=month (GETDATE())

SELECT* from #應(yīng)付明細(xì)本位幣
-- SELECT *FROM 貨幣匯率
-- SELECT *FROM 應(yīng)付賬款明細(xì)賬
-- EXEC  應(yīng)付折算本位幣_PROC