CREATE procedure [dbo].[MssWebCreateOrderThirdPartyService]
    @inOrderId int,
    @inVendorId varchar(15),
    @inAccountingVendorId int = null,
    @inAmount money,
    @inPONumber varchar(20),
    @inInvoiceNumber varchar(20),
    @inDescription varchar(60),
    @inServiceDate datetime,
    @inInvoiceReceivedDate datetime,
    @inInvoiceApprovedDate datetime
as
begin
    set nocount on

    declare @id int

    insert into OrderThirdPartys
    (
        OrdPriKey,
        VendorID,
        AccountingVendorFid,
        Amount,
        PONumber,
        InvoiceNumber,
        Description,
        Date,
        InvoiceReceivedDate,
        InvoiceApprovedDate
    )
    select
        OrdPriKey = @inOrderId,
        VendorID = @inVendorId,
        AccountingVendorFid = @inAccountingVendorId,
        Amount = @inAmount,
        PONumber = @inPONumber,
        InvoiceNumber = @inInvoiceNumber,
        Description = @inDescription,
        Date = @inServiceDate,
        InvoiceReceivedDate = @inInvoiceReceivedDate,
        InvoiceApprovedDate = @inInvoiceApprovedDate
    
    set @id = SCOPE_IDENTITY()

    update Orders set JobCostingCalculated = 0
    from dbo.OrderThirdPartys
        inner join Orders on Orders.PriKey = OrderThirdPartys.OrdPrikey and Orders.PriKey = @inOrderId
    where OrderThirdPartys.OrdThirdPartyPriKey = @id and Orders.ReleaseDate is null

    select @id
end
GO
GRANT EXECUTE ON  [dbo].[MssWebCreateOrderThirdPartyService] TO [MssExec]
GO