UFN_GIFTINKINDSALE_ISPOSTED

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

                if @r = 0 --Posted

                    return 1

                return 0
            end