UFN_RESERVATION_CONTRACTPASTDUE

            create function dbo.UFN_RESERVATION_CONTRACTPASTDUE(@ID uniqueidentifier)
            returns bit
            with execute as caller
            as begin
                declare @CONTRACTREQUIRED bit;
                declare @CONTRACTDUEDATE date;
                declare @CONTRACTRECEIVED bit;
                declare @CURRENTDATE date;

                set @CURRENTDATE = getdate();

                select @CONTRACTREQUIRED = CONTRACTREQUIRED,
                    @CONTRACTDUEDATE = CONTRACTDUEDATE,
                    @CONTRACTRECEIVED = CONTRACTRECEIVED
                from dbo.RESERVATION
                where ID = @ID;

                if (@CONTRACTREQUIRED = 1) and (@CONTRACTDUEDATE < @CURRENTDATE) and (@CONTRACTRECEIVED = 0)
                    return 1;

                return 0;
            end