CREATE procedure [dbo].[BcSaveTransactionUploadResult]
    @journalBcId uniqueidentifier = null,
    @documentNumber nvarchar(20) = null,
    @journalType nvarchar( 32 ),
    @failedDuring nvarchar( 32 ) = null,
    @exception nvarchar( max ) = null,
    @journalJson nvarchar( max ) = null,
    @transactionItems IntList readonly

as
begin
    set nocount on


    declare @resultId int

    insert into BcTransactionUploadResult(
        JournalBcId,
        BcJournalTypeFid,
        FailedDuringPhaseFid,
        Exception,
        JournalJson,
        DocumentNumber
    )
    select
        @journalBcId,
        BcJournalTypeFid =
            (
                select BcJournalType.BcJournalTypeId
                from BcJournalType
                where BcJournalType.TypeName = @journalType
            ),
        FailedDuringPhaseFid =
            (
                select BcTransactionUploadPhase.BcTransactionUploadPhaseId
                from BcTransactionUploadPhase
                where BcTransactionUploadPhase.TypeName = @failedDuring
            ),
        Exception = @exception,
        @journalJson,
        DocumentNumber = @documentNumber

    set @resultId = scope_identity()

    update BcTransactionBatchItem set BcTransactionUploadResultFid = @resultId
        from @transactionItems Items
        where BcTransactionBatchItem.BcTransactionBatchItemId = Items.Item

end
GO
GRANT EXECUTE ON  [dbo].[BcSaveTransactionUploadResult] TO [MssExec]
GO