UFN_CHARGETOTALINDIVIDUAL

Returns the charge total 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_CHARGETOTALINDIVIDUAL
            (
                @CONSTITUENTID uniqueidentifier,
                @STARTDATE datetime = null,
                @ENDDATE datetime = null
            )
            returns money
            with execute as caller
            as begin
                return dbo.UFN_BILLINGTRANSACTIONTYPETOTAL(104, @CONSTITUENTID, @STARTDATE, @ENDDATE, 0, 0, 0);
            end