UFN_GETBILLINGCYCLESBYINDIVIDUAL

Gets all the billing cycles in the system with unique dates and names for which a constituent has a transaction.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_GETBILLINGCYCLESBYINDIVIDUAL
            (
                @CONSTITUENTID uniqueidentifier
            )
            returns table
            as return
                select ACADEMICYEARID,
                        NAME,
                        BILLINGSTARTDATE,
                        BILLINGENDDATE
                from dbo.UFN_GETBILLINGCYCLES()
                where (exists (select FINANCIALTRANSACTION.ID
                                from dbo.FINANCIALTRANSACTION
                                where (FINANCIALTRANSACTION.CONSTITUENTID = @CONSTITUENTID) and
                                        (FINANCIALTRANSACTION.TYPECODE in (104, 105, 106)) and
                                        (FINANCIALTRANSACTION.DATE between BILLINGSTARTDATE and BILLINGENDDATE)));