UFN_BILLINGUNAPPLIEDPAYMENTCREDITTOTALINDIVIDUAL

Returns the total of the unapplied payments and credits for 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_BILLINGUNAPPLIEDPAYMENTCREDITTOTALINDIVIDUAL
            (
                @CONSTITUENTID uniqueidentifier,
                @STARTDATE datetime = null,
                @ENDDATE datetime = null
            )
            returns money
            with execute as caller
            as begin
                return dbo.UFN_BILLINGTRANSACTIONTYPETOTAL(105, @CONSTITUENTID, @STARTDATE, @ENDDATE, 1, 0, 1) + dbo.UFN_BILLINGTRANSACTIONTYPETOTAL(106, @CONSTITUENTID, @STARTDATE, @ENDDATE, 1, 0, 1)
            end