CREATE PROCEDURE [dbo].[MssWebUpdateOrderAdditionalCharge]
    @id int,
    @chargeAmount Money,
    @chargeTypeId int,
    @orderId int,
    @jobId int,
    @billToId int,
    @poNo varchar(20),
    @authorizedBy varchar(50),
    @authorizedViaId int,
    @billTransportation varchar(1)
AS
    UPDATE AddlCharges
    SET
           ChargeAmount = @chargeAmount,
           ChargeTypeID = @chargeTypeID,
           OrdPriKey = @orderId,
           JobsID = @jobId,
           BillToID = @billToId,
           PoNo = @poNo,
           AuthorizedBy = @authorizedBy,
           AuthViaID = @authorizedViaId,
           BillTrans = @billTransportation
    WHERE  AddlChargesID = @id
           AND OrdPriKey=@orderId
GO
GRANT EXECUTE ON  [dbo].[MssWebUpdateOrderAdditionalCharge] TO [MssExec]
GO