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 客戶編碼=@客戶編碼
--   EXEC PROC_憑證過賬 C01
-- SELECT *FROM 應收賬款明細賬