【SQL开源代码栏目提醒】:文章导读:在新的一年中,各位网友都进入紧张的学习或是工作阶段。网学会员整理了SQL开源代码-VoucPump_Sales.sql的相关内容供大家参考,祝大家在新的一年里工作和学习顺利!
CREATE PROCEDURE VoucPump_Sales
(
@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, '1144.0000', @Amount, 0, @SourceID)
INSERT INTO VoucDetail
(VoucID, AccItemID, DRAmount, CRAmount, Description)
VALUES
(@VoucID, '4102.0000', 0, @SubTotal, @SourceID)
INSERT INTO VoucDetail
(VoucID, AccItemID, DRAmount, CRAmount, Description)
VALUES
(@VoucID, '2262.0000', 0, @ValueAddTax, @SourceID)