V_QUERY_BILLINGINDIVIDUALINFORMATION

Return billing information about individuals.

Fields

Field	Field Type	Null	Description
CONSTITUENTID	uniqueidentifier		Constituent ID
BALANCE	money	yes	Balance
PASTDUEBALANCE	money	yes	Past due balance
BALANCEASOFTODAY	money	yes	Balance as of today
PASTDUEBALANCEASOFTODAY	money	yes	Past due balance as of today

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  11/30/2010 11:21:39 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.8.2022.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_BILLINGINDIVIDUALINFORMATION AS



                select
                    ID as CONSTITUENTID,
                    dbo.UFN_BILLINGBALANCEINDIVIDUAL(CONSTITUENT.ID, null, null) as BALANCE,
                    dbo.UFN_BILLINGPASTDUEBALANCEINDIVIDUAL(CONSTITUENT.ID, null, null) as PASTDUEBALANCE,
                    dbo.UFN_BILLINGBALANCEINDIVIDUAL(CONSTITUENT.ID, null, getdate()) as BALANCEASOFTODAY,
                    dbo.UFN_BILLINGPASTDUEBALANCEINDIVIDUAL(CONSTITUENT.ID, null, getdate()) as PASTDUEBALANCEASOFTODAY
                from dbo.CONSTITUENT