UFN_STOCKSALE_ISPOSTED

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

                if @r = 0 --Posted

                    return 1

                return 0
            end