UFN_WRITEOFF_ISPOSTED

            create function dbo.UFN_WRITEOFF_ISPOSTED
            (
                @WRITEOFFID uniqueidentifier
            )
            returns bit
            with execute as caller
            as 
            begin
                declare @r as int
                select @r = POSTSTATUSCODE from dbo.WRITEOFF where ID = @WRITEOFFID 

                if @r = 0 --Posted

                    return 1

                return 0
            end