V_QUERY_BBNCMEMBERSHIPBATCHCONTROLREPORT

View used for output by the Blackbaud Internet Solutions Membership Transaction Batch Control Report.

Fields

Field	Field Type	Null	Description
REVENUEID	uniqueidentifier		System record ID
PRIMARYMEMBER	nvarchar(154)	yes	Primary member
OTHERMEMBERS	nvarchar(max)	yes	Other members
AMOUNT	money		Amount
MEMBERSHIPPROGRAM	nvarchar(100)		Program
MEMBERSHIPLEVEL	nvarchar(100)		Level
MEMBERSHIPLEVELTERM	nvarchar(8)	yes	Term
ISO4217	nvarchar(3)		ISO4217
DECIMALDIGITS	tinyint		Decimal Digits
CURRENCYSYMBOL	nvarchar(5)		Currency Symbol
SYMBOLDISPLAYSETTINGCODE	tinyint		Symbol Display Setting Code

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  8/17/2011 2:46:23 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_BBNCMEMBERSHIPBATCHCONTROLREPORT AS



                select
                    REVENUESPLIT.REVENUEID,
                    CONSTITUENT_NF.NAME as PRIMARYMEMBER,
                    (select dbo.UDA_BUILDLIST(CONSTITUENT.NAME)
                     from dbo.CONSTITUENT
                     inner join dbo.MEMBER on MEMBER.CONSTITUENTID = CONSTITUENT.ID
                     where MEMBER.MEMBERSHIPID = MEMBERSHIPTRANSACTION.MEMBERSHIPID and MEMBER.ISDROPPED = 0 and MEMBER.ISPRIMARY = 0
                    ) as [OTHERMEMBERS],
                    REVENUESPLIT.TRANSACTIONAMOUNT as AMOUNT,
                    MEMBERSHIPPROGRAM.NAME as [MEMBERSHIPPROGRAM],
                    MEMBERSHIPLEVEL.NAME as [MEMBERSHIPLEVEL],
                    MEMBERSHIPLEVELTERM.TERM as [MEMBERSHIPLEVELTERM],
          CURRENCY.ISO4217,
                    CURRENCY.DECIMALDIGITS,
                    CURRENCY.CURRENCYSYMBOL,
                    CURRENCY.SYMBOLDISPLAYSETTINGCODE 
                from dbo.REVENUESPLIT
                inner join dbo.MEMBERSHIPTRANSACTION on MEMBERSHIPTRANSACTION.REVENUESPLITID = REVENUESPLIT.ID
                inner join dbo.MEMBERSHIPLEVEL on MEMBERSHIPLEVEL.ID = MEMBERSHIPTRANSACTION.MEMBERSHIPLEVELID
                inner join dbo.MEMBERSHIPPROGRAM on MEMBERSHIPPROGRAM.ID = MEMBERSHIPLEVEL.MEMBERSHIPPROGRAMID
                inner join dbo.MEMBERSHIPLEVELTERM on MEMBERSHIPLEVELTERM.ID = MEMBERSHIPTRANSACTION.MEMBERSHIPLEVELTERMID
                inner join dbo.MEMBER on MEMBER.MEMBERSHIPID = MEMBERSHIPTRANSACTION.MEMBERSHIPID and MEMBER.ISPRIMARY = 1
        inner join dbo.CURRENCY on REVENUESPLIT.TRANSACTIONCURRENCYID = CURRENCY.ID
        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(MEMBER.CONSTITUENTID) CONSTITUENT_NF