IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME='PROC_憑證過賬' AND TYPE='P')
DROP PROC PROC_憑證過賬
GO
create  PROC PROC_憑證過賬
@客戶編碼 varchar(10)
as
INSERT INTO  應(yīng)收賬款明細(xì)賬 ( 客戶編碼,借方金額,憑證號,發(fā)票號碼,發(fā)票日期)
SELECT 客戶編碼,發(fā)票金額,憑證號,發(fā)票號碼,發(fā)票日期
FROM  銷售記賬憑證  WHERE 客戶編碼=@客戶編碼
--   EXEC PROC_憑證過賬 C01
-- SELECT *FROM 應(yīng)收賬款明細(xì)賬