【SQL开源代码栏目提醒】:本文主要为网学会员提供VoucPump_PurchaseReturn.sql,希望对需要VoucPump_PurchaseReturn.sql网友有所帮助,学习一下!
CREATE PROCEDURE VoucPump_PurchaseReturn
(
@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 PurchaseMaster
WHERE PurchaseID = @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, '2141.0000', @Amount, 0, @SourceID)
INSERT INTO VoucDetail
(VoucID, AccItemID, DRAmount, CRAmount, Description)
VALUES
(@VoucID, '5204.0000', 0, @SubTotal, @SourceID)
INSERT INTO VoucDetail
(VoucID, AccItemID, DRAmount, CRAmount, Description)
VALUES
(@VoucID, '1291.0000', 0, @ValueAddTax, @SourceID)