UFN_PROCESSORTRANSACTIONSETTLEMENTIMPORT_DUPLICATEIMPORT

        CREATE function dbo.UFN_PROCESSORTRANSACTIONSETTLEMENTIMPORT_DUPLICATEIMPORT
        (
            @ID uniqueidentifier
        )
        returns bit
        with execute as caller
        as begin

            declare @STATUSCODE tinyint;

            select 
                @STATUSCODE = STATUSCODE
            from dbo.PROCESSORTRANSACTIONSETTLEMENTIMPORT
            where ID = @ID;

            if @STATUSCODE = 1
                return 1;

            return 0

        end