Stored Procedures [dbo].[XLedgerCheckIfTransactionUploadCompleted]
BUILD09 > MoversSuite2 > Stored Procedures > dbo.XLedgerCheckIfTransactionUploadCompleted
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@xledgerJournalEntryBatchIdint4
Permissions
TypeActionOwning Principal
GrantExecuteMssExec
SQL Script
CREATE PROCEDURE [dbo].[XLedgerCheckIfTransactionUploadCompleted]
    @xledgerJournalEntryBatchId int
as
begin
    set nocount on

    select convert( bit, 1 )
    from XLedgerJournalEntryBatch
    where
        XLedgerJournalEntryBatch.XLedgerJournalEntryBatchId = @xledgerJournalEntryBatchId and
        XLedgerJournalEntryBatch.CompletedOn is not null
end
GO
GRANT EXECUTE ON  [dbo].[XLedgerCheckIfTransactionUploadCompleted] TO [MssExec]
GO
Uses
Created 09 February 2026 07:28
Copyright  2026 - All Rights Reserved