CREATE PROCEDURE dbo.MssWebCreateQuoteHeader
    @inOrdersFID int,
    @inCreatedBySysUserFID int,
    @inQuoteStatus int,
    @inOrderContactFID int,
    @inDescription varchar(64)
as
begin
    set nocount on;

    declare @newQuoteId int;

    insert into QuoteHeader
        (OrdersFID,
         CreatedDate,
         CreatedBySysuserFID,
         QuoteStatusFID,
         OrderContactFID,
         Description)
    select
        @inOrdersFID,
        getdate(),
        @inCreatedBySysUserFID,
        @inQuoteStatus,
        @inOrderContactFID,
        @inDescription

    set @newQuoteId = SCOPE_IDENTITY()
    
    select @newQuoteId
end
GO
GRANT EXECUTE ON  [dbo].[MssWebCreateQuoteHeader] TO [MssExec]
GO