UFN_AUCTIONITEM_REQUIREDFIELDSFORNONPACKAGE

            CREATE function dbo.UFN_AUCTIONITEM_REQUIREDFIELDSFORNONPACKAGE
            (
                @TYPECODE integer,
                @REVENUEAUCTIONDONATIONID uniqueidentifier
            )
            returns bit
            with execute as caller
            as begin
                declare @VALID bit = 1

                if @TYPECODE = 1
                    return 1
                else if @REVENUEAUCTIONDONATIONID is null
                    set @VALID = 0

                return @VALID
            end