UFN_PROPERTYDETAIL_ISPOSTED

            create function dbo.UFN_PROPERTYDETAIL_ISPOSTED
            (
                @PROPERTYDETAILID uniqueidentifier
            )
            returns bit
            with execute as caller
            as 
            begin
                declare @r as int
                select @r = SALEPOSTSTATUSCODE from dbo.PROPERTYDETAIL where ID = @PROPERTYDETAILID

                if @r = 0 --Posted

                    return 1

                return 0
            end