UFN_BILLINGPASTDUEBALANCEINDIVIDUAL

Returns the past due balance of a given individual.

Return

Return Type
money

Parameters

Parameter	Parameter Type	Mode
@CONSTITUENTID	uniqueidentifier	IN
@STARTDATE	datetime	IN
@ENDDATE	datetime	IN

Definition

Copy



            CREATE function dbo.UFN_BILLINGPASTDUEBALANCEINDIVIDUAL
            (
                @CONSTITUENTID uniqueidentifier,
                @STARTDATE datetime = null,
                @ENDDATE datetime = null
            )
            returns money
            with execute as caller
            as begin
                if (@ENDDATE is null)
                    set @ENDDATE = dbo.UFN_DATE_GETEARLIESTTIME(getdate());

                declare @RETVAL money;
                set @RETVAL = dbo.UFN_BILLINGTRANSACTIONTYPETOTAL(104, @CONSTITUENTID, @STARTDATE, @ENDDATE, 1, 1, 0) - (dbo.UFN_BILLINGTRANSACTIONTYPETOTAL(105, @CONSTITUENTID, @STARTDATE, @ENDDATE, 1, 1, 0) + dbo.UFN_BILLINGTRANSACTIONTYPETOTAL(106, @CONSTITUENTID, @STARTDATE, @ENDDATE, 1, 1, 0));

                if (@RETVAL < 0)
                    set @RETVAL = 0;

                return @RETVAL;
            end