CREATE procedure [dbo].[MssWebUpdateOrderThirdPartyService]
    @inId int,
    @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

    update OrderThirdPartys
    set
        VendorID = @inVendorId,
        AccountingVendorFid = @inAccountingVendorId,
        Amount = @inAmount,
        PONumber = @inPONumber,
        InvoiceNumber = @inInvoiceNumber,
        Description = @inDescription,
        Date = @inServiceDate,
        InvoiceReceivedDate = @inInvoiceReceivedDate,
        InvoiceApprovedDate = @inInvoiceApprovedDate
    where OrdThirdPartyPriKey = @inId AND OrdPriKey=@inOrderId

    update Orders set JobCostingCalculated = 0
    from dbo.OrderThirdPartys
        inner join Orders on Orders.PriKey = OrderThirdPartys.OrdPrikey and Orders.PriKey = @inOrderId
    where OrderThirdPartys.OrdThirdPartyPriKey = @inId and Orders.ReleaseDate is null
end
GO
GRANT EXECUTE ON  [dbo].[MssWebUpdateOrderThirdPartyService] TO [MssExec]
GO