IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME='PROC_記賬憑證過賬' AND TYPE='P')
DROP PROC PROC_記賬憑證過賬
GO
CREATE  PROC PROC_記賬憑證過賬
@供應商編碼 VARCHAR(10)
AS
INSERT INTO  應付賬款明細賬 ( 供應商編碼,貸方金額,憑證號,發票號碼,發票日期)
SELECT 供應商編碼,發票金額+增值稅額,憑證號,發票號碼,發票日期
FROM  記賬憑證
WHERE 供應商編碼=@供應商編碼