【SQL开源代码栏目提醒】:以下是网学会员为您推荐的SQL开源代码-VoucPump_SalesReturn.sql,希望本篇文章对您学习有所帮助。
CREATE PROCEDURE VoucPump_SalesReturn
(
@SourceID Char(10),
@VoucDate Char(8)
)
AS
DECLARE @SubTotal int, @ValueAddTax int, @Amount int
DECLARE @VoucID Char(10)
SELECT @SubTotal = SubTotal, @ValueAddTax = ValueAddTax, @Amount = Amount
FROM DeliveryMaster
WHERE DeliveryID = @SourceID
INSERT INTO VoucMaster
(VoucDate, SourceID)
VALUES (@VoucDate, @SourceID)
SELECT @VoucID = VoucID
FROM VoucMaster
WHERE SourceID = @SourceID
INSERT INTO VoucDetail
(VoucID, AccItemID, DRAmount, CRAmount, Description)
VALUES
(@VoucID, '4104.0000', @SubTotal, 0, @SourceID)
INSERT INTO VoucDetail
(VoucID, AccItemID, DRAmount, CRAmount, Description)
VALUES
(@VoucID, '2262.0000', @ValueAddTax, 0, @SourceID)
INSERT INTO VoucDetail
(VoucID, AccItemID, DRAmount, CRAmount, Description)
VALUES
(@VoucID, '1144.0000', 0, @Amount, @SourceID)