CREATE PROCEDURE [dbo].[MssWebCreateOrderAdditionalCharge]
    @chargeAmount MONEY,
    @chargeTypeId INT,
    @orderId INT,
    @jobId INT,
    @billToId INT,
    @poNo VARCHAR(20),
    @authorizedBy VARCHAR(50),
    @authorizedViaId INT,
    @billTransportation varchar(1)
AS
BEGIN
    DECLARE @id int ;
    INSERT INTO AddlCharges
    (
        ChargeAmount,
        ChargeTypeID,
        OrdPriKey,
        JobsID,
        BillToID,
        PoNo,
        AuthorizedBy,
        AuthViaID,
        BillTrans
    )
    select
        ChargeAmount=@chargeAmount,
        ChargeTypeID=@chargeTypeId,
        OrdPriKey=@orderId,
        JobsID=@jobId,
        BillToID=@billToId,
        PoNo=@poNo,
        AuthorizedBy=@authorizedBy,
        AuthViaID=@authorizedViaId,
        BillTrans=@billTransportation
    Set @id=SCOPE_IDENTITY()
    Select @id
END
GO
GRANT EXECUTE ON  [dbo].[MssWebCreateOrderAdditionalCharge] TO [MssExec]
GO