CREATE PROCEDURE [dbo].[MssWebInsertQuoteLineItem]
    @inOrderID int,
    @inLoggedInSysuserID int,
    @inQuoteHeaderFID int,
    @inRateTypeFID int,
    @inItemCodeFID int,
    @inDescription varchar( 128 ),
    @inRate money,
    @inQuantity decimal(10, 4),
    @inQuantity2 decimal(10, 4),
    @inCharge money,
    @inQuoteServiceProviderTypeFID int,
    @inVendorID varchar(15),
    @inVendorQuotedCharge money,
    @inVendorActualCharge money,
    @inSortOrder int,
    @inPONumber varchar(20),
    @inInvoiceNumber varchar(20),
    @inServiceDate datetime,
    @inNoteText varchar(1024),
    @inLaborRatingType varchar(50) = NULL,
    @inQuoteServiceProviderBillToFID int,
    @inRateSource varchar(50),
    @inRateSourceRecord int,
    @inExternalVendorID varchar(15),
    @inExternalVendorName varchar(40),
    @inAccountingVendorFid int

as
set nocount on

begin

declare @newQuoteGroupId int;

insert into QuoteGroup
(
    QuoteHeaderFID,
    RateTypeFID,
    ItemCodeFID,
    [Description],
    Rate,
    Quantity,
    Quantity2,
    Charge,
    QuoteServiceProviderTypeFID,
    VendorID,
    VendorQuotedCharge,
    VendorActualCharge,
    PONumber,
    InvoiceNumber,
    ServiceDate,
    NoteText,
    SortOrder,
    LaborRatingTypeFID,
    QuoteServiceProviderBillToFID,
    RateSource,
    RateSourceRecord,
    ExternalVendorID,
    ExternalVendorName,
    AccountingVendorFid
)
select
    @inQuoteHeaderFID,
    @inRateTypeFID,
    @inItemCodeFID,
    @inDescription,
    @inRate,
    @inQuantity,
    @inQuantity2,
    @inCharge,
    @inQuoteServiceProviderTypeFID,
    @inVendorID,
    @inVendorQuotedCharge,
    @inVendorActualCharge,
    @inPONumber,
    @inInvoiceNumber,
    @inServiceDate,
    @inNoteText,
    @inSortOrder,
    (
        SELECT TOP 1 LaborRatingTypeID
        FROM LaborRatingType
        WHERE TypeName = @inLaborRatingType
    ),
    @inQuoteServiceProviderBillToFID,
    @inRateSource,
    @inRateSourceRecord,
    @inExternalVendorID,
    @inExternalVendorName,
    @inAccountingVendorFid

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